Re: mySQL Host access

Hi Lyn, Thanks for that info, that will certainly help me when I start looking into LC server. Unfortunately, I think I'm about 6 months into a 2-year contract with my current web host so probably could not switch at this point. On Thu, Jan 7, 2016 at 4:17 PM Lyn Teyla

Re: mySQL Host access

Hi Alex, You're probably right on the lc server issue (and thanks for the compliment). I already had a library of php db access scripts on my server which I've been using in batch cron jobson a nightly basis so the guts of what I needed to do was already in place, whereas I have never installed

Re: "fork" command?

Monte Goulding wrote: >> On 8 Jan 2016, at 6:03 am, Richard Gaskin wrote: >> >> I think we need a new command that launches a specified process >> but in a way that uses a call to "fork" to pass file descriptors >> (which include sockets and other I/O info) to the child process. >> >> In many

Subject: Re: "fork" command?

+1 for Me also I would for sure would support funding for this. LiveCode in a Node.JS like solution would be a KILLER!!! Especially if there was a direct connection to MongoDB which we are HEAVY users of. --Todd > Le 7 janv. 2016 ? 20:03, Richard Gaskin a ?crit : >

Re: mySQL Host access

Peter Haworth wrote: > Is this common practice when accessing mySQL on a host server? If so, is > there a better way to set about accessing a mySQL database in these > circumstances, perhaps using php scripts on the server instead of accessing > the db directly with the LC database functions?

equivalent to DISTINCT ON (with SUM()) for in-memory SQLite

I need to sum amounts and return keys where other fields are the same on an in-memory database. I have my own unique key uniqDna, fields cname and cadr, and numeric field due I want to SUM(due) for each unique cname||cadr, and get get the corresponding keys. DISTINCT ON would due this, but it's

Re: "fork" command?

> My understanding is that spawn-fcgi uses fork, no? Yes. Are you looking to implement your own process manager though? > > > > We mainly need two things for FastCGI: > > - an engine with the FastCGI accept loop as the main loop (LC Server > > just starts up and quits at the end of the code

Re: HTML5 update: why it is slow?

> Le 7 janv. 2016 à 03:56, Lyn Teyla a écrit : > > Monte Goulding wrote: > >> Personally I’d rather you declare force majeure on wait for HTML5 and apply >> your considerable talents to implementing non-blocking versions of >> everything. > > Agreed. Won’t the planned

Re: HTML5 update: why it is slow?

> Le 7 janv. 2016 à 14:18, Peter TB Brett a écrit : > > On 07/01/2016 11:59, Pierre Sahores wrote: >> >> >>> Le 7 janv. 2016 à 03:56, Lyn Teyla a écrit : >>> >>> Monte Goulding wrote: >>> Personally I’d rather you declare force majeure

Re: "fork" command?

Yes, Monte is correct, we switch our servers to Node.JS simply because of the ease of use, speed and productivity gains. BUT...there is tremendous power is using one language as a solution. The barrier of entry for most LiveCoders is very high to get a proper cloud App. If like LC had a solution

Re: LC app not displaying correctly on iPhone

Thank you, Colin. Sent from my iPhone > On Jan 6, 2016, at 1:05 PM, Colin Holgate wrote: > > Exact fit is rarely what you would want to do, it will distort the card area > to fit the screen size. > > The black bars are because you didn’t include the

Re: mySQL Host access

On 01/07/2016 06:05 PM, Lyn Teyla wrote: The stacks are a free download, and from what I can tell, don’t require you to be a HostM.com client. You just need to be able to run LiveCode Server. Maybe. The url *does* throw a 404, though. -- Mark Wieder ahsoftw...@gmail.com

Re: mySQL Host access

Peter Haworth wrote: > Thanks for that info, that will certainly help me when I start looking into > LC server. Unfortunately, I think I'm about 6 months into a 2-year > contract with my current web host so probably could not switch at this > point. The stacks are a free download, and from what

Re: "fork" command?

> On 8 Jan 2016, at 12:42 pm, Richard Gaskin wrote: > > Monte Goulding wrote: > > >> My understanding is that spawn-fcgi uses fork, no? > > > > Yes. Are you looking to implement your own process manager though? > > What constitutes "process manager" in this

Re: mySQL Host access

OK, thanks Lyn. I will have to check with my web host (Dreamhost) how to set LC server up. On Thu, Jan 7, 2016 at 6:05 PM Lyn Teyla wrote: > Peter Haworth wrote: > > > Thanks for that info, that will certainly help me when I start looking > into > > LC server.

Re: mySQL Host access

On 01/07/2016 06:43 PM, Mark Wieder wrote: The url *does* throw a 404, though. ...and now they fixed the link. -- Mark Wieder ahsoftw...@gmail.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe,

Re: [On-Rev Tio] could someone test the index.html files in her/his account on Tio?

CLOSURE ON THAT SUBJECT :: had to reinstall corrupted files / folders 1. Because I did not have a save copy locally (now I have!) 2. Because they only seem to have one daily backup and told me the corrupted files had just been corrupted before backup... ?? how can they not have a d-1 backup?? I

mySQL Host access

It seems that to access a mySQL database on my web host's servers from a Livecode program, I have to configure "Allowable hosts" in the database configuration. That can be an ip address or a domain name such as "@. mydomain.com" The program in question will be used by perhaps a half dozen users,

Re: equivalent to DISTINCT ON (with SUM()) for in-memory SQLite

I think this will work SELECT sum(due) from mytable WHERE ORDER BY cname || caddr GROUP BY cname || caddr GROUP may have to come before ORDER, don't remember. On Thu, Jan 7, 2016 at 4:32 PM Dr. Hawkins wrote: > I need to sum amounts and return keys where other fields are

Re: [On-Rev Tio] could someone test the index.html files in her/his account on Tio?

Robert Mann wrote: > So DO make a backup of your on-rev accounts locally after each major > modification!! With portable HDDs selling at around US$50/GB multiple redundant backups are easy, esp. with: > Has anybody made a stack that would scan changes within site files > and make local copy

Re: "fork" command?

> Le 7 janv. 2016 à 20:03, Richard Gaskin a écrit : > > I'm just far enough into Robert Love's "Linux System Programming" that I > think the solution to FastCGI may be much simpler than I'd previously thought. > <—snip —> > Forking seems so common in other tools,

Re: mySQL Host access

I wonder if Andres Dblib could be modified so that it could be used on both ends. On the client side, use the where, columns etc functionality to build up an array, (dbA) encode it, and post it to a page where its decoded, copied to the dbA variable (after you "start using.." andres stack) and

Re: "fork" command?

Hmm… I’m not convinced we need this for FastCGI. Apache mod_fcgid will start up processes for you and for Nginx and other servers that don’t do that you could use spawn-fcgi. I have done some thinking on FastCGI after Todd asked me to look into the feasibility of it and was considering funding

"fork" command?

I'm just far enough into Robert Love's "Linux System Programming" that I think the solution to FastCGI may be much simpler than I'd previously thought. I think we need a new command that launches a specified process but in a way that uses a call to "fork" to pass file descriptors (which

Re: mySQL Host access

Peter, I do this on my server. I keep the php on my server. Then I only have to allow access from "localhost' because the php is being run on the server. The php is accessed with "post" command from livecode. If you need an example, I can send you a sample stack, with some sample php. Bill

Re: mySQL Host access

Why would you consider php scripts, when it would (I assume) be much more familiar for you to use .lc scripts on LCServer, or CGI, scripts ? In fact, given it's you :-), I would think you could write such LC access scripts in your sleep :-), probably better than most of us. -- Alex. On

Re: "fork" command?

That would be a great addition, although I confess I am highly dependent on the "finish what you are doing and move on to the next step" model, or single threading as the less tech savy might call it. ;-) Bob S > On Jan 7, 2016, at 11:03 , Richard Gaskin wrote: >