[Info-vax] VMS databases

[Arne Vajhøj]

On 11/19/2023 4:00 PM, Arne Vajhøj wrote:
> 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.

I just did a check on my PC for what applications use SQLite.

A lot.

3 interesting ones:
* Oracle DB GDAL
* MySQL WorkBench
* PostgreSQL pgAdmin

:-)

Even if it is all about a database server then a small embedded database
can be the right tool for some task.

Arne