litefs

FUSE-based file system for replicating SQLite databases across a cluster of machines (by superfly)

Litefs Alternatives

Similar projects and alternatives to litefs

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better litefs alternative or higher similarity.

litefs discussion

Log in or Post with

litefs reviews and mentions

Posts with mentions or reviews of litefs. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-12-10.
  • Limbo: A complete rewrite of SQLite in Rust
    6 projects | news.ycombinator.com | 10 Dec 2024
    All this talk of “SQLite is not open contribution” never seems to consider that a project being “open contribution” doesn't mean the maintainers will accept your contributions.

    They have a process for contributions to follow: you suggest a feature, they implement it. It's far from the only project to take such a stance.

    Just in the SQLite “ecosystem” see the contribution policies of Litestream and LiteFS. I don't see people brandishing the ”not open contribution” to Ben's projects.

    https://github.com/superfly/litefs?tab=readme-ov-file#contri...

    https://github.com/benbjohnson/litestream?tab=readme-ov-file...

  • Litefs: FUSE-based file system for replicating SQLite databases
    1 project | news.ycombinator.com | 28 Aug 2024
  • Handle Incoming Webhooks with LiteJob for Ruby on Rails
    2 projects | dev.to | 22 Nov 2023
    Firstly, LiteJob's reliance on SQLite inherently restricts its horizontal scaling capabilities. Unlike other databases, SQLite is designed for single-machine use, making it challenging to distribute workload across multiple servers. This can certainly be done using novel technologies like LiteFS, but it is far from intuitive.
  • Experimenting on the Edge with Turso (and Go)
    2 projects | /r/golang | 28 Oct 2023
    Im curious to know if others have tried out Turso or LiteFS or any of the newer edge db providers that are popping up in 'real world' applications and what your experiences have been?
  • Skip the API, Ship Your Database
    5 projects | news.ycombinator.com | 13 Sep 2023
    Author here. I think we could have set better expectations with our Postgres docs. It wasn't meant to be a managed service but rather some tooling to help streamline setting up a database and replicas. I'm sorry about the troubles you've had and that it's come off as us being disingenuous. We blog about things that we're working on and find interesting. It's not meant say that we've figured everything out but rather this is what we've tried.

    As for this post, it's not managed SQLite but rather an open source project called LiteFS [1]. You can run it anywhere that runs Linux. We use it in few places in our infrastructure and found that sharing the underlying database for internal tooling was really helpful for that use case.

    [1]: https://github.com/superfly/litefs

  • SQLedge: Replicate Postgres to SQLite on the Edge
    9 projects | news.ycombinator.com | 9 Aug 2023
  • Fly.io Postgres cluster went down for 3 days, no word from them about it
    9 projects | news.ycombinator.com | 20 Jul 2023
  • LiteFS Cloud: Distributed SQLite with Managed Backups
    9 projects | news.ycombinator.com | 5 Jul 2023
    LiteFS works sorta like that. It provides read replicas on all your application servers so you can use it just like vanilla SQLite for queries.

    Write transactions have to occur on the primary node but that's mostly because of latency. SQLite operates in serializable isolation so it only allows one transaction at a time. If you wanted to have all nodes write then you'd need to acquire a lock on one node and then update it and then release the lock. We actually allow this on LiteFS using something called "write forwarding" but it's pretty slow so I wouldn't suggest it for regular use.

    We're adding an optional a query API over HTTP [1] soon as well. It's inspired by Turso's approach. That'll let you issue one or more queries in a batch over HTTP and they'll be run in a single transaction.

    [1]: https://github.com/superfly/litefs/issues/326

  • We Raised a Bunch of Money
    1 project | news.ycombinator.com | 28 Jun 2023
    Basically, LiteFS: https://github.com/superfly/litefs

    And then some load balancer cleverness that reroutes writes to a specific VM: https://fly.io/blog/globally-distributed-postgres/

  • Mycelite: SQLite extension to synchronize changes across SQLite instances
    8 projects | news.ycombinator.com | 25 Jun 2023
  • A note from our sponsor - SaaSHub
    www.saashub.com | 11 Dec 2024
    SaaSHub helps you find the best software and product alternatives Learn more →

Stats

Basic litefs repo stats
40
4,115
3.9
3 months ago

superfly/litefs is an open source project licensed under Apache License 2.0 which is an OSI approved license.

The primary programming language of litefs is Go.


Sponsored
CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai