I’m working on a new project. Can’t really disclose a lot but I can tell you its going to be based on Golang/REACT and I’m hoping to scale it to handle at least 100k hits per day. Because I’m a cheap bastard, I’m going to try to spend as little money as possible. I plan to document the entire process here.
Technologies Used
- Golang
- Docker
- SQLite
- React
3rd Party Services Used
- Oracle Cloud Infrastructure/Google Cloud
- Hosting the Golang backend
- OCI NoSQL database/Firebase
- Hosting user generated data
- SupaBase
- User authenitcation
- PostHog
- Analytics
- Vercel
- Hosting the React Frontend
Why SQLITE?
The project that I’m working on relies on a lot of static data. By storing this data in an SQLite, I’m decreasing the need to make additional network calls to a remote database. The initial data would consist of about 50,000 rows in the SQLite database which would take up about 5-6 megabytes. Each database would be deployed in a docker container with the Golang application.
SQLite can easily handle 100k http requests per day (You can read more about uses for SQLite here). I’m enabling WAL mode (Write-Ahead Logging) to make the database more performant since the database would only be accessed via a single host.
Feel free to comment or reach out to me on Bluesky (https://bsky.app/profile/rooseveltanderson.bsky.social)