Go Sqlite3

Open-source Go projects categorized as Sqlite3

Top 23 Go Sqlite3 Projects

  • usql

    Universal command-line interface for SQL databases

    Project mention: Usql – Universal command-line interface for SQL databases | news.ycombinator.com | 2022-12-30
  • SQLBoiler

    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.

  • 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.

  • bun

    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

  • sqler

    write APIs using direct SQL queries with no hassle, let's rethink about SQL

    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.

    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.

  • wunderbase

    Serverless GraphQL Database built on top of Firecracker, SQLite and Prisma

    Project mention: WunderBase – Serverless GraphQL Database Built on Top of SQLite | news.ycombinator.com | 2022-10-30
  • go-sqlite

    Low-level Go interface to SQLite 3

    Project 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

  • 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.

  • sqlite

    The pure-Go SQLite driver for GORM (by glebarez)

    Project mention: Go port of SQLite without CGo | news.ycombinator.com | 2023-04-07

    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.

  • go-sqlite

    pure-Go SQLite driver for Go (SQLite embedded) (by glebarez)

    Project mention: Go port of SQLite without CGo | news.ycombinator.com | 2023-04-07

    How does this compare to https://github.com/glebarez/go-sqlite ?

    Using that for https://www.octobench.com/ and I'm very happy.

  • journalist

    Journalist. An RSS aggregator.

  • ctlstore

    Control Data Store

    Project mention: Go port of SQLite without CGo | news.ycombinator.com | 2023-04-07

    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.

  • octillery

    Go package for sharding databases ( Supports every ORM or raw SQL )

  • grimoire

    Database access layer for golang

  • go-sqlite3-stdlib

    A standard library for mattn/go-sqlite3 including best-effort date parsing, url parsing, math/string functions, and stats aggregation functions

    Project 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 [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...

    [1]: https://github.com/multiprocessio/go-sqlite3-stdlib

    [2]: https://github.com/nalgeon/sqlean

  • sqlite

    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 :)).

    https://github.com/riyaz-ali/sqlite/blob/master/virtual_tabl...

  • grafana-sqlite-datasource

    Grafana Plugin to enable SQLite as a Datasource

  • go-sqlite3

    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).

  • 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.

  • sqlh

    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

    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

    Little Bigtable is an emulator for Google Bigtable w/ persistence in sqlite3

  • squirrel

    Go sqlite3 cache (by anacrolix)

  • 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-15

    View 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

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2023-05-20.

Go Sqlite3 related posts

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
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
www.onlyoffice.com