Hi Anton,
After reading your other thread about DB locking and going over the spec yet again I see your point.
On one hand record-level locking has nothing to do with the location of the DB and could equally apply to an in-memory DB (which is what I was proposing) that is later flushed to disk.
On the other hand the "data file format" section talks about a 2 byte flag for each record to determine whether it's valid or has been deleted. As soon as you recognize that you know that the file is an archive of sorts, and is probably intended to be directly manipulated regularly.
So I didn't want to create a RDBMS but it looks like I'm coming close to it
I haven't had to "seek" since my C days (several years ago). Here's hoping...
Raj.