http://www.perlmonks.org?node_id=967415


in reply to Databases made easy

SQLite remains a toy-database, its limitations honestly admitted by the sqlite crew on the sqlite site.

IMHO, one might as well start out with a real database and conquer the teething problems that might be caused by installing PostgreSQL. You won't regret it.

To use PostgreSQL, replace the SQLite connection string:

dbi:SQLite:Test.sqlite

with a connection string for PostgreSQL, for instance:

dbi:Pg:port=5421;db=testdb

The three parts in the above tutorial (create table, insert rows, select rows) will run the same on this postgresql $dbh (data base handle).

The PostgreSQL flavour of SQL is here: sql-commands.html