Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Why I Built Litestream

litestream.io

Post reply on HN
Print view View original

41–50 of 178 posts

Re: Why I Built Litestream

#41

Post by majkinetor »

bob1029 wrote: post #24

> “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…

Thanks for details.

I yet wait to see how somebody serve 1M users on a web service using sqlite. Sounds like you can do all that since you create desktop app, you almost never need anything more then sqlite for that.

Re: Why I Built Litestream

#42

Post by growt »

lostmsu wrote: post #31
devmunchies wrote: post #29

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?

I'm sure it's delicious! :)

Re: Why I Built Litestream

#43

Post by tomaszs »

So I create database on VPS, than set up Litestream on s3. Than what? Should I also setup the copied database and use it from my production application? It seems like I don't understand the workflow here in a real case scenario. It my be because I didn't work with such setups

Re: Why I Built Litestream

#44

Post by benatkin »

"Litestream is a tool that runs in a separate process and continuously replicates a SQLite database to Amazon S3."

Why Amazon S3? Was it a huge invention by people at Amazon, and even if so, does it assign credit where it is deserved? Is Amazon helping the open web? I don't think so.

Re: Why I Built Litestream

#45

Post by moonlighter »

benatkin wrote: post #44

"Litestream is a tool that runs in a separate process and continuously replicates a SQLite database to Amazon S3." Why Amazon S3? Was it a huge invention by people at Amazon, and even if so, does it assign credit where it is deserved? Is Amazon helping the open web? I don't think so.

"Why Amazon S3?"

Because it's extremely cheap, durable and easy to read/write?

Re: Why I Built Litestream

#46

Post by RobRivera »

devmunchies wrote: post #16

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've legit fallen in love with sqlite. i save my global-scale infra chops for the dayjerb

Re: Why I Built Litestream

#47

Post by hangonhn »

On the GitHub repo ( https://github.com/benbjohnson/litestream ), it saids: "Litestream only communicates with SQLite through the SQLite API so it will not corrupt your database."

Does that mean I can use an in memory SQLite DB and have it replicated too? That would have some amazing potentials.

Re: Why I Built Litestream

#48

Post by grandrew »

Things are not quite that simple. You can't say "because my Go app serves a single request under no load in 50us, it will serve 20'000 per core under 100% load" you'd be surprised it will not.

Modern machines are like a networked cluster themselves. You need to do a ton of work to tune both kernel and "hardware" parameters to identify bottlenecks with near-non-existing debugging tools.

There is one truth here: we used to get more performance by scaling "horizontally". Maybe it's time to "scale within"?

Re: Why I Built Litestream

#49

Post by Sayrus »

benatkin wrote: post #44

"Litestream is a tool that runs in a separate process and continuously replicates a SQLite database to Amazon S3." Why Amazon S3? Was it a huge invention by people at Amazon, and even if so, does it assign credit where it is deserved? Is Amazon helping the open web? I don't think so.

They did invent it and name it like this. Is there an issue with calling it Amazon S3? Can't they get credit for it?

Even software such as Ceph calls themselves compatible with "Amazon S3 API".

Re: Why I Built Litestream

#50

Post by KingOfCoders »

devmunchies wrote: post #16

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

As a non-native speaker I struggle with "make". To me "make" for a side-business means "personal income" but it looks like you mean "revenue"?
Post reply on HN