[Info-vax] CRTL and RMS vs SSIO

[Dave Froble]

On 10/12/2021 3:55 PM, Arne Vajhøj wrote:
> 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

Are you suggesting writing and maintaining code for RDBMS is any different?


-- 
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