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 →
Top 23 Sqlite3 Open-Source Projects
-
drizzle-orm
Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅
-
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.
-
Knex
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
-
MikroORM
TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, MS SQL Server, PostgreSQL and SQLite/libSQL databases.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
HeidiSQL
A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbase and Firebird, written in Delphi
-
trdsql
CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN. Can output to various formats.
-
moneymanagerex
Money Manager Ex is an easy to use, money management application built with wxWidgets
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Project mention: Go's old $GOPATH story for development and dependencies | news.ycombinator.com | 2024-05-24Yeah, 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.
Enter Drizzle, a lightweight typesafe ORM for TypeScript that comes with one promise: If you know SQL — you know Drizzle.
Project mention: Show HN: I built a back end so simple that it fits in 1 YAML file | news.ycombinator.com | 2024-06-01Looks exactly like https://knexjs.org/ but I bet there are query builders / ORMs with same syntax
Project mention: From GUI to CLI: Transforming my query workflow with usql and jq | dev.to | 2024-05-15Since some of the databases I was interacting were postgres, I started to play around with psql. It felt amazing, it had a great integration with the terminal, no visual pollution, I could also use vim as my query editor, and it was blazing fast. The problem was that only some of the databases I was interacting were postgres. I needed something that could connect to multiple databases, something universal, so I don't have to invest time in new tooling all the time. So I searched on github "universal sql" and I felt in love with usql.
In my usual NodeJS tech stack, which includes GraphQL, NestJS, SQL (predominantly PostgreSQL with MikroORM), I encountered these limitations. To overcome them, I've developed a new stack utilizing Rust, which still offers some ease of development:
Project mention: Eradicating N+1s: The Two-Phase Data Load and Render Pattern in Go | news.ycombinator.com | 2024-05-28If 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
HeidiSQL is used to show database changes, consider supporting it.
Project mention: denodb VS denodata - a user suggested alternative | libhunt.com/r/denodb | 2023-11-29
https://moneymanagerex.org hey they have Mac app, it's free... but also it's free...
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
Great guide. One thing that seems to be missing is something I see in a lot of README's: a list of the core tech stack being used in the repo. Good examples here https://github.com/undb-xyz/undb#-tech-stack and here https://github.com/steven-tey/novel#tech-stack. Did you already consider adding this as part of the guide and decide against it, or was it just not something you thought to add?
Sqlite3 related posts
-
From GUI to CLI: Transforming my query workflow with usql and jq
-
The Advantages of Bun: When to Choose it Over Node.js 🔥
-
Show HN: Roast my SQLite encryption at-rest
-
SQLite-x: The minimalistic SQLite editor for non-programmers
-
Soul: A SQLite REST and Realtime Server
-
Soul RESTful and realtime server for SQLite, now with Authentication!
-
Realtime telemetry from ISS internal components
-
A note from our sponsor - InfluxDB
www.influxdata.com | 3 Jun 2024
Index
What are some of the best open-source Sqlite3 projects? This list will help you:
Project | Stars | |
---|---|---|
1 | Gogs | 44,325 |
2 | drizzle-orm | 20,638 |
3 | Knex | 18,855 |
4 | q | 10,130 |
5 | usql | 8,674 |
6 | LitePal | 8,067 |
7 | MikroORM | 7,263 |
8 | SQLBoiler | 6,502 |
9 | better-sqlite3 | 5,138 |
10 | Isso | 4,976 |
11 | Tale | 4,879 |
12 | HeidiSQL | 4,509 |
13 | bun | 3,359 |
14 | datastation | 2,857 |
15 | sqlcheck | 2,393 |
16 | sqlite_orm | 2,163 |
17 | sqler | 2,061 |
18 | denodb | 1,912 |
19 | trdsql | 1,896 |
20 | moneymanagerex | 1,670 |
21 | marmot | 1,662 |
22 | undb | 1,635 |
23 | ElectroCRUD | 1,531 |
Sponsored