Page 1 of 5
SQLWIN - a free RDD for SQL
Posted: Wed Sep 10, 2008 4:57 am
by Antonio Linares
We start the development of SQLWIN, a free and open source RDD for SQL.
All of you interested in learning and use SQL are welcome to join this project. You can already download a very early prototype, but that can be already compiled and tested:
www.fivetechsoft.com/files/sqlwin.zip
The source code is licenced with the same Harbour licence (not included yet in its code). We start from the ADORDD source code, but just to use its structure, that will be totally redesigned.
Please visit also the spanish thread where some developers have already joined the project:
http://forums.fivetechsoft.com/viewtopic.php?t=12645
Posted: Wed Sep 10, 2008 5:00 am
by Antonio Linares
At this stage we are not making a real connection yet.
We are focused to translate all the RDD Db...() functions into their equivalent SQL sentences.
On a next step we will create real connections to the database engines. By now, we are using a "virtual" DBF for testing purposes.
Posted: Wed Sep 10, 2008 5:50 am
by Antonio Linares
New version that implements the emulated values "sql_recno" and "sql_deleted", and a first DbGoTop() version:
www.fivetechsoft.com/files/sqlwin.zip
Posted: Wed Sep 10, 2008 6:36 am
by Antonio Linares
New version that implements DbGoTo():
www.fivetechsoft.com/files/sqlwin.zip
Posted: Wed Sep 10, 2008 6:53 am
by Antonio Linares
New version that implements RecNo() and RecCount():
www.fivetechsoft.com/files/sqlwin.zip
Posted: Wed Sep 10, 2008 6:58 am
by Roberto Parisi
Hi Antonio,
what's the difference with adordd?
Regards,
Roberto Parisi
Posted: Wed Sep 10, 2008 7:06 am
by Antonio Linares
Roberto,
ADORDD is based on Microsoft ADO, and if has the limitations imposed by ADO.
SQLWIN is based on SQL that will be executed against different database engines or through ODBC, and it does not use ADO.
We have found that ADO imposes restrictions to mimic a full working RDD, in the sense that you may replace DBFCDX or DBFNTX with ADORDD and just recompile your app, with very few changes (database string connection info).
Using SQL we may be able to bypass those restrictions and implement a complete RDD, that may be able to replace DBFCDX or DBFNTX.
Posted: Wed Sep 10, 2008 7:13 am
by Roberto Parisi
Thx Antonio,
it looks quite interesting.
What are the target databases?
Regards,
Roberto Parisi
Posted: Wed Sep 10, 2008 7:21 am
by Antonio Linares
Roberto,
> What are the target databases?
We may start with the most widely used ones like MySQL, MS SQL, Oracle, Informix, etc.
But our idea is to support as much of them as possible
Posted: Wed Sep 10, 2008 7:32 am
by Antonio Linares
New version that implements PACK command (__DbPack()):
www.fivetechsoft.com/files/sqlwin.zip
Posted: Wed Sep 10, 2008 7:40 am
by Antonio Linares
New version that implements ZAP command (__DbZap()):
www.fivetechsoft.com/files/sqlwin.zip
Posted: Wed Sep 10, 2008 9:31 pm
by Rossine
Olá Antonio,
Seria possível fazer esta classe funcionar com firebird ou postgres ?
Obrigado e parabéns pela iniciativa
Rossine.
Posted: Thu Sep 11, 2008 1:24 pm
by Antonio Linares
Rossine,
> Seria possível fazer esta classe funcionar com firebird ou postgres ?
Si, claro que si. Podemas hacer que funcione con cualquier motor de bases de datos que soporte SQL
.
Yes, of course. We can make it make it work with any database engine that supports SQL
Posted: Thu Sep 11, 2008 1:27 pm
by Antonio Linares
New version that modifies the sql_recno as NOT NULL, AUTO_INCREMENTAL and UNIQUE. Also some changes for sql_deleted NOT NULL. More cleaned code and tested with Harbour and xHarbour:
www.fivetechsoft.com/files/sqlwin.zip
Posted: Fri Sep 12, 2008 4:26 pm
by vailtom
Hi Antonio!
This RDD is designed only for FiveWin? You want to run this RDD on Linux too?
Sorry for my bad english!