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,
Build web application with SQL server
Re: Build web application with SQL server
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 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.
-
- Posts: 10
- Joined: 2016-08-13 13:16
Re: Build web application with SQL server
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
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
-
- Posts: 10
- Joined: 2016-08-13 13:16
Re: Build web application with SQL server
How come my response to this was removed? Did I say something offensive?
-
- Moderator
- Posts: 82
- Joined: 2013-11-11 19:21
Re: Build web application with SQL server
It wasn't removed, it was just not approved "yet", as the very first post requires approval before posting.
Welcome to the forum
Welcome to the forum
-
- Posts: 10
- Joined: 2016-08-13 13:16
Re: Build web application with SQL server
Yep, I realized that after sending it, but couldn't remove the comment. Thanks, Noha.
Re: Build web application with SQL server
Ahmad,
WHere is the SQL support at now? This was 2016
WHere is the SQL support at now? This was 2016
Tina O'Connell
Web Dev & Appgini FAN
Web Dev & Appgini FAN
Re: Build web application with SQL server
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
Please advise any information you can provide at all is helpful.. anyone
Tina O'Connell
Web Dev & Appgini FAN
Web Dev & Appgini FAN
Re: Build web application with SQL server
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 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.
Re: Build web application with SQL server
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
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
Web Dev & Appgini FAN
Re: Build web application with SQL server
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 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.
Re: Build web application with SQL server
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
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
Web Dev & Appgini FAN
Re: Build web application with SQL server
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 :/
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.