Hi,
I'm about to start building my first app in livecode (conversion from Alpha Anywhere) and am wondering which is the best db engine to use...
The app will be available in both single & multi user versions and I intend to use SQLite for the single user version. As far as I can see, of the native supported database engines in livecode, postgresql appears to be closest to SQLite with regards to syntax etc.
Target is to produce one code base for both versions, with few or no 'if/then' constructs to cater for syntactical differences.
Any suggestions, pointers, comments received with thanks.
Building app for both standalone & client/server - which Db?
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
-
- Posts: 20
- Joined: Mon Apr 18, 2016 10:31 am
-
- Livecode Opensource Backer
- Posts: 1336
- Joined: Sun Jul 12, 2009 10:53 am
- Location: Bordeaux, France
Re: Building app for both standalone & client/server - which
I guess it is a personal choice... mine is sqlIte and mySql... both work well with liveCode and if there are little bits that you are getting confused about with your sql syntax then the w3s sql school tutorial is a great help...
-
- Posts: 20
- Joined: Mon Apr 18, 2016 10:31 am
Re: Building app for both standalone & client/server - which
Wow - quick response - thanks!
I'm concerned that MySQL syntax is a little 'non-standard' which will mean having to code lots of exceptions to test if running the standalone or client/server version. I understand Postgres is much closer to SQLite with very few differences in the SQL I'd need to code. I'll delve deeper into the web to see if I can get a definitive answer.
I'm concerned that MySQL syntax is a little 'non-standard' which will mean having to code lots of exceptions to test if running the standalone or client/server version. I understand Postgres is much closer to SQLite with very few differences in the SQL I'd need to code. I'll delve deeper into the web to see if I can get a definitive answer.