Go Sqlite3

Open-source Go projects categorized as Sqlite3
Edit details
Topics: Golang Go MySQL Database Sqlite
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.
www.influxdata.com
featured

Top 23 Go Sqlite3 Projects

  • Gogs

    Gogs is a painless self-hosted Git service

    • Project mention: Go's old $GOPATH story for development and dependencies | news.ycombinator.com | 2024-05-24

    Yeah, I'm actually doing that with Gitea: https://about.gitea.com/

    Some people went with the forgejo fork: https://forgejo.org/ though Gitea itself was a fork of Gogs, if I remember correctly: https://gogs.io/

    I also ran GitLab in the past: https://about.gitlab.com/ but keeping it updated and giving it enough resources for it to be happy was troublesome.

    There's also GitBucket: https://gitbucket.github.io/ and some other platforms, though those tend to be a little bit more niche.

    Either way, there's lots of nice options out there, albeit I'd still have to admit that just using GitHub or cloud GitLab version would be easier for most folks. Convenience and all.

  • usql

    Universal command-line interface for SQL databases

    • Project mention: From GUI to CLI: Transforming my query workflow with usql and jq | dev.to | 2024-05-15

    Since some of the databases I was interacting were postgres, I started to play around with psql. It felt amazing, it had a great integration with the terminal, no visual pollution, I could also use vim as my query editor, and it was blazing fast. The problem was that only some of the databases I was interacting were postgres. I needed something that could connect to multiple databases, something universal, so I don't have to invest time in new tooling all the time. So I searched on github "universal sql" and I felt in love with usql.

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

    InfluxDB logo

  • SQLBoiler

    Generate a Go ORM tailored to your database schema.

    • Project mention: Eradicating N+1s: The Two-Phase Data Load and Render Pattern in Go | news.ycombinator.com | 2024-05-28

    If you're using Go, sqlboiler can do this for you in most common cases (e.g., fetch all the Users matching this filter, and for each User, fetch the related Company)

    https://github.com/volatiletech/sqlboiler

  • bun

    SQL-first Golang ORM (by uptrace)

  • sqler

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

  • trdsql

    CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN. Can output to various formats.

  • marmot

    A distributed SQLite replicator built on top of NATS

    • Project mention: Distributed SQLite: Paradigm shift or hype? | news.ycombinator.com | 2024-04-09

    If you're willing to accept eventual consistency (a big ask, but acceptable in some scenarios) then there are options like marmot [1] that replicate cdc over nats.

    [1]: https://github.com/maxpert/marmot

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo

  • go-sqlite

    Low-level Go interface to SQLite 3

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

  • go-sqlite

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

  • sqlite

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

    • Project mention: Mayhem: A TUI based task tracker | /r/golang | 2023-08-03

    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.

  • wunderbase

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

  • journalist

    Journalist. An RSS aggregator.

  • go-sqlite3

    Go bindings to SQLite using wazero (by ncruces)

    • Project mention: Show HN: Roast my SQLite encryption at-rest | news.ycombinator.com | 2024-04-30

    Yep, I just made it tweakable at build, which was always the intent, although I expect the default to be popular.

    https://github.com/ncruces/go-sqlite3/blob/67d859a5/vfs/adia...

    That's unfortunate about the default parameters, but note that you can also replace the KDF altogether (besides just not using it).

    You just need to implement this interface, with any HBSH construction and KDF:

    https://github.com/ncruces/go-sqlite3/blob/67d859a5/vfs/adia...

    If you keep the HBSH and change the KDF, your file format will be “compatible.”

  • ctlstore

    Control Data Store

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

  • octillery

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

  • grimoire

    Database access layer for golang (by Fs02)

  • sqlite

    Golang library to build sqlite extensions :rocket: (by riyaz-ali)

  • go-sqlite3-stdlib

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

  • grafana-sqlite-datasource

    Grafana Plugin to enable SQLite as a Datasource

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

  • sqliterg

    A SQLite Remote Gateway - query SQLite via HTTP

    • Project mention: Soul: A SQLite REST and Realtime Server | news.ycombinator.com | 2024-03-19

  • sqlh

    Powerful struct scanning for Go's database/sql and other compatible interfaces.

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

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

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 Gogs 44,325
2 usql 8,674
3 SQLBoiler 6,486
4 bun 3,359
5 sqler 2,061
6 trdsql 1,896
7 marmot 1,662
8 go-sqlite 687
9 bob 618
10 go-sqlite 565
11 sqlite 542
12 wunderbase 516
13 journalist 293
14 go-sqlite3 307
15 ctlstore 259
16 octillery 190
17 grimoire 161
18 sqlite 153
19 go-sqlite3-stdlib 123
20 grafana-sqlite-datasource 122
21 xyr 63
22 sqliterg 44
23 sqlh 39

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com