SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 TypeScript Sqlite Projects
-
Project mention: Show HN: Visual DB – Web front end for your database | news.ycombinator.com | 2024-09-10
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
Project mention: How I Solved Common Prisma ORM Errors: Debugging Tips and Best Practices | dev.to | 2024-12-01The Prisma ORM is a powerful companion for every software engineer, indie maker, and SaaS founder who wants to add type safety to the queries executed on the database.
-
TypeORM
ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
// src/main/database/dataSource.ts import path from "node:path"; import "reflect-metadata"; import { DataSource } from "typeorm"; import { UserEntity } from "./entities/user/user.entity"; import { PostEntity } from "./entities/post/post.entity"; const isElectron = !!process.versions.electron; # simple trick to see if the data source is called from the Electron app or CLI (for migrations scripts) const isProduction = process.env.NODE_ENV === "production"; let databasePath: string; if (isElectron) { // eslint-disable-next-line @typescript-eslint/no-require-imports const { app } = require("electron"); databasePath = path.join( app.getPath("userData"), app.isPackaged ? "app-name.sqlite" : "app-name.dev.sqlite" ); } else { // use hardcoded path for running migrations in development (macOS) databasePath = path.join( "/Users/user/Library/Application Support/app-name/", isProduction ? "app-name.sqlite" : "app-name.dev.sqlite" ); } // https://typeorm.io/data-source-options#better-sqlite3-data-source-options const dataSource = new DataSource({ type: "better-sqlite3", database: databasePath, entities: [UserEntity, PostEntity], migrations: [ path.join(__dirname, isElectron ? "database" : "", "/migrations/*.{js,ts}"), ], synchronize: false, # important logging: true # use this for debugging }); export const entityManager = dataSource.createEntityManager(); export default dataSource;
-
Sequelize
Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.
3. Sequelize
-
Directus
The flexible backend for all your projects 🐰 Turn your DB into a headless CMS, admin panels, or apps with a custom UI, instant APIs, auth & more.
Project mention: Ask HN: Anybody used Retool for production, user-facing app? | news.ycombinator.com | 2024-11-18I would also recommend looking at Directus (https://directus.io).
We evaluated PayloadCMS to drive the backend of a mobile app and eventually settled on Directus because it supported heterogeneous collections which was something we had to have.
Directus also has a template for a multi-tenant app which sounds like something you might need.
-
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 😅
ORM: Drizzle
-
beekeeper-studio
Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
Project mention: Beekeeper Studio: Lightweight DataGrip Alternative | news.ycombinator.com | 2024-09-17I use Beekeeper and like it very much for a simple GUI that works with a number of sql databases.
It should be noted that the link here is a comparison page specifically for DataGrip. There are similar comparison pages for other tools. Or go to Beekeepers home page for an overview of the product.
https://www.beekeeperstudio.io
-
Project mention: Show HN: I just made my profitable online form builder open-sourced | news.ycombinator.com | 2024-04-01
I use nestjs in my open source no-code database https://github.com/teableio/teable, and I really like it, especially the dependency injection capability.
-
-
Project mention: Writing Composable SQL Using Knex and Pipelines | news.ycombinator.com | 2024-11-28
This was one of the problems I ran into https://github.com/kysely-org/kysely/issues/664, not being able to use functions inside onDuplicateKeyUpdate
-
chartdb
Database diagrams editor that allows you to visualize and design your DB with a single query.
Welcome 👋 to this blog. This blog will introduce new functionalities of chartDB. We have just added some new functionality to the chatDB project. This new functionality helps us share our diagram with other features and duplicate the table.
-
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.
Project mention: MikroORM: TypeScript ORM for Node.js Based on Data Mapper | news.ycombinator.com | 2024-07-18 -
-
-
-
Project mention: Automerge: A library of data structures for building collaborative applications | news.ycombinator.com | 2024-07-19
It looks very similar to Evolu (https://github.com/evoluhq/evolu)
-
node-sqlite
SQLite client wrapper around sqlite3 for Node.js applications with SQL-based migrations API written in Typescript
Project mention: Show HN: Mutable.ai Codebase chat that uses a Wiki for RAG | news.ycombinator.com | 2024-07-15 -
Nano-SQL
Universal database layer for the client, server & mobile devices. It's like Lego for databases.
-
We don't cache query responses in the Starbase application layer. When we originally set out to build this, we were under the assumption we had to handle the ACID transactional support ourselves. Thankfully someone from Cloudflare shed some light for us as you can see in our Github issues and open PR's :)
Learn more about that here: https://github.com/Brayden/starbasedb/issues/12
-
-
-
Project mention: Deno KV internals: building a database for the modern web | news.ycombinator.com | 2024-05-10
With what license?
(Several clicks in it looks like https://github.com/denoland/denokv is the repo and it's an MIT license.)
-
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).
TypeScript Sqlite discussion
TypeScript Sqlite related posts
-
Writing Composable SQL Using Knex and Pipelines
-
Show HN: Neon-PostgREST – Build a Supabase-Like API/SDK DevX over Neon
-
Handling TypeORM migrations in Electron apps
-
Can You Create a Product That Makes Money with Wasm?
-
SvelteKit, Lucia and Passkey authentication - a tutorial
-
SQLite Viewer: Fast, Browser-Based SQLite Database Tool
-
Building a community database with GitHub : A guide to Webhook and API integration with hono.js
-
A note from our sponsor - SaaSHub
www.saashub.com | 1 Dec 2024
Index
What are some of the best open-source Sqlite projects in TypeScript? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | nocodb | 49,979 |
| 2 | Prisma | 39,811 |
| 3 | TypeORM | 34,316 |
| 4 | Sequelize | 29,621 |
| 5 | Directus | 28,229 |
| 6 | drizzle-orm | 24,770 |
| 7 | beekeeper-studio | 16,837 |
| 8 | teable | 13,162 |
| 9 | noodle | 12,021 |
| 10 | kysely | 10,860 |
| 11 | chartdb | 10,390 |
| 12 | MikroORM | 7,838 |
| 13 | sqlchat | 4,665 |
| 14 | Keyv | 2,636 |
| 15 | denodb | 1,926 |
| 16 | evolu | 1,465 |
| 17 | node-sqlite | 905 |
| 18 | Nano-SQL | 781 |
| 19 | starbasedb | 722 |
| 20 | itwinjs-core | 621 |
| 21 | @databases | 609 |
| 22 | denokv | 514 |
| 23 | KaraokeEternal | 459 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com