indie-stack
sqlite
| indie-stack | sqlite | |
|---|---|---|
| 4 | 7 | |
| 1,004 | 554 | |
| 2.0% | - | |
| 6.3 | 0.0 | |
| 14 days ago | 11 days ago | |
| TypeScript | C | |
| MIT License | ISC License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
indie-stack
-
Need help creating a site with least number of dependencies
Remix Indie Stack! https://github.com/remix-run/indie-stack
-
The Future of the Web Is on the Edge
I'm building an app using fly.io and SQLite and it's pretty interesting.
this indie-stack shows how to use the remix framework, fly.io, SQLite and Prisma together.
https://github.com/remix-run/indie-stack
I think fly.io will only expand their SQLite features with the creator of Litestream onboard. Exciting stuff!
https://fly.io/blog/all-in-on-sqlite-litestream/
-
Add a Global Progress indicator to your Remix app
I bootstrapped a new Remix app using the Indie Stack which already has tailwind installed as we are going to use it in this exercise.
-
Awesome SQLite
remix-run/indie-stack - The Remix Stack for deploying to Fly with SQLite, authentication, testing, linting, formatting, etc
sqlite
-
Redis Re-Implemented with SQLite
> 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
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
crawshaw/sqlite - Low-level Go interface to SQLite
-
A pure Go embedded SQL database
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?
The second well known driver is https://github.com/crawshaw/sqlite
What are some alternatives?
blues-stack - The Remix Stack for deploying to Fly with PostgreSQL, authentication, testing, linting, formatting, etc.
sqlite
sqlite-plus - The ultimate set of SQLite extensions
go-sqlite-lite - SQLite driver for the Go programming language
epic-stack - This is a Full Stack app starter with the foundational things setup and configured for you to hit the ground running on your next EPIC idea.
go-sqlite - Low-level Go interface to SQLite 3
litestream - Streaming replication for SQLite.
go-sqlite3 - sqlite3 driver for go using database/sql
remix-render - A remix stack for deploying remix to render.com with postgres
chai - Modern embedded SQL database
deno - A modern runtime for JavaScript and TypeScript.
ql