![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Entry tags:
Database document software?
Something I've wished for several times recently is a database-document program.
By "document" I mean that the database is a single file, which I can move, copy, etc., as opposed to living in a database server which has to stay up, uses accounts and ACLs, needs special backup procedures, and so on. It doesn't need to support humongous data sets — fits-in-memory and even linear searches are fine.
I am aware that people use spreadsheets for such purposes, but I would like to have named, typed, and homogeneous columns, easy sorting/filtering/querying, etc. which I assume I'm not going to find there. Relational would be nice too.
It must be GUI, and run on Mac OS X, but it doesn't have to be thoroughly native — I can stand the better sort of Java or perhaps even X11 app.
And finally, it should have a file format that either is obvious how to parse, or has a specification, or is supported by many other programs.
Does such a thing exist?
(If not, I might write it.)
By "document" I mean that the database is a single file, which I can move, copy, etc., as opposed to living in a database server which has to stay up, uses accounts and ACLs, needs special backup procedures, and so on. It doesn't need to support humongous data sets — fits-in-memory and even linear searches are fine.
I am aware that people use spreadsheets for such purposes, but I would like to have named, typed, and homogeneous columns, easy sorting/filtering/querying, etc. which I assume I'm not going to find there. Relational would be nice too.
It must be GUI, and run on Mac OS X, but it doesn't have to be thoroughly native — I can stand the better sort of Java or perhaps even X11 app.
And finally, it should have a file format that either is obvious how to parse, or has a specification, or is supported by many other programs.
Does such a thing exist?
(If not, I might write it.)
no subject
(I've, generally speaking, become much more of a fan of sqlite over the past year or so.)
no subject
Does sqlite's file format meet my criteria? My use case is “I wrote this db-document ten years ago, I've changed/upgraded my computer/OS/apps, can I still read it?”
no subject
So, '10 years' is questionable, but sqlite hasn't changed much in the past Long-Time, and the development seems to keep backwards compatibility as an important principle, as I understand it... but I'm not positive.