The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. 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.
-
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.
-
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
> Gitea but the other one
Wouldn't that also be Gogs? https://gogs.io/
I remember when that one was what a lot of people were looking into, before the Gitea fork happened. It's odd to see how this has happened yet again, but I guess is a good thing that it's even possible in the first place, if there are indeed differing values and goals?
Drizzle ORM is a very popular TypeScript ORM that provides type safe access to your database, automated migrations, and a custom data model definition.
Project mention: JavaScript Libraries for Implementing Trendy Technologies in Web Apps in 2024 | dev.to | 2024-04-09Knex.js
Project mention: xo/usql: Universal command-line interface for SQL databases | /r/devel | 2023-06-08
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:
SQLBoiler takes a database-first approach, generating Go code from your database schema. This means it creates highly optimized and custom-tailored code for your specific database schema. SQLBoiler is great for applications where the database schema is well-defined and changes infrequently. However, like sqlc, it requires regenerating the code when the database schema changes. It's well-suited for projects where performance is a key concern and the database design is stable.
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.
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
- 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
- YAS-QWIN (Yet Another SQL-Query Writing Interface)
- Tropy: Explore Your Research Photos
- Extralite: SQLite Ruby gem with concurrency, extensions, backup features
-
A note from our sponsor - WorkOS
workos.com | 19 Apr 2024
Index
What are some of the best open-source Sqlite3 projects? This list will help you:
Project | Stars | |
---|---|---|
1 | Gogs | 44,097 |
2 | drizzle-orm | 19,263 |
3 | Knex | 18,720 |
4 | q | 10,109 |
5 | usql | 8,589 |
6 | LitePal | 8,050 |
7 | MikroORM | 7,122 |
8 | SQLBoiler | 6,412 |
9 | better-sqlite3 | 4,991 |
10 | Isso | 4,959 |
11 | Tale | 4,879 |
12 | HeidiSQL | 4,426 |
13 | bun | 3,097 |
14 | datastation | 2,853 |
15 | sqlcheck | 2,378 |
16 | sqlite_orm | 2,128 |
17 | sqler | 2,056 |
18 | denodb | 1,904 |
19 | trdsql | 1,781 |
20 | moneymanagerex | 1,645 |
21 | marmot | 1,612 |
22 | undb | 1,599 |
23 | ElectroCRUD | 1,523 |