Re: LC Server- Optimum setup
Thanks, Richard! RevIgniter also looks like something I should explore. Would a program that needs to produce graphs be practical? My current work requires various plots of earth data. Just wondering if I could think about getting it on a web server. Best, Bill William Prothero http://es.earthednet.org > On Oct 20, 2020, at 6:30 PM, Richard Gaskin via use-livecode > wrote: > > When you are, you're in good company. Just let us know if you get stuck on > anything and we'll get your server running in no time. > > 'Tween now and then, you might want to check out this blog post on a nice > addition to LC Server added a couple years back, letting you use LC as a > general purpose command-line language in addition to how most people use it > as a PHP replacement: > https://livecode.com/livecode-server/ > > This blog post may help spark ideas for how to put LC to work on system > monitoring and other tasks: > https://livecode.com/keeping-an-eye-on-your-server/ > > -- > Richard Gaskin > Fourth World Systems > > > William Prothero wrote: >> Thanks, Richard. Good info. I’m not quite ready to jump in on this yet, but >> soon, and probably with Trevore’s Levure app. >> Best, >> Bill >> William A. Prothero >> https://earthlearningsolutions.org On Oct 19, 2020, at 11:03 AM, Richard Gaskin via use-livecode wrote: >>> prothero wrote: >>> > I’ve been thinking about experimenting with Livecode server. I have >>> > a vps and root access, but I’m wondering what are the speed and user >>> > consequences of installing it at root level, or as a cgi. The cgi is >>> > fairly large and I’m concerned about both speed and memory issues when >>> > multiple users are accessing it. >>> > >>> > I know this has been discussed in the past, but would appreciate any >>> > advice based on recent experience. >>> CGIs are CGIs, whether configured for all users via admin access to Apache >>> config, or for individual users on a shared host via .htacces. >>> Also, the size on disk is not reflective of real-world RAM requirements. >>> You can check RAM requirements in Terminal by calling the engine with a >>> simple script using the timing tool located at /usr/bin/time: >>> /user/bin/time -v /path/to/your/lcserver somescript.lc >>> The -v flag is for "verbose", listing a wide range of runtime stats >>> including "Maximum resident set size" and "Average resident set size", with >>> "set size" referring to physical RAM used. >>> For example, running that on the script I posted earlier for my example CGI >>> yields: >>> User time (seconds): 0.02 >>>System time (seconds): 0.02 >>>Percent of CPU this job got: 97% >>>Elapsed (wall clock) time (h:mm:ss or m:ss): 0:00.04 >>>Average shared text size (kbytes): 0 >>>Average unshared data size (kbytes): 0 >>>Average stack size (kbytes): 0 >>>Average total size (kbytes): 0 >>>Maximum resident set size (kbytes): 19728 >>>Average resident set size (kbytes): 0 >>>Major (requiring I/O) page faults: 0 >>>Minor (reclaiming a frame) page faults: 1526 >>>Voluntary context switches: 1 >>>Involuntary context switches: 0 >>>Swaps: 0 >>>File system inputs: 0 >>>File system outputs: 0 >>>Socket messages sent: 0 >>>Socket messages received: 0 >>>Signals delivered: 0 >>>Page size (bytes): 4096 >>>Exit status: 0 >>> Separate from anything to do with LC, there is a modest performance >>> difference between using .htacess and making those directives available to >>> all users in Apache config: if you don't enable mod_rewrite, Apache doesn't >>> need to scan folders for .htaccess files. This is a VERY minor difference, >>> however, and if you need the flexibility of mod_rewrite you should use it. >>> But FWIW most production servers set things up in Apache config, and since >>> you're not limited to the issues with shared hosting you might as well do >>> it the standard way. It's more work, and you'll be using sudo a lot since >>> permissions are tighter. But for a production server, more restrictive >>> permissions are exactly what we want. >>> -- >>> Richard Gaskin >>> Fourth World Systems >>> Software Design and Development for the Desktop, Mobile, and the Web >>> >>> Ambassador at FourthWorld.comhttp://www.FourthWorld.com > > > ___ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: SQL Show Status
I was actually trying to look at the sslcypher tag. Wanted to see if it thought the server was enabled for it and if the certs would work. But there was no way of telling using revdb if the certs were wrong, if the server was set or anything. No one was able to tell me how to find out and was just flying blind (as is often the case with LC documentation). But I’ve abandoned revdb now and opted entirely for php. That way I just use https for security. Next issue when I transfer back to HTML5 deployment of these apps is to work out how to get RSA encryption working. Probably another php script (which again will be insecure while feeding through JS, unless the Post command works ok in that environment - ??). All the best Bob Sean Cole Pi Digital > On 20 Oct 2020, at 22:20, Bob Sneidar via use-livecode > wrote: > > I’m wondering what status you are trying to retrieve. If you are wanting to > see if the SQL database is accessible/online, using an actual query has it’s > drawbacks. Querying an SQL database that is inaccessible will result in a 60 > second timeout during which Livecode will be unresponsive. > > What I do instead is I first execute a telnet command using shell(). This > will tell me if I can get to the SQL server and if it’s listening. The next > thing you can do is execute a simple query SHOW STATUS will work as well as > anything else. You can also execute something like select 1+1 as sum. You > don’t even need to know a table or column. > > Bob S > > >> On Oct 19, 2020, at 10:53 AM, matthias rebbe via use-livecode >> wrote: >> >> You have to use >> >> revDataFromQuery() >> >> because that will execute the SQL statement and will return any data that is >> coming from the DB Server. >> >> Regards, >> Matthias >> >> - >> Matthias Rebbe >> Life Is Too Short For Boring Code >> Am 19.10.2020 um 19:41 schrieb Sean Cole (Pi) via use-livecode : >>> >>> Hi Ralph, >>> >>> What do I do to see the data in the two columns? My brain is hurting too >>> much to figure it out. >>> >>> Thanks >>> Sean >>> >>> On Mon, 19 Oct 2020 at 18:26, Ralph DiMola via use-livecode < >>> use-livecode@lists.runrev.com> wrote: >>> Sean, revQueryDatabase(tConnId, “SHOW STATUS”) only returns an integer That integer is a record set. In my case it returned 536 rows. Each row has two columns: Variable_name Value Let me tell you Mr. Johnson... Some very interesting stuff in there. Ralph DiMola IT Director Evergreen Information Services rdim...@evergreeninfo.net -Original Message- From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of Sean Cole (Pi) via use-livecode Sent: Monday, October 19, 2020 12:50 PM To: How to use LiveCode Cc: Sean Cole (Pi) Subject: SQL Show Status Hi As everyone likes to hijack threads here, I’ve started another to make sure it gets seen. revQueryDatabase(tConnId, “SHOW STATUS”) only returns an integer Same for revdb_execute which returns 0 Any clues on how to actually get the status back? Still trying to work out why these certificates are not working. -- Sean Cole *Pi Digital Productions Ltd* www.pidigital.co.uk +44(1634)402193 +44(7702)116447 'Don't try to think outside the box. Just remember the truth: There is no box!' 'For then you realise it is not the box you are trying to look outside of, but it is yourself!' > > ___ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: LC Server- Optimum setup
When you are, you're in good company. Just let us know if you get stuck on anything and we'll get your server running in no time. 'Tween now and then, you might want to check out this blog post on a nice addition to LC Server added a couple years back, letting you use LC as a general purpose command-line language in addition to how most people use it as a PHP replacement: https://livecode.com/livecode-server/ This blog post may help spark ideas for how to put LC to work on system monitoring and other tasks: https://livecode.com/keeping-an-eye-on-your-server/ -- Richard Gaskin Fourth World Systems William Prothero wrote: Thanks, Richard. Good info. I’m not quite ready to jump in on this yet, but soon, and probably with Trevore’s Levure app. Best, Bill William A. Prothero https://earthlearningsolutions.org On Oct 19, 2020, at 11:03 AM, Richard Gaskin via use-livecode wrote: prothero wrote: > I’ve been thinking about experimenting with Livecode server. I have > a vps and root access, but I’m wondering what are the speed and user > consequences of installing it at root level, or as a cgi. The cgi is > fairly large and I’m concerned about both speed and memory issues when > multiple users are accessing it. > > I know this has been discussed in the past, but would appreciate any > advice based on recent experience. CGIs are CGIs, whether configured for all users via admin access to Apache config, or for individual users on a shared host via .htacces. Also, the size on disk is not reflective of real-world RAM requirements. You can check RAM requirements in Terminal by calling the engine with a simple script using the timing tool located at /usr/bin/time: /user/bin/time -v /path/to/your/lcserver somescript.lc The -v flag is for "verbose", listing a wide range of runtime stats including "Maximum resident set size" and "Average resident set size", with "set size" referring to physical RAM used. For example, running that on the script I posted earlier for my example CGI yields: User time (seconds): 0.02 System time (seconds): 0.02 Percent of CPU this job got: 97% Elapsed (wall clock) time (h:mm:ss or m:ss): 0:00.04 Average shared text size (kbytes): 0 Average unshared data size (kbytes): 0 Average stack size (kbytes): 0 Average total size (kbytes): 0 Maximum resident set size (kbytes): 19728 Average resident set size (kbytes): 0 Major (requiring I/O) page faults: 0 Minor (reclaiming a frame) page faults: 1526 Voluntary context switches: 1 Involuntary context switches: 0 Swaps: 0 File system inputs: 0 File system outputs: 0 Socket messages sent: 0 Socket messages received: 0 Signals delivered: 0 Page size (bytes): 4096 Exit status: 0 Separate from anything to do with LC, there is a modest performance difference between using .htacess and making those directives available to all users in Apache config: if you don't enable mod_rewrite, Apache doesn't need to scan folders for .htaccess files. This is a VERY minor difference, however, and if you need the flexibility of mod_rewrite you should use it. But FWIW most production servers set things up in Apache config, and since you're not limited to the issues with shared hosting you might as well do it the standard way. It's more work, and you'll be using sudo a lot since permissions are tighter. But for a production server, more restrictive permissions are exactly what we want. -- Richard Gaskin Fourth World Systems Software Design and Development for the Desktop, Mobile, and the Web Ambassador at FourthWorld.comhttp://www.FourthWorld.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Question about Windows 10 for Surface
jbv wrote: > But what about devices like Surface tablets that run Windows 10 ? > Can a LC app compiled for windows run on these devices ? The Microsoft Surface is an awesome piece of hardware. If it wasn't notoriously difficult to install Linux on (needs a lot of specialized drivers which are included with Windows but not Linux) I'd have bought one long ago. They use Intel's Core series CPUs, so any LC app built for 64-bit Windows should run fine on them. They're full-featured computers, probably better thought of as a laptop with a detachable screen than a tablet with a docking keyboard. The only two areas I'm not certain of hopefully others who have a Surface can chime in on: - High-res screen: Not sure how gracefully LC's latest builds provide resolution independence on desktop OSes (Surface is 220 PPI). - Touch input: While modern desktop OSes have been extended in recent years to support multi-touch gestures, LC only handles multi-point touch inputs on Android and iOS. Windows does a good job of mapping many gestures to discernible keyboard sequences where practical, so your app can respond to some gestures via rawKeyDown. But if you need true multi-touch support, we'll have to wait for the engine team to add that to the LC desktop engines. -- Richard Gaskin Fourth World Systems Software Design and Development for the Desktop, Mobile, and the Web ambassa...@fourthworld.comhttp://www.FourthWorld.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Question about Windows 10 for Surface
Yes. It’s Windows 10. I do not thing there is anything different about a tablet running Windows 10 and a PC. There WERE some mobile devices running some sort of Windows OS that was NOT v10, but I haven’t seen one of those in years. They were as I understand it a total flop. People who want Windows want WINDOWS and those who don’t, well they don’t. Curious that something so simple escapes these big computer companies. Bob S On Oct 20, 2020, at 12:48 AM, jbv via use-livecode mailto:use-livecode@lists.runrev.com>> wrote: Hi list, I have a request from a potential client for an app that should run on iOS, Android and Microsoft devices. AFAIK, Microsoft has dropped Windows 10 Phone in 2019. But what about devices like Surface tablets that run Windows 10 ? Can a LC app compiled for windows run on these devices ? Thanks in advance. ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: SQL Show Status
I’m wondering what status you are trying to retrieve. If you are wanting to see if the SQL database is accessible/online, using an actual query has it’s drawbacks. Querying an SQL database that is inaccessible will result in a 60 second timeout during which Livecode will be unresponsive. What I do instead is I first execute a telnet command using shell(). This will tell me if I can get to the SQL server and if it’s listening. The next thing you can do is execute a simple query SHOW STATUS will work as well as anything else. You can also execute something like select 1+1 as sum. You don’t even need to know a table or column. Bob S > On Oct 19, 2020, at 10:53 AM, matthias rebbe via use-livecode > wrote: > > You have to use > > revDataFromQuery() > > because that will execute the SQL statement and will return any data that is > coming from the DB Server. > > Regards, > Matthias > > - > Matthias Rebbe > Life Is Too Short For Boring Code > >> Am 19.10.2020 um 19:41 schrieb Sean Cole (Pi) via use-livecode >> : >> >> Hi Ralph, >> >> What do I do to see the data in the two columns? My brain is hurting too >> much to figure it out. >> >> Thanks >> Sean >> >> On Mon, 19 Oct 2020 at 18:26, Ralph DiMola via use-livecode < >> use-livecode@lists.runrev.com> wrote: >> >>> Sean, >>> >>> revQueryDatabase(tConnId, “SHOW STATUS”) only returns an integer >>> >>> That integer is a record set. >>> In my case it returned 536 rows. >>> Each row has two columns: >>> Variable_name >>> Value >>> >>> >>> Let me tell you Mr. Johnson... Some very interesting stuff in there. >>> >>> Ralph DiMola >>> IT Director >>> Evergreen Information Services >>> rdim...@evergreeninfo.net >>> >>> >>> -Original Message- >>> From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On >>> Behalf Of Sean Cole (Pi) via use-livecode >>> Sent: Monday, October 19, 2020 12:50 PM >>> To: How to use LiveCode >>> Cc: Sean Cole (Pi) >>> Subject: SQL Show Status >>> >>> Hi >>> >>> As everyone likes to hijack threads here, I’ve started another to make >>> sure it gets seen. >>> >>> >>> revQueryDatabase(tConnId, “SHOW STATUS”) only returns an integer >>> >>> Same for revdb_execute which returns 0 >>> >>> Any clues on how to actually get the status back? >>> >>> Still trying to work out why these certificates are not working. >>> -- >>> Sean Cole >>> *Pi Digital Productions Ltd* >>> www.pidigital.co.uk >>> +44(1634)402193 >>> +44(7702)116447 >>> 'Don't try to think outside the box. Just remember the truth: There is no >>> box!' >>> 'For then you realise it is not the box you are trying to look outside of, >>> but it is yourself!' >>> ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Question about Windows 10 for Surface
Hi list, I have a request from a potential client for an app that should run on iOS, Android and Microsoft devices. AFAIK, Microsoft has dropped Windows 10 Phone in 2019. But what about devices like Surface tablets that run Windows 10 ? Can a LC app compiled for windows run on these devices ? Thanks in advance. jbv ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode