SQLite vs MySQL vs PostgreSQL: A Comparison Of Relational Database Management Systems

Posted on May 9, 2020. Filed under: Uncategorized | Tags: , , , , , , |

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

Posted on November 6, 2017. Filed under: Uncategorized | Tags: , , , , , , , |

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

Posted on February 6, 2017. Filed under: Uncategorized | Tags: , , , , , , |

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 )

Liked it here?
Why not try sites on the blogroll...