Chapter 12. Database Techniques

Chapter 11, “Working with Databases,” covers all the basics for using an SQLite database in your Adobe AIR applications. Every interaction with a database that you’ll ever perform will use that information. But there are some other concepts and general techniques that you should also be aware of, and that’s the focus here.

This chapter teaches some new, more advanced ideas, as well as demonstrates a handful of best practices. To start, you’ll learn how to distribute a database with an application rather than having the application create it from scratch. The next three topics—prepared statements, fetching SELECT results in groups, and using transactions—can be used to improve the efficiency and security of your programs. ...

Get Adobe AIR (Adobe Integrated Runtime) with Ajax: Visual QuickPro Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.