[Info-vax] VMS databases

[Arne Vajhøj]

On 11/19/2023 2:17 PM, Neil Rieck wrote:
> On Sunday, November 19, 2023 at 1:39:35 PM UTC-5, David Jones wrote:
>> On Sunday, November 19, 2023 at 12:37:17 PM UTC-5, Stephen Hoffman wrote:
>>> If you ask nicely, SQLite will defer the locking until the commit:
>>>
>>> https://sqlite.org/cgi/src/doc/begin-concurrent/doc/begin_concurrent.md
>>>
>>> Otherwise, SQLite picks a simpler approach to database locking,
>>> permitting one concurrent writer.
>> "BEGIN CONCURRENT" is part of an experimental 'high concurrency' development
>> branch and is not in the mainline code published by SQLite.org. If you try it you just
>> get a syntax error.
>>
>> Use of WAL mode (write-ahead logging) can alleviate some of the concurrent write
>> issues. It wants to use shared memory to coordinate between processes, however,
>> posing an issue for databases residing on shared disks in a cluster.
> 
> I have only done a small amount of SQLite programming on OpenVMS. In
> fact, I suppose you could say that it was only at the evaluation
> level because after I ran into some obvious problems, I switched over
> to MySQL / MariaDB then never looked back.
> 
> Now that is not to say that this is a garbage product. Most Linux
> people know that SQLite is employed by  RPM/YUM/DNF to keep track of
> package dependencies.
> 
> As I understand it, SQLlite is also employed on most smart phones,
> and there are probably more of these in the world than laptops,
> desktops, towers and servers.
It is used by Android, iOS, macOS, some Linux and Unix, FireFox,
ThunderBird, various Adobe products, Skype, various car navigation
systems etc..

I think that most people use something that use SQLite.

SQLite is a fine product.

But as always one need to pick the right tool for the job.

SQLite and MySQL are not solutions for the same problem.

Arne