Re: [OT] Why I don't use SQL Joins if I can help it

[Richard Gaskin]

Maybe the denormalization of document DBs isn't so crazy after all. :)

--
 Richard Gaskin
 Fourth World Systems

Bob Sneidar wrote:


An excerpt from the MySQL 5.7 reference manual. What grabbed my attention was the last 
part of the Note, "Also, some queries that appeared to work correctly in older 
versions (prior to 5.0.12) must be rewritten to comply with the standard." WHAA??? 
They changed the engine so that joins that used to work would suddenly produce different 
results???

Join Processing Changes in MySQL 5.0.12

Note
Natural joins and joins with USING, including outer join variants, are 
processed according to the SQL:2003 standard. The goal was to align the syntax 
and semantics of MySQL with respect to NATURAL JOIN and JOIN ... USING 
according to SQL:2003. However, these changes in join processing can result in 
different output columns for some joins. Also, some queries that appeared to 
work correctly in older versions (prior to 5.0.12) must be rewritten to comply 
with the standard.

These changes have five main aspects:

• The way that MySQL determines the result columns of NATURAL or USING 
join operations (and thus the result of the entire FROM clause).

• Expansion of SELECT * and SELECT tbl_name.* into a list of selected 
columns.

• Resolution of column names in NATURAL or USING joins.

• Transformation of NATURAL or USING joins into JOIN ... ON.

• Resolution of column names in the ON condition of a JOIN ... ON.

The following list provides more detail about several effects of current join 
processing versus join processing in older versions. The term “previously” 
means “prior to MySQL 5.0.12.”

• The columns of a NATURAL join or a USING join may be different from 
previously. Specifically, redundant output columns no longer appear, and the 
order of columns for SELECT * expansion may be different from before.


___
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

[OT] Why I don't use SQL Joins if I can help it

[Bob Sneidar]

An excerpt from the MySQL 5.7 reference manual. What grabbed my attention was 
the last part of the Note, "Also, some queries that appeared to work correctly 
in older versions (prior to 5.0.12) must be rewritten to comply with the 
standard." WHAA??? They changed the engine so that joins that used to work 
would suddenly produce different results??? 

Join Processing Changes in MySQL 5.0.12

Note
Natural joins and joins with USING, including outer join variants, are 
processed according to the SQL:2003 standard. The goal was to align the syntax 
and semantics of MySQL with respect to NATURAL JOIN and JOIN ... USING 
according to SQL:2003. However, these changes in join processing can result in 
different output columns for some joins. Also, some queries that appeared to 
work correctly in older versions (prior to 5.0.12) must be rewritten to comply 
with the standard.

These changes have five main aspects:

• The way that MySQL determines the result columns of NATURAL or USING 
join operations (and thus the result of the entire FROM clause).

• Expansion of SELECT * and SELECT tbl_name.* into a list of selected 
columns.

• Resolution of column names in NATURAL or USING joins.

• Transformation of NATURAL or USING joins into JOIN ... ON.

• Resolution of column names in the ON condition of a JOIN ... ON.

The following list provides more detail about several effects of current join 
processing versus join processing in older versions. The term “previously” 
means “prior to MySQL 5.0.12.”

• The columns of a NATURAL join or a USING join may be different from 
previously. Specifically, redundant output columns no longer appear, and the 
order of columns for SELECT * expansion may be different from before.


___
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: send control-C to a process?

[Phil Davis]

Thanks Thierry - "kill " does indeed give me the desired 
outcome - the audio duration is now displayed in Finder's "Get Info" 
window (and is also discovered & displayed by other tools like afinfo 
and mediainfo). I really appreciate your help!


Phil Davis


On 12/26/16 11:59 PM, Thierry Douez wrote:

Hi Phil,

Instead of closing your process,
try to send a SIGINT or SIGQUIT signal to the child process, eg:

kill 
kill -9 

This is just out of my head... HTH

Disclaimer: I know nothing about Sox.

and happy holidays too,

Thierry


2016-12-27 7:50 GMT+01:00 Phil Davis :


On a Mac I want to 'type' control-C to a process I opened for update. (I'm
using SoX to record some spoken audio, and I want to tell it to end.) How
do I do it?

I found I can just close the process and the audio is preserved in the
output file, but then Finder seems to have no idea what the audio duration
is.

Thanks and happy holidays to all -

--
Phil Davis






--
Phil Davis


___
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: TS Net for Indy vs Business

[Andre Garzia]

Hey,

Yes, we found that page as well. The problem is that even though the page
lists features available to each license, there is no list of commands and
functions per license. For example, it says that public key authentication
is only available to business license holders, so we'd assume that if we
call tsNetUploadFileSync passing a username and password as an SFTP URL,
should work but it doesn't. Then we'd look into the docs and see that we
can pass a settings array with username and password which also doesn't
work.

When I say "doesn't work", I don't mean it is buggy, I mean it returns an
error saying the external is unlicensed. Which will probably make me
fallback to using shell commands to scp/sftp/rsync or whatever I need to
make file transfers.

This "escalation of features" for file transfers based on your license for
me is cumbersome as I am more prone to use other solutions than stay inside
LC but this is a whole different thread.

What I think would be useful and not disruptive to HQ business model is
more info about this license limitations inside the LC dictionary. When you
look at a given entry there, you don't see this info.

om om
andre
PS: It has been a while hasn't it?

On Tue, Dec 27, 2016 at 7:32 AM, Richard Gaskin 
wrote:

> Sannyasin Brahmanathaswami wrote:
>
> > We need some help.
> >
> > We know that we can do SFTP with TS-Net external
> >
> > but
> >
> > functions that we try to use from an Indy LC return "unlicensed" even
> > when, the documentation make not indication that they should fail
> > without the business license.
> >
> > What we need is
> >
> > Documention on what functions and methods work for SFTP in Indy.
>
> There's probably a more intuitive taxonomic placement for this (though
> admittedly I can't decide on one offhand - suggestions?), but I poked
> around the livecode.com site and discovered that if I click "Pricing"
> then about the middle of the price comparison page is a link labeled
> "Compare Networking Fearures", which leads to this page that offers a
> breakdown by edition:
>
>  networking-layer/>
>
> --
>  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
>



-- 
http://www.andregarzia.com -- All We Do Is Code.
http://fon.nu -- minimalist url shortening service.
___
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: TS Net for Indy vs Business

[Richard Gaskin]

Sannyasin Brahmanathaswami wrote:

> We need some help.
>
> We know that we can do SFTP with TS-Net external
>
> but
>
> functions that we try to use from an Indy LC return "unlicensed" even
> when, the documentation make not indication that they should fail
> without the business license.
>
> What we need is
>
> Documention on what functions and methods work for SFTP in Indy.

There's probably a more intuitive taxonomic placement for this (though 
admittedly I can't decide on one offhand - suggestions?), but I poked 
around the livecode.com site and discovered that if I click "Pricing" 
then about the middle of the price comparison page is a link labeled 
"Compare Networking Fearures", which leads to this page that offers a 
breakdown by edition:




--
 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: TS Net for Indy vs Business

[Skip Kimpel]

I agree but I am also about to launch a product that uses the SFTP 
functionality and am curious about what feature you are getting that message 
for so I don't have any surprises.

SKIP

> On Dec 27, 2016, at 8:58 AM, Sannyasin Brahmanathaswami  
> wrote:
> 
> Would rather not piece-meal this: 
> 
> For the sake of the product (to keep new developers from cursing LC) 
> 
> Let's get documentation: simple:
> 
> All commands/methods that will work with Indy and any standalone built with 
> Indy
> 
> All commands/methods that are business license only
> 
> + ideally: sample stack with 1 card script for each of the above.
> 
> BR
> 
> On 12/26/16, 7:14 PM, "use-livecode on behalf of Skip Kimpel" 
>  
> wrote:
> 
>What features are you getting "unlicensed" for?
> 
>SKIP
> 
>> On Dec 26, 2016, at 9:03 PM, Sannyasin Brahmanathaswami  
>> wrote:
>> We need some help.
>> We know that we can do SFTP with TS-Net external
>> but
>> functions that we try to use from an Indy LC return "unlicensed" even when, 
>> the documentation make not indication that they should fail without the 
>> business license.
>> What we need is
>> Documention on what functions and methods work for SFTP in Indy.
>> and we have a stack with sample code
>>  one card script with all functions that work in Indy
>>  one card script with all functions that work in Business only
>> Svasti Astu, Be Well
>> Brahmanathaswami
>> www.himalayanacademy.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: Detect scroll activity (when LC is not frontmost)

[Bob Sneidar]

If you were able to do this, LC might get flagged as malware. Software that 
attempts to modify the OS or drivers gets the attention of malware protection 
pretty quickly.

Bob S


On Dec 25, 2016, at 07:21 , Paul Dupuis 
mailto:p...@researchware.com>> wrote:

Most productivity tracking software works by effectively inserting code
into where the device drivers meet the operating system, so that mouse
and keyboard events are captured by the productivity app's as well as
being sent by the OS to the active application as normal.

Using LCB and LC9.0 you might be able to write an LCB widget that does
this, but I am not familiar enough with current OSX APIs for event
capture or drivers under OSX to or the state of work in LC9.0 on
integrating OS API calls to say for sure.

You are unlikely to be able to do what you want in LiveCode script alone.

___
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: TS Net for Indy vs Business

[Sannyasin Brahmanathaswami]

Would rather not piece-meal this: 

For the sake of the product (to keep new developers from cursing LC) 

Let's get documentation: simple:

All commands/methods that will work with Indy and any standalone built with Indy

All commands/methods that are business license only

+ ideally: sample stack with 1 card script for each of the above.

BR

On 12/26/16, 7:14 PM, "use-livecode on behalf of Skip Kimpel" 
 wrote:

What features are you getting "unlicensed" for?

SKIP

>On Dec 26, 2016, at 9:03 PM, Sannyasin Brahmanathaswami  
wrote:
>We need some help.
>We know that we can do SFTP with TS-Net external
>but
>functions that we try to use from an Indy LC return "unlicensed" even 
when, the documentation make not indication that they should fail without the 
business license.
>What we need is
>Documention on what functions and methods work for SFTP in Indy.
>and we have a stack with sample code
>   one card script with all functions that work in Indy
>   one card script with all functions that work in Business only
>Svasti Astu, Be Well
>Brahmanathaswami
>www.himalayanacademy.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: send control-C to a process?

[Thierry Douez]

Hi Phil,

Instead of closing your process,
try to send a SIGINT or SIGQUIT signal to the child process, eg:

kill 
kill -9 

This is just out of my head... HTH

Disclaimer: I know nothing about Sox.

and happy holidays too,

Thierry


2016-12-27 7:50 GMT+01:00 Phil Davis :

> On a Mac I want to 'type' control-C to a process I opened for update. (I'm
> using SoX to record some spoken audio, and I want to tell it to end.) How
> do I do it?
>
> I found I can just close the process and the audio is preserved in the
> output file, but then Finder seems to have no idea what the audio duration
> is.
>
> Thanks and happy holidays to all -
>
> --
> Phil Davis
>
>


-- 

Thierry Douez - http
​s​
://sunny-tdz.com 
sunnYrex - sunnYtext2speech - sunnYperl - sunnYmidi - sunnYmage
___
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