[Info-vax] Layered products, the HP view !?!

[Stephen Hoffman]

On 2015-06-20 18:19:15 +0000, Jan-Erik Soderholm said:

> Stephen Hoffman skrev den 2015-06-20 18:15:
>> On 2015-06-20 09:53:33 +0000, Jan-Erik Soderholm said:
>> 
>>> I understand that from your earlier posts around databases and RMS as an
>>> possible alternative.
>>> 
>>> There is a *huge* difference between Rdb, DB2, MS SQL Server, Oracle 12
>>> and similar database products on one hand and the different embedded
>>> databases used in handheld devices and similar on the other.
>> 
>> Oracle Rdb, IBM DB2, Microsoft SQL Server and Oracle are all non-starters
>> here and seem somewhat less than relevant to the discussion, as two of
>> those four don't and won't run on OpenVMS,...
> 
> That was not the question. It was what the difference is between 
> "classic" databases and these new "embedded" database. That has nothing 
> with OpenVMS  to do. And this wasn't questioned by any anyway. so don't 
> correct *me*, I know this.

OK.  I see rather less of a difference here than you seem to, though 
there are trade-offs and applications do have different requirements.

Picking two of the more common choices outside of the Oracle databases, 
here are some of the limits: <http://www.sqlite.org/limits.html> 
<http://www.postgresql.org/about/>.

SQLite can run multithreaded and multiprocess, too: 
<http://www.sqlite.org/threadsafe.html> <https://sqlite.org/faq.html>  
PostgreSQL can, too.

I'd put what can now run on a smartphone up against some of the VMS 
databases I've seen, too — even against some of the smaller Rdb 
databases from the middling and older days of OpenVMS.  For many tasks, 
SQLite — once I got the hang of using it — is easier to deal with than 
the RMS services, too.  Not having to deal with the RMS record layouts 
is really handy, too.

In short, it seems a whole lot more of a continuum than any 
particularly "*huge*" difference.

> The rest is common knowledge...

Common knowledge isn't very common, unfortunately.


-- 
Pure Personal Opinion | HoffmanLabs LLC