Re: Embeddable databases

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Gerrit (msng1_at_newsgroups.nospam)
Date: 02/11/05 

Date: Fri, 11 Feb 2005 11:15:37 +0100

I agree, but the clients are only using the database as "read-only data
store". I was originally going to use a XML file, but I need something I can
perform some simple queries on without having to load the entire
database/dataset into memory. The database is only going to be updated once
a week or so, so there will be no concurrency conflicts or even concurrent
writes. Just simple quieries.

Gerrit

"Frans Bouma [C# MVP]" <perseus.usenetNOSPAM@xs4all.nl> wrote in message
news:OmCVTf7DFHA.1936@TK2MSFTNGP14.phx.gbl...
> Gerrit wrote:
>> It looks like when using the embedded Firebird engine, only one user can
>> access the database file at the time. Do you know if this is true? Only
>> one user will write to the database, but it may happen that multiple
>> users will read from it at the same time (even though that is unlikely).
>
> that's not the purpose of an embedded db I think: the db in an embedded
> app is there to support the app, which is ran by the user. If you have
> multi-user requirements, I think a normal server database setup would be
> more appropriate...
>
> FB
>
>>
>> Gerrit
>>
>> "Frans Bouma [C# MVP]" <perseus.usenetNOSPAM@xs4all.nl> wrote in message
>> news:uxOsq05DFHA.4052@TK2MSFTNGP15.phx.gbl...
>>
>>> Gerrit wrote:
>>>
>>>> Hi.
>>>>
>>>> I'm looking for a relational and embeddable "file system based"
>>>> (non-client/server) database engine for .NET applications. Microsoft
>>>> JET (Access) is not an option, as it looks like it is being quietly
>>>> phased out without a replacement. So far I have found these three that
>>>> seem to be worth considering:
>>>> SQLite: http://www.sqlite.org
>>>> Firebird (embedded): http://www.dotnetfirebird.org
>>>> VistaDB: http://www.vistadb.net
>>>
>>>
>>> Firebird's embedded server is OK, however some very complex queries
>>> might fail. (8 joined tables or more). but then again, it's free and
>>> works OK. Also an advantage: a lot of tools support firebird, and with
>>> Carlos' excellent .NET provider for Firebird, you can develop against
>>> the firebird server, and move your code to an embedded situation with
>>> just a change in the connection string.
>>>
>>> Frans
>>>
>>> --
>>> ------------------------------------------------------------------------
>>> Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
>>> My .NET blog: http://weblogs.asp.net/fbouma
>>> Microsoft MVP (C#)
>>> ------------------------------------------------------------------------
>>
>>
>
>
> --
> ------------------------------------------------------------------------
> Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
> My .NET blog: http://weblogs.asp.net/fbouma
> Microsoft MVP (C#)
> ------------------------------------------------------------------------

Relevant Pages

  • Re: DBIx::XML::DataLoader
    ... Is there a package or utility that can read an XML file of the sort I ... The dbinfo specifies the login ... credentials to the database, and the database. ... And, I have no idea what XPATH is, let alone what to do with it. ...
    (comp.lang.perl.misc)
  • Re: XML parser and writer
    ... XStream, Castor, JAXB come to mind. ... why not some database technology? ... an advanced user can edit the XML file directly at ...
    (comp.lang.java.programmer)
  • Re: XML parser and writer
    ... them on a calendar. ... set for it and I was thinking of storing all the data in an XML file. ... why not some database technology? ... Tasklist the DOM would quickly become unwieldy especially if you have any ...
    (comp.lang.java.programmer)
  • RE: Backup Log Links dont work in Server Management Console
    ... Check the database connection information and make sure that the database ... "Rob Currier" wrote: ... It created a new xml file with the same name. ... >> for the backup and last backup is correct. ...
    (microsoft.public.windows.server.sbs)
  • DBIx::XML::DataLoader
    ... Is there a package or utility that can read an XML file of the sort I ... credentials to the database, and the database. ... Also obviously not all columns in the database are keys or indeces. ...
    (comp.lang.perl.misc)