[odb-users] after sqlite, choosing between postgresql and mysql

[MM]

On Sun, 3 Sept 2023 at 19:14, MM <finjulhich at gmail.com> wrote:

> Hello,
> We are expanding our state in that we need to have a client server database
> system to allow for concurrent read and write from different nodes.
>
> odb is finally paying off:-)
>
> This is a hard question but let me describe our use case
>
> 1. small number of concurrent users (under dozen)
> 2. 3 databases in use, some read only, some read and write
> 3. 2 dozen tables in each database
> 4. Nbr of rows in each table ranges from 10 to 100 000 max
> 5. Nbr of columns from 3/4 to 2 dozen columns, but only few tables
> 6. concurrency: most of the transactions are read. 10% perhaps or less are
> writes.
> 7. There may be a desire to do a cross database "transaction", i.e. either
> both databases are written successfully to or the transaction reverts on
> both.
>
> That is what I can think of at the moment. Any advice?
>
> MM


I realize it is not a closed ended question but if anyone has some
guidelines as to how to pick from odb mysql vs odb postresql, either from
experience or just generally,  that would be appreciated

rds,