I was looking at databases last night for a customer who is totally Mac centric- runs stuff only on Macs and has since the 90s. I like this guy myself…
However, that limits the possible database servers, and I was looking at Valentina DB Server. I like the way they seems to think on their website, I like the prices, I like there is developer support, nice that they offer a small 5 user version of it at no cost, and so on. Lots of things to like about this little database server.
However, after licensing the server and getting it running correctly, I managed to get myself stumped twice in the GUI application; it allowed me to define a table, with an index and so forth, but not to save it. Also, I could not find any easy way to tell it where I wanted to put the database files, it just kinda stuffed them where it wanted. Also, the connection display on the GUI seemed to disappear, so I had to login more than once. Which is when I discovered those connections were not really going away, just not displaying. The five user limit works just fine!
Are any of you guys using this database? Do you feel it be worthwhile to find the manuals and read through them? I am not the worlds most expert DB person, but I have not had trouble wrangling various versions of DB2, Oracle, Informix, Empress, Ingress, ADABAS and others around to my liking. It really surprised me simple tasks like those above appeared to be so difficult.
Of course, I many be misjudging the beastie- if it is primarily intended as an embedded database, that may be why it didn’t act as I expected. Or I may be a victim of tunnel vision.
Opinons welcome please.