different database (SQL Server, SQLite, PostgreSQL)

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
Contact:

different database (SQL Server, SQLite, PostgreSQL)

Post by onoehring » 2022-06-02 05:19

Hi,

has anyone used AG with a different backend database than MySQL/MariaDB? I am thinking of SQL Server, SQLite or PostgreSQL.
I know that in AG code we are supposed to be able to add certain database specific commands, but I have not done it.
Now, another project lurking around the corner this might be interesting.

If you have used another database system maybe you could elaborate what you did and how it worked, which errors you encountered while testing/in production. Didi it match the MySQL experience or are some things more problematic?

Thanks already
Olaf

User avatar
crnjak
Veteran Member
Posts: 37
Joined: 2021-12-29 20:25

Re: different database (SQL Server, SQLite, PostgreSQL)

Post by crnjak » 2022-06-02 11:51

in db.php you have a comment on top
/*
To implement a new db driver you should change the value of
the DATABASE cnonstant in definitions.php to the desired driver name, for example 'mssql'.
then adding cases for the that driver in each function below ...
*/
Personaly I dont try. But I have similar problem over a year ago where old base data is in MSSQL and I need to deliver on MySQL.

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: different database (SQL Server, SQLite, PostgreSQL)

Post by onoehring » 2022-06-03 05:15

Hi crnjak,

thanks for point out that file/position - I did not remember that.

Did you solve your MSSSQL problem? Did you try to access via ODBC? Did it work - or how did you handle the task (and with which result?

Olaf

User avatar
crnjak
Veteran Member
Posts: 37
Joined: 2021-12-29 20:25

Re: different database (SQL Server, SQLite, PostgreSQL)

Post by crnjak » 2022-06-03 06:51

I try but didnt work. I think its because it have a lot of script for this database in MSSQL. For me is best solution to migrate data on MySQL and build solution from zero.

Post Reply