Query Builder and SQL databases settings?
Posted: Wed Aug 07, 2019 6:25 pm
Okay.
So a Servoy application is written to interact with Postgresql. Reasonable since they are packaged together.
Also reasonable, imho, that changing database servers should be handled by Query Builder, assuming the tool is meant to normalize SQL between database vendors.
Missed the mark on that point, as it has NOT been just changing the databases, but the SQL is particular about types, groupBy, etc.
Does a setting exist where Query Builder adjusts SQL to perform with different databases, or is it tweaking by the developer to get the correct SQL to execute against the chosen vendor flavor of SQL?
What is the standard practice when supporting differing vendor databases?
Thanks!
--Joe.
So a Servoy application is written to interact with Postgresql. Reasonable since they are packaged together.
Also reasonable, imho, that changing database servers should be handled by Query Builder, assuming the tool is meant to normalize SQL between database vendors.
Missed the mark on that point, as it has NOT been just changing the databases, but the SQL is particular about types, groupBy, etc.
Does a setting exist where Query Builder adjusts SQL to perform with different databases, or is it tweaking by the developer to get the correct SQL to execute against the chosen vendor flavor of SQL?
What is the standard practice when supporting differing vendor databases?
Thanks!
--Joe.