1. Simplest database management system for Euphoria?
- Posted by GreenEuphorian Jun 07, 2014
- 1791 views
What database management system would you recommend for a beginner to Euphoria who wants to learn the basics of relational database management? Something simple, please.
Is EDS still the "official" dabatase management system in Euphoria? I read on an old post that its binary search implementation is "embarrassingly obsolete". I honestly don't know much about databases, so I can't judge for myself as to what this criticism actually means, and whether it is valid. Does anyone care to explain, in brief? Above all, I need to know whether EDS would be the best starting point for an Euphoria learner to learn the basics of database functionality.
Thanks
2. Re: Simplest database management system for Euphoria?
- Posted by ChrisB (moderator) Jun 07, 2014
- 1817 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
3. Re: Simplest database management system for Euphoria?
- Posted by GreenEuphorian Jun 07, 2014
- 1781 views
Thanks. I believe that Euphoria's natively supported database system will be the best for my small needs. In addition to the reference documentation, is there any tutorial of it somewhere?
4. Re: Simplest database management system for Euphoria?
- Posted by ChrisB (moderator) Jun 08, 2014
- 1677 views
Hi
Sorry, been away a few days.
Not specifically, but the docs are fairly easy to follow
http://openeuphoria.org/docs/database.html#_654_euphoriadatabasesystemeds
Chris
5. Re: Simplest database management system for Euphoria?
- Posted by egis Jun 09, 2014
- 1702 views
It all depends on how much you know about relational databases. If you know nothing why not start a simple tutorial such as located at w3schools:
http://www.w3schools.com/sql/default.asp?PHPSESSID=300ae3404d5fa2612f238abeebb8869c
The next question I would ask is what kind of problem do you think you need a relational database for. For larger scale data (I do mapping) you can try out mariadb (mysqls creator) or mysql. If you require a small database you can try sqlite suggested in an earlier post (sqlite can get slow loading large tables). All of these databases are very fast for many applications.
Personally I don't have experience using euphorias native db.
I use a database utility edbi (do a search for edbi on this site). edbi interfaces with a number of databases so it opens the doors to a number of databases.
Best of luck.
