Better yet, as everybody's working on dynamic web pages today, our nice database server is very quick at estabilishing a connection. If you have already tried a CGI script connecting to Oracle, DB2 or some other powerhouse database you know how the connection time can slow down your web site.As with any modern tool, you can write C programs to get your data from, but it's easier to write a REXX script or a Java applet. It even comes ready with an easy to use web gateway. Add to this wide multi-platform coverage and we have a perfect match to our desires.On the downside, you won't get some nice features common in corporate workhorses like transaction commit and rollback, no locking (our database simply serializes all requests to avoid concurrency problems), no stored procedures, nested queries nor two-phase commit.Even with that limitations, our database is being successfully used by many web sites and corporations to build a broad range of systems. It's a tried-and-trusted solutions with broad third-party support.

Questo testo ha lo scopo di descrivere il primo approccio al database MySql. Non contiene quindi una descrizione completa del linguaggio ma le sue parti ritenute essenziali. Come prerequisito è richiesta una conoscenza del linguaggio SQL cui si fa riferimento in svariati punti.

Terza e ultima puntata di questa completissima guida "Ubuntu Server Guide Part 3": Databases, eMail Services, Windows Networking

Firebird SQL è un database management system relazionale (RDBMS) opensource distribuito sotto licenza IPL (Interbase Public License) o IDPL (simile alla Mozilla Public License) .Supporta numerosi sistemi operativi tra i quali: Windows, FreeBSD, Mac OS X, Linux e alcuni sistemi Unix.Le principali caratteristiche di questo RDBMS sono l'alto livello di conformità con gli standard SQL, la completa integrazione con molti linguaggi di programmazione e la facile installazione e manutenzione del software.Le ultime versioni rilasciate portano grandi miglioramenti riguardo alla resistenza del software ai crash esterni, la velocità d'esecuzione dei comandi SQL e la gestione e l'accesso ai dati del computer.

La nuova versione alpha di Ubuntu 8.04 Hardy Heron include l'ultima release rilasciata dal team di Firebird, la versione 2.03.Features * Full support of Stored Procedures and Triggers * Full ACID compliant transactions * Referential Integrity * Multi Generational Architecture (sometimes called MVCC) * Very small footprint * Fully featured internal language for Stored Procedures and Triggers (PSQL) * Support for External Functions (UDFs) * Little or no need for specialized DBAs * Almost no configuration needed - just install and start using * Big community and lots of places where you can get free and good support * Optional single file embedded version - great to create CDROM catalogs, single user or evaluation versions of applications * Dozens of third party tools, including GUI administrative tools, replication tools, etc. * Careful writes - fast recovery, no need for transaction logs * Many ways to access your database: native/API, dbExpress drivers, ODBC, OLEDB, .Net provider, JDBC native type 4 driver, Python module, PHP, Perl, etc. * Native support for all major operating systems, including Windows, Linux, Solaris, MacOS. * Incremental Backups * 64bits builds available * Full cursor implementation in PSQL