Welcome to the fourth edition of my Weekly Indie Log! After a week of marketing, last week was a coding week again - and code I did! I had several important infrastructure related updates to tackle.
MRR Update
Before we dive into the bits and pieces of coding week, a quick look at the MRR update for Stomod. I am now at $184 MRR for Stomod and it’s growing very nicely. My goal is to at least hit $200 by the end of this month, which I look to be on track for.
The week started off with a very important task on my todo list: migrate Stomod from SQLite to PostgreSQL.
After banging the drums of SQLite for so long, you might be wondering why I’m moving away from SQLite to PostgreSQL?
There are many reasons. The biggest reason is schema changes in SQLite are not very easy.
There are some schema changes which require me to create a new column, copy all the data over then drop the previous column. There are other different schema changes which are simply very tedious to perform in SQLite. With Stomod being a fast-moving application, there are times I need to switch things around a bit and I don’t just get the flexibility with SQLite.
The next reason being support for vector embeddings in SQLite. I have some planned features which would bring the “AI” aspect to Stomod and with PostgreSQL, I get highly performant vector embeddings with pg_vector whereas vector embeddings with SQLite is not great.
There’s also the case of my other product AssistFlare which is built on PostgreSQL. The idea of consolidating both products into a single database platform looked appealing to me.
I personally use
Migration of Stomod to Caddy Server
as its web server which proxied requests to the Next.js app running in the backend.
Whilst nginx was good, I wanted to move to for putting Caddy on my radar. He put together a very nice tutorial on how to get going with Caddy and that was what I used to get going with first, my AssistFlare Caddy setup and eventually the Stomod nginx to Caddy migration. You can check out the tutorial below if you’re interested.
Other Stomod Feature Updates
Once having done the two big migrations mentioned above, I then shifted focus to implementing customer-requested features for Stomod.
Multiple Subdirectory Blogs and Tag Aliasing
Stomod allows you to host your blog at a freely provided *.stomod.com subdomain or using your own custom domain or custom subdomain - for e.g. - “Use Cases” needed to be accessible at
This hopefully will close this type of support request (which is mostly all I get as support request on Stomod).
That’s it from me in terms of this week’s Weekly Indie Log! Catch you in the next one! Cheers! 😀
SOCIAL SHARE CARD GENERATOR