Database document software?
Thursday, October 30th, 2008 16:22![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
kpreidSomething 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.)
