FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexActive topicsAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour FWH - Data Access Layer
Antonio Linares
Posts: 44162
Joined: Thu Oct 06, 2005 05:47 PM
FWH - Data Access Layer
Posted: Wed Sep 10, 2025 06:40 AM 
</s>graph TD

%% Clusters / Subgraphs
subgraph subGraph0["Data Sources"]
  DBF["DBF Files"]
  MySQL["MySQL/MariaDB"]
  ADO["ADO Connections"]
  Arrays["Arrays/Hashes"]
end

subgraph subGraph1["Access Classes"]
  TDatabase["TDatabase&lt;br/&gt;DBF RDD Access"]
  FWMariaConnection["FWMariaConnection&lt;br/&gt;Native MySQL"]
  TRecSet["TRecSet&lt;br/&gt;ADO Wrapper"]
  FWRowSet["FWRowSet&lt;br/&gt;Array Data"]
end

subgraph Presentation["Presentation"]
  TXBrowse["TXBrowse&lt;br/&gt;Data Grid"]
  TDataRow["TDataRow&lt;br/&gt;Record Editor"]
end

%% Conexiones Data Sources -&gt; Access Classes
DBF --&gt; TDatabase
MySQL --&gt; FWMariaConnection
ADO --&gt; TRecSet
Arrays --&gt; FWRowSet

%% Conexiones Access Classes -&gt; Presentation
TDatabase --&gt; TXBrowse
FWMariaConnection --&gt; TXBrowse
TRecSet --&gt; TXBrowse
FWRowSet --&gt; TXBrowse

TDatabase --&gt; TDataRow
FWMariaConnection --&gt; TDataRow
TRecSet --&gt; TDataRow
<e>
regards, saludos

Antonio Linares
www.fivetechsoft.com
Otto
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: FWH - Data Access Layer
Posted: Wed Sep 10, 2025 07:21 PM
Dear Antonio,
thank you for the flowchart.

I have extended the classic architecture (Arrays, ADO, MySQL, DBF) with an additional data source: Microservice JSON API.
This is the variant I am working with – I use Variant B.
Through the access class TServiceClient, the microservice stands on equal footing with TDatabase or FWMariaConnection.
This allows us to feed TXBrowse or TDataRow directly with data from the microservice.

Variant A – Direct access:
TServiceClient communicates directly with the microservice (e.g., Desktop/Win32).

Variant B – Proxy access:
TServiceClient communicates via a PHP proxy script, which forwards requests to the microservice (e.g., web frontend with browser + PHP).

Best regards,
Otto






Antonio Linares
Posts: 44162
Joined: Thu Oct 06, 2005 05:47 PM
Re: FWH - Data Access Layer
Posted: Thu Sep 11, 2025 06:59 AM
Dear Otto,

Would you mind to share how have you implemented the Microservice JSON API ?

It seems very interesting :wink:
regards, saludos

Antonio Linares
www.fivetechsoft.com
Otto
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: FWH - Data Access Layer
Posted: Thu Sep 11, 2025 03:49 PM

Dear Antonio,

I’m glad you find the project interesting – I feel the same way. At the moment, however, it is designed as an in-house solution. I will check whether it’s possible to extract a simplified version. But you know better than anyone how much more effort it takes to build a function that can be used generally compared to one that solves a very specific problem.

Best regards,

Otto

Continue the discussion

Static archive · New replies & topics via GitHub Discussions