Loading JSON data into datasets is pretty straightforward using LoadFromFile or LoadFromStream. FireDAC provides these methods as part of its TFDDataset descendants. I have published several videos showing how easy it is to store generate JSON data with FireDAC and consuming it in a client application be this client application a web application or a VCL desktop application.
…
JSON has become the common format to store structured information in text files. Further, web services tend to return JSON these days. XML seems to have lost the battle as it generates too much meta-information nobody needs. In addition, developers hardly need the validation of XML documents which is not possible to implement using JSON.
…
Happy New Year!
A couple of weeks ago I showed how to use FireDAC to import text data into datasets. Furthermore, Local SQL was used to filter and make other changes to the data.
Delphi also offers very simple means to export data from a query or dataset in a file.
…
