![]() I do everything with prepared statements and transactions so I’m doing ACID and fine in 99% of the cases.įrom tiny to larger clustered setups, I see MySQL as an allrounder that never gave me any problems. I don’t know what it’s for but in my case (unless there are specific requirements) I always stick with MySQL (stable releases) and InnoDB. So where the files sit is less important given those constraints.Īny specific reason why MySQL isn’t in your list? You don’t want to be connecting directly to the files while simultaneously running it in server mode. Remember if you are running in server mode then it’s accessing the raw database files. On a Mac this is less interesting because its likely already in an intelligent location. You can on the server side if I recall change the default directories in the configuration. They may share components and the library may be capable of working in either mode but at the end of the day… the server is handling the files. The plugins/libraries you utilize to access it are just client connection libraries and not the full stack. When you are using it in server mode the server handles placement of the database files. You are utilizing the Valentina plugins/libraries to manipulate that database file wherever it sits. So when you are using it in embedded form as say a companion database to a desktop app you can place it wherever you want it. However the server component of it makes it a full fledged server that can handle multiple connections. However the database is primarily designed for embedded use. I don’t work for Valentina so I can’t say officially. 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. It really surprised me simple tasks like those above appeared to be so difficult. The five user limit works just fine!Īre 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. Which is when I discovered those connections were not really going away, just not displaying. ![]() Also, the connection display on the GUI seemed to disappear, so I had to login more than once. 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. 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. Lots of things to like about this little database 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. However, that limits the possible database servers, and I was looking at Valentina DB Server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |