Adobe AIR in Action

Chapter 5. Using local databases

 

This chapter covers

• Using basic SQL
• Creating databases
• Running SQL statements
• Adding parameters
• Retrieving record sets

 

In chapter 3, you learned how to work with the file system. Using a file system allows you to store data in a persistent fashion and organize that data in a variety of ways. Writing data to files is a great solution in some cases. For example, files are ideal for writing binary data such as images or videos that your application will need to load at runtime. Files are also great for portability. If you want to output text to a format that a user can easily send to a friend, a file is good for that. But as useful as files may be, they’re not a panacea for all things data. In this chapter, ...