dcsimg
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

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


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

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


 

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
Thanks for your registration, follow us on our social networks to keep up-to-date