1. SQLite just awarded open source award
Hi
See
http://osdir.com/Article6677.phtml
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.
http://members.aol.com/chriscrylex/euphoria.htm
http://uboard.proboards32.com/
http://members.aol.com/chriscrylex/EUSQLite/eusql.html
2. Re: SQLite just awarded open source award
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.
>
> 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.
>
No offense taken. I wrote EuSQL, in part, to see if it could be done. Also,
I think it's good to have something that's pure Eu. One of the nice things
about EuSQL is that since it sits on top of EDS, you can use that lower level
of access if you need to. That said, I doubt I'll manage to match almost
any 'real' db package out there for features or speed. I like that some
other people have found some use for it.
Matt Lewis
3. Re: SQLite just awarded open source award
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).
Chris, how would I go about setting that up on my web server? With Euphoria
and EDS, I don't have to have an external linked file or DLL. I wonder if it
would be possible to put the SQLite linked file into a local directory on my
web host's Linux box and call it from there...? I'd like to test it if only
to try it out.
-=ck
"Programming in a state of EUPHORIA."
http://www.cklester.com/euphoria/
4. Re: SQLite just awarded open source award
- Posted by D. Newhall <derek_newhall at yahoo.com>
Aug 19, 2005
-
Last edited Aug 20, 2005
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.
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.
The Euphoria Standard Library project :
http://esl.sourceforge.net/
The Euphoria Standard Library mailing list :
https://lists.sourceforge.net/lists/listinfo/esl-discussion
5. Re: SQLite just awarded open source award
- Posted by Chris Burch <chriscrylex at aol.com>
Aug 19, 2005
-
Last edited Aug 20, 2005
cklester 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).
>
> Chris, how would I go about setting that up on my web server? With Euphoria
> and EDS, I don't have to have an external linked file or DLL. I wonder if it
> would be possible to put the SQLite linked file into a local directory on my
> web host's Linux box and call it from there...? I'd like to test it if only
> to try it out.
>
> -=ck
> "Programming in a state of EUPHORIA."
> <a
> href="http://www.cklester.com/euphoria/">http://www.cklester.com/euphoria/</a>
>
Hi
Unfortunately, this is way above me, I don't do any web database programming, so
I've never had any need to look into it.
If your host doesn't give you access to sqlite (which would actually be a bit
surprising), they shouldn't have too many problems with adding it - its very well
known, and its a tiny install. Failing that, try adding it to your user space,
and try specifying the path to the library in eusqlite3.ew.
Let me know if it works.
Chris
http://members.aol.com/chriscrylex/euphoria.htm
http://uboard.proboards32.com/
http://members.aol.com/chriscrylex/EUSQLite/eusql.html
6. Re: SQLite just awarded open source award
- Posted by cklester <cklester at yahoo.com>
Aug 19, 2005
-
Last edited Aug 20, 2005
D. Newhall wrote:
> Chris Burch wrote:
> > 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.
The problem with both solutions (SQLite and MySQL) is that most web hosts
require extra dough to set those up for you, or you have to install an extra
.so or .dll. With a EDS, it's all Euphoria, all the time.
I still don't know why Rob hasn't put this forum into a Euphoria database, at
least as a cool demo of the technology. :)
-=ck
"Programming in a state of EUPHORIA."
http://www.cklester.com/euphoria/
7. Re: SQLite just awarded open source award
- Posted by Chris Burch <chriscrylex at aol.com>
Aug 19, 2005
-
Last edited Aug 20, 2005
cklester wrote:
>
> D. Newhall wrote:
> > Chris Burch wrote:
> > > 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.
>
> The problem with both solutions (SQLite and MySQL) is that most web hosts
> require extra dough to set those up for you, or you have to install an extra
> .so or .dll. With a EDS, it's all Euphoria, all the time.
Yes, I can see that as a big plus. But don't they also have to set up euphoria
as an executable? If I remember rightly from briefly looking at these things, not
many host providers like users installing executable programs themselves.
>
> I still don't know why Rob hasn't put this forum into a Euphoria database, at
> least as a cool demo of the technology. :)
He he - isn't it already - now what would be REALLY cool would be if we could
have the choice of a forum style, or list style, written in eu, style selectable
by the user (guess what style I would have!)
Chris
>
> -=ck
> "Programming in a state of EUPHORIA."
> <a
> href="http://www.cklester.com/euphoria/">http://www.cklester.com/euphoria/</a>
>
http://members.aol.com/chriscrylex/euphoria.htm
http://uboard.proboards32.com/
http://members.aol.com/chriscrylex/EUSQLite/eusql.html
8. Re: SQLite just awarded open source award
- Posted by Chris Burch <chriscrylex at aol.com>
Aug 19, 2005
-
Last edited Aug 20, 2005
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
9. Re: SQLite just awarded open source award
- Posted by cklester <cklester at yahoo.com>
Aug 19, 2005
-
Last edited Aug 20, 2005
Chris Burch wrote:
> cklester wrote:
> > The problem with both solutions (SQLite and MySQL) is that most web hosts
> > require extra dough to set those up for you, or you have to install an extra
> > .so or .dll. With a EDS, it's all Euphoria, all the time.
> Yes, I can see that as a big plus. But don't they also have to set up euphoria
> as an
> executable?
Not in my case and Rob's case. We both just plopped down the exu file into
a cgi-bin or whatever and off we go.
> If I remember rightly from briefly looking at these things, not many host
> providers like users installing executable programs themselves.
That would probably be true for the unpaid or free accounts, but not so for
my host provider (http://www.webintellects.com/). I just checked, and for
$108/yr, I get 5 MySQL databases. I wonder if those have to be in a certain
directory though. I'll check into it.
-=ck
"Programming in a state of EUPHORIA."
http://www.cklester.com/euphoria/
10. Re: SQLite just awarded open source award
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>
>
11. Re: SQLite just awarded open source award
Tone Škoda wrote:
>
> 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?
>
Hi
SQLite is free, uses LIKE very efficiently (as does euSQL!)
There are tons of SQL tutorials on the web - look at the bottom link below, or
google an SQL tutorial. (Is google a verb now?)
in SQLite, if you want to find the structure of a database use the master
keyword
eg SELECT * FROM sqlite_master
will return a sequence containg all the tables, all the fields, and all the
field types of each of the fields
so, for your above request, you would have to know what fields you wanted to
look through, assuming it was the field 'strange_words' in the table 'stuff',
then you would do
SELECT * FROM stuff WHERE strange_words LIKE '%oria'
would select all the fields, or
SELECT strange_words FROM stuff WHERE strange_words LIKE '%oria'
of course these words would have to end in oria - if you wanted to look for oria
withinm the string, then
SELECT strange_words FROM stuff WHERE strange_words LIKE '%oria%'
As far as search efficiency goes, SQLite uses a btrieve search tree (I have no
idea what that means, but it sounds good), and there are benchmarks on the site (
www.sqlite.org )
Chris
http://members.aol.com/chriscrylex/euphoria.htm
http://uboard.proboards32.com/
http://members.aol.com/chriscrylex/EUSQLite/eusql.html
12. Re: SQLite just awarded open source award
Hi all,
Got to get a little plug in here :)
I wrote an SQLite db manager (Sequential) a while ago with Euphoria and Win32Lib
- works a treat. Screenshots available <a
href="http://www.purpletiger.com/index.php?pageid=sequential">Here</a>. I am
hoping to make it commercially available soon, but with a slightly hamstrung demo
free to download (ie some features not active).
The Marina Manager software on the site is also a Euphoria, Win32Lib and SQLite
based tool.
Basically SQLite is really easy and fast to use with Euphoria.
For web servers all you need to do is ask the server people to upgrade PHP to
version 5 - which uses SQLite as another natively supported DB. That should
provide the necessary support modules etc to get SQLite to work. Though I would
have thought that a simple sqlite .so/.dll sitting somewhere accessable on the
server should be enough to get Eu CGI's to work ok!? I haven't tried SQLite on
the server yet - still using MySQL.
Cheers,
Dave
. .. : :: = == == = :: : .. .
Server-Side DB driven web sites,
Software Development
(and part-time games developer)
contact dave_p at purpletiger dot com
or probert.dave at gmail dot com
. .. : :: = == == = :: : .. .
13. Re: SQLite just awarded open source award
- Posted by Chris Burch <chriscrylex at aol.com>
Aug 20, 2005
-
Last edited Aug 21, 2005
Dave Probert wrote:
>
> Hi all,
>
> Got to get a little plug in here :)
>
> I wrote an SQLite db manager (Sequential) a while ago with Euphoria and
> Win32Lib -
> works a treat. Screenshots available <a
> href="http://www.purpletiger.com/index.php?pageid=sequential">Here</a>.
> I am hoping to make it commercially available soon, but with a slightly
> hamstrung
> demo free to download (ie some features not active).
>
> The Marina Manager software on the site is also a Euphoria, Win32Lib and
> SQLite based
> tool.
>
> Basically SQLite is really easy and fast to use with Euphoria.
>
> For web servers all you need to do is ask the server people to upgrade PHP to
> version
> 5 - which uses SQLite as another natively supported DB. That should provide
> the necessary
> support modules etc to get SQLite to work. Though I would have thought that a
> simple
> sqlite .so/.dll sitting somewhere accessable on the server should be enough to
> get
> Eu CGI's to work ok!? I haven't tried SQLite on the server yet - still using
> MySQL.
>
> Cheers,
> Dave
>
> . .. : :: = == == = :: : .. .
> Server-Side DB driven web sites,
> Software Development
> (and part-time games developer)
>
> contact dave_p at purpletiger dot com
> or probert.dave at gmail dot com
> . .. : :: = == == = :: : .. .
>
Nice one - email me when its done, and I'll link to it from the the eusqlite
page (if thats ok, of course)
Chris
http://members.aol.com/chriscrylex/euphoria.htm
http://uboard.proboards32.com/
http://members.aol.com/chriscrylex/EUSQLite/eusql.html
14. Re: SQLite just awarded open source award
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>
>
Chris, the Eusql link on the official sqlite page here:
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
still points to Rays obsolete page.
Thanks for all your work with Eusql. :)
Ken Rhodes
SuSE Linux 9.3
100% MicroSoft Free
