Re: Euphoria + Database
- Posted by Anthill Nov 02, 2010
- 1547 views
Here is a summary of my notes for getting euphori + edbi + sqlite3 on linux...
- Installed sqlite3
- Download and install the Linux (x86) Debian package from http://openeuphoria.org/downloads/index.wc
- Download and extract http://bitbucket.org/jcowgar/edbi/get/tip.tar.gz (from http://bitbucket.org/jcowgar/edbi/downloads under Tags & snapshots) to /usr/share/euphoria (include are: /usr/share/euphoria/edbi/drivers, /usr/share/euphoria/edbi/edbi, /usr/share/euphoria/edbi/examples, and /usr/share/euphoria/edbi/License.txt
- cd to /usr/share/euphoria/edbi/drivers/sqlite3
- modify GNUmakefile and change $(EUDIR)/bin/eu.a to /usr/lib/eu.a
- run the command: make -f GNUmakefile
- the file edbi_sqlite3.so should now be created
- cd to /usr/share/euphoria/edbi/examples
- modify example.ex and changed the db_handle so that it points to a local database edbi:open("sqlite3:///data/sqlite/TM"). Notice that three slashes for an absolute path.
- run: eui example.ex
The output should read:
Name=Ronald Mc'Donald, Zip=29382, Dob=11/01/1978 Name=Super Man, Zip=55555, Dob=05/18/1944 Name=Wonder Woman, Zip=21232, Dob=09/29/1972 Name=Ronald Mc'Donald, Zip=29382, Dob=11/01/1978 Name=Super Man, Zip=55555, Dob=05/18/1944 Name=Wonder Woman, Zip=21232, Dob=09/29/1972
I used SQLite Database Browser to verify the insertion of data
Thank Jeremy! By the way I saw that you also can fly a glider. That is something I always wanted to do.