Databases Archive

Interview with Josh Berkus of PostgreSQL

Submitted by SilentBob4 2005-03-15 Databases 13 Comments

The PostgreSQL database project has recently released Version 8.0, which was received with quite some fanfare, mostly due to its first-ever Windows port. Mad Penguin talked with Josh Berkus, one of the core team members, to find out how 8.0 has fared since its official release on January 17, 2005.

Providing database encryption

Submitted by LogError 2005-02-20 Databases No Comments

In this paper, we explore a new approach for data privacy and security in which a security administrator protecting privacy at the level of individual fields and records, and providing seamless mechanisms to create, store, and securely access databases.

Comparing MySQL performance, Part II

Submitted by mudrii 2005-02-10 Databases 53 Comments

With the introduction of the 2.6 Linux kernel, FreeBSD-5-STABLE, Solaris 10, and now NetBSD 2.0, you might be wondering which of them offers superior database performance.

Study: Few bugs in MySQL database

Submitted by Tudy 2005-02-05 Databases 29 Comments

A source-code analysis of the MySQL database revealed few bugs compared with the number found in commercial code, testing company Coverity said Friday.

MySQL Worm Hits Windows Systems

Adam Scheinberg 2005-01-28 Databases 32 Comments

"A worm that takes advantage of administrators' poor password choices has started spreading among database systems." Read more at ZDNet.

Firebird Relational Database 1.5.2 Released

Eugenia Loli 2005-01-23 Databases 31 Comments

Firebird is a relational database offering many ANSI SQL-92 features that runs on Linux, Windows, and a variety of Unix platforms. Many fixes were made for this release. Blobs containing more than 65535 segments were not being backed up by GBAK properly. ISQL problems that were fixed include statement terminators and "--" comments that are no longer recognized in multi-line literals, and tab characters that are no longer translated to spaces in literal strings.

PostgreSQL 8 Released

Submitted by Enrique 2005-01-19 Databases 42 Comments

After more than a year of hard work, the PostgreSQL Global Development Group has proudly announced the release of version 8.0.0 of the PostgreSQL ORDBMS. This release involves possibly more major changes than any prior version of PostgreSQL since 6.3, and it is the first PostgreSQL release to natively run on Microsoft Windows as a server. You can read the complete announcement and download it from any mirror or using BitTorrent.

Get Groovy with JDBC programming; PostgreSQL 8.0.0-RC5

Eugenia Loli 2005-01-16 Databases 14 Comments

Development is distinctively breezy with Groovy, and its lightweight syntax can alleviate some of the verbosity of JDBC in Java. This article shows you how to use GroovySql to build a simple data-reporting application. GroovySql combines closures and iterators to ease Java Database Connectivity (JDBC) programming by shifting the burden of resource management from you to the Groovy framework itself. Elsewhere, PostgreSQL 8.0.0 RC5 was released.

Enterprise MySQL Beta Imminent

Submitted by Rahul Sundaram 2005-01-06 Databases 8 Comments

MySQL, at the end of January, is expected to release a beta version of its MySQL 5.0 open source database, which is to feature enterprise-level functionality such as stored procedures and triggers, according to a company representative.

Derby database development with Apache Ant

Eugenia Loli 2004-12-29 Databases 13 Comments

The open source Derby database engine provides developers with a powerful new tool for lightweight database development. Derby databases are file system based and portable across different types of systems. Because of this, a common strategy is to create databases at development time and ship them with the binary distribution as opposed to having it created on the fly.

Firebird 1.5.2 is Released

Submitted by Juarez Rudsatz 2004-12-27 Databases 31 Comments

Firebird V1.5.x is the first release of the Firebird 2 codebase and represents a significant milestone for the developers and the whole Firebird project, but it is not an end in itself. With these release, major development continues toward the next point release on the journey to Firebird V2.0.

High-performance SQL with DB2

Eugenia Loli 2004-12-01 Databases 2 Comments

Its a SQL tour through the DB2 TPC-C benchmark implementation. This article introduces advanced SQL features which are being used in IBM DB2 Universal Database for Linux, UNIX, and Windows TPC-C benchmarks. Find out how to use efficient SQL query plans, which in turn will mean that the only codepath that is necessary will be executed.

Old VMS Databases Never Die

Submitted by Ken Farmer 2004-11-30 Databases 21 Comments

Datamation ran an article about databases running on OpenVMS that never die or quit. These databases have uptimes longer than the existance of Linux and definitely longer that Microsoft product lifetimes. Here's the article.

MySQL prepares for version 5.0; PostgreSQL 8.0-b5 Available

Eugenia Loli 2004-11-29 Databases 41 Comments

Open source database vendor MySQL AB will release version 5.0 of its eponymous database management system in the first quarter of 2005, a year after it first went in to alpha testing. Also, after 4 weeks of work, involving a lot of bug fixes, and documentation improvements to the source tree, PostgreSQL.org have released the 5th Beta of 8.0.0.

Installing Oracle Database 10g on Linux x86

Eugenia Loli 2004-11-02 Databases 8 Comments

Learn the basics of installing Oracle Database 10g on RHEL 2.1, RHEL 3, or SLES 8, from the bare metal up.

MySQL Version 4.1 Certified as Production-Ready

Eugenia Loli 2004-10-26 Databases 28 Comments

MySQL announced the general availability of MySQL 4.1. Certified by the company as production-ready for large-scale enterprise deployment, this significant upgrade to the MySQL database server features advanced querying capabilities through subqueries, faster and more secure client-server communication, new installation and configuration tools, and support for international character sets and geographic data.

Open Source: Good for the OS, But Not for the Database

Eugenia Loli 2004-10-09 Databases 30 Comments

Larry Ellison embraces Linux, but don't expect open source databases from Oracle any time soon. (Part Two of six part interview).

Sybase releases free database for Linux

Eugenia Loli 2004-09-09 Databases 9 Comments

The database maker announced on Wednesday the availability of a version of its Adaptive Server Enterprise (ASE) database for Linux. David Jacobson, a marketing director at Sybase, said the database was produced for customers who want to run a test pilot of a commercial database on a Linux box.

PostgreSQL 8.0 will run on Windows

Eugenia Loli 2004-08-20 Databases 59 Comments

The new version of open-source database PostgreSQL, which is already in beta, is expected to go into production within three months and will for the first time run natively on Windows.

Installing DB2 Version 8.1.6 for Linux

Eugenia Loli 2004-08-19 Databases 13 Comments

This article guides you through the steps to install IBM DB2 Universal Database Personal Edition V8.1.6, as well as the IBM Java™ Runtime Environment (JRE), with minimal fuss and frustration. Developers who are new to Linux or UNIX-based operating systems will get the most out of this article.

1
2
3
4
5
6
7
8
9
10