free, lightweight sql engine

[Pierre Sahores]

Le mer 27/08/2003 à 09:46, revolution at knowledgeworks.plus.com a écrit :
> It is possible to access SQLite from Rev in two ways:
> 1) via odbc (requires installing odbc drivers with your standalone)
> 2) via shelling out to a command line, running the SQLite SQL client & processing the result.
> 
> I believe that Pierre mentioned that someone (Andu?) on the Metacard list has been using SQLite successfully.

Andu is the one ! He use both MC-CGI's and PHP's SQLite driven
solutions. 
> 
> I've written to Tuviah to say that I don't think that the author of SQLite would get involved in providing drivers for a specific language.  Other people are providing drivers for major languages (Python, Perl, PHP, Smalltalk, Objective-C).  As the code for SQLite is publicly available, I've offered to look at generating the drivers for Rev.  Of course, it would be best of all if Runrev took a look at SQLite and provided and supported the drivers.
> 
> I would suggest that anyone who wants to start looking at SQLite uses the odbc drivers, and looks to the SQLite list for any specific help with SQLite (http://www.yahoogroups.com/subscribe/sqlite).
> 
> People might want to have a look at some speed comparisons between SQLite, MySQL and PostgreSQL - http://sambar.polie.nl/sqllite.htm
> 
> >Your welcome to have the author of the database contact me and I will send
> >him the revdb headers...so he can compile a revdb driver. Should be fairly
> >straightforward.
> 
> >>Not sure, but I don't think it's currently possible; someone would have
> >>to write an external to use the SQLite client API or write a new
> >>database driver for RR.
>  
> Regards Bernard
> 
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
> 

Thanks for your input about the 2 ways yet availables :-)
-- 
Bien cordialement, Pierre Sahores

Inspection académique de Seine-Saint-Denis
Applications et SGBD ACID SQL (WEB et PGI)
Penser et produire "delta de rentabilité"