advertisement
Premier Club Log In/Registration
  Include Code  Search Tips
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   SKILLBUILDING  |   TIP BANK  |   SOURCEBANK  |   FORUMS  |   NEWSLETTERS
Browse DevX
The Apache Derby Project
MySQL Open Source Database
PostgreSQL Global Development Group
One$DB Open Source Database
Open Source Databases
Using MySQL 4.0 with .NET
PostgreSQL vs. MySQL vs. Commercial Databases: It's All About What You Need
WAMP Up Your Open Source Development on Windows for Free
DevX: Database Dev Zone
DevX: Open Source Zone
More Open Source Articles
More Database Articles
Partners & Affiliates
advertisement
advertisement
 
Open Source Database Feature Comparison Matrix
Looking for a database? This handy database feature comparison matrix and glossary let you compare and contrast the supported features of four popular open source databases: Apache Derby 10.1, MySQL 5.0, PostgreSQL 8.1, and One$DB 4.0.  

by Joshua D. Drake,
Uday Parmar  
October 14, 2005  

 

Apache Derby 10.1

MySQL 5.0

PostgreSQL 8.1

One$DB 4.0

General

 

 

 

 

Database Connections

Multiple

Multiple

Multiple

Multiple

Concurrent Access to Multiple Databases

√

√

√

√

Multi-version Concurrency Control

X

√

√

√

Unicode Support

√

√

√

√

Replication Support

√

√

√

√

License

Apache (BSD)

GPL

BSD

LPGL

Specifications

 

 

 

 

SQL 99

√

X

√

√

ODBC

*

√

√

√

Relational Database Features

 

 

 

 

Sequences/Auto-increment Column

√

√

√

√

User Defined Functions

√

√

√

X

Update-capable Views

√

√

√

√

Referential Integrity

√

√

√

√

Triggers

Statement / Row Level

Before / After

Nesting

Compound

√

√

√

√

√

√

√

√

√

X

√

√

√

√

√

√

Domains

X

X

√

√

BLOB

√

√

√

√

CLOB

√

√

√

√

Name Length Limit

128

64

64

128

Delimited Identifiers

√

√

√

√

Stored Procedures

√

√

√

√

Procedural Languages




 

PL/SQL (or equivalent)

X

√

√

√

Java

√

X

*

X

Python

X

X

√

X

Perl

X

X

√

X

PHP

X

X

√

X

Ruby

X

X

*

X

R

X

X

*

X



Key to Symbols

√

Feature supported

X

Feature not supported

*

External or unofficial support
  Next Page: DQL, Java, Native Language Support
Page 1: Open Source Database Comparison MatrixPage 3: Security, Administration, Graphical Interface
Page 2: DQL, Java, Native Language Support 
DevX is a division of Jupitermedia Corporation
© Copyright 2007 Jupitermedia Corporation. All Rights Reserved. Legal Notices
Untitled
advertisement
Advertising Info  |   Member Services  |   Permissions  |   Contact Us  |   Help  |   Feedback  |   Site Map  |   Network Map  |   About


JupiterOnlineMedia

internet.comearthweb.comDevx.commediabistro.comGraphics.com

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info


Legal Notices, Licensing, Reprints, & Permissions, Privacy Policy.

Advertise | Newsletters | Tech Jobs | Shopping | E-mail Offers
Solutions
Whitepapers and eBooks
Intel PDF: Virtualization Delivers Data Center Efficiency
Intel eBook: Managing the Evolving Data Center
Microsoft Article: BitLocker Brings Encryption to Windows Server 2008
Symantec eBook: The Guide to E-Mail Archiving and Management
Microsoft Article: RODCs Transform Branch Office Security
Go Parallel Article: James Reinders on the Intel Parallel Studio Beta Program
 Avaya Article: Advancing the State of the Art in Customer Service
Adobe Acrobat Connect Pro: Web Conferencing and eLearning Whitepapers
Avaya Article: Avaya AE Services Provide Rapid Telephony Integration with Facebook
Go Parallel Article: Getting Started with TBB on Windows
HP eBook: Storage Networking , Part 1
MORE WHITEPAPERS, EBOOKS, AND ARTICLES
Webcasts
Intel Seminar: Efficiencies in Hardware/Software Virtualization
HP Webcast: Disaster Recovery Planning
Go Parallel Video: Performance and Threading Tools for Game Developers
 HP Video: StorageWorks EVA4400 and Oracle
HP Webcast: Storage Is Changing Fast - Be Ready or Be Left Behind
MORE WEBCASTS, PODCASTS, AND VIDEOS
Downloads and eKits
IBM TCO eKIT: Your IT Budget is Under Attack, Get in Control
IBM Energy Efficiency eKIT: Learn How to Reduce Costs
30-Day Trial: SPAMfighter Exchange Module
 Red Gate Download: SQL Toolbelt and free High-Performance SQL Code eBook
Iron Speed Designer Application Generator
MORE DOWNLOADS, EKITS, AND FREE TRIALS
Tutorials and Demos
Microsoft Article: Silverlight Streaming--Free Video Hosting for All
Featured Algorithm: Intel Threading Building Blocks - parallel_reduce
 HP Demo: StorageWorks EVA4400
MORE TUTORIALS, DEMOS AND STEP-BY-STEP GUIDES