On 10/28/24 1:09 AM, Lawrence D'Oliveiro wrote:
On Mon, 28 Oct 2024 00:58:34 -0400, 186282@ud0s4.net wrote:
Long back I did extensive development on a PICK-OS based DB called
'Revelation'. It DID do an early version of SQL. It was used for over
a decade.
HOWEVER you never used the SQL beyond the top-level selections
because it was too slow.
Pick wasn’t even a relational database.
Nope. Entirely different philosophy.
I liked it.
All hail multi-value :-)
Put together a little library - 'C' and Pascal and
to a degree even Python - over the years with functions
that do some of the same stuff on data strings you may
find in PICK. Tend to import it, often. Useful.
Hey, even made an abridged version for Ada !
Waste of effort alas ....
Back then, it was quite common to support open standards like SQL with “malicious compliance” -- deliberately make them look worse than your proprietary interface, to “persuade” your users to lock themselves in to your product.
Wasn't 'malicious' ... it's just that PICK was never
really MADE for SQL or its style of finding/sorting stuff.
SQL was an "add-on".
However the initial level selects, they DID save a lot
of time/effort. After that however .....
Anyway, search on "Advanced Revelation". It's still sold.
DOS alas. The 'OpenInsight' follow-on product is VASTLY
more expensive, albeit still MV.
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)