./more_optimizations
SQLite -> postgreSQL
So, I finally made the jump over to postgres. This allows me to future-proof the game on the back-end a little bit and break away from the prototyping I did in the beginning just to get something up and running, which SQLite is great for. But now, I need to start thinking and planning for more complex database schemas and a way to handle increasing amounts of database calls for when the time comes for an increased userbase (if ever at all).
The point is, I’d rather handle this now than later, similar to how I switched over to bun from node. It’s just easier to handle these things now that the game is being invested in more seriously.
fight modifiers
Before I changed databases, I did manage to get around to adding at least one fight modifier out of the three that will be initially available. It provides a small chance on the enemy you’re fighting to instantly die. This modifier is nice to have when fighting particularly hard non-boss fights. There are some tweaks I need to make for it still, but as of now, the prototype works.
Within the next day or so, I should be making it work in a scalable way as well as add the other two modifiers. And then from there, more story integration, and other ways to make the player’s character more interesting.
See you around,
-gnp