Free Pascal Database Server-Client Examples

[DeBritto]

Hi Everyone,

I'm looking for a Free Pascal/Lazarus source code that could teach me how to deal with database transactions/commits/selects/inserts/updates/deletes in a client-server structure. I know that we have some samples included in Lazarus IDE but I need something more "real world"application.

Please, could anyone tell where I can find it?

I'm trying to figure it out how to do it but it's not easy to follow the explanations I've found at Lazarus Wiki.

Best regards

[DonAlfredo]

http://synopse.info/fossil/wiki?name=SQLite3+Framework

The mORMot will give you all you need !

[Graeme]

Take a look at the tiOPF (Object Persistence Framework) - I've used it for the last 15 years in production code, and allows for Client/Server or 3-tier development, without changing a single line of code [when switching between the two]. tiOPF also manages the Create/Read/Update/Delete with Transactions for you. It also includes an [option] Model-GUI-Mediator implementation (similar idea to MVC or MVP), which allows you to hook up your business objects with GUI widgets - it makes standard GUI widgets (eg: TEdit, TComboBox, TStringGrid etc) "object-aware" and does two-way synchronisation (change the Object and the UI gets updated automatically - and vice versa). It also supports multiple DB components (SqlDB, Zeos, DOA, ADO, IBX etc) and multiple databases (Firebird, NexusDB, MySQL, Oracle, MS SQL Server etc) and even text file storage (XML). Switching between these is simply a change in a compiler define, and a recompile of your project.

There are tons of documentation, years of knowledge and FAQs in the non-expiring NNTP support newsgroup and stacks of examples (demos and real-world apps). Over 1700+ unit tests are run ever 2 hours 24/7 to makes sure the framework is always in a stable state.

tiOPF:  http://www.tiopf.com
Lazarus+tiOPF wiki page:  http://wiki.freepascal.org/tiOPF
tiOPF SourceForge project:  https://sourceforge.net/projects/tiopf/

[nullpointer]

Currently, most of the ways to create a communication process between client and server applications are via http requests. You just need to learn how to send and receive data from the protocol. Of course, Lazarus and Free Pascal have supported all of them.

However, if you need a ready-made component, you can study the Laz-N-Tier / DBNetAdapter / DBNetProcessor component developed by yangjixian (https://sourceforge.net/projects/laz-n-tier/). However, there are some lines of code that are outdated. I have adjusted it so that it can run well on Lazarus 4.0 + FPC 3.2.2

Please see: https://github.com/tauhidcp/dbnetadapter

or

Example GUI Based Lazarus Free Pascal Database Client Server Application (HTTP Request) :

https://github.com/tauhidcp/free-pascal-database-client-server-app

[Leledumbo]

I'm looking for a Free Pascal/Lazarus source code that could teach me how to deal with database transactions/commits/selects/inserts/updates/deletes in a client-server structure. I know that we have some samples included in Lazarus IDE but I need something more "real world"application.

The examples are real world, desktop database apps really are coded that way. The desktop app is the client, the dbms is the server. It can even be leveraged to cross the internet using HTTP tunnels, but the safe methods these days require you to understand HTTP and make wrapper APIs instead. But that doesn't change the communication to database, it simply adds a HTTP layer to transmit the data.