[Lazarus] SQLDBRestBridge

[Michael Van Canneyt]

On Sun, 6 Nov 2022, duilio foschi wrote:

> Hi Michael,
>
> I am digging into your SQLDBRestBridge component. Very useful code.
>
> I could fix and run both the server part and the client part (I used
> the BufDataset client).
>
> My code (with very few changes applied to the original one) can be
> downloaded from this link:
> https://mega.nz/file/Gxx3FBya#LbvDvuFnH5rUDVAdPoGyuUCnkNE761A62SZ1MYX8oFQ
>
> I hope it be helpful for somebody.
>
>
>
> I have 2 questions:
>
> 1. the client needs to know the name of the primary key (PK) of each
> table. Is there a way to ask the server for the name of the PK of
> table A?  Or to have the PK listed in the metadata?

Normally the server has this info, and the primary key is retrieved when
exposing a database. It is part of fieldinfo, but not yet exposed in the
metadata, I think. I will add it, this is easy to do.

> 2. the client needs to periodically refresh the visible rows in the
> event that another client applied changes to the DB. How is this done?
> I reckon that the client will remember the last command
> like
> BASEURL/resourcename?limit=10&Offset=50
> and reissue it. Right?

Yes, but you need to program this yourself.

Michael.