Cockatrice: Migration to Postgresql

[detectiveYarmas]

Optimize db, and eventual migration to postgresql to help future proof the program.

[Daenyth]

Game plan:

• Get cockatrice running with strict mode mysql
• Then swap out the db backend

[detectiveYarmas]

First thing I'm doing is setting up a docker-compose file so that we can set up a server and check for errors without having to worry about destroying anything outside the container. I am still new to docker as is, so if you know docker well, let me know.

[ZeldaZach]

I believe we have a servatrice docker already established, but feel free to do anythign you need to do :)

[tooomm]

@detectiveYarmas In case you haven't seen it yet: https://github.com/Cockatrice/Cockatrice#servatrice-docker-container

[Daenyth]

I'm not a docker expert but I have a little experience - ping me on gitter if you have specific questions and hopefully I can point you in the right direction. A docker-compose file is a great idea.

[detectiveYarmas]

Right you are guys, as far as I can tell though the dockerfile compiles Servatrice, but doesn't set up any database, but with the compose file we can set up a database with it that we can at least control the settings of from one spot. Working on making that work now.

[Daenyth]

There's an official postgres docker image you should be able to use as a base - I've used it a bit. I image there's one for a mysql also. That would be convenient, I think.
https://hub.docker.com/_/postgres/

[leematos]

Also, we could potentially use a tool like http://pgloader.io/ to migrate a schema from MySQL to Postgres, Dump that, and rebuild the queries and tweak those.

[tooomm]

@detectiveYarmas any news or progress in between?

[detectiveYarmas]

Sorry for the absence, I've got it up and running with docker-compose and all that, will upload the files with git. Let me know if anyone has troubles with it.

[Daenyth]

@detectiveYarmas exciting news! Do you have a fork or gist where you've uploaded the changes?

[tooomm]

Please let us participate on your findings @detectiveYarmas!
Really cool that you got it working. ;)

[l1n]

@detectiveYarmas would love to see this!