NoSQL Yoga?

This is the place to post technical queries about SQL Yoga

Moderators: FourthWorld, heatherlaine, Klaus, robinmiller, trevordevore

Post Reply
icouto
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 92
Joined: Wed May 29, 2013 1:54 am
Location: Sydney, Australia

NoSQL Yoga?

Post by icouto » Sat Oct 12, 2013 12:00 am

Are there any plans for SQL Yoga to support NoSQL databases, like MongoDB, CouchDB or ArangoDB?

shawnblc
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 342
Joined: Fri Jun 01, 2012 11:11 pm
Location: USA

Re: NoSQL Yoga?

Post by shawnblc » Sat Oct 12, 2013 2:04 am

icouto wrote:Are there any plans for SQL Yoga to support NoSQL databases, like MongoDB, CouchDB or ArangoDB?
Check out DBLib by Andre Garzia. It might be just what you're looking for.

icouto
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 92
Joined: Wed May 29, 2013 1:54 am
Location: Sydney, Australia

Re: NoSQL Yoga?

Post by icouto » Sat Oct 12, 2013 9:29 am

shawnblc wrote:Check out DBLib by Andre Garzia. It might be just what you're looking for.
The 'data storage' add-on to DBLib is very good, and Andre Garzia has indeed done an excellent job at providing basic NoSQL functionality through his simple datastore.

However, I'd still love to have a library that would allow me to access powerful datastore backends like MongoDB - specially if I could do it using LiveCode-like commands and functions, rather than having to write my queries in JavaScript, JSON or yet another language...

trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 1005
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

Re: NoSQL Yoga?

Post by trevordevore » Sat Oct 12, 2013 8:49 pm

At the moment I don't have plans to add NoSQL support to SQL Yoga. I don't use those types of databases myself so I haven't had a need to build a LiveCode library for interacting with them.
Trevor DeVore
ScreenSteps - https://www.screensteps.com

LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder

icouto
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 92
Joined: Wed May 29, 2013 1:54 am
Location: Sydney, Australia

Re: NoSQL Yoga?

Post by icouto » Sat Oct 12, 2013 9:55 pm

NoSQL is probably the most exciting development in the database world in decades. It rose out of a need to redefine basic database requirements, due to the way databases have become pervasive on the web, and used for everything from small personal sets of data, right through to petabytes of company information. Managing ever-increasing complex relationships between data which is often fluid and flexible, became a nightmare with traditional relational databases.

In a NoSQL database, you store your information in 'collections', not tables. In a collection each record - often called a 'document' - can have totally distinctive sets of fields. You can store a 'blog' document with a 'user' document in the same collection, and each user record can have a different number of fields. You can also embed documents inside each other. This flexibility means that your database basically has NO hard-set predefined schema. There are several other advantages as well, like amazing scalability, and data redundancy and safety.

MongoDB is arguably one of the most well-known and widely used NoSQL projects. They have downloadable binaries for all main platforms, and both GPL and Commercial licenses (if your project needs it). They have just received millions of dollars in private funding, and it should be worthwhile keeping an eye on their progress over the next several months.

MongoDB is also one of the easiest NoSQL databases to use. It uses JSON throughout - both to store data, as well as to make queries. The query language is reasonably simple, yet powerful - and they are expanding it. Considering that there are already a couple of JSON libraries in LiveCode, writing a driver for MongoDB might not be as difficult as writing a driver for MySQL, Postgres or Oracle...

A freeware and heavily documented LiveCode-only JSON library can be found here:

https://github.com/luxlogica/easyjson
Last edited by icouto on Sat Oct 12, 2013 10:08 pm, edited 1 time in total.

trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 1005
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

Re: NoSQL Yoga?

Post by trevordevore » Sat Oct 12, 2013 10:03 pm

Yes, I'm familiar with NoSQL databases, I just don't have need of them right now :-) My primary business isn't writing and selling LiveCode components so I only work with technologies that I use to develop products at my company.
Trevor DeVore
ScreenSteps - https://www.screensteps.com

LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder

icouto
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 92
Joined: Wed May 29, 2013 1:54 am
Location: Sydney, Australia

Re: NoSQL Yoga?

Post by icouto » Sat Oct 12, 2013 10:09 pm

trevordevore wrote:Yes, I'm familiar with NoSQL databases, I just don't have need of them right now :-) My primary business isn't writing and selling LiveCode components so I only work with technologies that I use to develop products at my company.
I understand - makes good business sense to focus resources where they're needed!

I'll keep my fingers crossed and hope that a NoSQL project may come your way soon!... :wink:

Post Reply

Return to “SQL Yoga”