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 Sqlite3 Projects
-
> Gitea but the other one
Wouldn't that also be Gogs? https://gogs.io/
I remember when that one was what a lot of people were looking into, before the Gitea fork happened. It's odd to see how this has happened yet again, but I guess is a good thing that it's even possible in the first place, if there are indeed differing values and goals?
-
Project mention: xo/usql: Universal command-line interface for SQL databases | /r/devel | 2023-06-08
-
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.
-
SQLBoiler takes a database-first approach, generating Go code from your database schema. This means it creates highly optimized and custom-tailored code for your specific database schema. SQLBoiler is great for applications where the database schema is well-defined and changes infrequently. However, like sqlc, it requires regenerating the code when the database schema changes. It's well-suited for projects where performance is a key concern and the database design is stable.
-
-
-
trdsql
CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN. Can output to various formats.
-
-
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.
-
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 :)
-
bob
SQL query builder and ORM/Factory generator for Go with support for PostgreSQL, MySQL and SQLite (by stephenafamo)
Use something that does codegen, like sqlc or Bob.
-
How does this compare to https://github.com/glebarez/go-sqlite ?
Using that for https://www.octobench.com/ and I'm very happy.
-
-
Edit: Thanks to u/lbgdn, the cross compilation issue was resolved. I was able to bypass the CGO issue by using pure-Go SQLite driver.
-
-
Project mention: SQLedge: Replicate Postgres to SQLite on the Edge | news.ycombinator.com | 2023-08-09
We replicated our MySQL database to a SQLite edge at Segment in ctlstore: https://github.com/segmentio/ctlstore
We considered tailing binlogs directly but there's so much cruft and complexity involved trying to translate between types and such at that end, once you even just get passed properly parsing the binlogs and maintaining the replication connection. Then you have to deal with schema management across both systems too. Similar sets of problems using PostgreSQL as a source of truth.
In the end we decided just to wrap the whole thing up and abstract away the schema with a common set of types and a limited set of read APIs. Biggest missing piece I regret not getting in was support for secondary indexes.
-
struggling figuring out how to make my cgo sqlite cross-compile to Windows
Plenty of people trying to fix that.
There's at least:
Then there's https://github.com/zombiezen/go-sqlite that actually builds https://crawshaw.io/sqlite on top of modernc.
And there's mine that has both a low level and a database/sql driver builds and runs everywhere Go does: https://github.com/ncruces/go-sqlite3
-
-
-
-
go-sqlite3-stdlib
A standard library for mattn/go-sqlite3 including best-effort date parsing, url parsing, math/string functions, and stats aggregation functions
-
-
xyr
Query any data source using SQL, works with the local filesystem, s3, and more. It should be a very tiny and lightweight alternative to AWS Athena, Presto ... etc.
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Go Sqlite3 related posts
- Soul: A SQLite REST and Realtime Server
- Billion File Filesystem
- Jsonfile: A Quick Hack for Tinkering
- SQLite-memory-vfs: Open a SQLite db from memory in Python, without hitting disk
- JSONB Has Landed in SQLite
- Show HN: Go bindings to SQLite using wazero
- Show HN: Gogosseract, a Go Lib for CGo-Free Tesseract OCR via Wazero
-
A note from our sponsor - WorkOS
workos.com | 28 Mar 2024
Index
What are some of the best open-source Sqlite3 projects in Go? This list will help you:
Project | Stars | |
---|---|---|
1 | Gogs | 43,989 |
2 | usql | 8,537 |
3 | SQLBoiler | 6,373 |
4 | bun | 2,890 |
5 | sqler | 2,053 |
6 | trdsql | 1,750 |
7 | marmot | 1,561 |
8 | go-sqlite | 654 |
9 | bob | 552 |
10 | go-sqlite | 515 |
11 | wunderbase | 513 |
12 | sqlite | 509 |
13 | journalist | 283 |
14 | ctlstore | 257 |
15 | go-sqlite3 | 246 |
16 | octillery | 188 |
17 | grimoire | 160 |
18 | sqlite | 147 |
19 | go-sqlite3-stdlib | 123 |
20 | grafana-sqlite-datasource | 118 |
21 | xyr | 61 |
22 | sqlh | 39 |
23 | sqliterg | 36 |