OpenEuphoria

Re: SQLite just awarded open source award

• Posted by Tone Škoda <tskoda at email.si> Aug 20, 2005
• 585 views

SQL LIKE operator can be used for pattern match. Now I'm having trouble finding
out which (free) databases use this keyword efficiently for left or doubly
truncated wildcards: %oria: Euphoria, Doria

I'm thinking that you have to know in what structure database stores data to be
able to use it efficiently. Is there documentation for that?


Chris Burch wrote:
> 
> Hi
> 
> See
> <a
> href="http://osdir.com/Article6677.phtml">http://osdir.com/Article6677.phtml</a>
> 
> 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.
> 
> I cannot possibly knock Matts efforts (please don't think this is some sort of
> ego
> trip competition type thing, its not), but RDS should be screaming from the
> rooftops
> that euphoria has SQLite wrappers available.
> 
> Its small enough to use for day to day quick storage of stuff too.
> 
> See the links at the bottom of the page.
> 
> Chris.
> 
> 
> <a
> href="http://members.aol.com/chriscrylex/euphoria.htm">http://members.aol.com/chriscrylex/euphoria.htm</a>
> <a href="http://uboard.proboards32.com/">http://uboard.proboards32.com/</a>
> <a
> href="http://members.aol.com/chriscrylex/EUSQLite/eusql.html">http://members.aol.com/chriscrylex/EUSQLite/eusql.html</a>
>