1. EuSQL and EDB
Hello,
I've submitted to Rob an update to EuSQL (anyone currently using EuSQL
should upgrade, as this has several bug fixes and some optimizations) and
EDB (Euphoria Database Browser).
EDB will be useful for anyone working with EDS databases, as it allows you
to view, create and edit EDS databases. If you're using EuSQL databases, it
also allows you to run SQL statements interactively. The only things
planned but not implemented are the import and export features (plus, of
course, running on Linux). You will need the wxEuphoria DLL in order to run
this, though you don't need the wxEuphoria library source, since I've done a
clear shroud on it, as the library is somewhat in flux right now. I've also
included the main source to edb.exw, if you're interested in seeing how to
work with wxEuphoria.
You can get EDB (~200K) at:
http://www14.brinkster.com/matthewlewis/projects.html
and the DLL (~1MB) at:
http://www.sourceforge.net/projects/wxeuphoria
Matt Lewis
2. EuSQL and EDB
I've put up new versions of EuSQL (v0.74) and EDB. EDB is mainly bug
fixes. I've added the ability to prevent EDB from resizing the data
columns automatically.
EuSQL v0.74 has some major optimizations (well, really I just trashed
some of the lame algorithms I had in there) for SELECT queries. I've
seen up to 25 times faster queries (depending on the size of the tables
and how well the tables have been indexed). There are also bug fixes to
the UPDATE and DELETE queries. I've added the IN() keyword, and changed
the precedence of evaluation for boolean operators, so that conditional
expressions read a lot more naturally (you don't need to put everything
into parenthesis).
The updates are available at
http://www14.brinkster.com/matthewlewis/projects.html
Matt Lewis
3. Re: EuSQL and EDB
- Posted by sixs at ida.net
Apr 21, 2003
Hi, Idownloaded the EUSQL andEDB from your website. I tried to run SqlRep1
program to try the delete of a record. Iget the message is
C:\Euphoria\DEMO\Esq74\eusql.e:5704
db_rename_table has not been declared
db_rename_table( table_name, new_name )
I find a procedure in EDBS exw by that name.Maybe I haven't installed
something properly
JIm
----- Original Message -----
From: "Matt Lewis" <matthewwalkerlewis at yahoo.com>
To: "EUforum" <EUforum at topica.com>
Subject: EuSQL and EDB
> I've put up new versions of EuSQL (v0.74) and EDB. EDB is mainly bug
> fixes. I've added the ability to prevent EDB from resizing the data
> columns automatically.
>
> EuSQL v0.74 has some major optimizations (well, really I just trashed
> some of the lame algorithms I had in there) for SELECT queries. I've
> seen up to 25 times faster queries (depending on the size of the tables
> and how well the tables have been indexed). There are also bug fixes to
> the UPDATE and DELETE queries. I've added the IN() keyword, and changed
> the precedence of evaluation for boolean operators, so that conditional
> expressions read a lot more naturally (you don't need to put everything
> into parenthesis).
>
> The updates are available at
>
> http://www14.brinkster.com/matthewlewis/projects.html
>
> Matt Lewis
>
>
>
> TOPICA - Start your own email discussion group. FREE!
>
>
