The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →
Top 23 Go Sqlite Projects
-
memos
An open source, lightweight note-taking service. Easily capture and share your great thoughts.
Project mention: GitHub issues from top Open Source Golang Repositories that you should contribute to | dev.to | 2024-01-15Memos - customise max content length of memo
-
Project mention: The lightweight, easy-to-use, distributed relational database built on SQLite | news.ycombinator.com | 2024-02-23
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
$ curl -L https://github.com/golang-migrate/migrate/releases/download/$version/migrate.$os-$arch.tar.gz | tar xvz
-
"Is there a way to get sqlc to use pointers for nullable columns instead of the sql.Null types?"
-
This presentation is focused on the use-case of vertically scaling a single server and driving everything through that app server, which is running SQLite embedded within your application process.
This is the sweet-spot for SQLite applications, but there have been explorations and advances to running SQLite across a network of app servers. LiteFS (https://fly.io/docs/litefs/), the sibling to Litestream for backups (https://litestream.io), is aimed at precisely this use-case. Similarly, Turso (https://turso.tech) is a new-ish managed database company for running SQLite in a more traditional client-server distribution.
-
Project mention: xo/usql: Universal command-line interface for SQL databases | /r/devel | 2023-06-08
-
Readers may also enjoy Steampipe [1], an open source CLI to live query Google Sheets [2] and 140+ other services with SQL (e.g. AWS, GitHub, etc). It uses Postgres Foreign Data Wrappers under the hood and supports joins etc across the services. (Disclaimer - I'm a lead on the project.)
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
In v3.16.0 we added a new Provider feature that unlocks the ability to implement a lot of highly requested features. More details in the blog post:
-
As we want to maintain the track of our changes to the DB, we are going to use migrations. In this case, we are going to use dbmate. But, you can use any other tool you want.
-
xo
Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server (by xo)
Project mention: Open-sourcing SQX, a way to build flexible database models in Go | news.ycombinator.com | 2023-09-02i like xo's approach https://github.com/xo/xo but it is as is. I would love if something similar comes along that is used by db practititoners that is actively used and supported.
-
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.
-
upper.io/db
Data access layer 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. 🔍 📊
-
-
-
For SQL, I'd probably go with goqu http://doug-martin.github.io/goqu/
-
Project mention: Open-sourcing SQX, a way to build flexible database models in Go | news.ycombinator.com | 2023-09-02
We are really happy using jet. It lets you write type safe SQL and can read the results into structs- including joins into slice fields.
-
Project mention: Prisma Client Go: Typesafe Database Client for Golang | news.ycombinator.com | 2024-01-20
-
-
Here are 2 options for you * https://github.com/huandu/go-sqlbuilder * https://github.com/Masterminds/squirrel
-
IceFireDB
@IceFireLabs -> IceFireDB is a database built for web3.0 It strives to fill the gap between web2 and web3.0 with a friendly database experience, making web3 application data storage more convenient, and making it easier for web2 applications to achieve decentralization and data immutability.
-
Project mention: Create and share code snippets from your code editor with snips.nvim : https://github.com/Sanix-Darker/snips.nvim/tree/master | /r/neovim | 2023-06-15
it's snips.sh behind the scene.
-
Project mention: JSON Canvas – An open file format for infinite canvas data | news.ycombinator.com | 2024-03-11
Check out https://github.com/zombiezen/go-sqlite if you're interested in trying out Sqlite in Go again. Nice interface, negligible compile time impact, fast, compiles without CGO. It's very comfortable.
I agree that going from text to sqlite is a bit of a hurdle, especially if you're not writing C :)
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Go Sqlite related posts
- How (and why) to run SQLite in production
- Soul: A SQLite REST and Realtime Server
- SQLite3 Replication: A Wizard's Guide🧙🏽
- The lightweight, easy-to-use, distributed relational database built on SQLite
- Jsonfile: A Quick Hack for Tinkering
- Ask HN: Time travel" into a SQLite database using the WAL files?
- Ask HN: Are you using SQLite and Litestream in production?
-
A note from our sponsor - WorkOS
workos.com | 28 Mar 2024
Index
What are some of the best open-source Sqlite projects in Go? This list will help you:
Project | Stars | |
---|---|---|
1 | memos | 26,281 |
2 | rqlite | 14,760 |
3 | migrate | 13,720 |
4 | sqlc | 10,518 |
5 | litestream | 9,700 |
6 | usql | 8,537 |
7 | steampipe | 6,325 |
8 | goose | 5,436 |
9 | dbmate | 4,252 |
10 | xo | 3,547 |
11 | litefs | 3,546 |
12 | upper.io/db | 3,474 |
13 | mergestat-lite | 3,407 |
14 | tbls | 3,020 |
15 | bun | 2,890 |
16 | goqu | 2,212 |
17 | jet | 1,962 |
18 | prisma-client-go | 1,904 |
19 | gobuffalo/pop | 1,403 |
20 | go-sqlbuilder | 1,177 |
21 | IceFireDB | 1,069 |
22 | snips.sh | 912 |
23 | go-sqlite | 654 |