Before You Get Started

This manual will walk you through how to create a To-Do application using SQL Yoga. As we walk through creating the application you will be shown how to use SQL Yoga to get things done.

We will use the GLX Application Framework as the foundation for the application. Before you continue you should download the To-Do Application tutorial files.

IMPORTANT: SQL Yoga Is Built On Top of RevDB And the Valentina (V4REV) External

SQL Yoga is built on top of RevDB and the Valentina external (V4REV). In order to use SQL Yoga you must have a version of LiveCode that supports database access or own a copy of the V4REV database external.

This sample is built using SQLite.

Download To-Do Sample Application

You can download the To-Do Application tutorial files here:

http://www.bluemangolearning.com/download/revolution/sql_yoga/sql_yoga_todo_app.zip

Start a Fresh LiveCode Session

Start up LiveCode and don't open any other stacks. This ensures that you don't have any stack name conflicts or conflicts caused by previous SQL Yoga tests while working on the tutorial.

Have A SQLite Database Editor At The Ready

When developing a database application it can be handy to have an application available for managing the database you are working on. The are numerous SQLite tools available. Here are links to two:

SQLite Manager for FireFox (free)

https://addons.mozilla.org/en-US/firefox/addon/5817

SQLiteManager by sqlabs (paid)

http://www.sqlabs.com/sqlitemanager.php

Optional: Install GLX Application Framework Plugin

If you want to look into how the sample application was configured using the framework then the GLX Application Framework plugin is required. This is optional and is not required to work through the tutorial. If you have not already installed the GLX Application Framework plugin you can get it at the following url:

http://www.bluemangolearning.com/download/revolution/glxapp_framework/glx_application_framework.zip

After downloading the framework distribution follow these instruction to install the GLX Application Framework plugin:

http://revolution.screenstepslive.com/spaces/revolution/manuals/glxapp/lessons/5489-Installing-the-Plugin

3 Comments

Jérôme Rosat

I use SQLite Database Browser. It is a freeware, public domain, open source visual tool used to create, design and edit database files compatible with SQLite. More info at http://sqlitebrowser.sourceforge.net/index.html

Vaughn Clement

I am finding that the directions assume that I know more than what is described. I tried to find the following using the link and it was nowhere to be found. A little more information would be helpful?

IMPORTANT: SQL Yoga Is Built On Top of RevDB And the Valentina (V4REV) External

SQL Yoga is built on top of RevDB and the Valentina external (V4REV). In order to use SQL Yoga you must have a version of Revolution that supports database access or own a copy of the V4REV database external.

Trevor DeVore

@Vaughn - you would need to contact Paradigma if you want to learn about the V4REV external. It is for working with the Valentina database. Unless you plan on using Valentina as your database you don't need to worry about it though. LiveCode gives you access to SQLite, MySQL, and PostgreSQL by default (through the RevDB database layer).

Add your comment

E-Mail me when someone replies to this comment