Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Open Source Database Feature Comparison Matrix : Page 3

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.


advertisement

 

Apache Derby 10.1



MySQL 5.0

PostgreSQL 8.1

One$DB 4.0

Security

 

 

 

 

Users

Role

X

X

Privilege

X

Encryption

X

Database Administration Tools

 

 

 

 

Tools

IJ Scripting Tool, Cloudview,
Import/Export

WinMySQL Admin, MySQL Administrator, MySQL Query Browser
Command Shell

PgAdmin, psql, phpPgAdmin

Shell, Browser, Shell Server, Browser Server, Server

Hot Backup

*

X 

Table Spaces

X

X 

Point in Time recovery

X

*

X 

Table partitioning

X

X

X 

Graphical Interface

 

 

 

 

Creating Database Objects

*

 

Manipulate Data in Database Objects

*

 

Viewing Properties of Various Database Objects

*

 

Graphical Interface to Execute SQL Queries

*

 

Support for Executing Multiple Queries Simultaneously

*

 

 

Key to Symbols

Feature supported

X

Feature not supported

*

External or unofficial support



Joshua D. Drake is President of Command Prompt, Inc. a dedicated PostgreSQL support and custom programming company. He is also the co-author of "Practical PostgreSQL" from O'Reilly and Associates.
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap