Re: Best relational database for IOS / Android

[doc hawk via use-livecode]

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 followup that checks all three once all are 
done—and what if you lose power or otherwise crash before that happens?

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Best relational database for IOS / Android

[Alex Tweedly via use-livecode]

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 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 use-livecode
Sent: Wednesday, April 29, 2020 6:54 AM
To: How to use LiveCode 
Cc: Skip Kimpel 
Subject: Best relational database for IOS / Android

Good morning,

In your opinion, what is the best relational database to use for an IOS /
Android application?

Being a PC guy and always living in the Microsoft world, I always default to
SQL, however, with my latest discoveries of the complexities involved and
lack of support in LC I don't think that would be the best move at this
point.

Suggestions?

SKIP
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Best relational database for IOS / Android

[Rick Harrison via use-livecode]

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.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Best relational database for IOS / Android

[doc hawk via use-livecode]

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.
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Best relational database for IOS / Android

[Rick Harrison via use-livecode]

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 opinion, what is the best relational database to use for an IOS /
> Android application?
> 
> Being a PC guy and always living in the Microsoft world, I always default
> to SQL, however, with my latest discoveries of the complexities involved
> and lack of support in LC I don't think that would be the best move at this
> point.
> 
> Suggestions?
> 
> SKIP
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

RE: Best relational database for IOS / Android

[Ralph DiMola via use-livecode]

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 Message-
From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf
Of Skip Kimpel via use-livecode
Sent: Wednesday, April 29, 2020 9:54 AM
To: How to use LiveCode
Cc: Skip Kimpel
Subject: Best relational database for IOS / Android

Good morning,

In your opinion, what is the best relational database to use for an IOS /
Android application?

Being a PC guy and always living in the Microsoft world, I always default to
SQL, however, with my latest discoveries of the complexities involved and
lack of support in LC I don't think that would be the best move at this
point.

Suggestions?

SKIP
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Best relational database for IOS / Android

[Mike Kerner via use-livecode]

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 IOS /
> Android application?
>
> Being a PC guy and always living in the Microsoft world, I always default
> to SQL, however, with my latest discoveries of the complexities involved
> and lack of support in LC I don't think that would be the best move at this
> point.
>
> Suggestions?
>
> SKIP
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>


-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

RE: Best relational database for IOS / Android

[Clarence Martin via use-livecode]

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 use-livecode
Sent: Wednesday, April 29, 2020 6:54 AM
To: How to use LiveCode 
Cc: Skip Kimpel 
Subject: Best relational database for IOS / Android

Good morning,

In your opinion, what is the best relational database to use for an IOS /
Android application?

Being a PC guy and always living in the Microsoft world, I always default to
SQL, however, with my latest discoveries of the complexities involved and
lack of support in LC I don't think that would be the best move at this
point.

Suggestions?

SKIP
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Best relational database for IOS / Android

[Skip Kimpel via use-livecode]

Good morning,

In your opinion, what is the best relational database to use for an IOS /
Android application?

Being a PC guy and always living in the Microsoft world, I always default
to SQL, however, with my latest discoveries of the complexities involved
and lack of support in LC I don't think that would be the best move at this
point.

Suggestions?

SKIP
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode