sqlite

Go SQLite3 driver (by crawshaw)

Sqlite Alternatives

Similar projects and alternatives to sqlite

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

sqlite reviews and mentions

Posts with mentions or reviews of sqlite. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-04-14.
  • Redis Re-Implemented with SQLite
    15 projects | news.ycombinator.com | 14 Apr 2024
    > You can get substantially better performance out of sqlite by using the lower level https://github.com/crawshaw/sqlite, turning on WAL etc, using a connection per goroutine for reads, and sending batches of writes over a buffered channel / queue to a dedicated writer thread. That way you can turn off SQLite’s built in per-connection mutex but still be thread safe since each connection is only used on a single thread at a time.

    Would this protect against a row update in the middle of a read? e.g. would a row at least be internally consistent at the time it was read?

  • SQLite in Go, with and Without Cgo
    16 projects | news.ycombinator.com | 13 May 2022
    The default go sqlite driver is https://github.com/mattn/go-sqlite3, which is quite lovely, but I ran into issues with concurrency on read only databases.

    I'm now using https://github.com/crawshaw/sqlite and it seems to address those issues (but I haven't gotten around to setting up a proper test to confirm). It may be worth perusing if you do run into performance problems. It does come with the caveat of not being a database/sql driver though.

  • Awesome SQLite
    17 projects | dev.to | 28 Apr 2022
    crawshaw/sqlite - Low-level Go interface to SQLite
  • A pure Go embedded SQL database
    10 projects | news.ycombinator.com | 29 Jan 2022
    crawshaw/sqlite actually uses CGo -- it's a wrapper around the C version of SQLite. For example, see https://github.com/crawshaw/sqlite/blob/23d646f8ac00d9dd2390...

    zombiezen/go-sqlite uses cznic's pure Go converted version of SQLite, so avoids CGo. It's explicitly stated to be "a fork of crawshaw.io/sqlite that uses modernc.org/sqlite, a CGo-free SQLite package. It aims to be a mostly drop-in replacement for crawshaw.io/sqlite."

  • Are both MySQL and Postgres drivers similar in quality?
    6 projects | /r/golang | 8 Nov 2021
    The second well known driver is https://github.com/crawshaw/sqlite
  • A note from our sponsor - SaaSHub
    www.saashub.com | 17 May 2024
    SaaSHub helps you find the best software and product alternatives Learn more →

Stats

Basic sqlite repo stats
7
554
0.0
27 days ago

crawshaw/sqlite is an open source project licensed under ISC License which is an OSI approved license.

The primary programming language of sqlite is C.


Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com