Oliveriver / 5d-diplomacy-with-multiverse-time-travel

5D Diplomacy With Multiverse Time Travel
Other
217 stars 29 forks source link

Consider porting the database to SQLite and/or Postgres #12

Open avioletheart opened 1 month ago

avioletheart commented 1 month ago

for running the game locally on a player's machine, it's a lot easier to use a single-file sqlite database, rather than setting up a microsoft sql server; for cloud hosting, postgresql is a lot cheaper and easier to run

while i generally don't like ORMs like EFCore, the abstraction might make it easier to port to other database engines in this case.

Stefan-5422 commented 1 month ago

In this case I think moving database should be as simple as simply changing the database provider in the Program.cs file.