noob postgresql user question

[Seth Gordon]

BTW, for small and medium-size database-backed Web sites, you might be 
better off using SQLite than PostgreSQL (or MySQL).  An SQLite database 
is just a file, and authentication is handled at the Unix layer: a 
process that can read the file can read from the database, and a process 
that can write to the file can write to it.  No muss, no fuss.

(Also no stored procedures, no running your Web server and your database 
server on different machines, no authorization schemes along the lines 
of "user X can select from table A but not table B".)