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.

 
 


October 4th, 2007

 

Contents

 

 

 



SQLite

How to Contribute to this Newsletter

editorial staff

We would like to have your contributions. We are gathering topics for future newsletters. Please write to us about your projects, activities and tips you have learned. Let us know what you would like to have featured in future issues as well. If you have ideas about how to grow the community share that as well.

 

You can subscribe, unsubscribe and change your preferences here.

Want a previous article? See our Newsletter Archive.


Warning: include(/home/runrev/public_html/html/include/banner.php) [function.include]: failed to open stream: No such file or directory in /home/runrev/public_html/runrev/html/newsletter/october/issue34/newsletter4.php on line 162

Warning: include() [function.include]: Failed opening '/home/runrev/public_html/html/include/banner.php' for inclusion (include_path='.:/usr/lib/php') in /home/runrev/public_html/runrev/html/newsletter/october/issue34/newsletter4.php on line 162
©2005 Runtime Revolution Ltd, 15-19 York Place, Edinburgh, Scotland, UK, EH1 3EB.
Questions? Email info@runrev.com for answers.