Go Sqlite

Open-source Go projects categorized as Sqlite
Edit details
Topics: Golang SQL Postgresql Go Database
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 Sqlite Projects

Sqlite

  • memos

    An open source, lightweight note-taking service. Easily capture and share your great thoughts.

    • Project mention: GitHub issues from top Open Source Golang Repositories that you should contribute to | dev.to | 2024-01-15

    Memos - customise max content length of memo

  • 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

  • rqlite

    The lightweight, distributed relational database built on SQLite.

    • Project mention: Why SQLite Is Taking over with Brian Holt and Marco Bambini | news.ycombinator.com | 2024-06-12

    SQLite is not competing with RDMBSes. SQLite is competing with fopen().

    There are of course solutions which wrap this fopen() replacement in a network/cluster-aware tools, e.g. https://github.com/rqlite/rqlite - these are competing with postgres.

  • migrate

    Database migrations. CLI and Golang library.

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

    golang-migrate

  • sqlc

    Generate type-safe code from SQL

    • Project mention: FrankenPHP: The Modern PHP App Server | news.ycombinator.com | 2024-05-29

    >> Also, I can think of a number of json schemas that are impossible to replicate in Go's type system but work just fine in PHP.

    Not at all. There are some that would be painful to write "by hand". An expansive and nested set of null fields would suck if I had to spell it all out...

    https://sqlc.dev << changes everything. If you add in the YAML (and I hate yaml) you can get your JSON to DB mapping in there, as well as your validations (all output as struct tags).

    Everything else that you're going to want (transforming inputs to/from json, logging, auth) is some pretty simple middleware.

  • litestream

    Streaming replication for SQLite.

    • Project mention: Why SQLite Is Taking over with Brian Holt and Marco Bambini | news.ycombinator.com | 2024-06-12

    As hruk pointed out, you can use docker volumes to solve for this. However, you can also ship multiple DBs depending on your use-case. If it's a shared DB, it's probably not a great idea for micro-services. But if you're building a majestic monolith, there's few reasons NOT to go with SQLite. Especially paired with litestream[0].

    0: https://litestream.io/

  • 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

  • steampipe

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

    • Project mention: DuckDB Doesn't Need Data to Be a Database | news.ycombinator.com | 2024-05-29

    https://steampipe.io/ showcases some really interesting scenarios for using FDWs in place of regular ETL and API integrations

  • SaaSHub

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

    SaaSHub logo

  • 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

  • dbmate

    :rocket: A lightweight, framework-agnostic database migration tool.

    • Project mention: Dbmate: A lightweight, framework-agnostic database migration tool | news.ycombinator.com | 2024-06-16

  • litefs

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

    • Project mention: Handle Incoming Webhooks with LiteJob for Ruby on Rails | dev.to | 2023-11-22

    Firstly, LiteJob's reliance on SQLite inherently restricts its horizontal scaling capabilities. Unlike other databases, SQLite is designed for single-machine use, making it challenging to distribute workload across multiple servers. This can certainly be done using novel technologies like LiteFS, but it is far from intuitive.

  • 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: Open-sourcing SQX, a way to build flexible database models in Go | news.ycombinator.com | 2023-09-02

    i like xo's approach https://github.com/xo/xo but it is as is. I would love if something similar comes along that is used by db practititoners that is actively used and supported.

  • upper.io/db

    Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.

  • mergestat-lite

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

  • bun

    SQL-first Golang ORM (by uptrace)

  • tbls

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

    • Project mention: Tbls, a CI-friendly database documentation tool written in Go | news.ycombinator.com | 2024-06-05

  • redka

    Redis re-implemented with SQLite

    • Project mention: Redka: Redis re-implemented with SQLite v0.5.0 | news.ycombinator.com | 2024-05-20

  • goqu

    SQL builder and query library for golang

    • Project mention: newbie here looking for a framework | /r/golang | 2023-10-03

    For SQL, I'd probably go with goqu http://doug-martin.github.io/goqu/

  • jet

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

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

    Jet can automatically load joined objects into embedded Go structs: https://github.com/go-jet/jet/wiki/Query-Result-Mapping-(QRM...

    Depending on what you are doing there might be some duplication that you could remove by creating hash lookups as in this post, but I would reach for Jet first.

    sqlc supports embedding but not embedded slices?

  • prisma-client-go

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

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

    Go Prisma

  • gobuffalo/pop

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

  • go-sqlbuilder

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

  • IceFireDB

    @IceFireLabs -> IceFireDB is a database built for web3.0 It strives to fill the gap between web2 and web3.0 with a friendly database experience, making web3 application data storage more convenient, and making it easier for web2 applications to achieve decentralization and data immutability.

  • snips.sh

    ✂️ passwordless, anonymous SSH-powered pastebin with a human-friendly TUI and web UI

  • 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 28,107
2 rqlite 15,098
3 migrate 14,306
4 sqlc 11,380
5 litestream 10,225
6 usql 8,695
7 steampipe 6,566
8 goose 6,033
9 dbmate 4,448
10 litefs 3,713
11 xo 3,601
12 upper.io/db 3,491
13 mergestat-lite 3,434
14 bun 3,393
15 tbls 3,177
16 redka 3,153
17 goqu 2,280
18 jet 2,151
19 prisma-client-go 2,002
20 gobuffalo/pop 1,413
21 go-sqlbuilder 1,230
22 IceFireDB 1,088
23 snips.sh 977

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