Special

Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 21 in printed book and digital formats -- plus a one-year subscription (beginning with 22.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

Issue 11.2 ('Boolean')
Instant purchase and download via GumRoad!

COLUMN

Using REALSQLDatabase as your file format

The SQLite database behind REALSQLDatabase is ideal as your application's file format.

Issue: 11.2 (March/April 2013)
Author: Seth Verrinder
Author Bio: Seth is a consultant who uses Real Studio every day in his job at BKeeney Software, Inc.
Article Description: No description available.
Article Length (in bytes): 9,165
Starting Page Number: 68
Article Number: 12110
Related Web Link(s):

http://sqlite.org

Excerpt of article text...

I want to explore some areas of Real Software that aren't immediately accessible when you start out but that can give your programming a big boost once you start using them. One of those sleeper features is the built-in REALSQLDatabase class. Behind the scenes REALSQLDatabase uses the SQLite database a popular SQL database written in C. It's very fast but without sacrificing the safety of your user's data.

Most of us have rolled our own application file format at some point. It might have been a binary file where information was at a fixed position or maybe it was a comma-separated text file. These approaches have their place but if you are writing a desktop application in Real Studio, I think your first choice for an application file format should be REALSQLDatabase.

Advantages of SQLite

  • It's battle hardened

  • It won't corrupt your data

...End of Excerpt. Please purchase the magazine to read the full article.