OpenEuphoria

Re: SQLite just awarded open source award

• Posted by Chris Burch <chriscrylex at aol.com> Aug 19, 2005
• 516 views

D. Newhall wrote:
> 
> Chris Burch wrote:
> > 
> > 
> > Matt, you are a far better and more prolificprogrammer than me, and euSQL is
> > a great
> > piece of work, but anybody who wants to do serious (lightweight) SQL
> > database programming,
> > should look at SQLite, and Ray Smith's euSQLite database (updated and
> > maintained by
> > me).
> > 
> > SQLite has flavours for windows and Linux, is extremely small, is very very
> > fast, is
> > web / CGI enabled, with many servers already offering it as a service, and,
> > the most
> > important one, euSQL is specific to euphoria, and as a consequence the
> > databases are
> > not transportable - SQLite has wrappers for perl, basic, ruby, python,
> > delphi etc etc
> > etc.
> 
> Yeah, but arguably more importantly is that there is a MySQL library in the
> archive.
> MySQL is much more popular than SQLite. SQLite wrappers are important but not
> every
> webhost supports SQLite databases but almost all have MySQL.

No argument from me there, since I know sfa about web database programming 

> 
> Sadly, we don't have a PostgreSQL library yet (which in my case is the most
> important
> since my job uses it). Once we get that all the popular SQL databases will be
> covered
> so there'll be no reason not to use Euphoria for database programming.
> 

What drew me to SQLite is its size (it really is tiny), and really quick, large
(but admittedly not as large as MySQL, and postgresql) featureset, and the fact
that for the program I'm writing, I didn't need the feature set, the overheads,
and the maintaimnence input inherent in the larger ones. Cross platformness was
quite nice too.

Chris

> 
> The Euphoria Standard Library project :
>     <a href="http://esl.sourceforge.net/">http://esl.sourceforge.net/</a>
> The Euphoria Standard Library mailing list :
>     <a
>     href="https://lists.sourceforge.net/lists/listinfo/esl-discussion">https://lists.sourceforge.net/lists/listinfo/esl-discussion</a>
> 


http://members.aol.com/chriscrylex/euphoria.htm
http://uboard.proboards32.com/
http://members.aol.com/chriscrylex/EUSQLite/eusql.html