SQLite
Reddit take
Not enough linked mention summaries yet; the source excerpts below are the evidence.
Pros
- Since its essentially just one SQLITE table there are plenty of tutorials out there to get the basic functionality working.
- Sqlite on a cheap VPS with SSD storage
- Database: SQLite (with repositories pattern for data access)
- Storing it on SQLite or other database would be good since the data already persists, but I refuse to believe a game would actually be made to store a state on a database?
- I already know python and I was thinking about using Flask as the web framework and SQLite as the database.
Cons
- I’m using Node.js + Next.js (frontend/backend with React libs), SQLite with Prisma, and AWS SDK for Cloudflare R2 image/file uploads.
- I used Strapi CMS (although I should've used MongoDB or something else, I stuck with the default SQLite).
Sentiment
8 positive (80%) · 2 mixed (20%) · 0 negative (0%)
Trust + time weighted score: +77% · raw score 80%
What redditors said (10 of 10)
I’m using Node.js + Next.js (frontend/backend with React libs), SQLite with Prisma, and AWS SDK for Cloudflare R2 image/file uploads.
Since its essentially just one SQLITE table there are plenty of tutorials out there to get the basic functionality working.
Sqlite on a cheap VPS with SSD storage
Database: SQLite (with repositories pattern for data access)
Storing it on SQLite or other database would be good since the data already persists, but I refuse to believe a game would actually be made to store a state on a database?
I already know python and I was thinking about using Flask as the web framework and SQLite as the database.
SQLite has had no issues with concurrency (for me at least) since SQLite 3 using the WAL pragma. (Write Ahead Log).
I used Strapi CMS (although I should've used MongoDB or something else, I stuck with the default SQLite).
In terms of databases, you should learn about a relational SQL database like SQLite.
I am currently playing around with / building a boilerplate using: - Flask backend - SQLite for DB - JS / Alpine.JS - Tailwind / DaisyUI
Compare
Related
- React · related · 204 mentions
- Visual Studio Code · related · 168 mentions
- Next.js · related · 151 mentions
- Claude Code · related · 137 mentions
- Astro · related · 88 mentions
- Laravel · related · 82 mentions