Update: SQL Yoga 1 is no longer available for sale. SQL Yoga 2 has been released under an MIT license. You can find the project at https://github.com/trevordevore/sql-yoga.
SQL Yoga extends the simplicity of LiveCode to databases by allowing you to treat your database like an object. Stop wrestling with SQL and see how easy database integration can be:
- Set properties rather than writing SQL
- Define searches using english words rather than arcane wildcard symbols
- Manipulate arrays, not cursors
- Easily generate searches from complex search UIs
- Tap into database table relationships to simplify code
With SQL Yoga you focus on using your data instead of worrying about accessing your data.
SQL Yoga is available under the GNU Affero General Public License (AGPL).
You can be released from the requirements of the license by purchasing a commercial license. Buying such a license is mandatory as soon as you develop commercial activities involving the SQL Yoga Library without disclosing the source code of your own applications. These activities include: offering paid services to customers as an ASP, using SQL Yoga in a web application, shipping SQL Yoga Library with a closed source product.
Download SQL Yoga 1.1.1 build 1
Read the change log (you really should).
Download the latest SQL Yoga distribution.
Read the API Documentation and How-To Manual
The SQL Yoga API documentation is included with the SQL Yoga download. You can also view it on the web.
The SQL Yoga How-To manual is available to help you accomplish various tasks.
Quick Overview: French Regions, Departments and Towns
The French Regions, Departments and Towns manual provides a quick walkthrough of a sample application that showcases SQL Yoga features. Check this out if you are new to SQL Yoga and want to see what it can do. View
In-Depth Tutorial: The To-Do Application
If you are ready to incorporate SQL Yoga into an application or just want to know how to use SQL Yoga from start to finish then check out the To-Do Application manual. This detailed tutorial provides you all the information you need to get up and running with SQL Yoga in your application. View
SQL Yoga IDE Plugin
The SQL Yoga distribution comes with an Revolution IDE plugin that helps perform some tasks and provides SQL query logging. Read the plugin manual to learn about what the plugin can do.
Visit the Forums
Forums are available for you to ask questions.
SQL Yoga Requirements
SQL Yoga is built on top of RevDB (the LiveCode database external). It also supports the Valentina external from http://www.valentina-db.com. In order to use SQL Yoga you must have a version of LiveCode (3.5 or later) that supports database access or own a copy of the V4REV database external.
The SQL Yoga source code is hosted at https://github.com/trevordevore/sql-yoga. You will find instructions on how to contribute to the project there.
Note: SQL Yoga has currently been tested with SQLite, MySQL, PostgreSQL, SQL Server (over ODBC) and Valentina (both local and client).
Pingback: SQL Yoga: A Flexible Database Library for Revolution : Releasable Revolution
Pingback: New Dates For Professional Application Development Course and Free Session Sponsored By RunRev : Releasable Revolution
Pingback: SQL Yoga Now Supports More Databases : Releasable Revolution
Pingback: SQL Yoga 1.0.1 Released with New IDE Plugin : Releasable Revolution
Pingback: SQL Yoga Updated : Releasable Revolution
Is this a version for Livecode 8 and 9? It seems this site was not updated for a long time. There are dead links and not even the name Revolution is replaced by Livecode where appropriate. Product is still available and useful?
The current version will not work with LC 8/9. Last week I started moving all of the code over to script only stacks. As part of that I’ve been updating the code to work with LC 8 and 9. As a plus, it should also work with LiveCode server. You can see the current code in the following branch on GitHub:
I’ve added the sqlyoga.livecodescript and sqlyoga_schema.livecodescript files which are the script only stacks. The other thing I’m seriously considering with this update is dropping the paid version of SQL Yoga and moving over to the MIT license.