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.

Licensing

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.

Purchase a SQL Yoga Commercial License

SQL Yoga retails for $199. You can purchase a license at LiveCode store: http://livecode.com/store/marketplace/sql-yoga-1-0-0/

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.

Contributing

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

FacebookTwitterGoogle+Share

5 thoughts on “SQL Yoga

  1. Pingback: SQL Yoga: A Flexible Database Library for Revolution : Releasable Revolution

  2. Pingback: New Dates For Professional Application Development Course and Free Session Sponsored By RunRev : Releasable Revolution

  3. Pingback: SQL Yoga Now Supports More Databases : Releasable Revolution

  4. Pingback: SQL Yoga 1.0.1 Released with New IDE Plugin : Releasable Revolution

  5. Pingback: SQL Yoga Updated : Releasable Revolution

Leave a Reply

Your email address will not be published. Required fields are marked *