| @@ -1,8 +1,8 @@ |
| This is a little soap box I have about databases. I am often asked about databases, and how they compare. I will illustrate with pictures three current favorites:
|
|
|
| || ::__MySQL__:: | ::__PostgreSQL__:: | ::__Firebird__:: | ::__Oracle__::
|
| - {attachment id=123} | {attachment id=122} | {attachment id=124}
|
| -Cute and easy to drive you'll get going in a hurry, however it's not the safest place to be if something goes terribly, terribly wrong | It offers rugged durability while being very easy to drive | When you have to kick ass and take names there's only one answer, however just getting the things moving takes a lot of training and education ||
|
| + {attachment id=123} | {attachment id=122}| {attachment id=1038 size=small} | {attachment id=124} |
| +Cute and easy to drive you'll get going in a hurry, however it's not the safest place to be if something goes terribly, terribly wrong | It offers rugged durability while being very easy to drive | Swiss army knife of a database which scales from simple embedded to multi-gigabyte distributed systems. Totally open source and without any licensing restrictions. Being deployed as a free replacement for Oracle on many sites. | When you have to kick ass and take names there's only one answer, however just getting the things moving takes a lot of training and education || |
|
|
| What this illustrates is that database selection depends on your needs. bitweaver supports many databases via the [http://adodb.sourceforge.net|ADODB] database abstraction layer. This allows you to choose a database that fits your site's requirements - be it performance, financial, stability, or any combination there of.
|
|
|
|
|
| @@ -21,6 +21,10 @@ |
| ((PostgreSQLSupport|PostgreSQL)) is another open-source database that is very stable and supports many more data-critical features to insure data integrity. These include all the features lacking in MySQL as mentioned above. There are also several [http://www.commandprompt.com/entry.lxp?lxpe=304|replication solutions] that offer great redundancy solutions. While UNIX support is excellent, Windows support is lacking, however it will indeed run with use of the Cygwin POSIX compatibility package. __News!__ There is significant work being done on a [http://momjian.postgresql.org/main/writings/pgsql/project/win32.html|native windows port]. For enterprise class features and open-source, this is as good as it gets.
|
|
|
| (:arrow:) If you are using any flavor of unix, I strongly recommend PostgreSQL. I have used it for many years and it has been awesome, and extremely reliable. It is just as easy to use as MySQL and offers many, many more features. Windows users should consult with others to see how good of an option it is, I proudly don't do Windows.
|
| + |
| +!Firebird |
| + |
| +((FirebirdInstallNotes|Firebird)) is a totally open source, powerful alternative to Oracle. It is a generational relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names, since 1981. |
|
|
| !Oracle
|
|
|
|
|