OpenEuphoria

RE: database questions...

• Posted by Matthew Lewis <matthewwalkerlewis at YAHOO.COM> Oct 31, 2002
• 451 views

> From: rubis at fem.unicamp.br [mailto:rubis at fem.unicamp.br]

> 2- It's possible do make queries to a sql database using euphoria and 
> extract the results ? What information I need from de sql 
> database to do 
> this ?(I never work with sql !).

Yes.  You have a few alternatives, depending on what you want to do.

- There are a couple of ODBC (Open DataBase Connectivity) libs in the
archives (I think Tone's is a little more mature than the one I contributed,
which wasn't much more than a proof of concept).  This allows you to access
pretty much any database package out there.

- I've been working on a SQL engine for EDS (EuSQL).  The latest version is
up at www14.brinkster.com/matthewlewis/projects.html.  It still lacks a lot
of SQL functionality, and there are no doubt a lot of bugs lurking there,
but it might be suitable depending on your needs.

- I've gotten COM wrappers for Access to work with EuCOM (my lib that lets
you use COM objects in Eu).  I've got a much updated version of the lib that
I think is just about ready to be released.  Let me know if you're
interested, and I can email it as is.

- Several other people have wrapped certain specific db packages (MySQL,
SQLite,...)

Matt Lewis