Re: On-Rev mySQL security issues? -- or use an LC stack for the DB?

2011-11-28 Thread Kay C Lan
On Mon, Nov 28, 2011 at 11:55 AM, Tim Selander wrote: > > Any thoughts on validation needs for lookups only? And on using a stack or > text file for the data? (Hmmm... how does the LC server handle variables - > limit on size?) > > Tim, again I'm no expert here (on anything, LC, SQL or On-Rev) bu

Re: On-Rev mySQL security issues? -- or use an LC stack for the DB?

2011-11-28 Thread Tim Selander
Hi Pierre, It took me a couple readings to follow your email (I'm a newbie!) but I think I get it... especially the point about not using a flat database, but letting the various parts of the system work in parallel. I hadn't thought about the performance hit if there are many, many users (th

Fwd: On-Rev mySQL security issues? -- or use an LC stack for the DB?

2011-11-28 Thread Pierre Sahores
Please replace below : > get yourapplogics_code() with > get yourserver_response() Début du message réexpédié : > De : Pierre Sahores > Date : 28 novembre 2011 11:47:37 HNEC > À : How to use LiveCode > Cc : Pierre Sahores > Objet : Rép : On-Rev mySQL security issues?

Re: On-Rev mySQL security issues? -- or use an LC stack for the DB?

2011-11-28 Thread Pierre Sahores
Hi Tim, In an "n-tiers" app logic build on top of LC-server, the best is to 1.- use a "script.lc" to bind the web UI+forms to the backend where the "script.lc" is just a couple of lines : 2.- start using a "server_lib.livecode" 3.- and run the "yourapplogics_code()" function included in "s

Re: On-Rev mySQL security issues? -- or use an LC stack for the DB?

2011-11-27 Thread Tim Selander
Hi Kay, Appreciate the input... I've wondered about mySQL's license, too. Here is additional info. My catalog is an archive of the radio and TV programs we've aired. We will create the database and add to it bit by bit behind the scenes. No data will be input through the web/browser -- strict