In the previous section, we had a look at the persistence capabilities built into every FireDAC dataset. This is a really useful technique when you need to save and load back your datasets, possibly keeping the actual state (including local modifications).
However, this is not the equivalent of having an onboard or local database you can use to store a larger amount of data (the persistence mechanism is not incremental so you can actually save a large dataset, but you'll deal with it with a none-or-nothing strategy and you may spend some time waiting for the full dataset to load) or when you need to perform queries and extract (or store) data with datasets that can actually vary in shape (the columns or relation involved).
This is not really a FireDAC feature but it is the result of the combination of Delphi cross-platform support and FireDAC connectivity features; however, to add an onboard database to your applications is actually very easy.
The...
