Postgres or MariaDb
Moderator: Rathinagiri
- karweru
- Posts: 220
- Joined: Fri Aug 01, 2008 1:51 pm
- DBs Used: DBF,mysql,mariadb,postgresql,sqlite,odbc
- Contact:
Postgres or MariaDb
Dear Friends,
I have been using Sqlite for many years now. However, I have an urgent need to move to PostGres or MariaDb and is desperate for a step-by-step guidance of how to do it...a working sample i can compile from the IDE would really be useful.
I'm getting an error when i try the sample for postgres
I cant find examples for MariaDb
Kindly assist.
I have been using Sqlite for many years now. However, I have an urgent need to move to PostGres or MariaDb and is desperate for a step-by-step guidance of how to do it...a working sample i can compile from the IDE would really be useful.
I'm getting an error when i try the sample for postgres
I cant find examples for MariaDb
Kindly assist.
Kind regards,
Gilbert.
Gilbert.
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Re: Postgres or MariaDb
I tried PostgreSQL and Oracle, with failed, mysql works great.
examples are \ hmgx.x.x \ Samples \ HCFL \ sql \ mysql
1.install mysql ( recommendation 5.5 or 5.6 )
2 In the program folder to copy libmysql.dll from mysql \ bin folder
3 to do compilation
MariaDB do not use, but it should be similar
examples are \ hmgx.x.x \ Samples \ HCFL \ sql \ mysql
1.install mysql ( recommendation 5.5 or 5.6 )
2 In the program folder to copy libmysql.dll from mysql \ bin folder
3 to do compilation
MariaDB do not use, but it should be similar
- serge_girard
- Posts: 3165
- Joined: Sun Nov 25, 2012 2:44 pm
- DBs Used: 1 MySQL - MariaDB
2 DBF - Location: Belgium
- Contact:
Re: Postgres or MariaDb
Hi Gilbert,
I work with MySQL/MariaDB and it works perfect.
Your postgres error-file do not show exact error message?
Serge
I work with MySQL/MariaDB and it works perfect.
Your postgres error-file do not show exact error message?
Serge
There's nothing you can do that can't be done...
- karweru
- Posts: 220
- Joined: Fri Aug 01, 2008 1:51 pm
- DBs Used: DBF,mysql,mariadb,postgresql,sqlite,odbc
- Contact:
Re: Postgres or MariaDb
Thank you Serge for your quick reply. The error I'm getting for postgress is;
I have also downloaded mariadb, will try the steps above. A quick question though,...does it mean one has to supply libmysql.dll to clients with the applications executable?Harbour 3.2.0dev (r1601151502)
Copyright (c) 1999-2015, http://harbour-project.org/
C:\hmg.3.4.3\SAMPLES\HFCL\SQL\POSTGRESQL_1\demo.prg(85) Error E0030 Syntax error "syntax error at '.'"
C:\hmg.3.4.3\SAMPLES\HFCL\SQL\POSTGRESQL_1\demo.prg(91) Error E0030 Syntax error "syntax error at '.'"
2 errors
No code generated.
hbmk2[demo]: Error: Running Harbour compiler (embedded). 1
(C:\hmg.3.4.3\harbour\bin\harbour.exe) -n2 C:\hmg.3.4.3\SAMPLES\HFCL\SQL\POSTGRESQL_1\demo.prg -DHBMK_HAS_HMG32=1 -q -DHBMK_HAS_DEMO=1 -oC:\Users\gkarweru\AppData\Local\Temp\hbmk_1urbk2.dir\ -iC:\hmg.3.4.3\harbour\include -i. -iC:\hmg.3.4.3\include
Kind regards,
Gilbert.
Gilbert.
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: Postgres or MariaDb
MariaDB is good and widely used.
Yes, we need libmysql.dll at runtime.
Yes, we need libmysql.dll at runtime.
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.
- serge_girard
- Posts: 3165
- Joined: Sun Nov 25, 2012 2:44 pm
- DBs Used: 1 MySQL - MariaDB
2 DBF - Location: Belgium
- Contact:
Re: Postgres or MariaDb
As Rathi said: libmysql.dll is indeed needed.
This could be a problem when you want to remote-distribute your application. I used to check with a small program which checks if it present. If not I copy it.
Serge
This could be a problem when you want to remote-distribute your application. I used to check with a small program which checks if it present. If not I copy it.
Serge
There's nothing you can do that can't be done...
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Re: Postgres or MariaDb
I do not know how many know MySQL,
I recommend to start the portable version, like http://www.uniformserver.com/ZeroXI_doc ... guide.html
(new version include module MariaDB)
It is portable Web server but has more or can only be started MySQL which is enough and make a basic database administration and users
For MySQL to recommend databse manager https://www.heidisql.com/
It's can be install or use portable
Hint for first use, start database, create user, then create database
I recommend to start the portable version, like http://www.uniformserver.com/ZeroXI_doc ... guide.html
(new version include module MariaDB)
It is portable Web server but has more or can only be started MySQL which is enough and make a basic database administration and users
For MySQL to recommend databse manager https://www.heidisql.com/
It's can be install or use portable
Hint for first use, start database, create user, then create database
- karweru
- Posts: 220
- Joined: Fri Aug 01, 2008 1:51 pm
- DBs Used: DBF,mysql,mariadb,postgresql,sqlite,odbc
- Contact:
Re: Postgres or MariaDb
Thanks everyone,
Is there away (or even an RDBMS) that one can connect to from a HMG application, as easily as with sqlite, without the need to supply libraries beside the executable? Sorry, too many questions
Is there away (or even an RDBMS) that one can connect to from a HMG application, as easily as with sqlite, without the need to supply libraries beside the executable? Sorry, too many questions
Kind regards,
Gilbert.
Gilbert.
- serge_girard
- Posts: 3165
- Joined: Sun Nov 25, 2012 2:44 pm
- DBs Used: 1 MySQL - MariaDB
2 DBF - Location: Belgium
- Contact:
Re: Postgres or MariaDb
There's nothing you can do that can't be done...