Sign in Join
Wiki copytemporary

multi-tier options with fpc: what changed

Revision 0 to 1. Removed lines have a minus sign; added lines have a plus sign.

Title: multi-tier options with fpc

OldNewLine
1+## Overview
2+
3+Free Pascal doesn't support multi-tier database development out of the box. The good news is that there are a few options available.
4+
5+## tiOPF
6+
7+[[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.
8+
9+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.
10+
11+## Laz-n-tier
12+
13+[Laz-n-tier](https://sourceforge.net/projects/laz-n-tier/) is a datasnap alternative for Lazarus. Some of its features are discussed in this Lazarus forum [thread](https://forum.lazarus.freepascal.org/index.php/topic,14147.0.html).
14+
15+## Synopse mORMot
16+
17+[Synopse *mORMot*](https://synopse.info/fossil/wiki/Synopse+OpenSource) is an Open Source Client-Server ORM (Object-Relational Mapping) SOA (Service Oriented Architecture) MVC (Model View Controller) framework for Delphi 6 up to Delphi 10.3 Rio and **Free Pascal**, targeting Windows/Linux for the server, and any platform for clients (including mobile or AJAX).
18+
19+## More alternatives
20+
21+More alternatives may perhaps be found on the [FPC Forums](https://forum.lazarus.freepascal.org). If so, please update this page.
22+
23+---
24+*From the Free Pascal wiki, page "multi-tier options with fpc", as it stood on 2020-07-05 after a change by Trev, out of the wiki's dump of 2024-05-26. Copyright stays with the author who wrote it, according to the old wiki's [[Licensing]] page. If you have concerns about this material, [message the admin](/wiki-contact).*
25+Category: Databases
26+Category: FPC

Back to history