31–40 of 178 posts
Earlier quoted context omitted.
You make $200k/m delivering cookies in two cities? That’s incredible! Always amazed by these niche businesses that make bank
we only have a single kitchen and it seems just above 200k is our ceiling for a single location. Expanding soon. we took down our revenue from indiehackers but somebody took a screenshot and posted on twitter of the stripe verified revenue. https://pbs.twimg.com/media/EXbNBVUX0AAotOo?format=jpg&name=...
> “But nobody writes production applications with SQLite, right?" We've been doing it for 5 years now. Basic tricks we employ are: Use PRAGMA user_version for purposes of managing automatic migrations, a. la. Entity Framework. This means you can actually do one better than Microsoft's approach, because you don't need a special unicorn table to store migration info. A simple integer compared with your latest integer a…
Awesome! I built a side-business that runs completely on Crystal + SQLite. Very light, fast service and makes ~$200k/mo. I just cp my sqlite file to S3 every 2 hours. From my app, i have a page[1] where i can load any snapshot database saved on S3. I can backup at anytime too with a click, which i do before deployment. [1]: https://i.imgur.com/Ls1Tnxc.png
I'm too building a site on Crystal. This is my first production site(static comment). Would love to hear some story about how you run it.
Especially how you manage migration with Crystal+SQlite?
Awesome! I built a side-business that runs completely on Crystal + SQLite. Very light, fast service and makes ~$200k/mo. I just cp my sqlite file to S3 every 2 hours. From my app, i have a page[1] where i can load any snapshot database saved on S3. I can backup at anytime too with a click, which i do before deployment. [1]: https://i.imgur.com/Ls1Tnxc.png
Awesome! I built a side-business that runs completely on Crystal + SQLite. Very light, fast service and makes ~$200k/mo. I just cp my sqlite file to S3 every 2 hours. From my app, i have a page[1] where i can load any snapshot database saved on S3. I can backup at anytime too with a click, which i do before deployment. [1]: https://i.imgur.com/Ls1Tnxc.png
Congratulations my dude!
> “But nobody writes production applications with SQLite, right?" We've been doing it for 5 years now. Basic tricks we employ are: Use PRAGMA user_version for purposes of managing automatic migrations, a. la. Entity Framework. This means you can actually do one better than Microsoft's approach, because you don't need a special unicorn table to store migration info. A simple integer compared with your latest integer a…
I'm used to leaning on SQLite for desktop apps, but now I'm keen to think about it WRT to web apps using these tips.
This is fantastic. I have hemmed and hawed in doing similar things to build a serverless database. (both in the embedded sense and the FaaS sense) I could have a file or more per client and pay nothing until they load the app. There are a lot of use-cases as in mine that have low read frequency and low or no updates yet high write throughput. I would love to not have to pay for keeping all my indexes in hot ram If at…
Earlier quoted context omitted.
we only have a single kitchen and it seems just above 200k is our ceiling for a single location. Expanding soon. we took down our revenue from indiehackers but somebody took a screenshot and posted on twitter of the stripe verified revenue. https://pbs.twimg.com/media/EXbNBVUX0AAotOo?format=jpg&name=...
Is that gross?