NoSQL Yoga?
Moderators: FourthWorld, heatherlaine, Klaus, robinmiller, trevordevore
-
- VIP Livecode Opensource Backer
- Posts: 92
- Joined: Wed May 29, 2013 1:54 am
- Location: Sydney, Australia
NoSQL Yoga?
Are there any plans for SQL Yoga to support NoSQL databases, like MongoDB, CouchDB or ArangoDB?
Re: NoSQL Yoga?
Check out DBLib by Andre Garzia. It might be just what you're looking for.icouto wrote:Are there any plans for SQL Yoga to support NoSQL databases, like MongoDB, CouchDB or ArangoDB?
-
- VIP Livecode Opensource Backer
- Posts: 92
- Joined: Wed May 29, 2013 1:54 am
- Location: Sydney, Australia
Re: NoSQL Yoga?
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.shawnblc wrote:Check out DBLib by Andre Garzia. It might be just what you're looking for.
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...
-
- VIP Livecode Opensource Backer
- Posts: 1005
- Joined: Sat Apr 08, 2006 3:06 pm
- Location: Overland Park, Kansas
- Contact:
Re: NoSQL Yoga?
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
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
-
- VIP Livecode Opensource Backer
- Posts: 92
- Joined: Wed May 29, 2013 1:54 am
- Location: Sydney, Australia
Re: NoSQL Yoga?
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
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.
-
- VIP Livecode Opensource Backer
- Posts: 1005
- Joined: Sat Apr 08, 2006 3:06 pm
- Location: Overland Park, Kansas
- Contact:
Re: NoSQL Yoga?
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
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
-
- VIP Livecode Opensource Backer
- Posts: 92
- Joined: Wed May 29, 2013 1:54 am
- Location: Sydney, Australia
Re: NoSQL Yoga?
I understand - makes good business sense to focus resources where they're needed!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'll keep my fingers crossed and hope that a NoSQL project may come your way soon!...