Go Sqlite

Open-source Go projects categorized as Sqlite

Top 23 Go Sqlite Projects

  • 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

  • rqlite

    The lightweight, distributed relational database built on SQLite.

    Project mention: The lightweight, easy-to-use, distributed relational database built on SQLite | news.ycombinator.com | 2024-02-23
  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  • migrate

    Database migrations. CLI and Golang library.

    Project mention: How to use SQLC with Golang | dev.to | 2024-01-03

    $ curl -L https://github.com/golang-migrate/migrate/releases/download/$version/migrate.$os-$arch.tar.gz | tar xvz

  • sqlc

    Generate type-safe code from SQL

    Project mention: Give Up Sooner | dev.to | 2024-03-13

    "Is there a way to get sqlc to use pointers for nullable columns instead of the sql.Null types?"

  • litestream

    Streaming replication for SQLite.

    Project mention: How (and why) to run SQLite in production | news.ycombinator.com | 2024-03-27

    This presentation is focused on the use-case of vertically scaling a single server and driving everything through that app server, which is running SQLite embedded within your application process.

    This is the sweet-spot for SQLite applications, but there have been explorations and advances to running SQLite across a network of app servers. LiteFS (https://fly.io/docs/litefs/), the sibling to Litestream for backups (https://litestream.io), is aimed at precisely this use-case. Similarly, Turso (https://turso.tech) is a new-ish managed database company for running SQLite in a more traditional client-server distribution.

  • usql

    Universal command-line interface for SQL databases

    Project mention: xo/usql: Universal command-line interface for SQL databases | /r/devel | 2023-06-08
  • steampipe

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

    Project mention: Show HN: Query Your Sheets with SheetSQL | news.ycombinator.com | 2024-03-13

    Readers may also enjoy Steampipe [1], an open source CLI to live query Google Sheets [2] and 140+ other services with SQL (e.g. AWS, GitHub, etc). It uses Postgres Foreign Data Wrappers under the hood and supports joins etc across the services. (Disclaimer - I'm a lead on the project.)

    1 - https://github.com/turbot/steampipe

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

  • goose

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

    Project mention: Recent improvements to the pressly/goose migration tool | /r/golang | 2023-11-14

    In v3.16.0 we added a new Provider feature that unlocks the ability to implement a lot of highly requested features. More details in the blog post:

  • dbmate

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

    Project mention: Level UP your RDBMS Productivity in GO | dev.to | 2023-12-05

    As we want to maintain the track of our changes to the DB, we are going to use migrations. In this case, we are going to use dbmate. But, you can use any other tool you want.

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

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

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

  • tbls

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

    Project mention: FLaNK 25 December 2023 | dev.to | 2023-12-26
  • bun

    SQL-first Golang ORM (by uptrace)

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

    We are really happy using jet. It lets you write type safe SQL and can read the results into structs- including joins into slice fields.

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

  • prisma-client-go

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

    Project mention: Prisma Client Go: Typesafe Database Client for Golang | news.ycombinator.com | 2024-01-20
  • 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.

    Project mention: Best sqlc alternative for dynamic queries? | /r/golang | 2023-05-15

    Here are 2 options for you * https://github.com/huandu/go-sqlbuilder * https://github.com/Masterminds/squirrel

  • 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

    Project mention: Create and share code snippets from your code editor with snips.nvim : https://github.com/Sanix-Darker/snips.nvim/tree/master | /r/neovim | 2023-06-15

    it's snips.sh behind the scene.

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

  • SaaSHub

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

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 2024-03-27.

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 26,281
2 rqlite 14,760
3 migrate 13,720
4 sqlc 10,518
5 litestream 9,700
6 usql 8,537
7 steampipe 6,325
8 goose 5,436
9 dbmate 4,252
10 xo 3,547
11 litefs 3,546
12 upper.io/db 3,474
13 mergestat-lite 3,407
14 tbls 3,020
15 bun 2,890
16 goqu 2,212
17 jet 1,962
18 prisma-client-go 1,904
19 gobuffalo/pop 1,403
20 go-sqlbuilder 1,177
21 IceFireDB 1,069
22 snips.sh 912
23 go-sqlite 654
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com