SVN 3370

[HunabKu]

Just for say i personnaly need to update the project to .NET Framework 4.5.1 to compile because of SQLite

[Leodagan]

And before that you didn't needed it ?

Well I though .NET 4.5.1 was already needed with previous revision (due to SQLite and MySQL drivers updates)

I know this can be troublesome but I think it shouldn't be too much constraints to keep .NET Framework up to date

[HunabKu]

Yep i approove to be up-to-date.

What GUI Tool do you use for SQLite Leodagan ?

[Leodagan]

I use this : https://github.com/sqlitebrowser/sqlitebrowser/releases

But it's only for testing purpose, SQLite still have a lot of limitations compared to MySQL and shouldn't be used for "production" Shard... (SQLite doesn't support Table altering, so you need to start from scratch with the actual DOLDatabase behavior !)

For my part I use copies of MySQL data to create my SQLite DB to have a "portable" DOL to be launched from an USB stick, it's pretty useful when you're not using your own computer to work on DOL

[HunabKu]

I've founded too the Navicat for SQLite but not free of charge.
SQLite is more efficient than MySQL / MariaDB (about performances) but yes it doesn't support Altering and multi-user
PostgreSQL is less efficient than MySQL / MariaDB (about performances) therefore removed from office.

[Leodagan]

With Current DOL behavior we would take no benefit of using PostGres...

Postgres is really usefull for storing object directly in database and use a lot of specific object method to remove work from server and give it to database !

For what I think this would need a lot of DOL part to be changed to take advantage of it, and other Database Driver won't be able to match up !

[Graveen]

PostgreSQL is open-source... MySQL is on double-licensing, which is somehow questionning for some kind of software.

I personnaly switched everything to MariaDB without any troubles, i feel it more interesting than MySQL.

[Leodagan]

Well for now I'm used to have both...

At office they were using both Oracle for critical software and Mysql for lower-end software, now that MySQL is owned by Oracle, the support is "mostly" included in the horribly expensive license for Oracle Enterprise (something like silver or gold support, I don't know the details exactly...) so they haven't switch to MariaDB.

For my part I don't have any more "MySQL binaries", everything has been drop-in replaced by MariaDB, maybe it's still embedded in the "Wamp Setup" I use for portability when working on DOL out of home

[HunabKu]

I personnaly switched everything to MariaDB without any troubles, i feel it more interesting than MySQL.

Same for me