mySQL: PHP or direct access?
pete at lcsql.com
Fri Aug 14 20:35:13 CEST 2015
Thanks Todd, that sounds very interesting. I will email you off list for
On Fri, Aug 14, 2015 at 11:28 AM Todd Fabacher <tfabacher at gmail.com> wrote:
> I have used SQLite on a database server, but it has it's limitations. mySQL
> is the way to go for a long term solution. It is actually MUCH better when
> you start to go over everything that is needed for a true web server such
> as backup, load balance, multi user transactions and a VERY long list.
> We do use LC Server + revIgniter to create a great middleware REST API to
> our database. We host it on both the LC servers and and hostM
> We have not released it to open source yet, but we are working on a
> multi-user LiveCode database sync tool that will sync between a local
> SQLite DB and a web server DB. There are a few limitations like not using
> auto-counters as PrimaryKeys, you will have to use UUIDs which is better
> We are a few months away, but early stages look VERY good. If you are
> interested, email me and I will see if I can help you.
> --Todd Fabacher
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the use-livecode