Livecode <=> SQL?

[Pierre Sahores]

> Le 22 mai 2015 à 03:47, Dr. Hawkins <dochawk at gmail.com> a écrit :
> 
> On Sun, May 17, 2015 at 3:57 PM, Pierre Sahores <sc at sahores-conseil.com> wrote:
>> 
>> 
>>> Le 18 mai 2015 à 00:23, Dr. Hawkins <dochawk at gmail.com> a écrit :
>>> 
>> 
>>> There are definitely a couple of *whopping* holes:
>>> * cannot connect securely to Postgres
>> 
>> Why don’t you access it in localhost mode only (via lc server + script/stack lib). I do this
>> all the time to store incoming HTTPS POST data. It’s, as long as i know, the most
>> reliable way to go in about server’s security task.
> 
> I'm not sure what you're saying here--I'm assuming a central server being hit by
> clients around the country, wo how can locahost handle that?

The remote client -> HTTPS -> Apache -> (LC-Server -> PostgreSQL, both those two last components connected trough port 5432 on the 127.0.0.1 localhost IP address)
> 
> 
>>> * cannot submit multi-line queries to mySQL
>> 
>> Did’t try myself at this point under MariaDB/MySQL (and i will do soon as i’m on
>> the way to move some of my apps from PG to MariaDB) but this works perfectly
>> fine against PostgreSQL.
> 
> That's the problem--I trried to use mySQL as a temporary replacement
> until I have
> my server working, but the compound commands I've been using with postgres
> and mySQL bomb.

Agreed ! MariaDB is too permissive, even in using the INNODB engine...

> In another thread, it was mentioned that there is work to
> make livecode handle multiline mySQL, but it isn't there now.  

Confirmed. Just tested this today and did’t find any way to go at this point. Will try with shell or curl and report there if something can do the job. revDB don’t seems to be able to handle this at all.

> And in
> my googling,
> the top hits were from when I asked the question a couple of years ago . . .
> 
> 
> 
>>> 
>>> These are both drop-dead showstoppers.
>>> 
>>> There are also conditions in which"revdberr," is returned after successful
>>> transactions. I believe this applies to both both post postgres and SQLite
>> 
>> Never had to deal with this « revdberr » glitchy until yet, at least against my LC-Server+PostgreSQL server's apps.
> 
> if you use revDataFromQuery() and postgres, in a couple of circumstances (I
> believe INSERT is one of them), this is the message returned on a successful
> operation.
> 
> 
> 
> 
> -- 
> Dr. Richard E. Hawkins, Esq.
> (702) 508-8462
> 
> _______________________________________________
> 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

--
Pierre Sahores
mobile : 06 03 95 77 70
www.sahores-conseil.com