Postgres

[Zarel]

PS's database structure is currently a mess:

Login server:

MySQL:

• users
• ladders (dies a lot, has trouble timing out UPDATE queries)

TokuDB:

• replays (has weird bugs)

Sim server, included for completion:

plaintext:

• most logs

JSON:

• plugin state, room state (including room ranks)

CSV:

• global ranks

TSV:

• punishments

We don't have a good understanding on what's wrong with replays or ladders. The current plan is to migrate the login server databases Postgres in the hopes that it will have fewer issues, or at least allow more people like @monsanto to leverage their experience in Postgres.

[marksg07]

Any progress on this @Zarel?

[Zarel]

Heavens, no, I'm personally still really busy on Gen 8 mechanics.

[marksg07]

@Zarel @AnnikaCodes is there a current status on this? Is this migration still in the works, or is something else happening?

[AnnikaCodes]

It's in the works, but probably will take some time to happen.

[marksg07]

@scheibo @Zarel @AnnikaCodes how about now :o

[mia-pi-git]

@scheibo @Zarel @AnnikaCodes how about now :o

Still a long ways out. I wouldn't bet on it for quite some time.

[AnnikaCodes]

We're waiting for the loginserver TypeScript refactor before pursuing this further.