[Info-vax] CRTL and RMS vs SSIO

[Arne Vajhøj]

On 10/6/2021 10:00 PM, Lawrence D’Oliveiro wrote:
> Given that nowadays an SQL-based RDBMS like SQLite can offer full
> support for transactions, joins and subqueries (missing only more
> multi-user-type features like locking and replication), and yet still
> be resource-light enough to fit in your mobile phone, I would say the
> time for application developers to be grubbing about in ISAM files is
> past.

There are still cases where it make sense. RMS index-sequential files
are really a NoSQL Key Value Store in modern terminology and
they are still used and new ones even being developed (like
RocksDB).

But the default should change.

"use index-sequential file unless good reason to use relational database"

=>

"use relational database unless good reason to use
index-sequential file"

Arne