[Info-vax] CRTL and RMS vs SSIO

[Dave Froble]

On 10/7/2021 11:50 AM, Arne Vajhøj wrote:
> 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
>
>

I'd suggest there should not be a "default".  Rather, make good 
thoughtful decisions.  Have valid reasons for any decisions or choices.

-- 
David Froble                       Tel: 724-529-0450
Dave Froble Enterprises, Inc.      E-Mail: davef at tsoft-inc.com
DFE Ultralights, Inc.
170 Grimplin Road
Vanderbilt, PA  15486