Build web application with SQL server

The recommended method of customizing your AppGini-generated application is through hooks. But sometimes you might need to add functionality not accessible through hooks. You can discuss this here.
Post Reply
Monato
Posts: 1
Joined: 2016-06-22 01:05

Build web application with SQL server

Post by Monato » 2016-06-22 01:08

We have our own SQL Server 2012, I would like to build my appgini with backend connected to my SQL server. Is this option doable?

Thank you,

User avatar
a.gneady
Site Admin
Posts: 938
Joined: 2012-09-27 14:46
Contact:

Re: Build web application with SQL server

Post by a.gneady » 2016-06-23 21:23

You could try editing the generated db.php file to add mssql or odbc functions to it .. though we haven't thoroughly tested this so far.
AppGini: Responsive, collaborative web db apps in minutes.
:idea: Learn all the tips and tricks of customizing AppGini apps through our online course.

Appgini_tester
Posts: 10
Joined: 2016-08-13 13:16

Re: Build web application with SQL server

Post by Appgini_tester » 2016-08-13 13:21

I'm just looking into AppGini now, but was disappointed to hear that it only officially supports MySql. I'm using Sql Server, at the office.

I've used several other CASE tools for PHP, but almost all of them generate levels of abstraction that make it difficult for a person familiar with that tool, to see what's going on. AppGini's code seems to be more generic and obvious.

Will continue to check it out, anyway. Just noticed this site, which purports to help users add MsSql support:

https://github.com/bigprof/appgini-mssql

Appgini_tester
Posts: 10
Joined: 2016-08-13 13:16

Re: Build web application with SQL server

Post by Appgini_tester » 2016-08-14 21:39

How come my response to this was removed? Did I say something offensive?

Noha Eshra
Moderator
Posts: 81
Joined: 2013-11-11 19:21

Re: Build web application with SQL server

Post by Noha Eshra » 2016-08-16 16:14

It wasn't removed, it was just not approved "yet", as the very first post requires approval before posting.

Welcome to the forum :)

Appgini_tester
Posts: 10
Joined: 2016-08-13 13:16

Re: Build web application with SQL server

Post by Appgini_tester » 2016-08-17 12:17

Yep, I realized that after sending it, but couldn't remove the comment. Thanks, Noha.

toconnell
Veteran Member
Posts: 203
Joined: 2013-04-09 19:29

Re: Build web application with SQL server

Post by toconnell » 2018-10-24 20:09

Ahmad,
WHere is the SQL support at now? This was 2016

toconnell
Veteran Member
Posts: 203
Joined: 2013-04-09 19:29

Re: Build web application with SQL server

Post by toconnell » 2018-10-24 20:30

Which driver do you recommend Ahmad? Microsoft JDBC DRIVER 6.0 for SQL Server or ODBC?
Please advise any information you can provide at all is helpful.. anyone

User avatar
a.gneady
Site Admin
Posts: 938
Joined: 2012-09-27 14:46
Contact:

Re: Build web application with SQL server

Post by a.gneady » 2018-10-31 11:42

I'd recommend ODBC ... Regarding SQL Server support, we investigated it for some time before and it turned out to be a non-easy task, as most SQL queries would have to be rewritten since SQL syntax is different from MySQL ... We plan to revisit this some time later .. perhaps in AppGini 6.0.
AppGini: Responsive, collaborative web db apps in minutes.
:idea: Learn all the tips and tricks of customizing AppGini apps through our online course.

toconnell
Veteran Member
Posts: 203
Joined: 2013-04-09 19:29

Re: Build web application with SQL server

Post by toconnell » 2018-11-14 19:37

When is 6.0 planned? This is kinda a requirement now per the boss. So I have to make it so now.
so all the queries for each file?

Is there a step by step hidden away somewhere so I have some instructions on the actions that need to happen in each file?

Thanks, T

User avatar
a.gneady
Site Admin
Posts: 938
Joined: 2012-09-27 14:46
Contact:

Re: Build web application with SQL server

Post by a.gneady » 2018-11-28 11:42

AppGini 6.0 is perhaps 4-6 months away. You'd have unfortunately to check the SQL queries in each generated file and manually edit them. There might be a way to do it centrally inside the sql() function defined in incCommon.php and admin/incFunctions.php .. The sql() function is where most of the SQL queries are executed .. So, you might find a method of parsing the MySQL version of SQL queries and converting them to SQL Server compatible ones. I didn't research this in detail but it could save a lot of work if done directly inside sql() function instead of having to chase all SQL code in all PHP files.
AppGini: Responsive, collaborative web db apps in minutes.
:idea: Learn all the tips and tricks of customizing AppGini apps through our online course.

Post Reply