Having no affiliation with this company whatsoever and have to say this is a bit unfair towards this excellent db. It’s true it’s not free, but some people like paying for the benefits of a database. I’m looking at Daylite (crm/erp application for macos x) for example which is using the commercial Openbase because of it’s excellent stability, transparent offline synchronisation capabilities etc.
I’ve used Valentina with a few of the other languages that it supports and in terms of speed, it blows away the other dbs away easily. What I particularly liked about it when using it in conjunction with REALbasic (which can be great for low budget applications), was its object-relational nature, binary links (habtm without a real table) and its random virtual recordset access. Instead of having to use LIMIT and OFFSET, you could query a recordset that let’s say yields a 50,000 record result, then randomly say: well, get me object 10,212 to 10,500 and 35,141 and 44,984 to 45,014 and send it over to me. There’s a whole lot of query parsing and seperate queries involved if you’d be using plain sql for this. I don’t know how far this support is backed into their adapter, but if it is, you’ll be pleasantly surprised.
To give you a simple example, in a company I used to work for, a prospect asked us to make his very large database with quite a few linked tables live searchable locally on those old clamshell ibooks and some superslow dell laptops. I spent about one day, maybe even a little less and I had both the Windows and Mac version of the app compiled and ready to run, including an import procedure to import all the data. Every keydown in the app narrowed the list down almost instantly using a random access datagrid, and I’m talking about some fulltext searched fields here too or you could browse through all of the records using the scrollbar. We never deemed such a thing possible on those old machines, still Valentina did it without a fuss.
Also, if you look at the licensing scheme, it’s a lot more clear than MySQL’s, which is not as free as you claim it to be.
Peter De Berdt