Re: What's a good database for a really simple app?

well if it is a small amount of data

you could also create the stuff as a object database and just serialize
and deserialize it to disk on startup and shutdown of your app

or just throw everything in a dataset and retrieve and store it to XML

regards

Michel Posseth [MCP]


"dgk" <dgk@xxxxxxxxxxxxx> schreef in bericht
news:hk9lr15c4rpt99rhpmpfr5j3bu68ldc3nk@xxxxxxxxxx
> On Tue, 3 Jan 2006 17:14:22 +0100, "Cor Ligthert [MVP]"
> <notmyfirstname@xxxxxxxxx> wrote:
>
>>dgk,
>>
>>A search in this newsgroup will surely give you this link, as well has
>>Paul
>>Clement written a lot about this.
>>
>>http://www.vb-tips.com/default.aspx?ID=e76b8450-4c8a-4662-8f41-d6dda3c888c8
>>
>>The same kind of samples are on our website for SQLServer and MySQL
>>
>>I hope this helps,
>>
>>Cor
>>
> Yes, that's the one. You had posted it two years ago. Still, what's
> the downside of creating a dataset in memory? My thought is to check
> if it's on disk at startup, create it if not, and serialize it as the
> app is shut down. I think that there's even an option to serialize it
> in a binary format now but XML would be sufficient. All I need are a
> few tables and if there are even a hundred rows for any of them I will
> be (happily) surprised.
>
> It's kind of like having a database without any database software at
> all. No versioning problems, no deployment issues. It won't work for
> anyone needing even a two user app, but for a single user app it
> should work.
>
> Of course, I can't use Access to look at it in a pinch. But maybe I
> can. Access can probably import a database from XML, and if not, it
> should be able to.


.

Relevant Pages

  • Re: Whats a good database for a really simple app?
    ... I think that there's even an option to serialize it ... It's kind of like having a database without any database software at ... anyone needing even a two user app, but for a single user app it ... Access can probably import a database from XML, and if not, it ...
    (microsoft.public.dotnet.languages.vb)
  • Re: High Avg. Disk Queue Length When Opening Shared Calendars
    ... Let's assume 10K spindles, a 3:1 read/write ratio, and IOPS/user of 1. ... Now let's look at the logs. ... the database LUN would become a bottleneck prior to the log LUN. ... A disk bottleneck on the database LUN. ...
    (microsoft.public.exchange.admin)
  • Re: Oracle Performance -- Possible Disk Bottleneck
    ... I've read that 15k drives can perform 180 IO's per second. ... confirm this is a disk bottle neck. ... so I'm hoping someone here has experience with SANs and ORACLE to help ... this is a disk bottleneck and that giving the database more spindles ...
    (comp.databases.oracle.server)
  • [PATCH] inotify: add hook to catch fsync/msync events
    ... I actually excluded msync events when the MS_ASYNC flag is specified. ... application will perform an fsync to safely store data on disk. ... In my specific case I am using a database engine that supports ... +static inline void fsnotify_sync ...
    (Linux-Kernel)
  • Re: Chaotic IMAP Message list
    ... bits of the database which are scattered about on your hard disk into a new ... break at an unfortunate location in the database. ... I was busy and didnšt read carefully so I thought you were advocating the more complete rebuild solution. ... or can you offer a thumbnail explanation of what happened and why a compact would fix it? ...
    (microsoft.public.mac.office.entourage)