Re: Best relational database for IOS / Android

Rick remanded, > Nice! Not just nice, but necessary for consistency—if I have a variable change which also causes two more to change, it is absolutely critical that either all three change, or that the whole thing fail. You just can’t do that without begin/end, AFAIK, unless you have a

Re: Best relational database for IOS / Android

Livecloud is indeed from Canela Software - but there's no obvious link from their own website for it. Go straight to livecloud.io to get the info about it. It does require Indy or above LC license Alex. On 29/04/2020 15:06, Clarence Martin via use-livecode wrote: You may want to explore

Re: Best relational database for IOS / Android

Nice! > On Apr 29, 2020, at 12:15 PM, doc hawk via use-livecode > wrote: > > I recoded for Postgres from mysql a few years ago simply because, at the time > at least, livecode can send a compound transaction to Postgres, and only > single transactions to mysql.

Re: Best relational database for IOS / Android

Rick rejoined, > I have a preference for PostgreSQL. I recoded for Postgres from mysql a few years ago simply because, at the time at least, livecode can send a compound transaction to Postgres, and only single transactions to mysql. ___

Re: Best relational database for IOS / Android

Hi Skip, I have a preference for PostgreSQL. https://www.postgresql.org Free - MIT-License, Open-source, and it works really well with LC. Good luck! Rick > On Apr 29, 2020, at 9:54 AM, Skip Kimpel via use-livecode > wrote: > > Good morning, > > In your

RE: Best relational database for IOS / Android

For a DB local on the device I use SQLite and it holds up well with very complex multi table queries. For a remote database I have had no problems with MySQL and it's open source brother MariaDB. Ralph DiMola IT Director Evergreen Information Services rdim...@evergreeninfo.net -Original

Re: Best relational database for IOS / Android

do you mean for c/s? if it's client-only, then sqlite and mysql are perfectly integrated into lc for ios. On Wed, Apr 29, 2020 at 9:55 AM Skip Kimpel via use-livecode < use-livecode@lists.runrev.com> wrote: > Good morning, > > In your opinion, what is the best relational database to use for an

RE: Best relational database for IOS / Android

You may want to explore LiveCloud. It is a cloud based database by Canela Software that allows for both cloud and Local- to the device- database. http://canelasoftware.com/ I am developing and testing for a while. -Original Message- From: use-livecode On Behalf Of Skip Kimpel via