InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises. Learn more →
Top 23 Go Sqlite Projects
-
Project mention: Hctree is an experimental high-concurrency database back end for SQLite | news.ycombinator.com | 2023-01-18
Meaning something like rqlite[1]? The age of fat desktop clients all connecting back to the central SQL server is long behind us, so yeah there is probably little reason beyond fun for something like that, but where there is fun!
-
Project mention: Managing external database versions in Kubernetes | reddit.com/r/kubernetes | 2022-12-25
We use golang-migrate for our platforms and it’s works exceptionally well even when many pods are active. https://github.com/golang-migrate/migrate
-
InfluxDB
Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
-
Project mention: SQLite-based databases on the Postgres protocol? Yes we can | news.ycombinator.com | 2023-01-25
- Ben is developing https://github.com/superfly/litefs at Fly after stopping the streaming replication effort https://github.com/benbjohnson/litestream/issues/8
- And, of course, SQLite has announced a new backend that hopes to support concurrent writes and streaming replication: https://sqlite.org/hctree/doc/hctree/doc/hctree/index.html
What a time for SQLite
-
Project mention: Usql – Universal command-line interface for SQL databases | news.ycombinator.com | 2022-12-30
-
-
Try: github.com/pressly/goose
-
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: Help with XO's new templating, how to access fields and params | reddit.com/r/golang | 2022-08-23I am using the library xo to generate basic data retrieval code from a sql schema for a crud api.
-
SonarQube
Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.
-
mergestat-lite
Query git repositories with SQL. Generate reports, perform status checks, analyze codebases. 🔍 📊
You can query git with this: https://github.com/mergestat/mergestat if you like the idea.
-
upper.io/db
Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
Project mention: [Hiring] Remote Golang job: Senior Backend Engineer (Go) at Horizon (Toronto, Canada) | reddit.com/r/jobbit | 2022-05-28You will be joining the expert Go team at Horizon, previously who in our spare time + for fun, authored OSS projects like chi (https://github.com/go-chi/chi), upper/db (https://github.com/upper/db), webrpc (https://github.com/webrpc/webrpc), goware (https://github.com/goware), and much more. Our Go codebases are extremely clean and the patterns we've built have been shaped over 7 years of writing production Go systems and open source projects. These are the patterns which we apply to our infrastructure at Horizon in our products Skyweaver and Sequence.
-
Project mention: New post: Is Prisma better than your 'traditional' ORM? | reddit.com/r/node | 2022-12-06
Would always go for a language agnostic migration tool, e.g. https://github.com/amacneil/dbmate to stay flexible and stay away from lock-in effects (besides sql).
-
Project mention: SQLite-based databases on the Postgres protocol? Yes we can | news.ycombinator.com | 2023-01-25
- Ben is developing https://github.com/superfly/litefs at Fly after stopping the streaming replication effort https://github.com/benbjohnson/litestream/issues/8
- And, of course, SQLite has announced a new backend that hopes to support concurrent writes and streaming replication: https://sqlite.org/hctree/doc/hctree/doc/hctree/index.html
What a time for SQLite
-
This way: https://github.com/uptrace/bun, I prefer in all cases with PostgreSQL
-
SQL Builders (think squirrel or goqu)
-
-
The same company that stopped officially maintaining their golang library when it wasn't getting "the growth we were hoping for".
-
I've also used https://github.com/gobuffalo/pop for an on-hold side project.
-
-
IceFireDB
IceFireDB is a database built for web3 and web2. It strives to fill the gap between web2 and web3 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.
Project mention: IceFireDB-Redis-proxy:Redis database proxy meets P2P, an interesting attempt. | reddit.com/r/golang | 2022-07-17 -
-
Project mention: Temporalite: Experimental distribution of Temporal that runs as single process | news.ycombinator.com | 2023-01-29
-
Project mention: WunderBase – Serverless GraphQL Database Built on Top of SQLite | news.ycombinator.com | 2022-10-30
-
Project mention: ws4sqlite v0.12.1 released - connect to sqlite via HTTP/"REST" | reddit.com/r/Database | 2022-08-11
If you are interested, feel free to browse the git repo, read the documentation (with a tutorial) or connect to the discord channel.
-
Project mention: Good embedded database with replication support? | reddit.com/r/golang | 2022-09-09
You could also look at something like this https://github.com/canonical/go-dqlite.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Go Sqlite related posts
- Temporalite: Experimental distribution of Temporal that runs as single process
- An experimental high-concurrency backend for SQLite
- Hctree is an experimental high-concurrency database back end for SQLite
- Introducing Datacake, the batteries included framework for building distributed systems in Rust.
- LiteSync – Easy synchronization of SQLite databases
- rqlite – the easy-to-use, distributed, relational database built on SQLite
- rqlite
-
A note from our sponsor - InfluxDB
www.influxdata.com | 3 Feb 2023
Index
What are some of the best open-source Sqlite projects in Go? This list will help you:
Project | Stars | |
---|---|---|
1 | rqlite | 13,073 |
2 | migrate | 10,705 |
3 | litestream | 8,030 |
4 | usql | 7,815 |
5 | sqlc | 7,329 |
6 | goose | 3,405 |
7 | xo | 3,309 |
8 | mergestat-lite | 3,244 |
9 | upper.io/db | 3,244 |
10 | dbmate | 3,049 |
11 | litefs | 2,340 |
12 | bun | 1,847 |
13 | goqu | 1,807 |
14 | tbls | 1,693 |
15 | prisma-client-go | 1,385 |
16 | gobuffalo/pop | 1,290 |
17 | jet | 1,029 |
18 | IceFireDB | 961 |
19 | go-sqlbuilder | 930 |
20 | temporalite | 449 |
21 | wunderbase | 442 |
22 | ws4sqlite | 360 |
23 | go-dqlite | 332 |