Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free. Learn more →
Top 23 Go Sqlite3 Projects
Universal command-line interface for SQL databasesProject mention: Usql – Universal command-line interface for SQL databases | news.ycombinator.com | 2022-12-30
Generate a Go ORM tailored to your database schema.Project mention: Comparing database/sql, GORM, sqlx, and sqlc | reddit.com/r/golang | 2023-04-27
Moved all my projects to https://github.com/volatiletech/sqlboiler.
Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.
SQL-first Golang ORM (by uptrace)Project mention: ORM or no ORM (and which ones)? | reddit.com/r/golang | 2023-01-17
This way: https://github.com/uptrace/bun, I prefer in all cases with PostgreSQL
write APIs using direct SQL queries with no hassle, let's rethink about SQLProject mention: sqler: Write APIs using direct SQL queries with no hassle, let's rethink about SQL | reddit.com/r/himigifavievcu | 2022-07-29
CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN. Can output to various formats.Project mention: sqly - execute SQL against CSV / JSON with shell | reddit.com/r/SQL | 2022-11-10
Apparently, there were many who thought the same thing; Tools to execute SQL against CSV were trdsql, q, csvq, TextQL. They were highly functional, hoewver, had many options and no input completion. I found it just a little difficult to use.
Serverless GraphQL Database built on top of Firecracker, SQLite and PrismaProject mention: WunderBase – Serverless GraphQL Database Built on Top of SQLite | news.ycombinator.com | 2022-10-30
Low-level Go interface to SQLite 3Project mention: Any Full Text Search library for json data? | reddit.com/r/golang | 2023-01-01
There are several different Go bindings for SQLite. I maintain https://pkg.go.dev/zombiezen.com/go/sqlite
Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.
The pure-Go SQLite driver for GORM (by glebarez)
Each call out to a C library from Go locks an OS thread rather than participating in the go routine scheduling. If stuff happens that makes those threads slow or have some issue, they just sit here. I had a server with C Kafka libraries and each time the network glitched the CPU would spike up wards and not decline. With pure go the scheduler is able to just swap out and ignore code that is stuck some where (unless it were in a busy loop).
With this SQLite implementation I can stick it in my server (as a background, near real time mirror of memory state to disk) without worrying that the main loop will get clogged or my real time path will be hurt.
I use glabarez’ wrapper which makes it have an API like other Go databases: https://github.com/glebarez/sqlite/ and hey have been very responsive to issues I raised.
I have been running load tests against it for a few weeks, and it is quite solid.
pure-Go SQLite driver for Go (SQLite embedded) (by glebarez)
How does this compare to https://github.com/glebarez/go-sqlite ?
Using that for https://www.octobench.com/ and I'm very happy.
Journalist. An RSS aggregator.
Control Data Store
at segment we benchmarked https://github.com/segmentio/ctlstore against this driver. We saw about a 50% hit to read performance, so we didn't move forward with it, but the improvements in service build times were really appealing.
Go package for sharding databases ( Supports every ORM or raw SQL )
Database access layer for golang
A standard library for mattn/go-sqlite3 including best-effort date parsing, url parsing, math/string functions, and stats aggregation functionsProject mention: SQLite: Past, Present, and Future | news.ycombinator.com | 2022-09-01
Adding user-defined functions to SQLite is not difficult, and the mechanism is quite flexible. You can create extensions and load them when you create the SQLite connection to have the functions available in queries. I wrote a blog post explaining how to do that using Rust, and the example is precisely a `regex_extract` function .
If you need them, you also have a "stdlib" implemented for Go  and a pretty extensive collection of extensions 
Golang library to build sqlite extensions (by riyaz-ali)Project mention: Row Level Security Extension for SQLite Feasiblity | news.ycombinator.com | 2022-08-16
A recent project has me happily using SQLite but I am missing having Row Level Security (RLS) for my application. I searched around and SQLite has no out-of-the-box or 3rd party ext support for RLS.
I am seeing that 1) we can load extensions into SQLite (see attached URL), and 2) that extensions can create modules with pretty rich functionality. Maybe a virtual table impl with `xFilter` and/or `xNext` fns could help yield the row filtering, plus some custom fns to add some state used during the query to configure the dynamic constraint?
Interesting idea? Plausible?
I also saw someone made some handy golang bindings, which could add a few niceties to writing such an extension (albeit heresy to some, to lodge Go into SQLite :)).
Grafana Plugin to enable SQLite as a Datasource
Go bindings to SQLite using Wazero (by ncruces)Project mention: C to WASM to Go | reddit.com/r/golang | 2023-05-20
Using the stack pointer global is an interesting hack. I'd never thought of that. Need to compare with what I'm doing for SQLite (a kind of per connection arena).
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.
Powerful struct scanning for Go's database/sql and other compatible interfaces.Project mention: Dapper-like ORM, Mapping | reddit.com/r/golang | 2022-10-06
You might also consider https://github.com/nofeaturesonlybugs/sqlh as an alternative to sqlx.
sqly - eaisly execute SQL against CSV/TSV/LTSV/JSON with shell. (by nao1215)Project mention: sqly - execute SQL against CSV / JSON with shell | reddit.com/r/SQL | 2022-11-10
Hi, reddit user. I have released a tool that allows you to execute SQL against CSV or JSON. It's called sqly. I would like to introduce it to you.
Little Bigtable is an emulator for Google Bigtable w/ persistence in sqlite3
Go sqlite3 cache (by anacrolix)
A low-code intrusion library that provides SQL tracing capabilities, suitable for any relational database (Sqlite3, MySQL, Oracle, SQL Server, PostgreSQL, TiDB, TDengine, etc.) and ORM libraries for various relational database (gorm, xorm, sqlx, ent, etc.)Project mention: sqltrace: A low-code intrusion library that provides SQL tracing capabilities | dev.to | 2022-09-15
View on GitHub
ONLYOFFICE Docs — document collaboration in your environment. Powerful document editing and collaboration in your app or environment. Ultimate security, API and 30+ ready connectors, SaaS or on-premises
Go Sqlite3 related posts
C to WASM to Go
1 project | reddit.com/r/golang | 20 May 2023
Go port of SQLite without CGo
12 projects | news.ycombinator.com | 7 Apr 2023
Introducing wazero from Tetrate
2 projects | reddit.com/r/golang | 20 Mar 2023
Questions regarding prepared statements in database/sql
3 projects | reddit.com/r/golang | 23 Feb 2023
GitHub code coverage badge
6 projects | reddit.com/r/golang | 27 Jan 2023
Usql – Universal command-line interface for SQL databases
1 project | news.ycombinator.com | 30 Dec 2022
Benchmarking SQLite Performance in Go. Using Go's awesome built-in simple benchmarking tools to investigate SQLite database performance in a couple of different benchmarks, plus a comparison to Postgres.
6 projects | reddit.com/r/golang | 14 Dec 2022
A note from our sponsor - SonarQube
www.sonarqube.org | 1 Jun 2023
What are some of the best open-source Sqlite3 projects in Go? This list will help you: