Re: Euphoria + Database

new topic     » goto parent     » topic index » view thread      » older message » newer message

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.

new topic     » goto parent     » topic index » view thread      » older message » newer message

Search



Quick Links

User menu

Not signed in.

Misc Menu