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
-
Project mention: Usql – Universal command-line interface for SQL databases | news.ycombinator.com | 2022-12-30
-
Moved all my projects to https://github.com/volatiletech/sqlboiler.
-
SonarQube
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.
-
This way: https://github.com/uptrace/bun, I prefer in all cases with PostgreSQL
-
Project mention: sqler: Write APIs using direct SQL queries with no hassle, let's rethink about SQL | reddit.com/r/himigifavievcu | 2022-07-29
-
trdsql
CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN. Can output to various formats.
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.
-
Project mention: WunderBase – Serverless GraphQL Database Built on Top of SQLite | news.ycombinator.com | 2022-10-30
-
There are several different Go bindings for SQLite. I maintain https://pkg.go.dev/zombiezen.com/go/sqlite
-
InfluxDB
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.
-
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.
-
How does this compare to https://github.com/glebarez/go-sqlite ?
Using that for https://www.octobench.com/ and I'm very happy.
-
-
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-sqlite3-stdlib
A standard library for mattn/go-sqlite3 including best-effort date parsing, url parsing, math/string functions, and stats aggregation functions
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 [0].
If you need them, you also have a "stdlib" implemented for Go [1] and a pretty extensive collection of extensions [2]
[0]: https://ricardoanderegg.com/posts/extending-sqlite-with-rust...
-
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 :)).
https://github.com/riyaz-ali/sqlite/blob/master/virtual_tabl...
-
-
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).
-
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.
-
You might also consider https://github.com/nofeaturesonlybugs/sqlh as an alternative to sqlx.
-
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.
-
-
-
sqltrace
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-15View on GitHub
-
ONLYOFFICE
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
- Go port of SQLite without CGo
- Introducing wazero from Tetrate
- Questions regarding prepared statements in database/sql
- GitHub code coverage badge
- Usql – Universal command-line interface for SQL databases
- 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.
-
A note from our sponsor - SonarQube
www.sonarqube.org | 1 Jun 2023
Index
What are some of the best open-source Sqlite3 projects in Go? This list will help you:
Project | Stars | |
---|---|---|
1 | usql | 8,041 |
2 | SQLBoiler | 5,794 |
3 | bun | 2,090 |
4 | sqler | 2,027 |
5 | trdsql | 1,514 |
6 | wunderbase | 478 |
7 | go-sqlite | 330 |
8 | sqlite | 303 |
9 | go-sqlite | 298 |
10 | journalist | 235 |
11 | ctlstore | 231 |
12 | octillery | 183 |
13 | grimoire | 158 |
14 | go-sqlite3-stdlib | 118 |
15 | sqlite | 116 |
16 | grafana-sqlite-datasource | 96 |
17 | go-sqlite3 | 83 |
18 | xyr | 58 |
19 | sqlh | 34 |
20 | sqly | 26 |
21 | little_bigtable | 18 |
22 | squirrel | 14 |
23 | sqltrace | 9 |