note
erix
<p>SQLite remains a toy-database, its limitations honestly admitted by the sqlite crew on [http://www.sqlite.org/whentouse.html|the sqlite site].
<p>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.
<p>To use PostgreSQL, replace the SQLite connection string:
<p><blockquote> dbi:SQLite:Test.sqlite</blockquote>
<p>with a connection string for PostgreSQL, for instance:
<p><blockquote> dbi:Pg:port=5421;db=testdb</blockquote>
<p>The three parts in the above tutorial (create table, insert rows, select rows) will run the same on this postgresql $dbh (data base handle).
<p>The PostgreSQL flavour of SQL is here: [http://www.postgresql.org/docs/current/interactive/sql-commands.html|sql-commands.html]
896028
896028