[Tshwanelex-l] PostgreSQL or MySQL

[David Joffe]

Hi,


For ODBC editing we work more often with PostgreSQL so it's probably 
the better 'optimized and stabilized' and recommended at this point. 

However do take note of this, this is very important, that you may 
have to do once-off the first time you 'save as ODBC' for each 
database:

https://tshwanedje.com/kb/14


(For the TLex Online online dictionary backend though, we usually 
work with MySQL as it's traditinoally a bit more commonly available 
and supported etc. on web server hosting platforms, and was 
especially when we first implemented TLex Online.)

 - David




On 28 Nov 2022 at 12:13, Nika Zhenya wrote:

Date sent:	Mon, 28 Nov 2022 12:13:07 -0800
To:	tshwanelex-l at mailman.yale.edu
From:	Nika Zhenya <nika.zhenya at programando.li>
Subject:	[Tshwanelex-l] PostgreSQL or MySQL

> 
> Hi, in the user guide I see it is possible to use PostgreSQL or 
> MySQL as ODBC database, but I don't see which one is recommended. 
> So I wanted to ask:
> *   Which one is preferred, PostgreSQL or MySQL?
> *   For the end-user, which one is easier to configure? Since 
>     drives are required and so on.
> Thanks