Sonar helps you commit clean code every time. With over 300 unique rules to find JavaScript bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work. Learn more →
Top 23 TypeScript Sqlite Projects
-
Project mention: Unicorn Startup Airtable Lays Off 27% of Firm, Shifts Focus to Big Clients | news.ycombinator.com | 2023-09-15
Baserow is cool. We evaluated it within our company a few months ago and eventually settled for Nocodb (https://nocodb.com/) - easy to run, more mature.
Leaptable is another Open Source framework like Airtable I saw recently with support for AI Agents. https://github.com/peterwnjenga/leaptable
-
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
Ghostfolio is written in TypeScript and organized as an Nx workspace, utilizing the latest framework releases. The backend is based on NestJS in combination with PostgreSQL as a database together with Prisma and Redis for caching. The frontend is built with Angular.
-
Amplication
Amplication: open-source Node.js backend code generator. An open-source platform that helps developers build backends without spending time on boilerplate & repetitive coding. Including production-ready GraphQL & REST APIs, DB schema, DTOs, filtering, pagination, RBAC, & more.
-
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.
-
Directus
The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.
One of our DevRel initiatives at Directus is constantly improving our documentation. As a small team with finite time and resources, we rely a lot on user feedback to help guide our writing efforts. But we were missing the most important bit there – your feedback.
-
Project mention: Database Review: Top Five Missing Features from Database APIs | dev.to | 2023-09-14
Drizzle ORM
-
Project mention: Database Review: Top Five Missing Features from Database APIs | dev.to | 2023-09-14
Kysely
-
MikroORM
TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases.
It also does code generation into its own module, so good luck with hoisting in a monorepo where you want multiple independent prisma schemas. MikroORM[1] is a much better alternative to Prisma in my opinion but any ORM carries some form of baggage.
-
Appwrite
Appwrite - The open-source backend cloud platform. The open-source backend cloud platform for developing Web, Mobile, and Flutter applications. You can set up your backend faster with real-time APIs for authentication, databases, file storage, cloud functions, and much more!
-
SQL Chat is a young player, prompting SQL clients from the traditional GUI-based to the Chat-based stage: it's powered by ChatGPT to write and polish SQL for you.
-
Project mention: Show HN: Glue4 is a Redux extension that handles your back end concerns | news.ycombinator.com | 2022-12-19
Thank you for the details.
The databases integrations looks similar to keyv https://www.npmjs.com/package/keyV
-
Project mention: Building a REST API with Deno and Hono.js: A Step-by-Step Guide | dev.to | 2023-08-13
denodb - Object-relational Mapper (ORM)
-
evolu
Local-first platform designed for privacy, ease of use, and no vendor lock-in to sync and backup people's lifetime data
-
At Databases because you don't need ORM.
-
-
Project mention: Show HN: Visit material by local network on any device | news.ycombinator.com | 2023-06-17
-
-
nuxt-todos-edge
A full-stack application with authentication, SSR and SQLite, running on the edge with Nuxt 3.
Project mention: A composable that requires access to the Nuxt instance was called outside of a plugin, Nuxt hook, Nuxt middleware, or Vue setup function. | /r/Nuxt | 2023-07-13the demo project link: https://github.com/Atinux/nuxt-todos-edge/blob/eda23bfd36278fcd53d602cd3080fd61c58b0ed1/composables/session.ts
-
trilogy
TypeScript SQLite layer with support for both native C++ & pure JavaScript drivers. (by haltcase)
-
aurora
CLI tool that orchestrates prisma files in a way that allows multiple .prisma files with cross-relations (by sabinadams)
-
-
-
Project mention: SpatiaLite (SQLite extension) for browser and node | news.ycombinator.com | 2023-09-20
-
Project mention: Appropriate way to retrieve data from PlanetScale in client side code? | /r/nextjs | 2023-06-07
While the example is next interacting with postgresql, the lib also supports mysql (and planetscale by extension) https://github.com/subzerocloud/showcase/tree/main/node-myrest
-
I am preparing for this! Building https://github.com/kikko-land/kikko that widely supports all the of platforms that have SQLite on it, and allows building reactive interface on top of React/Vue/AngularJS(WIP)/whatever.
Project is in alpha, and already has support of absurd-sql, wa-sqlite for web; expo, tauri, electron, ionic, React Native.
I am super excited to add support of official SQLite wasm implementation
-
SurveyJS
A Non-Cloud Alternative to Google Forms that has it all.. SurveyJS JavaScript libraries allow you to easily set up a robust form management system fully integrated into your IT infrastructure where users can create and edit multiple dynamic JSON-based forms in a no-code form builder. Learn more now.
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 2023-09-26.
TypeScript Sqlite related posts
- SpatiaLite (SQLite extension) for browser and node
- Some notes on local-first development
- 👻Top 8 Free, Open Source SQL Clients🔥
- Kysely - Typescript successor to Knex - `kysely-codegen` also generates types from your existing database.
- Show HN: Doculite – Use SQLite Like Firestore
- A composable that requires access to the Nuxt instance was called outside of a plugin, Nuxt hook, Nuxt middleware, or Vue setup function.
- Memos: A lightweight self-hosted memo hub
-
A note from our sponsor - Sonar
www.sonarsource.com | 28 Sep 2023
Index
What are some of the best open-source Sqlite projects in TypeScript? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | nocodb | 37,883 |
| 2 | Prisma | 33,925 |
| 3 | TypeORM | 32,161 |
| 4 | Directus | 23,214 |
| 5 | drizzle-orm | 13,375 |
| 6 | kysely | 7,424 |
| 7 | MikroORM | 6,505 |
| 8 | sqlchat | 3,095 |
| 9 | Keyv | 2,251 |
| 10 | denodb | 1,911 |
| 11 | evolu | 711 |
| 12 | @databases | 550 |
| 13 | itwinjs-core | 530 |
| 14 | rao-pics | 482 |
| 15 | react-native-sqlite-2 | 351 |
| 16 | nuxt-todos-edge | 267 |
| 17 | trilogy | 252 |
| 18 | aurora | 206 |
| 19 | vscode-sqlite | 184 |
| 20 | kysely-d1 | 158 |
| 21 | spl.js | 136 |
| 22 | showcase | 125 |
| 23 | kikko | 121 |
Collect and Analyze Billions of Data Points in Real Time
Manage all types of time series data in a single, purpose-built database. Run at any scale in any environment in the cloud, on-premises, or at the edge.
www.influxdata.com