Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: RFC: Databases made easy

by erix (Vicar)
on Mar 24, 2011 at 21:26 UTC ( #895346=note: print w/ replies, xml ) Need Help??


in reply to RFC: Databases made easy

PostgreSQL, compared to SQLite, is a little more difficult to get started with, but for those who have already got over postgres' initial connection gotchas: the SQLite connection string that is used here ("dbi:SQLite:Test.sqlite") can be replaced with a connection string for PostgreSQL, for instance: "dbi:Pg:port=6542;db=testdb", and the three parts in the OP (create table, insert rows, select rows) will run exactly the same on such a postgresql $dbh (data base handle).

PostgreSQL flavour of SQL: sql-commands.html

SQLite remains a toy-database; IMHO one might as well start out with the real thing.


Comment on Re: RFC: Databases made easy

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://895346]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (10)
As of 2015-07-30 18:20 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (273 votes), past polls