Fog Creek Software
Discussion Board

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..

The goal is actualy to find a free DB, including for comercial use: see my OP here for background infos.. (god I love the tinyUrl's toolbar button!)

See this post about sqlite:
and this one about postgreSql:

Comments anyone? Thanks in advance!

Thursday, October 28, 2004

I believe sqlite is the back-end for the Meedio HTPC product ( It seems to work well there...

Thursday, October 28, 2004

You'd have to mention what your platform is.

I'd like to use Postgres, but I'm waiting for the native Windows version.

    Flava Flav!

Flava Flav
Thursday, October 28, 2004

The platform is Windows (ASP.NET).

Friday, October 29, 2004

SQLite is designed to be used as an embedded db.  PG is designed for use in client/server situations.

Jonathan Ellis
Tuesday, November 2, 2004

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?

Len Weaver
Thursday, November 11, 2004

*  Recent Topics

*  Fog Creek Home