Databases

MySQL — by Khairil Yusof — last modified Apr 24, 2008 05:56 AM

MySQL is a multithreaded, multi-user SQL database management system.

PostgreSQL — by Khairil Yusof — last modified Apr 24, 2008 05:58 AM

PostgreSQL is a powerful, open source relational database system. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

MySQL Savior backup script — by P.P.Foong — last modified Jul 01, 2008 10:41 PM

MySQL Savior is a bash script that, after simple configuration, will create local backups of your databases. If configured to do so it can also email your backups to a remote email address or scp them to a remote server. Or it can do all 3.