Summary

In this chapter, we've examined ways to store and retrieve relational data on mobile devices and showed how FireDAC can work with a variety of products. We learned about several editions of the enterprise-grade InterBase database that have been made available for mobile devices, thus providing advanced security and scalability within an application that can be held in your hand. SQLite, a robust and open source library that is available everywhere, was shown to be quite capable, despite its simplicity and price.

Free database management tools were then introduced for each of these products. After that, we loaded those databases and showed you how to access tables and queries from your Delphi environment, as well as how to set up the connections to edit the same data when it's deployed to a mobile device. Finally, considerations for working with edit controls were presented, giving you a great start toward managing mobile data in a user-friendly way.

Now that...