Page 1 of 1

SVN 3370

PostPosted: Sun Oct 26, 2014 5:28 am
by HunabKu
Just for say i personnaly need to update the project to .NET Framework 4.5.1 to compile because of SQLite

Re: SVN 3370

PostPosted: Sun Oct 26, 2014 6:55 am
by 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 :)

Re: SVN 3370

PostPosted: Sun Oct 26, 2014 7:45 am
by HunabKu
Yep i approove to be up-to-date.

What GUI Tool do you use for SQLite Leodagan ?

Re: SVN 3370

PostPosted: Sun Oct 26, 2014 8:57 am
by 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 :)

Re: SVN 3370

PostPosted: Sun Oct 26, 2014 10:11 am
by 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.

Re: SVN 3370

PostPosted: Sun Oct 26, 2014 10:51 am
by 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 !

Re: SVN 3370

PostPosted: Sun Oct 26, 2014 11:11 am
by 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.

Re: SVN 3370

PostPosted: Sun Oct 26, 2014 11:27 am
by 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 :)

Re: SVN 3370

PostPosted: Sun Oct 26, 2014 12:50 pm
by HunabKu
I personnaly switched everything to MariaDB without any troubles, i feel it more interesting than MySQL.
Same for me ;-)