Re: Simplest database management system for Euphoria?
- Posted by ChrisB (moderator) Jun 07, 2014
- 1908 views
Hi
Eu has access to quite a few database management systems. Its worthwhlie doing a little research as to what type of system you want.
They start at the very simple, easy to use EDBS, which is pretty much single user one computer, with its own set of database reading commands. Install euphoria and its installed to.
Next would be sqlite (my favourite) www.sqlite.org, is still pretty much single user (though I use it with multiple users, and an external record locking system, but its also great for small flatfile storage systems, as it provides a little more versatility than a simple flat file, and is very small. Install the sqlite dlls / shared libraries, and the eusqlite wrapper, and you're pretty much set, http://eusqlite.wikispaces.com/ This is my favourite. It also use the industry standard SQL (Structured Query Language) to access the database, so is a great way to actually learn SQL (if I recall Matt may have created a wrapper to EDBS using SQL). There are also helper functions in eusqlite to make database access exceptionally easy. Its fast too.
Finally would be the client / server models, which the likes of mysql and so on use. A computer acts as a server which serves the database requests from clients either on the computer being used, or other computers. This system handles multiple users and record locking itself, feeding back results to clients. It is more complicated to set up (you have to set up ODBMS for the server, and though I don't use this system myself, can be more tricky to maintain, but on the upside larger databases can be handled than the above, although I am currently using sqlite with a database over 1 Gb in size. Again SQL is used to access the database.
Jeremy has also created a multi database wrapper to access whatever database you have installed, using whatever method is required, which may be of interest to you.
Chris
