SQLite vs MySQL vs PostgreSQL: A Comparison Of Relational Database Management Systems
SQLite vs MySQL vs PostgreSQL: A Comparison Of Relational Database Management Systems This article compares and contrasts three of the most widely implemented open-source RDBMSs: SQLite, MySQL, and PostgreSQL. Specifically, it will explore the data types that each RDBMS uses, their advantages and disadvantages, and situations where they are best optimized.
Read Full Post | Make a Comment ( Comments Off on SQLite vs MySQL vs PostgreSQL: A Comparison Of Relational Database Management Systems )Sample Database: Chinook
Chinook Database Chinook is a sample database available for SQL Server, Oracle, MySQL, etc. It can be created by running a single SQL script. Chinook database is an alternative to the Northwind database, being ideal for demos and testing ORM tools targeting single and multiple database servers. (Data is music oriented – artist, album, track […]
Read Full Post | Make a Comment ( Comments Off on Sample Database: Chinook )Learn ORM in Perl with DBIx::Class
This post will provide a brief hands-on introduction to ORM in Perl using a few DBIx::Class sub classes. In detail, this means we will generate Schema, Result and ResultSet classes (Perl modules) which will be used to interface with a SQLite database. The database will contain a single users table. Once the database has been […]
Read Full Post | Make a Comment ( Comments Off on Learn ORM in Perl with DBIx::Class )