New database library to be available shortly

[SoapDog]

Hey Folks,

Since I am about to release a new database library, I
decided to share a video about it.

https://vimeo.com/46918350

Feedback is welcome!

Cheers

[sturgis]

Great video, where is the link to more info? And do you have a price yet?

Do you still need testers?

[SoapDog]

I will post more information shortly.

I am just solving an issue with my online shopping provider. My PayPal payment page is appearing in Portuguese instead of English. Once this is solved the library will be made available.

Cheers
andre

[sturgis]

I already own it! Looking forward to trying it with lc server too. I have a few ideas, such as the posting arrays to lc server to make it easier to insert record batches into a remote db. Will make it So much easier to build db gateway scripts. Pass in the table, send encoded array, decode, 1 function call (after getting the connection up) and voila. Posted.

Hmm that makes me ponder a question. When building up criterias (wheres, likes) would it be possible to do that on the desktop, encode the array and send it, decode it remotely to the same array name and have it work? I mean easily enough to make it worthwhile.

Also, should I not be talking about this here yet? And are you going to have your own board here for questions? And can I start a few more sentences with and and/or also? Love the library so far.

[SoapDog]

Hey Sturgis,

I will have my own board but I don't see a reason not to use this thread too.

If you're working with LiveCodeServer, I recommend that you look into RevIgniter at http://www.revigniter.com, lots of the syntax for DB Lib was inspired by RevIgniter. Actually my library was made because I could not use RevIgniter on the desktop. It is a better solution for web stuff.

Now, with that said, you can use my library for web stuff and you can use "the bas64encode of the arrayencode of myarray" to transfer arrays back and forth. I do not recommend you using dbPreserverQueryParameters() to generate such array and sending it over. It is too powerful and too flexible. Someone evil might to the same and wreck your database. DB Lib was created mostly for SQLite mobile development so it completely ignores the whole XSS and SQL injection problem. On the web you can't be that naive.

I've used my own DB Lib on the web when I needed a quick solution and did not want to do a full RevIgniter app but that application is not exposed to the world and it is password protected so my db is somewhat safe.

[SoapDog]

Hey Guys and Gals,

I am thrilled to announced that DB Lib is now available to purchase at:

http://andregarzia.com/page/dblib

DB Lib is a new minimalistic database library inspired by RevIgniter and other
active record implementations. It makes it a lot easier to create common
database aware applications.

My main target is SQLite and mobile but this library works on the Desktop as well
and with any database engine supported by RevDB.

There is a screencast showing some of its usage at:

https://vimeo.com/46918350

I've also created a forum for support requests, feedback and general cheese talking at:

http://andregarzia.com/forum

Cheers
andre