Go Sqlite

Open-source Go projects categorized as Sqlite

Top 23 Go Sqlite Projects

  1. memos

    An open-source, lightweight note-taking solution. The pain-less way to create your meaningful notes. Your Notes, Your Way.

    Project mention: Memos: Open-source, lightweight note-taking solution | news.ycombinator.com | 2025-01-15
  2. CodeRabbit

    CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

    CodeRabbit logo
  3. rqlite

    The lightweight, user-friendly, distributed relational database built on SQLite.

    Project mention: The definitive guide to using Django with SQLite in production đź’ˇ | dev.to | 2025-01-18

    rqlite: The lightweight, user-friendly, distributed relational database built on SQLite

  4. migrate

    Database migrations. CLI and Golang library.

    Project mention: How to use migrations with Golang | dev.to | 2024-11-06

    Go doesn't support migrations natively for that propuso we can use the popular golang-migrate package also if you use an ORM like GORM you can use it for that.

  5. sqlc

    Generate type-safe code from SQL

    Project mention: User authentication in go | dev.to | 2025-01-30

    Next, let's write sql queries for retrieving our users & their permissions. Here we will use sqlc for type-safe code generation from our sql queries, and pgx as its backend

  6. litestream

    Streaming replication for SQLite.

    Project mention: The definitive guide to using Django with SQLite in production đź’ˇ | dev.to | 2025-01-18

    ... # Install wget and Litestream RUN --mount=type=cache,target=/var/cache/apt,sharing=locked --mount=type=cache,target=/var/lib/apt,sharing=locked \ apt-get update --fix-missing && \ apt-get install --no-install-recommends -y wget && \ wget https://github.com/benbjohnson/litestream/releases/download/v0.3.13/litestream-v0.3.13-linux-amd64.deb && \ dpkg -i litestream-v0.3.13-linux-amd64.deb ENTRYPOINT ["./entrypoint.sh"]

  7. usql

    Universal command-line interface for SQL databases

    Project mention: Usql: Universal command-line interface for SQL databases | news.ycombinator.com | 2024-11-16

    It seems to support quite a large number of database drivers. If file size is such a concern you could recompile it with unneeded drivers omitted.

    https://github.com/xo/usql?tab=readme-ov-file#building

  8. goose

    A database migration tool. Supports SQL migrations and Go functions.

    Project mention: How to handle migrations in Golang | dev.to | 2024-06-11

    goose

  9. SaaSHub

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

    SaaSHub logo
  10. steampipe

    Zero-ETL, infinite possibilities. Live query APIs, code & more with SQL. No DB required.

    Project mention: Cyphernetes: A Query Language for Kubernetes | news.ycombinator.com | 2024-12-15

    I really really like Steampipe to do this kind of query: https://steampipe.io, which is essentially PostgreSQL (literally) to query many different kind of APIs, which means you have access to all PostgreSQL's SQL language can offer to request data.

    They have a Kubernetes plugin at https://hub.steampipe.io/plugins/turbot/kubernetes and there are a couple of things I really like:

    * it's super easy to request multiple Kubernetes clusters transparently: define one Steampipe "connection" for each of your clusters + define an "aggregator" connection that aggregates all of them, then query the "aggregator" connection. You will get a "context" column that indicates which Kubernetes cluster the row came from.

  11. dbmate

    🚀 A lightweight, framework-agnostic database migration tool.

    Project mention: User authentication in go | dev.to | 2025-01-30

    We will use awesome dbmate migration tool for our migrations.

  12. litefs

    FUSE-based file system for replicating SQLite databases across a cluster of machines

    Project mention: Limbo: A complete rewrite of SQLite in Rust | news.ycombinator.com | 2024-12-10

    All this talk of “SQLite is not open contribution” never seems to consider that a project being “open contribution” doesn't mean the maintainers will accept your contributions.

    They have a process for contributions to follow: you suggest a feature, they implement it. It's far from the only project to take such a stance.

    Just in the SQLite “ecosystem” see the contribution policies of Litestream and LiteFS. I don't see people brandishing the ”not open contribution” to Ben's projects.

    https://github.com/superfly/litefs?tab=readme-ov-file#contri...

    https://github.com/benbjohnson/litestream?tab=readme-ov-file...

  13. bun

    SQL-first Golang ORM (by uptrace)

  14. xo

    Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server (by xo)

    Project mention: Sqlc: Compile SQL to type-safe code | news.ycombinator.com | 2024-09-08

    XO doesn’t have them built-in, but it uses easily customizable templates.

    I added support for a bunch of postgres fancy stuff in a previous app, it wasn’t too difficult

    https://github.com/xo/xo

  15. tbls

    tbls is a CI-Friendly tool to document a database, written in Go.

    Project mention: Show HN: Outerbase Studio – Open-Source Database GUI | news.ycombinator.com | 2024-12-04

    Two more tools I really enjoy:

    - https://www.beekeeperstudio.io/ - electron based and I find it really simple to use.

    - https://github.com/k1LoW/tbls - generate markdown docs from databases (similar to DbVisualizer, but it's a static binary and you can just push the md files - see https://github.com/bbkane/envelope/tree/master/dbdoc for example)

  16. redka

    Redis re-implemented with SQLite

    Project mention: Some Go web dev notes | news.ycombinator.com | 2024-09-29

    Yeah, it'd be much nicer if libraries were designed to be driver agnostic, like redka which supports 4 different SQLite drivers:

    https://github.com/nalgeon/redka/tree/main/example

  17. upper.io/db

    Data Access Layer (DAL) for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.

  18. mergestat-lite

    Query git repositories with SQL. Generate reports, perform status checks, analyze codebases. 🔍 📊

  19. jet

    Type safe SQL builder with code generation and automatic query result data mapping

    Project mention: Some Go web dev notes | news.ycombinator.com | 2024-09-29

    It gets mentioned a lot in the context of database/sql and sqlc alternatives, but Jet has been a great alternative so far, most notably because of its non-issue with dynamic queries support.

    https://github.com/go-jet/jet/

  20. algernon

    Small self-contained pure-Go web server with Lua, Teal, Markdown, Ollama, HTTP/2, QUIC, Redis, SQLite and PostgreSQL support ++

    Project mention: Web Server with Support for HTTP, Lua, Markdown, JSX, BoltDB, Redis, PostgreSQL | news.ycombinator.com | 2024-03-11
  21. goqu

    SQL builder and query library for golang

    Project mention: PostgreSQL 17 Released | news.ycombinator.com | 2024-09-26

    I've been using Go with Goqu [1] for SQL for a lot of things lately. But, the language shouldn't matter much. The functions are just building the appropriate SQL clauses.

    For some of the operations, the method I was using required marshaling the inputs to JSON before sending them over the wire. And that's nicer in a non SQL programming language. But both db's ultimately do have json_build_array/json_build_object for PostgreSQL or json_array/json_object for SQLite3.

    [1] https://github.com/doug-martin/goqu

  22. pagoda

    Rapid, easy full-stack web development starter kit in Go

    Project mention: Pagoda: Rapid, easy full-stack web development starter kit in Go | news.ycombinator.com | 2024-09-29
  23. prisma-client-go

    Prisma Client Go is an auto-generated and fully type-safe database client

    Project mention: I made SQL easy in Go | dev.to | 2025-02-02

    When I've used it in projects in the past its been through libraries like prisma-client-go. This is a really cool package. You define your schema, and run 1 command and you instantly have fully typed Go code to work with. I even used it to create a monitoring mobile app called Cronus.

  24. go-sqlbuilder

    A flexible and powerful SQL string builder library plus a zero-config ORM.

  25. gobuffalo/pop

    A Tasty Treat For All Your Database Needs (by gobuffalo)

  26. 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 Sqlite discussion

Log in or Post with

Go Sqlite related posts

Index

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

# Project Stars
1 memos 36,692
2 rqlite 16,200
3 migrate 15,984
4 sqlc 14,170
5 litestream 11,412
6 usql 9,187
7 goose 7,631
8 steampipe 7,170
9 dbmate 5,681
10 litefs 4,210
11 bun 3,976
12 xo 3,770
13 tbls 3,599
14 redka 3,594
15 upper.io/db 3,553
16 mergestat-lite 3,483
17 jet 2,873
18 algernon 2,865
19 goqu 2,451
20 pagoda 2,286
21 prisma-client-go 2,234
22 go-sqlbuilder 1,498
23 gobuffalo/pop 1,465

Sponsored
CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai

Did you know that Go is
the 4th most popular programming language
based on number of references?