HMGSQL - HMG -> MySQL/PostgreSQL/SQLite Bridge
Moderator: Rathinagiri
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
HMGSQL - HMG -> MySQL/PostgreSQL/SQLite Bridge
I am happy to share with you HMGSQL a 3-in-one library for connecting and manipulating MySQL, PostgreSQL and SQLite databases easily in HMG.
Download the following file and extract it in c:\hmg.
Follow the instructions in c:\hmg\hmgsql\doc\index.htm.
This is initial version. Please do give your comments and suggestions for improvement. Thanks Sudip for inducing me to create PostgreSQL bridge.
Download the following file and extract it in c:\hmg.
Follow the instructions in c:\hmg\hmgsql\doc\index.htm.
This is initial version. Please do give your comments and suggestions for improvement. Thanks Sudip for inducing me to create PostgreSQL bridge.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
- luisvasquezcl
- Posts: 1258
- Joined: Thu Jul 31, 2008 3:23 am
- Location: Chile
- Contact:
Re: HMGSQL - HMG -> MySQL/PostgreSQL/SQLite Bridge
Muchas gracias Rathi.
como siempre haciendo buenos aportes.
saludos cordiales,
luis vasquez
como siempre haciendo buenos aportes.
saludos cordiales,
luis vasquez
Re: HMGSQL - HMG -> MySQL/PostgreSQL/SQLite Bridge
Thank you very much for writing this library and sharing it with us. As you can see it is already downloaded many times. Right now, I am using ODBC and slowly shifting to PGRDD, which lets me use the regular dbase syntax, which is more legible IMHO.
I am very interested in this development. Is your software also an RDD, or will it require to manipulate arrays filled with data? If I understand your Doc-file correctly, it is not an RDD.
Could you explain the advantage over RDDs? Please excuse me, if my question is too stupid. I have not done much playing around with your code.
Raumi
I am very interested in this development. Is your software also an RDD, or will it require to manipulate arrays filled with data? If I understand your Doc-file correctly, it is not an RDD.
Could you explain the advantage over RDDs? Please excuse me, if my question is too stupid. I have not done much playing around with your code.
Raumi
Raumi75 http://raumi75.jimdo.com
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: HMGSQL - HMG -> MySQL/PostgreSQL/SQLite Bridge
Hi Raumi,
Thanks for your concern.
It is not RDD. It requires retrieval of data into arrays.
Advantage over RDDs?
Well, if you want to use only SQL queries for data manipulation, then it will be easy to use this library.
Thanks for your concern.
It is not RDD. It requires retrieval of data into arrays.
Advantage over RDDs?
Well, if you want to use only SQL queries for data manipulation, then it will be easy to use this library.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
Re: HMGSQL - HMG -> MySQL/PostgreSQL/SQLite Bridge
Great work, Rathi Thanks a lot
My dream is coming true.
I created libraries (after changing some files, as I am using hmg from e: drive). I shall test and send my feedback
After 5 minutes:
For my case, it will reduce the source code size, as I am using sql.prg (after some minor modifications) with all my projects.
My dream is coming true.
I created libraries (after changing some files, as I am using hmg from e: drive). I shall test and send my feedback
After 5 minutes:
For my case, it will reduce the source code size, as I am using sql.prg (after some minor modifications) with all my projects.
With best regards,
Sudip
Sudip
Re: HMGSQL - HMG -> MySQL/PostgreSQL/SQLite Bridge
Thank you for explaining. I also have some SQL-Queries in my code and will give it a try. If I understand you right, it will help my use the same SQL-Statements no matter if I use MySQL, PostgreSQL or SQLite.
I will let you know about my experience.
Raumi
I will let you know about my experience.
Raumi
Raumi75 http://raumi75.jimdo.com
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: HMGSQL - HMG -> MySQL/PostgreSQL/SQLite Bridge
Yep. That is it! But there are some package specific issues too! For example, in SQLite, you don't have IF() function inside SQL Query. However, there is a work-around method available for that.raumi75 wrote:Thank you for explaining. I also have some SQL-Queries in my code and will give it a try. If I understand you right, it will help my use the same SQL-Statements no matter if I use MySQL, PostgreSQL or SQLite.
I will let you know about my experience.
Raumi
Awaiting your experience.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
-
- Posts: 132
- Joined: Thu Jul 31, 2008 12:05 pm
Re: HMGSQL - HMG -> MySQL/PostgreSQL/SQLite Bridge
Hello Rathi.
Muy bueno tu aporte.
Estuve probando las lib este fin de semana y funcionan OK.
Quisiera saber si dichas LIB (HMGSQL 0.10) estaran disponibles en versiones nuevas de HMG o habran que instalarla?
Muchas Gracias y perdon por la traducción
Claudio
Hello Rathi.
Very good your contribution.
I tested the lib this weekend and work OK.
I wonder if the LIB (HMGSQL 0.10) will be available in new versions of HMG or have to be installed?
Thank you very much and sorry for the translation
Claudio
Muy bueno tu aporte.
Estuve probando las lib este fin de semana y funcionan OK.
Quisiera saber si dichas LIB (HMGSQL 0.10) estaran disponibles en versiones nuevas de HMG o habran que instalarla?
Muchas Gracias y perdon por la traducción
Claudio
Hello Rathi.
Very good your contribution.
I tested the lib this weekend and work OK.
I wonder if the LIB (HMGSQL 0.10) will be available in new versions of HMG or have to be installed?
Thank you very much and sorry for the translation
Claudio
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: HMGSQL - HMG -> MySQL/PostgreSQL/SQLite Bridge
Thanks for checking out Claudio.
I am happy that, it is helpful to somebody.
I am happy that, it is helpful to somebody.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
-
- Posts: 5
- Joined: Wed Apr 02, 2014 11:45 am
Re: HMGSQL - HMG -> MySQL/PostgreSQL/SQLite Bridge
Hi everyone
I'm still a "newbie" using this software. I was a clipper programmer back on the 90's but i'm been away long time!
Now I was searching for new kinda programming languages (without the need to pay to use the language), and I was happy to find out about this projects!
Well I found on the installation of HMG 3.2 a folder called HMGSQL .. i've read the document on the Doc Folder and then i came to this
3. Under c:\hmg\hmgsql\source directory run makehmgsql.bat. Three files namely libhmgmysql.a, libhmgpgsql.a, libhmgsqlite.a will be created in c:\hmg\lib directory. The corresponding library should be linked while compiling your program.
This has been done. and the files are on the c:\hmg\lib
4 (a). In HMG-IDE, select tools->preferences
(b). Add in additional libraries 'hmgmysql' or 'hmgpgsql' or 'hmgsqlite' as the case may be without quotes.
Well I open the IDE but i don't see the place to put the additional libraries .....
Only appears on my preferences of the IDE a place to put the code editor that is NOTEPAD++!
Can anybody help me on this?
I'm still a "newbie" using this software. I was a clipper programmer back on the 90's but i'm been away long time!
Now I was searching for new kinda programming languages (without the need to pay to use the language), and I was happy to find out about this projects!
Well I found on the installation of HMG 3.2 a folder called HMGSQL .. i've read the document on the Doc Folder and then i came to this
3. Under c:\hmg\hmgsql\source directory run makehmgsql.bat. Three files namely libhmgmysql.a, libhmgpgsql.a, libhmgsqlite.a will be created in c:\hmg\lib directory. The corresponding library should be linked while compiling your program.
This has been done. and the files are on the c:\hmg\lib
4 (a). In HMG-IDE, select tools->preferences
(b). Add in additional libraries 'hmgmysql' or 'hmgpgsql' or 'hmgsqlite' as the case may be without quotes.
Well I open the IDE but i don't see the place to put the additional libraries .....
Only appears on my preferences of the IDE a place to put the code editor that is NOTEPAD++!
Can anybody help me on this?