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: 1281
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.
:idea: AppGini plugins to add more power to your apps:
  • DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
  • Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
  • Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.

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: 82
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.

User avatar
toconnell
Veteran Member
Posts: 204
Joined: 2013-04-09 19:29
Location: Oklahoma City, OK
Contact:

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
Tina O'Connell
Web Dev & Appgini FAN

User avatar
toconnell
Veteran Member
Posts: 204
Joined: 2013-04-09 19:29
Location: Oklahoma City, OK
Contact:

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
Tina O'Connell
Web Dev & Appgini FAN

User avatar
a.gneady
Site Admin
Posts: 1281
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.
:idea: AppGini plugins to add more power to your apps:
  • DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
  • Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
  • Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.

User avatar
toconnell
Veteran Member
Posts: 204
Joined: 2013-04-09 19:29
Location: Oklahoma City, OK
Contact:

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
Tina O'Connell
Web Dev & Appgini FAN

User avatar
a.gneady
Site Admin
Posts: 1281
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.
:idea: AppGini plugins to add more power to your apps:
  • DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
  • Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
  • Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.

User avatar
toconnell
Veteran Member
Posts: 204
Joined: 2013-04-09 19:29
Location: Oklahoma City, OK
Contact:

Re: Build web application with SQL server

Post by toconnell » 2020-05-07 15:54

Ahmad,
Any luck with the updates to this supporting SQL instead of MySQL?
Boss requires only SQL with new security and I have about 8 apps I could build in a minute with this if it output to SQL databases instead of MYSql. I cannot use it and buy it until then. Please let me know when available outputting to SQL and I will purchase immediately.

Thank you! Bunches Ahmad for all the hard work you do on this awesome program. I truely love it and cannot wait to showcase it's abilities once it is avialable to allow use of the SQL databases we use.

Thank you, Tina
Tina O'Connell
Web Dev & Appgini FAN

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

Re: Build web application with SQL server

Post by a.gneady » 2020-05-09 19:36

Thanks for your feedback Tina. We haven't made progress regarding SQL Server porting yet unfortunately. It's still high on our roadmap but not in the very near future :/
:idea: AppGini plugins to add more power to your apps:
  • DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
  • Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
  • Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.

Post Reply