Forum > Database
Wanted: Navigational Database
ron.dunn:
I want a database that has both SQL and navigational support. By "navigational" I mean functions like get row, next row, previous row, etc; as well as SQL query capability.
It needs to support Linux (Intel) and Raspberry Pi, as well as (obviously) Free Pascal. Commercial offerings are fine.
ElevateDb looked like a great fit but they're completely unresponsive to all attempts at contact, so I think they must have fallen by the wayside. Actian's Zen Core might have worked, but they don't support Pi.
Any other ideas?
TRon:
Single or multi user ?
First thing that pops to mind is simply sqlite.
ron.dunn:
Sqlite will be my fallback position if I can't get what I want, but it lacks the navigational capability I'm after.
I do need multi-user, but sqlite is fine with the expected workload.
TRon:
--- Quote from: ron.dunn on March 10, 2024, 01:39:56 am ---Sqlite will be my fallback position if I can't get what I want, but it lacks the navigational capability I'm after.
--- End quote ---
I have no idea what you are talking about. A query descents from a dataset which has provision for that kind of functionality.
ron.dunn:
You're thinking about how the dataset shows up in your code, I'm thinking about its impact on the DBMS.
A relational implementation is about sets, navigational is about individual rows. https://en.wikipedia.org/wiki/Navigational_database
There are a few databases which combine both, two of which I referenced in my first post. I happen to have a workload that could benefit from this approach.
Navigation
[0] Message Index
[#] Next page