[Mono-list] [Mono-aspnet-list] sqlite questions?

[Michael J. Ryan]

On 11/3/2009 1:43 AM, Gonzalo Paniagua Javier wrote:
 > On Tue, 2009-11-03 at 08:35 +0000, william leader wrote:
 >> I would suggest you consider using another database altogether. SQLite
 >> is meant to interface with c and c++ programs, neither of which is a
 >> language mono supports.
 > [...]
 >
 > I would suggest you do some research before giving advice to other
 > people. A simple Google search for the words "Sqlite mono" (who would
 > have thought of those?) would have been enough.

Beyond that, FirebirdSQL has a very mature set of drivers for Mono, as well as 
feature rich support with NHibernate/Castle ActiveRecord/Fluent etc...

There's also PostgreSQL.

One bit of caution is that SQLite really won't scale well if there's a single 
database with many people connecting at once (for writes)... It'll go a little 
further than say Access/Jet but not nearly as much as a service based rdbms. 
It may be a decent database for certain implementations, and if you can 
segment the data into separate DBs it'll scale better under load.

-- 
Michael J. Ryan - http://tracker1.info/

... FRA #059: Free advice is seldom cheap.