Go Sqlite3

Open-source Go projects categorized as Sqlite3

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.

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

    Universal command-line interface for SQL databases

  • Project mention: JetBrains DataGrip doesn't accept JSON1 data type | news.ycombinator.com | 2024-06-15

    Does JSON1 data type works fine with usql [1]? I haven't use it yet.

    [1] https://github.com/xo/usql

  • 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

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

  • journalist

    Journalist. An RSS aggregator.

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

  • sqlh

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

  • napp

    Napp: A command line tool that bootstraps Go, HTMX and SQLite web applications and Dockerises them for ease of deployment.

  • Project mention: Napp: Don't Get Caught Sleeping On Your Stack | dev.to | 2024-04-08

    Napp CLI Tool

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

Log in or Post with

Go Sqlite3 related posts

  • JetBrains DataGrip doesn't accept JSON1 data type

    1 project | news.ycombinator.com | 15 Jun 2024
  • From GUI to CLI: Transforming my query workflow with usql and jq

    2 projects | dev.to | 15 May 2024
  • Soul: A SQLite REST and Realtime Server

    8 projects | news.ycombinator.com | 19 Mar 2024
  • Billion File Filesystem

    2 projects | news.ycombinator.com | 8 Feb 2024
  • Jsonfile: A Quick Hack for Tinkering

    2 projects | news.ycombinator.com | 7 Feb 2024
  • SQLite-memory-vfs: Open a SQLite db from memory in Python, without hitting disk

    4 projects | news.ycombinator.com | 27 Dec 2023
  • JSONB Has Landed in SQLite

    1 project | news.ycombinator.com | 6 Dec 2023
  • A note from our sponsor - InfluxDB
    www.influxdata.com | 20 Jun 2024
    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. Learn more →

Index

What are some of the best open-source Sqlite3 projects in Go? This list will help you:

Project Stars
1 Gogs 44,440
2 usql 8,705
3 SQLBoiler 6,519
4 bun 3,410
5 sqler 2,061
6 trdsql 1,902
7 marmot 1,673
8 go-sqlite 695
9 bob 675
10 go-sqlite 574
11 sqlite 551
12 wunderbase 516
13 go-sqlite3 317
14 journalist 295
15 ctlstore 262
16 octillery 191
17 grimoire 161
18 sqlite 153
19 go-sqlite3-stdlib 123
20 grafana-sqlite-datasource 123
21 xyr 63
22 sqlh 42
23 napp 38

Sponsored
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