Cloning a SQLite (or any SQL) database

[ethan at lish.net]

Check out LiveCloud for LiveCodehttps://livecloud.io
Addresses the cloning element but it's seems like a closed database architecture so you have to adopt their model
I've played with it but yet to build anything production grade with it. 
The team is extremely helpful and stays with you every step of the way. It holds excellent promise. 
E

ethan at lish.net
240.876.1389

Sent from my pocket computer 
Please excuse my brevity and typos




On Sun, May 22, 2016 at 1:47 PM -0700, "Paul Dupuis" <paul at researchware.com> wrote:










On 5/22/2016 11:19 AM, Mike Bonner wrote:
> If you just need to duplicate the database, would making a copy of the file
> be sufficient?
>

Yes. I should have been clearer. While I could just copy the file for a
sqlite db, this app may use MySQL (or someday, possible other flavors of
SQL database) and I'd like to have a generalized routine that just
relies on LiveCode and "standard" SQL commands.

Also I already see that "standard" SQL commands may be an issue in that
I would have assumed DESCRIBE  to get the details of a table was
part of sqlite, but now I see you need to use other tricks to get a
table description in sqlite.


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