Livecode <=> SQL?

[Dr. Hawkins]

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?


> > * 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.  In another thread, it was mentioned that there is work to
make livecode handle multiline mySQL, but it isn't there now.  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