Runtime Revolution
 
Articles Other News

Revolution Workshops: Work With Databases


by Revolution Staff


This workshop: Explore an SQL database front end

We know how important database access is to many of our users, so we're pleased to bring you this workshop focusing on how to get started with Revolution's database capabilities.

Database screenshot


By now, you've had an opportunity to use the world's easiest programming language to produce stunning multimedia, analyze text and access information on the Internet. With these skills you're well placed to process and present.

Many applications require accessing information stored in databases. Whether you're writing a desktop application to interact with a web service, a customer records database, a corporate employee information system or a web content management system the chances are you'll want to create or interact with a database.

Exploring Revolution: Work with Databases

Revolution allows you to access data stored in most databases and supports the industry standard Structured Query Language (SQL). Better yet, you can combine your data access with any look you choose: integrate rich media or blend with the OS. Your data application can be delivered as a native application on any platform Revolution supports.

In this workshop we show you how to create your own simple database front end. The example covers using etiher a local SQLite database, or a MySQL database located on a server. The techniques can easily be adapted to other SQL databases. You will learn how to display and update both text and binary data, as well as how to create a SQLite database by code.

Interactive Workshop: Learn How, Now

Try out the comprehensive database abilities in Revolution right now by downloading this workshop. In it, we show you how to complete several common tasks. As your understanding grows, you can change the examples and see the effects right within the workshop, or just drop the example code into a new project and create something completely new.

Get it now from within Revolution by opening the Message Box from the toolbar then pasting in the following and pressing return:

go stack URL "http://www.runrev.com/ws/databases.rev"

Or you can get it by downloading it from:

http://www.runrev.com/ws/databases.zip

We hope you have enjoyed this series on learning Revolution.

 
©2005 Runtime Revolution Ltd, 15-19 York Place, Edinburgh, Scotland, UK, EH1 3EB.
Questions? Email info@runrev.com for answers.