Re^2: online database for desktop app

Thanks. Interesting thoughts. My data structure is quite simple. Two columns: 1. column to match a query, 2. columns contains results. Just reading. Any data maintenance is done in SQL. Your description of the process seems what I am looking for. Just searching if there are modules I can use in order to not reinvent the wheel (and probably build errors in it).

Comment on Re^2: online database for desktop app

Replies are listed 'Best First'.
Re^3: online database for desktop app by LanX (Saint) on Nov 04, 2018 at 13:37 UTC
Plz have a look at the sketched communication flow in my second footnote (updated). A CGI using JSON and DBI to run just 2 or 3 prepared statements returning AoAs should have less overhead than configuring a full REST/ODATA layer. Without knowing your app I can't judge how complicated it's supposed to become later, hence justifying the long term investment into abstraction. Cheers Rolf _{(addicted to the Perl Programming Language :) Wikisyntax for the Monastery FootballPerl is like chess, only without the dice} update NB: if you put these SQL-statements into a separate module you can use and test them directly. The additional CGI/JSON layer would be transparent.	[reply]

Replies are listed 'Best First'.

Re^3: online database for desktop app
by LanX (Saint) on Nov 04, 2018 at 13:37 UTC

A CGI using JSON and DBI to run just 2 or 3 prepared statements returning AoAs should have less overhead than configuring a full REST/ODATA layer.

Without knowing your app I can't judge how complicated it's supposed to become later, hence justifying the long term investment into abstraction.

Cheers Rolf
_{(addicted to the Perl Programming Language :)

Wikisyntax for the Monastery
FootballPerl is like chess, only without the dice}

update

NB: if you put these SQL-statements into a separate module you can use and test them directly. The additional CGI/JSON layer would be transparent.

[reply]