SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Go Sqlite Projects
-
memos
An open-source, lightweight note-taking solution. The pain-less way to create your meaningful notes. Your Notes, Your Way.
Project mention: Memos: Open-source, lightweight note-taking solution | news.ycombinator.com | 2025-01-15 -
CodeRabbit
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.
-
Project mention: The definitive guide to using Django with SQLite in production đź’ˇ | dev.to | 2025-01-18
rqlite: The lightweight, user-friendly, distributed relational database built on SQLite
-
Go doesn't support migrations natively for that propuso we can use the popular golang-migrate package also if you use an ORM like GORM you can use it for that.
-
Next, let's write sql queries for retrieving our users & their permissions. Here we will use sqlc for type-safe code generation from our sql queries, and pgx as its backend
-
Project mention: The definitive guide to using Django with SQLite in production đź’ˇ | dev.to | 2025-01-18
... # Install wget and Litestream RUN --mount=type=cache,target=/var/cache/apt,sharing=locked --mount=type=cache,target=/var/lib/apt,sharing=locked \ apt-get update --fix-missing && \ apt-get install --no-install-recommends -y wget && \ wget https://github.com/benbjohnson/litestream/releases/download/v0.3.13/litestream-v0.3.13-linux-amd64.deb && \ dpkg -i litestream-v0.3.13-linux-amd64.deb ENTRYPOINT ["./entrypoint.sh"]
-
Project mention: Usql: Universal command-line interface for SQL databases | news.ycombinator.com | 2024-11-16
It seems to support quite a large number of database drivers. If file size is such a concern you could recompile it with unneeded drivers omitted.
https://github.com/xo/usql?tab=readme-ov-file#building
-
goose
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
I really really like Steampipe to do this kind of query: https://steampipe.io, which is essentially PostgreSQL (literally) to query many different kind of APIs, which means you have access to all PostgreSQL's SQL language can offer to request data.
They have a Kubernetes plugin at https://hub.steampipe.io/plugins/turbot/kubernetes and there are a couple of things I really like:
* it's super easy to request multiple Kubernetes clusters transparently: define one Steampipe "connection" for each of your clusters + define an "aggregator" connection that aggregates all of them, then query the "aggregator" connection. You will get a "context" column that indicates which Kubernetes cluster the row came from.
-
We will use awesome dbmate migration tool for our migrations.
-
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...
-
-
xo
Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server (by xo)
XO doesn’t have them built-in, but it uses easily customizable templates.
I added support for a bunch of postgres fancy stuff in a previous app, it wasn’t too difficult
https://github.com/xo/xo
-
Project mention: Show HN: Outerbase Studio – Open-Source Database GUI | news.ycombinator.com | 2024-12-04
Two more tools I really enjoy:
- https://www.beekeeperstudio.io/ - electron based and I find it really simple to use.
- https://github.com/k1LoW/tbls - generate markdown docs from databases (similar to DbVisualizer, but it's a static binary and you can just push the md files - see https://github.com/bbkane/envelope/tree/master/dbdoc for example)
-
Yeah, it'd be much nicer if libraries were designed to be driver agnostic, like redka which supports 4 different SQLite drivers:
https://github.com/nalgeon/redka/tree/main/example
-
upper.io/db
Data Access Layer (DAL) for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
-
mergestat-lite
Query git repositories with SQL. Generate reports, perform status checks, analyze codebases. 🔍 📊
-
It gets mentioned a lot in the context of database/sql and sqlc alternatives, but Jet has been a great alternative so far, most notably because of its non-issue with dynamic queries support.
https://github.com/go-jet/jet/
-
algernon
Small self-contained pure-Go web server with Lua, Teal, Markdown, Ollama, HTTP/2, QUIC, Redis, SQLite and PostgreSQL support ++
Project mention: Web Server with Support for HTTP, Lua, Markdown, JSX, BoltDB, Redis, PostgreSQL | news.ycombinator.com | 2024-03-11 -
I've been using Go with Goqu [1] for SQL for a lot of things lately. But, the language shouldn't matter much. The functions are just building the appropriate SQL clauses.
For some of the operations, the method I was using required marshaling the inputs to JSON before sending them over the wire. And that's nicer in a non SQL programming language. But both db's ultimately do have json_build_array/json_build_object for PostgreSQL or json_array/json_object for SQLite3.
[1] https://github.com/doug-martin/goqu
-
Project mention: Pagoda: Rapid, easy full-stack web development starter kit in Go | news.ycombinator.com | 2024-09-29
-
When I've used it in projects in the past its been through libraries like prisma-client-go. This is a really cool package. You define your schema, and run 1 command and you instantly have fully typed Go code to work with. I even used it to create a monitoring mobile app called Cronus.
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Go Sqlite discussion
Go Sqlite related posts
-
Memos: Open-source, lightweight note-taking solution
-
Rqlite: The distributed relational database built on SQLite
-
Limbo: A complete rewrite of SQLite in Rust
-
Amazon Aurora DSQL
-
Sqlpkg – The SQLite Extension Hub
-
PgPDF: Pdf Type and Functions for Postgres
-
Using SQLite as Storage for Web Server Static Content
-
A note from our sponsor - SaaSHub
www.saashub.com | 8 Feb 2025
Index
What are some of the best open-source Sqlite projects in Go? This list will help you:
# | Project | Stars |
---|---|---|
1 | memos | 36,692 |
2 | rqlite | 16,200 |
3 | migrate | 15,984 |
4 | sqlc | 14,170 |
5 | litestream | 11,412 |
6 | usql | 9,187 |
7 | goose | 7,631 |
8 | steampipe | 7,170 |
9 | dbmate | 5,681 |
10 | litefs | 4,210 |
11 | bun | 3,976 |
12 | xo | 3,770 |
13 | tbls | 3,599 |
14 | redka | 3,594 |
15 | upper.io/db | 3,553 |
16 | mergestat-lite | 3,483 |
17 | jet | 2,873 |
18 | algernon | 2,865 |
19 | goqu | 2,451 |
20 | pagoda | 2,286 |
21 | prisma-client-go | 2,234 |
22 | go-sqlbuilder | 1,498 |
23 | gobuffalo/pop | 1,465 |