Welcome! and rules
Joel on Software
Comments on using postgreSql or sqlite?
I saw a few post here about .net with postgreSql or sqlite but only a few comments about which of these one would prefer to use and why, and -important also- which data provider seems to work best..
I believe sqlite is the back-end for the Meedio HTPC product (www.meedio.com). It seems to work well there...
You'd have to mention what your platform is.
The platform is Windows (ASP.NET).
SQLite is designed to be used as an embedded db. PG is designed for use in client/server situations.
I think your best bet is to code against the generic interfaces (IDbConnection, IDbCommand, etc). Why tie yourself to a specific provider if you don't have to?
Fog Creek Home