multi-tier options with fpc
Free Pascal doesn't support multi-tier database development out of the box. The good news is that there are a few options available.
tiOPF supports multi-tier development with Free Pascal. It uses the Indy 10.5's HTTP client and server components. It packs the SQL statements or data in XML, then compresses it with zlib, and then base64 encodes it, before sending the data packet over the wire. That greatly reduces the packet size, and thus leads to faster transfers.
With tiOPF based database applications, you can switch your application from local storage (XML, CSV or TAB) to Client/Server or to multi-tier, simply with a change of a compiler define. No need to change a single line of code in your application. See Demo 18 (Address Book demo) in the source code repository for a feature complete example of what tiOPF can do.
More alternatives may perhaps be found on the forum. If so, please update this page.