search

smogon / pokemon-showdown-client

The client for Pokémon Showdown
http://pokemonshowdown.com
GNU Affero General Public License v3.0
561 stars 790 forks source link

Postgres #1423

Open Zarel opened 4 years ago

Zarel commented 4 years ago

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 commented 4 years ago

Any progress on this @Zarel?

Zarel commented 4 years ago

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

marksg07 commented 3 years ago

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

AnnikaCodes commented 3 years ago

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

marksg07 commented 3 years ago

@scheibo @Zarel @AnnikaCodes how about now :o

mia-pi-git commented 3 years ago

@scheibo @Zarel @AnnikaCodes how about now :o

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

AnnikaCodes commented 3 years ago

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