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)