Quantcast

User friendly functions to replace MySQL queries?

classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

User friendly functions to replace MySQL queries?

Richmond Mathewson via use-livecode
Hi all

Writing MySQL queries using LiveCode is a bit painful, so I thought of
writing some higher level functions to produce the queries, a bit like
these from Ken Ray:

http://www.sonsothunder.com/devres/livecode/tips/data005.htm

But before I start I wonder if anyone else has done these.

I know André Garcia wrote a big package, but his site seems down:

http://www.andregarzia.com/page/revspark

Any pointers please?

--
Kaveh Bazargan
Director
River Valley Technologies
@kaveh1000
+44 7771 824 111
www.rivervalleytechnologies.com
_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: User friendly functions to replace MySQL queries?

Richmond Mathewson via use-livecode

you find revspark now here
https://bitbucket.org/andregarzia/revspark <https://bitbucket.org/andregarzia/revspark>


> Am 07.05.2017 um 22:55 schrieb Kaveh Bazargan via use-livecode <[hidden email] <mailto:[hidden email]>>:
>
> Hi all
>
> Writing MySQL queries using LiveCode is a bit painful, so I thought of
> writing some higher level functions to produce the queries, a bit like
> these from Ken Ray:
>
> http://www.sonsothunder.com/devres/livecode/tips/data005.htm <http://www.sonsothunder.com/devres/livecode/tips/data005.htm>
>
> But before I start I wonder if anyone else has done these.
>
> I know André Garcia wrote a big package, but his site seems down:
>
> http://www.andregarzia.com/page/revspark
>
> Any pointers please?
>
> --
> Kaveh Bazargan
> Director
> River Valley Technologies
> @kaveh1000
> +44 7771 824 111
> www.rivervalleytechnologies.com
> _______________________________________________
> use-livecode mailing list
> [hidden email]
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

Matthias Rebbe
Bramkampsieke 13
32312 Lübbecke
Tel +49 5741 310000
    +49 160 5504462
Fax: +49 5741 310002
eMail: [hidden email] <mailto:[hidden email]>

BR5 Konverter - BR5 -> MP3 <http://matthiasrebbe.eu/portfolio/produkte/brx/>
_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: User friendly functions to replace MySQL queries?

Richmond Mathewson via use-livecode
In reply to this post by Richmond Mathewson via use-livecode
If it's a user-friendly way to call SQL, I don't think you want
revSpark, you want his DBLib.

I think the current / latest is at

https://github.com/Himalayan-Academy/Siva-Siva-App/wiki/aagDBLib

-- Alex.

On 07/05/2017 21:55, Kaveh Bazargan via use-livecode wrote:

> Hi all
>
> Writing MySQL queries using LiveCode is a bit painful, so I thought of
> writing some higher level functions to produce the queries, a bit like
> these from Ken Ray:
>
> http://www.sonsothunder.com/devres/livecode/tips/data005.htm
>
> But before I start I wonder if anyone else has done these.
>
> I know André Garcia wrote a big package, but his site seems down:
>
> http://www.andregarzia.com/page/revspark
>
> Any pointers please?
>


_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: User friendly functions to replace MySQL queries?

Richmond Mathewson via use-livecode
That's the one. :-) Sorry for the confusion and thanks...

On 7 May 2017 at 22:57, Alex Tweedly via use-livecode <
[hidden email]> wrote:

> If it's a user-friendly way to call SQL, I don't think you want revSpark,
> you want his DBLib.
>
> I think the current / latest is at
>
> https://github.com/Himalayan-Academy/Siva-Siva-App/wiki/aagDBLib
>
> -- Alex.
>
> On 07/05/2017 21:55, Kaveh Bazargan via use-livecode wrote:
>
>> Hi all
>>
>> Writing MySQL queries using LiveCode is a bit painful, so I thought of
>> writing some higher level functions to produce the queries, a bit like
>> these from Ken Ray:
>>
>> http://www.sonsothunder.com/devres/livecode/tips/data005.htm
>>
>> But before I start I wonder if anyone else has done these.
>>
>> I know André Garcia wrote a big package, but his site seems down:
>>
>> http://www.andregarzia.com/page/revspark
>>
>> Any pointers please?
>>
>>
>
> _______________________________________________
> use-livecode mailing list
> [hidden email]
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



--
Kaveh Bazargan
Director
River Valley Technologies
@kaveh1000
+44 7771 824 111
www.rivervalleytechnologies.com
_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: User friendly functions to replace MySQL queries?

Richmond Mathewson via use-livecode
In reply to this post by Richmond Mathewson via use-livecode
sqlYoga is awesome. The learning curve is a bit steep at first, but once you get it, it's great. I wrote functions and a database setup interface that makes it all fairly transparent to use. I can share if you like.

Bob S


> On May 7, 2017, at 13:55 , Kaveh Bazargan via use-livecode <[hidden email]> wrote:
>
> Hi all
>
> Writing MySQL queries using LiveCode is a bit painful, so I thought of
> writing some higher level functions to produce the queries, a bit like
> these from Ken Ray:
>
> http://www.sonsothunder.com/devres/livecode/tips/data005.htm
>
> But before I start I wonder if anyone else has done these.
>
> I know André Garcia wrote a big package, but his site seems down:
>
> http://www.andregarzia.com/page/revspark
>
> Any pointers please?
>
> --
> Kaveh Bazargan
> Director
> River Valley Technologies
> @kaveh1000
> +44 7771 824 111
> www.rivervalleytechnologies.com
> _______________________________________________
> use-livecode mailing list
> [hidden email]
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: User friendly functions to replace MySQL queries?

Richmond Mathewson via use-livecode
Sounds great. Yes please Bob...

On 8 May 2017 at 16:21, Bob Sneidar via use-livecode <
[hidden email]> wrote:

> sqlYoga is awesome. The learning curve is a bit steep at first, but once
> you get it, it's great. I wrote functions and a database setup interface
> that makes it all fairly transparent to use. I can share if you like.
>
> Bob S
>
>
> > On May 7, 2017, at 13:55 , Kaveh Bazargan via use-livecode <
> [hidden email]> wrote:
> >
> > Hi all
> >
> > Writing MySQL queries using LiveCode is a bit painful, so I thought of
> > writing some higher level functions to produce the queries, a bit like
> > these from Ken Ray:
> >
> > http://www.sonsothunder.com/devres/livecode/tips/data005.htm
> >
> > But before I start I wonder if anyone else has done these.
> >
> > I know André Garcia wrote a big package, but his site seems down:
> >
> > http://www.andregarzia.com/page/revspark
> >
> > Any pointers please?
> >
> > --
> > Kaveh Bazargan
> > Director
> > River Valley Technologies
> > @kaveh1000
> > +44 7771 824 111
> > www.rivervalleytechnologies.com
> > _______________________________________________
> > use-livecode mailing list
> > [hidden email]
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
> _______________________________________________
> use-livecode mailing list
> [hidden email]
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



--
Kaveh Bazargan
Director
River Valley Technologies
@kaveh1000
+44 7771 824 111
www.rivervalleytechnologies.com
_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: User friendly functions to replace MySQL queries?

Richmond Mathewson via use-livecode
Aloha Friends,

I have been away for a while but I am about to make some cool announcements
today. I will be releasing some updates in the next few days for all
libraries including this one. Also re-uploading them to my site.

om om
andre

On Mon, May 8, 2017 at 1:30 PM, Kaveh Bazargan via use-livecode <
[hidden email]> wrote:

> Sounds great. Yes please Bob...
>
> On 8 May 2017 at 16:21, Bob Sneidar via use-livecode <
> [hidden email]> wrote:
>
> > sqlYoga is awesome. The learning curve is a bit steep at first, but once
> > you get it, it's great. I wrote functions and a database setup interface
> > that makes it all fairly transparent to use. I can share if you like.
> >
> > Bob S
> >
> >
> > > On May 7, 2017, at 13:55 , Kaveh Bazargan via use-livecode <
> > [hidden email]> wrote:
> > >
> > > Hi all
> > >
> > > Writing MySQL queries using LiveCode is a bit painful, so I thought of
> > > writing some higher level functions to produce the queries, a bit like
> > > these from Ken Ray:
> > >
> > > http://www.sonsothunder.com/devres/livecode/tips/data005.htm
> > >
> > > But before I start I wonder if anyone else has done these.
> > >
> > > I know André Garcia wrote a big package, but his site seems down:
> > >
> > > http://www.andregarzia.com/page/revspark
> > >
> > > Any pointers please?
> > >
> > > --
> > > Kaveh Bazargan
> > > Director
> > > River Valley Technologies
> > > @kaveh1000
> > > +44 7771 824 111
> > > www.rivervalleytechnologies.com
> > > _______________________________________________
> > > use-livecode mailing list
> > > [hidden email]
> > > Please visit this url to subscribe, unsubscribe and manage your
> > subscription preferences:
> > > http://lists.runrev.com/mailman/listinfo/use-livecode
> >
> > _______________________________________________
> > use-livecode mailing list
> > [hidden email]
> > Please visit this url to subscribe, unsubscribe and manage your
> > subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
> >
>
>
>
> --
> Kaveh Bazargan
> Director
> River Valley Technologies
> @kaveh1000
> +44 7771 824 111
> www.rivervalleytechnologies.com
> _______________________________________________
> use-livecode mailing list
> [hidden email]
> 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
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: User friendly functions to replace MySQL queries?

Richmond Mathewson via use-livecode
Friends,

I have fixed the page for the library
http://andregarzia.com/en/projects/dblib. I am also using github to track
development now and moved all the data to a repository linked on that page.
The library continues to be dual-licensed, GPL or Commercial, depending on
your needs.

I have just made a new release tagged v1.18 that moves from binary stacks
to plain-text stacks. New features will be added shortly. Previous
customers should be receiving an automated update email from sendowl with a
link.

Cheers
andre

On Thu, May 18, 2017 at 3:41 PM, Andre Garzia <[hidden email]> wrote:

> Aloha Friends,
>
> I have been away for a while but I am about to make some cool
> announcements today. I will be releasing some updates in the next few days
> for all libraries including this one. Also re-uploading them to my site.
>
> om om
> andre
>
> On Mon, May 8, 2017 at 1:30 PM, Kaveh Bazargan via use-livecode <
> [hidden email]> wrote:
>
>> Sounds great. Yes please Bob...
>>
>> On 8 May 2017 at 16:21, Bob Sneidar via use-livecode <
>> [hidden email]> wrote:
>>
>> > sqlYoga is awesome. The learning curve is a bit steep at first, but once
>> > you get it, it's great. I wrote functions and a database setup interface
>> > that makes it all fairly transparent to use. I can share if you like.
>> >
>> > Bob S
>> >
>> >
>> > > On May 7, 2017, at 13:55 , Kaveh Bazargan via use-livecode <
>> > [hidden email]> wrote:
>> > >
>> > > Hi all
>> > >
>> > > Writing MySQL queries using LiveCode is a bit painful, so I thought of
>> > > writing some higher level functions to produce the queries, a bit like
>> > > these from Ken Ray:
>> > >
>> > > http://www.sonsothunder.com/devres/livecode/tips/data005.htm
>> > >
>> > > But before I start I wonder if anyone else has done these.
>> > >
>> > > I know André Garcia wrote a big package, but his site seems down:
>> > >
>> > > http://www.andregarzia.com/page/revspark
>> > >
>> > > Any pointers please?
>> > >
>> > > --
>> > > Kaveh Bazargan
>> > > Director
>> > > River Valley Technologies
>> > > @kaveh1000
>> > > +44 7771 824 111
>> > > www.rivervalleytechnologies.com
>> > > _______________________________________________
>> > > use-livecode mailing list
>> > > [hidden email]
>> > > Please visit this url to subscribe, unsubscribe and manage your
>> > subscription preferences:
>> > > http://lists.runrev.com/mailman/listinfo/use-livecode
>> >
>> > _______________________________________________
>> > use-livecode mailing list
>> > [hidden email]
>> > Please visit this url to subscribe, unsubscribe and manage your
>> > subscription preferences:
>> > http://lists.runrev.com/mailman/listinfo/use-livecode
>> >
>>
>>
>>
>> --
>> Kaveh Bazargan
>> Director
>> River Valley Technologies
>> @kaveh1000
>> +44 7771 824 111
>> www.rivervalleytechnologies.com
>> _______________________________________________
>> use-livecode mailing list
>> [hidden email]
>> 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.
>



--
http://www.andregarzia.com -- All We Do Is Code.
http://fon.nu -- minimalist url shortening service.
_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: User friendly functions to replace MySQL queries?

Richmond Mathewson via use-livecode
In reply to this post by Richmond Mathewson via use-livecode
On 05/18/2017 11:41 AM, Andre Garzia via use-livecode wrote:
> Aloha Friends,
>
> I have been away for a while...

I believe we have a winner in the understatement of the week contest.

--
  Mark Wieder
  [hidden email]

_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: User friendly functions to replace MySQL queries?

Richmond Mathewson via use-livecode
auhaauhahuuhahauauhahu yes, it has been how long? years? :-P

On Thu, May 18, 2017 at 10:09 PM, Mark Wieder via use-livecode <
[hidden email]> wrote:

> On 05/18/2017 11:41 AM, Andre Garzia via use-livecode wrote:
>
>> Aloha Friends,
>>
>> I have been away for a while...
>>
>
> I believe we have a winner in the understatement of the week contest.
>
> --
>  Mark Wieder
>  [hidden email]
>
>
> _______________________________________________
> use-livecode mailing list
> [hidden email]
> 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
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: User friendly functions to replace MySQL queries?

Richmond Mathewson via use-livecode
Since I refuse to move over to HTML5 and Andre works on our projects, I have the joy of helping to make sure he sticks with this community.

@ Alex

cat's out of the bag… yes our current project (of which Andre has master minded a large part) is on git, public.

https://github.com/Himalayan-Academy/Siva-Siva-App

the only functional branch at the moment it "add-journal" which, for fun, you could you download. the mainloader stack to run is "Siva-Siva-App.livecode"

All code written by Andre, myself or anyone on our team (includes Jacque and, previously, David) is open source.

Hope to release V1 in Jun… still needs a lot of work. and we have big plans for this app in the future.  Wish us luck… it's been a bit of a slog with LC, but finally we have things work on mobile.

BR

 

On 5/18/17, 4:04 PM, "use-livecode on behalf of Andre Garzia via use-livecode" <[hidden email] on behalf of [hidden email]> wrote:

    auhaauhahuuhahauauhahu yes, it has been how long? years? :-P
   
    On Thu, May 18, 2017 at 10:09 PM, Mark Wieder via use-livecode <
    [hidden email]> wrote:
   
    > On 05/18/2017 11:41 AM, Andre Garzia via use-livecode wrote:
    >
    >> Aloha Friends,
    >>
    >> I have been away for a while...
    >>
    >
    > I believe we have a winner in the understatement of the week contest.
    >
    > --
    >  Mark Wieder
    >  [hidden email]
    >
    >
    > _______________________________________________
    > use-livecode mailing list
    > [hidden email]
    > 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
    [hidden email]
    Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
    http://lists.runrev.com/mailman/listinfo/use-livecode
   

_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Loading...