Mastodon

0 posts0 participants0 posts today

LavX NewsThe Siren Call of SQLite: Navigating Server-Side DeploymentsAs developers explore innovative architectures, SQLite's role in server-side applications raises both excitement and caution. This piece delves into the implications of using SQLite in production envi...<a href="https://news.lavx.hu/article/the-siren-call-of-sqlite-navigating-server-side-deployments" rel="nofollow noopener noreferrer" target="_blank">https://news.lavx.hu/article/the-siren-call-of-sqlite-navigating-server-side-deployments</a><a href="https://mastodon.cloud/tags/news" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#news</a> <a href="https://mastodon.cloud/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#tech</a> <a href="https://mastodon.cloud/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> <a href="https://mastodon.cloud/tags/FlyIO" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#FlyIO</a> <a href="https://mastodon.cloud/tags/LiteFS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LiteFS</a>

Alejandro Baez<a href="https://hachyderm.io/@markus" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@markus</a> I'm sorry for be the bearer of bad news friend, but here 😭: <a href="https://community.fly.io/t/sunsetting-litefs-cloud/20829?u=ab1" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://community.fly.io/t/sunsetting-litefs-cloud/20829?u=ab1</a> On the plus side, <a href="https://fosstodon.org/tags/litefs" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#litefs</a> is still being developed. Just not as a service anymore and more as utility. 🫠

Alejandro BaezAnd now I found out about <a href="https://fosstodon.org/tags/turso" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#turso</a>, an <a href="https://fosstodon.org/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a> service provider. 😅 They're using <a href="https://fosstodon.org/tags/libsql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#libsql</a> fork to make this doable.The premise on the service is simple. They build a distributed sqlite set up. You as a user can then use that.Knowing full well how to make a distributed sqlite and with backup control, this can take a lot of time. I can see value in that. 😅 And considering <a href="https://fosstodon.org/tags/litefs" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#litefs</a> cloud is deprecated... It may be a good try. 🫠<a href="https://turso.tech/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://turso.tech/</a>

GripNews🌗 跳過API，直接發送您的數據庫 · The Fly Blog ➤ 跳過API，直接發送您的數據庫 ✤ <a href="https://fly.io/blog/skip-the-api/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://fly.io/blog/skip-the-api/</a> 本文介紹了使用LiteFS作為API層的替代方案，並將數據庫直接發送到客戶端。這種方法可以提高靈活性和效率，但也有一些限制。 + 這是一種非常有趣的方法，可以提高效率和靈活性。 + 這種方法的限制是什麼？ <a href="https://mastodon.social/tags/%E6%95%B8%E6%93%9A%E5%BA%AB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#數據庫</a> <a href="https://mastodon.social/tags/API" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#API</a> <a href="https://mastodon.social/tags/LiteFS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LiteFS</a>

Paul Rohr<a href="https://fosstodon.org/@chrisg" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@chrisg</a> If you had to rank them in order, which aspects are most/least important to your vision?- storage engine - replication protocol(s) - backup / resilience mechanisms - query / indexing modes - primary means of access (web, SQL, ...) - licenseDo you see this falling somewhere on the <a href="https://hachyderm.io/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> / <a href="https://hachyderm.io/tags/Litestream" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Litestream</a> / <a href="https://hachyderm.io/tags/LiteFS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LiteFS</a> spectrum, or are you envisioning a new greenfield project?

Trey PiepmeierWell, this sure is neat. <a href="https://fly.io/blog/litefs-cloud/" rel="nofollow noopener noreferrer" target="_blank">https://fly.io/blog/litefs-cloud/</a>I’ll be very curious to see how much it ends up costing.<a href="https://indieweb.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> <a href="https://indieweb.social/tags/Litestream" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Litestream</a> <a href="https://indieweb.social/tags/LiteFS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LiteFS</a>

Markus 🤓✨<a href="https://hachyderm.io/tags/litefs" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#litefs</a> 0.4.0 for distributed <a href="https://hachyderm.io/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a> is out, and I’m really looking forward to trying it out! <a href="https://community.fly.io/t/litefs-v0-4-0-released/12278" rel="nofollow noopener noreferrer" target="_blank">https://community.fly.io/t/litefs-v0-4-0-released/12278</a>

Markus 🤓✨I've started building my public-data-enrichment-platform using <a href="https://hachyderm.io/tags/flyio" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#flyio</a>, <a href="https://hachyderm.io/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> and <a href="https://hachyderm.io/tags/LiteFS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LiteFS</a>, and <a href="https://hachyderm.io/tags/Golang" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Golang</a>. Fly is just such a breeze to work with.Not only do I now deploy to Amsterdam, Stockholm, and Frankfurt all at once (the platform is for Danish customers) for redundancy, but since by Grafana cloud setup automatically picks up the new app from Fly's Prometheus, I've got monitoring working right after deploy.Works so much easier than anything AWS ever offered!

Markus 🤓✨<a href="https://mstdn.dk/@polarcoder" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@polarcoder</a> Nice article, but it's aged a bit. <a href="https://hachyderm.io/tags/LiteFS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LiteFS</a> and <a href="https://hachyderm.io/tags/rqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#rqlite</a> are doing some really interesting things with distributed SQLite. I wrote up an article about LiteFS (using Go, but usable in all languages) if you're curious. 😊 <a href="https://www.golang.dk/articles/distributed-sqlite-with-litefs" rel="nofollow noopener noreferrer" target="_blank">https://www.golang.dk/articles/distributed-sqlite-with-litefs</a>

FErki<a href="https://babka.social/@serge" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@serge</a> The Litestream website has a nice overview of similar alternatives: <a href="https://litestream.io/alternatives/" rel="nofollow noopener noreferrer" target="_blank">https://litestream.io/alternatives/</a>Quite nice selection for various priorities and trade-offs.TL;DR: - <a href="https://fosstodon.org/tags/Litestream" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Litestream</a> is primarily for disaster recovery - <a href="https://fosstodon.org/tags/LiteFS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LiteFS</a> is a distributed file system from the same authors for "high availability and low global latency" - <a href="https://fosstodon.org/tags/rqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#rqlite</a> (and <a href="https://fosstodon.org/tags/dqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dqlite</a>) " trades higher durability for lower write throughput"

Recent searches

Search options

Administered by:

Server stats:

#litefs