Forum > Database
Wanted: Navigational Database
TRon:
--- Quote from: ron.dunn on March 10, 2024, 02:53:17 am ---You're thinking about how the dataset shows up in your code, I'm thinking about its impact on the DBMS.
--- End quote ---
Indeed I was/am. My apologies.
In case it was not clear already from my answer, I am not familiar with the concept (though I understand what I've read from your link). I am mostly familiar with relational databases.
So in that regards and unfortunately, I can't add anything else that might be useful.
Thaddy:
Have you considered Sqlite in combination with a TBufDataset?
TBufDataset can provide the navigational part.
One word of warning: Navigational access to a large database tables can soon become very slow.
In My view this should be an ideal combination of the two you need provided the navigational part uses filters to fetch its data or the database tables are not very large, say under 1000 records.
ron.dunn:
Thank you for the suggestion, it's how current solutions to the problem work, but I'm trying to do something better.
The scenario is a very large number of records with multiple pathways between them.
In a navigational scenario I can position a record pointer anywhere in that table, step through rows by one path (eg date), then switch to another path (eg customer).
In a relational scenario I'd need to consider the data volume, construct LIMIT/OFFSET clauses, and repeat the query/fetch for each change in path. A solution based on sqlite3 or duckdb is where I'll go if I can't find a viable alternative.
Thaddy:
Mind my warning about navigational access. For a local single user database it usually does not matter too much.
ginoo:
--- Quote from: Thaddy on March 10, 2024, 05:49:14 am ---Have you considered Sqlite in combination with a TBufDataset?
--- End quote ---
Hi Thaddy,
what do you mean by sqlite in combination with TBufDataset? Can you give an example?
Navigation
[0] Message Index
[*] Previous page