Re: [ANN] Introducing Remote DB Lib

2017-06-08 Thread Richard Gaskin via use-livecode 

Andre Garzia wrote:

> On Wed, Jun 7, 2017 at 7:43 PM, Richard Gaskin wrote:
>> VPSes are great when you need custom configuration, but they can be a
>> challenge to set up when you're learning, and a bigger challenge to
>> harden sufficiently, things a shared hosting service takes care of.
>
>> Is your library for the LC Server CGI, or does it require a custom LC
>> standalone daemon?
>
> The server part is PHP for maximum compatibility with cheap VPS
> everywhere but I am thinking about doing a LC based one as well.

To clarify, my question was mostly focused on whether your solution will 
work well on shared hosting services as it on VPSes.


Written in PHP, it sounds like it will.

--
 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: [ANN] Introducing Remote DB Lib

2017-06-07 Thread William Prothero via use-livecode 
Andre:
I just uploaded the php script and tested out your remoteDbLib. I love it. It 
will make db access much more robust and easier for me to manage. Great job!
Best,
Bill P

> On Jun 6, 2017, at 1:16 PM, Andre Garzia via use-livecode 
>  wrote:
> 
> DB Lib (andregarzia/projects/dblib) is a minimalistic database library for
> LiveCode that works on Desktop and Mobile and allows you to build
> database-savvy apps without writing SQL directly.
> 
> This post is to introduce a great new feature called Remote DB Lib. As you
> may know from posts on the mailing list and forums, many developers would
> like to use DB Lib in their apps over the internet. Like all other database
> libraries that work on top of RevDB, DB Lib (until today) needed to connect
> directly to the database server to work and this is not a good solution for
> apps that work over the internet since exposing MySQL to the internet at
> large is a huge security risk.
> 
> Today I am releasing the first version of a drop-in replacement library
> called **Remote DB Lib**. This new library has the same API as the current
> DB Lib but instead of working on top of RevDB, it works alongside a
> matching PHP file on your server, it is this PHP file that actually talks
> to the database server. The Remote DB Lib picks all your DB Lib calls and
> packs it on an encrypted message that is sent to the PHP file where it is
> decrypted and executed. This library is using state of the art AES 256
> encryption.
> 
> More info at: andregarzia.com/en/blog/introducing-remote-dblib
> 
> This new library is a part of the DB Lib product so all current customers
> should be receiving an update notice shortly. For those that don't have a
> license yet, this is a good time to get it and enhance the security of your
> apps.
> 
> Cheers
> 
> andre
> 
> 
> 
> 
> 
> -- 
> 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


___
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: [ANN] Introducing Remote DB Lib

2017-06-07 Thread Andre Garzia via use-livecode 
On Wed, Jun 7, 2017 at 7:43 PM, Richard Gaskin via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Is your library for the LC Server CGI, or does it require a custom LC
> standalone daemon?


The server part is PHP for maximum compatibility with cheap VPS everywhere
but I am thinking about doing a LC based one as well.


-- 
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: [ANN] Introducing Remote DB Lib

2017-06-07 Thread Richard Gaskin via use-livecode 

Andre Garzia wrote:

> My advise is for you to get a small VPS...
...
> Also, on-rev should be an easy sell here for RunRev helps sets things
> up right? Am I wrong? I haven't been up to date with on-rev stuff...

Is your library for the LC Server CGI, or does it require a custom LC 
standalone daemon?


If CGI then on-rev would seem a good fit, or HostM which also has LC 
pre-installed, or just about any other shared hosting service if you 
don't mind setting up the CGI yourself.


VPSes are great when you need custom configuration, but they can be a 
challenge to set up when you're learning, and a bigger challenge to 
harden sufficiently, things a shared hosting service takes care of.


--
 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: [ANN] Introducing Remote DB Lib

2017-06-07 Thread Andre Garzia via use-livecode 
Bill,

I think AWS is over complicated. It is its own ecosystem and has a steep
learning curve. I don't advise starting with it. It is a wonderful
collection of products but they are not that easy.

Cheers

On Wed, Jun 7, 2017 at 7:01 PM, William Prothero via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Andre:
> I actually don’t have anything in mind. But, I keep getting ads for AWS
> and am curious whether it would be useful. Anyway, it’s low priority and I
> really like the way your dB library simply takes an array and puts it into
> the dB without a lot of fussing around.
> Best,
> Bill
>
> > On Jun 7, 2017, at 12:10 PM, Andre Garzia via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >
> > William,
> >
> > I have considered updating my own FB library to use the new GraphQL
> > standard (it will be a major refactor, as in, from scratch). What other
> > services would you like?
> >
> > om om
> > andre
> >
> > On Wed, Jun 7, 2017 at 2:41 PM, William Prothero via use-livecode <
> > use-livecode@lists.runrev.com> wrote:
> >
> >> Andre, I’ll check this out.
> >>
> >> What would be really useful, tho, are libraries to access various web
> >> services that are becoming so popular these days.
> >>
> >> Bill P
> >>
> >>
> >>> On Jun 6, 2017, at 1:16 PM, Andre Garzia via use-livecode <
> >> use-livecode@lists.runrev.com> wrote:
> >>>
> >>> DB Lib (andregarzia/projects/dblib) is a minimalistic database library
> >> for
> >>> LiveCode that works on Desktop and Mobile and allows you to build
> >>> database-savvy apps without writing SQL directly.
> >>>
> >>> This post is to introduce a great new feature called Remote DB Lib. As
> >> you
> >>> may know from posts on the mailing list and forums, many developers
> would
> >>> like to use DB Lib in their apps over the internet. Like all other
> >> database
> >>> libraries that work on top of RevDB, DB Lib (until today) needed to
> >> connect
> >>> directly to the database server to work and this is not a good solution
> >> for
> >>> apps that work over the internet since exposing MySQL to the internet
> at
> >>> large is a huge security risk.
> >>>
> >>> Today I am releasing the first version of a drop-in replacement library
> >>> called **Remote DB Lib**. This new library has the same API as the
> >> current
> >>> DB Lib but instead of working on top of RevDB, it works alongside a
> >>> matching PHP file on your server, it is this PHP file that actually
> talks
> >>> to the database server. The Remote DB Lib picks all your DB Lib calls
> and
> >>> packs it on an encrypted message that is sent to the PHP file where it
> is
> >>> decrypted and executed. This library is using state of the art AES 256
> >>> encryption.
> >>>
> >>> More info at: andregarzia.com/en/blog/introducing-remote-dblib
> >>>
> >>> This new library is a part of the DB Lib product so all current
> customers
> >>> should be receiving an update notice shortly. For those that don't
> have a
> >>> license yet, this is a good time to get it and enhance the security of
> >> your
> >>> apps.
> >>>
> >>> Cheers
> >>>
> >>> andre
> >>>
> >>>
> >>> 
> >>>
> >>>
> >>> --
> >>> 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
> >>
> >>
> >> ___
> >> 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
>
>
> ___
> 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: [ANN] Introducing Remote DB Lib

2017-06-07 Thread William Prothero via use-livecode 
Andre:
I actually don’t have anything in mind. But, I keep getting ads for AWS and am 
curious whether it would be useful. Anyway, it’s low priority and I really like 
the way your dB library simply takes an array and puts it into the dB without a 
lot of fussing around.
Best,
Bill

> On Jun 7, 2017, at 12:10 PM, Andre Garzia via use-livecode 
>  wrote:
> 
> William,
> 
> I have considered updating my own FB library to use the new GraphQL
> standard (it will be a major refactor, as in, from scratch). What other
> services would you like?
> 
> om om
> andre
> 
> On Wed, Jun 7, 2017 at 2:41 PM, William Prothero via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> 
>> Andre, I’ll check this out.
>> 
>> What would be really useful, tho, are libraries to access various web
>> services that are becoming so popular these days.
>> 
>> Bill P
>> 
>> 
>>> On Jun 6, 2017, at 1:16 PM, Andre Garzia via use-livecode <
>> use-livecode@lists.runrev.com> wrote:
>>> 
>>> DB Lib (andregarzia/projects/dblib) is a minimalistic database library
>> for
>>> LiveCode that works on Desktop and Mobile and allows you to build
>>> database-savvy apps without writing SQL directly.
>>> 
>>> This post is to introduce a great new feature called Remote DB Lib. As
>> you
>>> may know from posts on the mailing list and forums, many developers would
>>> like to use DB Lib in their apps over the internet. Like all other
>> database
>>> libraries that work on top of RevDB, DB Lib (until today) needed to
>> connect
>>> directly to the database server to work and this is not a good solution
>> for
>>> apps that work over the internet since exposing MySQL to the internet at
>>> large is a huge security risk.
>>> 
>>> Today I am releasing the first version of a drop-in replacement library
>>> called **Remote DB Lib**. This new library has the same API as the
>> current
>>> DB Lib but instead of working on top of RevDB, it works alongside a
>>> matching PHP file on your server, it is this PHP file that actually talks
>>> to the database server. The Remote DB Lib picks all your DB Lib calls and
>>> packs it on an encrypted message that is sent to the PHP file where it is
>>> decrypted and executed. This library is using state of the art AES 256
>>> encryption.
>>> 
>>> More info at: andregarzia.com/en/blog/introducing-remote-dblib
>>> 
>>> This new library is a part of the DB Lib product so all current customers
>>> should be receiving an update notice shortly. For those that don't have a
>>> license yet, this is a good time to get it and enhance the security of
>> your
>>> apps.
>>> 
>>> Cheers
>>> 
>>> andre
>>> 
>>> 
>>> 
>>> 
>>> 
>>> --
>>> 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
>> 
>> 
>> ___
>> 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


___
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: [ANN] Introducing Remote DB Lib

2017-06-07 Thread Andre Garzia via use-livecode 
On Wed, Jun 7, 2017 at 4:11 PM, Dan Brown via use-livecode <
use-livecode@lists.runrev.com> wrote:

> I purchased to support and tinker. What would be really stellar is a
> livecode standalone that can be run on a webserver and act as a restful API
> endpoint for a database, all without the need for php. There are some
> websocket / httpd vodoo stacks floating around from years ago that were
> exploring that kind of functionality.  Revspark 2017 perhaps...
>

That sounds doable... DB Lib works on the server and can work with
RevSpark. Probably next week ;-)

A minimal RevSpark based server just for this. Should work

Thanks for this feedback, will build on it.

-- 
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: [ANN] Introducing Remote DB Lib

2017-06-07 Thread Dan Brown via use-livecode 
I purchased to support and tinker. What would be really stellar is a
livecode standalone that can be run on a webserver and act as a restful API
endpoint for a database, all without the need for php. There are some
websocket / httpd vodoo stacks floating around from years ago that were
exploring that kind of functionality.  Revspark 2017 perhaps...

On 7 Jun 2017 7:21 pm, "Bob Sneidar via use-livecode" <
use-livecode@lists.runrev.com> wrote:

> I watched the video, and discovered Andre uses some of the same function
> names as I use in my sqlYoga wrappers! DOH!
>
> Bob S
>
>
>
> ___
> 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: [ANN] Introducing Remote DB Lib

2017-06-07 Thread Andre Garzia via use-livecode 
Bob,

uhauhahuaahuahu I use basically the same names as Ralfs RevIgniter ORM so
you can credit him for coming up with them.

om om

On Wed, Jun 7, 2017 at 3:21 PM, Bob Sneidar via use-livecode <
use-livecode@lists.runrev.com> wrote:

> I watched the video, and discovered Andre uses some of the same function
> names as I use in my sqlYoga wrappers! DOH!
>
> Bob S
>
>
>
> ___
> 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: [ANN] Introducing Remote DB Lib

2017-06-07 Thread Andre Garzia via use-livecode 
William,

I have considered updating my own FB library to use the new GraphQL
standard (it will be a major refactor, as in, from scratch). What other
services would you like?

om om
andre

On Wed, Jun 7, 2017 at 2:41 PM, William Prothero via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Andre, I’ll check this out.
>
> What would be really useful, tho, are libraries to access various web
> services that are becoming so popular these days.
>
> Bill P
>
>
> > On Jun 6, 2017, at 1:16 PM, Andre Garzia via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >
> > DB Lib (andregarzia/projects/dblib) is a minimalistic database library
> for
> > LiveCode that works on Desktop and Mobile and allows you to build
> > database-savvy apps without writing SQL directly.
> >
> > This post is to introduce a great new feature called Remote DB Lib. As
> you
> > may know from posts on the mailing list and forums, many developers would
> > like to use DB Lib in their apps over the internet. Like all other
> database
> > libraries that work on top of RevDB, DB Lib (until today) needed to
> connect
> > directly to the database server to work and this is not a good solution
> for
> > apps that work over the internet since exposing MySQL to the internet at
> > large is a huge security risk.
> >
> > Today I am releasing the first version of a drop-in replacement library
> > called **Remote DB Lib**. This new library has the same API as the
> current
> > DB Lib but instead of working on top of RevDB, it works alongside a
> > matching PHP file on your server, it is this PHP file that actually talks
> > to the database server. The Remote DB Lib picks all your DB Lib calls and
> > packs it on an encrypted message that is sent to the PHP file where it is
> > decrypted and executed. This library is using state of the art AES 256
> > encryption.
> >
> > More info at: andregarzia.com/en/blog/introducing-remote-dblib
> >
> > This new library is a part of the DB Lib product so all current customers
> > should be receiving an update notice shortly. For those that don't have a
> > license yet, this is a good time to get it and enhance the security of
> your
> > apps.
> >
> > Cheers
> >
> > andre
> >
> >
> > 
> >
> >
> > --
> > 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
>
>
> ___
> 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: [ANN] Introducing Remote DB Lib

2017-06-07 Thread Andre Garzia via use-livecode 
Hey Bob,

Setting up web servers is beyond what I can do in that documentation. It is
not that hard but it is really outside of the scope of database libraries.
My advise is for you to get a small VPS on Digital Ocean, they cost 5 USD
per month and their setup guides are amazing, for example, check this one
out:


https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu-16-04

:D :D :D

Also, on-rev should be an easy sell here for RunRev helps sets things up
right? Am I wrong? I haven't been up to date with on-rev stuff...

On Wed, Jun 7, 2017 at 1:56 PM, Bob Sneidar via use-livecode <
use-livecode@lists.runrev.com> wrote:

> This will take some refactoring for me but I think I must go this route.
> Unfortunately, I have never set up a web server to do this, which I assume
> I will need to do. Does this add-on/plugin have basic instructions for
> getting that side up and running?
>
> Bob S
>
>
> > On Jun 6, 2017, at 13:16 , Andre Garzia via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >
> > DB Lib (andregarzia/projects/dblib) is a minimalistic database library
> for
> > LiveCode that works on Desktop and Mobile and allows you to build
> > database-savvy apps without writing SQL directly.
>
>
> ___
> 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: [ANN] Introducing Remote DB Lib

2017-06-07 Thread Andre Garzia via use-livecode 
Richard,

Solving database sync is a very custom job. It is quite tricky, I don't
know if I can build a generic enough lib for this but I might try. If I do,
then it will be added to DB Lib just like this one.

om om
andre

On Tue, Jun 6, 2017 at 8:47 PM, Richard Gaskin via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Andre Garzia wrote:
>
> > With this library you can have a local SQLite database on a mobile
> > app, then, use the new remote library to connect to a remote MySQL
> > server and sync data. Of course you would still need to write the sync
> > and conflict resolution code...
>
> I see another library opportunity there.
>
> --
>  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: [ANN] Introducing Remote DB Lib

2017-06-07 Thread Bob Sneidar via use-livecode 
I watched the video, and discovered Andre uses some of the same function names 
as I use in my sqlYoga wrappers! DOH! 

Bob S



___
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: [ANN] Introducing Remote DB Lib

2017-06-07 Thread Dan Brown via use-livecode 
I went ahead and purchased to show support and tinker but what would be
really stellar is a livecode restful api standalone that  runs on a
webserver  without the need for php. Revspark 2017 perhaps

On 7 Jun 2017 6:41 pm, "William Prothero via use-livecode" <
use-livecode@lists.runrev.com> wrote:

> Andre, I’ll check this out.
>
> What would be really useful, tho, are libraries to access various web
> services that are becoming so popular these days.
>
> Bill P
>
>
> > On Jun 6, 2017, at 1:16 PM, Andre Garzia via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >
> > DB Lib (andregarzia/projects/dblib) is a minimalistic database library
> for
> > LiveCode that works on Desktop and Mobile and allows you to build
> > database-savvy apps without writing SQL directly.
> >
> > This post is to introduce a great new feature called Remote DB Lib. As
> you
> > may know from posts on the mailing list and forums, many developers would
> > like to use DB Lib in their apps over the internet. Like all other
> database
> > libraries that work on top of RevDB, DB Lib (until today) needed to
> connect
> > directly to the database server to work and this is not a good solution
> for
> > apps that work over the internet since exposing MySQL to the internet at
> > large is a huge security risk.
> >
> > Today I am releasing the first version of a drop-in replacement library
> > called **Remote DB Lib**. This new library has the same API as the
> current
> > DB Lib but instead of working on top of RevDB, it works alongside a
> > matching PHP file on your server, it is this PHP file that actually talks
> > to the database server. The Remote DB Lib picks all your DB Lib calls and
> > packs it on an encrypted message that is sent to the PHP file where it is
> > decrypted and executed. This library is using state of the art AES 256
> > encryption.
> >
> > More info at: andregarzia.com/en/blog/introducing-remote-dblib
> >
> > This new library is a part of the DB Lib product so all current customers
> > should be receiving an update notice shortly. For those that don't have a
> > license yet, this is a good time to get it and enhance the security of
> your
> > apps.
> >
> > Cheers
> >
> > andre
> >
> >
> > 
> >
> >
> > --
> > 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
>
>
> ___
> 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: [ANN] Introducing Remote DB Lib

2017-06-07 Thread William Prothero via use-livecode 
Andre, I’ll check this out.

What would be really useful, tho, are libraries to access various web services 
that are becoming so popular these days. 

Bill P


> On Jun 6, 2017, at 1:16 PM, Andre Garzia via use-livecode 
>  wrote:
> 
> DB Lib (andregarzia/projects/dblib) is a minimalistic database library for
> LiveCode that works on Desktop and Mobile and allows you to build
> database-savvy apps without writing SQL directly.
> 
> This post is to introduce a great new feature called Remote DB Lib. As you
> may know from posts on the mailing list and forums, many developers would
> like to use DB Lib in their apps over the internet. Like all other database
> libraries that work on top of RevDB, DB Lib (until today) needed to connect
> directly to the database server to work and this is not a good solution for
> apps that work over the internet since exposing MySQL to the internet at
> large is a huge security risk.
> 
> Today I am releasing the first version of a drop-in replacement library
> called **Remote DB Lib**. This new library has the same API as the current
> DB Lib but instead of working on top of RevDB, it works alongside a
> matching PHP file on your server, it is this PHP file that actually talks
> to the database server. The Remote DB Lib picks all your DB Lib calls and
> packs it on an encrypted message that is sent to the PHP file where it is
> decrypted and executed. This library is using state of the art AES 256
> encryption.
> 
> More info at: andregarzia.com/en/blog/introducing-remote-dblib
> 
> This new library is a part of the DB Lib product so all current customers
> should be receiving an update notice shortly. For those that don't have a
> license yet, this is a good time to get it and enhance the security of your
> apps.
> 
> Cheers
> 
> andre
> 
> 
> 
> 
> 
> -- 
> 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


___
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: [ANN] Introducing Remote DB Lib

2017-06-07 Thread Bob Sneidar via use-livecode 
This will take some refactoring for me but I think I must go this route. 
Unfortunately, I have never set up a web server to do this, which I assume I 
will need to do. Does this add-on/plugin have basic instructions for getting 
that side up and running?

Bob S


> On Jun 6, 2017, at 13:16 , Andre Garzia via use-livecode 
>  wrote:
> 
> DB Lib (andregarzia/projects/dblib) is a minimalistic database library for
> LiveCode that works on Desktop and Mobile and allows you to build
> database-savvy apps without writing SQL directly.


___
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: [ANN] Introducing Remote DB Lib

2017-06-06 Thread Richard Gaskin via use-livecode 

Andre Garzia wrote:

> With this library you can have a local SQLite database on a mobile
> app, then, use the new remote library to connect to a remote MySQL
> server and sync data. Of course you would still need to write the sync
> and conflict resolution code...

I see another library opportunity there.

--
 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: [ANN] Introducing Remote DB Lib

2017-06-06 Thread Andre Garzia via use-livecode 
On Tue, Jun 6, 2017 at 5:45 PM, Mike Bonner via use-livecode <
use-livecode@lists.runrev.com> wrote:

> GREAT!  Love your library already, this makes it that much better.  Thank
> you!
>

I should have implemented that a long time ago rsrsrsrsrsrs... The cool
thing is the amount of security you get. If you choose a good encryption
key and also add a SSL certificate to your site (like the ones from Let's
Encrypt), you're essentially adding a very thick protection layer to your
database calls. A person would need not only to do a MITM attack on your
connection and also break the AES 256 encryption of the message. That is
quite hard to do. It is the first time that this kind of safe/remote
database library is available for LiveCode.

With this library you can have a local SQLite database on a mobile app,
then, use the new remote library to connect to a remote MySQL server and
sync data. Of course you would still need to write the sync and conflict
resolution code but it is much easier and safer than exposing your MySQL
server to the internet.


-- 
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: [ANN] Introducing Remote DB Lib

2017-06-06 Thread Mike Bonner via use-livecode 
GREAT!  Love your library already, this makes it that much better.  Thank
you!

On Tue, Jun 6, 2017 at 2:23 PM, Andre Garzia via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Remember to send me feedback! :D :D :D
>
>
>
> On Tue, Jun 6, 2017 at 5:19 PM, Skip Kimpel via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
> > Excited to try this out!
> >
> > SKIP
> >
> > On Tue, Jun 6, 2017 at 4:16 PM, Andre Garzia via use-livecode <
> > use-livecode@lists.runrev.com> wrote:
> >
> > > DB Lib (andregarzia/projects/dblib) is a minimalistic database library
> > for
> > > LiveCode that works on Desktop and Mobile and allows you to build
> > > database-savvy apps without writing SQL directly.
> > >
> > > This post is to introduce a great new feature called Remote DB Lib. As
> > you
> > > may know from posts on the mailing list and forums, many developers
> would
> > > like to use DB Lib in their apps over the internet. Like all other
> > database
> > > libraries that work on top of RevDB, DB Lib (until today) needed to
> > connect
> > > directly to the database server to work and this is not a good solution
> > for
> > > apps that work over the internet since exposing MySQL to the internet
> at
> > > large is a huge security risk.
> > >
> > > Today I am releasing the first version of a drop-in replacement library
> > > called **Remote DB Lib**. This new library has the same API as the
> > current
> > > DB Lib but instead of working on top of RevDB, it works alongside a
> > > matching PHP file on your server, it is this PHP file that actually
> talks
> > > to the database server. The Remote DB Lib picks all your DB Lib calls
> and
> > > packs it on an encrypted message that is sent to the PHP file where it
> is
> > > decrypted and executed. This library is using state of the art AES 256
> > > encryption.
> > >
> > > More info at: andregarzia.com/en/blog/introducing-remote-dblib
> > >
> > > This new library is a part of the DB Lib product so all current
> customers
> > > should be receiving an update notice shortly. For those that don't
> have a
> > > license yet, this is a good time to get it and enhance the security of
> > your
> > > apps.
> > >
> > > Cheers
> > >
> > > andre
> > >
> > >
> > > 
> > >
> > >
> > > --
> > > 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
> > >
> > ___
> > 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
>
___
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: [ANN] Introducing Remote DB Lib

2017-06-06 Thread Andre Garzia via use-livecode 
Remember to send me feedback! :D :D :D



On Tue, Jun 6, 2017 at 5:19 PM, Skip Kimpel via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Excited to try this out!
>
> SKIP
>
> On Tue, Jun 6, 2017 at 4:16 PM, Andre Garzia via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
> > DB Lib (andregarzia/projects/dblib) is a minimalistic database library
> for
> > LiveCode that works on Desktop and Mobile and allows you to build
> > database-savvy apps without writing SQL directly.
> >
> > This post is to introduce a great new feature called Remote DB Lib. As
> you
> > may know from posts on the mailing list and forums, many developers would
> > like to use DB Lib in their apps over the internet. Like all other
> database
> > libraries that work on top of RevDB, DB Lib (until today) needed to
> connect
> > directly to the database server to work and this is not a good solution
> for
> > apps that work over the internet since exposing MySQL to the internet at
> > large is a huge security risk.
> >
> > Today I am releasing the first version of a drop-in replacement library
> > called **Remote DB Lib**. This new library has the same API as the
> current
> > DB Lib but instead of working on top of RevDB, it works alongside a
> > matching PHP file on your server, it is this PHP file that actually talks
> > to the database server. The Remote DB Lib picks all your DB Lib calls and
> > packs it on an encrypted message that is sent to the PHP file where it is
> > decrypted and executed. This library is using state of the art AES 256
> > encryption.
> >
> > More info at: andregarzia.com/en/blog/introducing-remote-dblib
> >
> > This new library is a part of the DB Lib product so all current customers
> > should be receiving an update notice shortly. For those that don't have a
> > license yet, this is a good time to get it and enhance the security of
> your
> > apps.
> >
> > Cheers
> >
> > andre
> >
> >
> > 
> >
> >
> > --
> > 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
> >
> ___
> 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: [ANN] Introducing Remote DB Lib

2017-06-06 Thread Skip Kimpel via use-livecode 
Excited to try this out!

SKIP

On Tue, Jun 6, 2017 at 4:16 PM, Andre Garzia via use-livecode <
use-livecode@lists.runrev.com> wrote:

> DB Lib (andregarzia/projects/dblib) is a minimalistic database library for
> LiveCode that works on Desktop and Mobile and allows you to build
> database-savvy apps without writing SQL directly.
>
> This post is to introduce a great new feature called Remote DB Lib. As you
> may know from posts on the mailing list and forums, many developers would
> like to use DB Lib in their apps over the internet. Like all other database
> libraries that work on top of RevDB, DB Lib (until today) needed to connect
> directly to the database server to work and this is not a good solution for
> apps that work over the internet since exposing MySQL to the internet at
> large is a huge security risk.
>
> Today I am releasing the first version of a drop-in replacement library
> called **Remote DB Lib**. This new library has the same API as the current
> DB Lib but instead of working on top of RevDB, it works alongside a
> matching PHP file on your server, it is this PHP file that actually talks
> to the database server. The Remote DB Lib picks all your DB Lib calls and
> packs it on an encrypted message that is sent to the PHP file where it is
> decrypted and executed. This library is using state of the art AES 256
> encryption.
>
> More info at: andregarzia.com/en/blog/introducing-remote-dblib
>
> This new library is a part of the DB Lib product so all current customers
> should be receiving an update notice shortly. For those that don't have a
> license yet, this is a good time to get it and enhance the security of your
> apps.
>
> Cheers
>
> andre
>
>
> 
>
>
> --
> 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
>
___
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

[ANN] Introducing Remote DB Lib

2017-06-06 Thread Andre Garzia via use-livecode 
DB Lib (andregarzia/projects/dblib) is a minimalistic database library for
LiveCode that works on Desktop and Mobile and allows you to build
database-savvy apps without writing SQL directly.

This post is to introduce a great new feature called Remote DB Lib. As you
may know from posts on the mailing list and forums, many developers would
like to use DB Lib in their apps over the internet. Like all other database
libraries that work on top of RevDB, DB Lib (until today) needed to connect
directly to the database server to work and this is not a good solution for
apps that work over the internet since exposing MySQL to the internet at
large is a huge security risk.

Today I am releasing the first version of a drop-in replacement library
called **Remote DB Lib**. This new library has the same API as the current
DB Lib but instead of working on top of RevDB, it works alongside a
matching PHP file on your server, it is this PHP file that actually talks
to the database server. The Remote DB Lib picks all your DB Lib calls and
packs it on an encrypted message that is sent to the PHP file where it is
decrypted and executed. This library is using state of the art AES 256
encryption.

More info at: andregarzia.com/en/blog/introducing-remote-dblib

This new library is a part of the DB Lib product so all current customers
should be receiving an update notice shortly. For those that don't have a
license yet, this is a good time to get it and enhance the security of your
apps.

Cheers

andre





-- 
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