[Mono-aspnet-list] sqlite questions?
Michael J. Ryan
mygroups at tracker1.info
Thu Nov 5 01:16:20 EST 2009
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.
More information about the Mono-aspnet-list