[Info-vax] CRTL and RMS vs SSIO

[Arne Vajhøj]

On 10/7/2021 1:25 PM, Dave Froble wrote:
> 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"
> 
> I'd suggest there should not be a "default".  Rather, make good 
> thoughtful decisions.  Have valid reasons for any decisions or choices.

Fair enough.

But the money math has changed.

I would say that over the last 30 years:

RDBMS license cost changed from expensive to free options available

RDBMS hardware resource cost changed from expensive to insignificant

writing and maintaining code to manage IDX file cost is more or less 
constant

Arne