[Info-vax] Integrated Databases (was: Re: The best VMS features, was: Re: openvms renaming file)

[Stephen Hoffman]

On 2018-05-28 18:56:17 +0000, seasoned_geek said:

> On Sunday, May 27, 2018 at 10:53:36 PM UTC-5, Stephen Hoffman wrote:
>> open source tools including open source databases, too.  Among other 
>> available choices, MariaDB, SQLite and PostgreSQL are all competent 
>> database products.
> 
> While I'm unfamiliar with MariaDB,

MariaDB is a fork of MySQL, and intended to be a drop-in replacement for MySQL.

> I can say SQLite isn't a relational database.

Others can and do disagree with that statement.

For those that might be curious about SQLite, here's an intro: 
https://www.dr-chuck.net/pythonlearn/slides/EN_us/Py4Inf-14-Databases.pdf 


Some additional reading:  
https://www.tutorialspoint.com/sqlite/index.htm    
https://en.wikibooks.org/wiki/SQLite/Introduction

> It's an SQL front end for a Btree system providing absolutely no data 
> integrity.

SQLite does quite nicely around transactions and integrity and ACID, 
and the few cases I've had with crashes and corruptions have repaired 
themselves.  The SQLite testing is quite extensive, and it shows.

For some background on the package:

https://www.sqlite.org/howtocorrupt.html
https://sqlite.org/transactional.html
https://www.sqlite.org/lockingv3.html

An OpenVMS (cluster-aware, using the DLM) native port of SQLite:
https://github.com/endlesssoftware/sqlite3

> PostgreSQL would be a phenom bundle for businesses looking for an 
> enterprise class database.

Ayup.   https://www.postgresql.org/docs/10/static/index.html

But that port has unfortunately been blocked by flaws in the OpenVMS 
SSIO implementation.


-- 
Pure Personal Opinion | HoffmanLabs LLC