TypeScript Sqlite

Open-source TypeScript projects categorized as Sqlite Edit details

Top 23 TypeScript Sqlite Projects

  • TypeORM

    ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.

    Project mention: Comparing 4 popular NestJS ORMs | dev.to | 2022-06-22

    TypeORM is another mature ORM for Node.js. It has a rich feature set, including an entity manager, connection pooling, replication, and query caching. It's also directly supported by NestJS with its own package, @nestjs/typeorm.

  • nocodb

    🔥 🔥 🔥 Open Source Airtable Alternative - turns any MySQL, Postgres, SQLite into a Spreadsheet with REST APIs.

    Project mention: Easiest way for a simple frontend for my database? | reddit.com/r/SQL | 2022-06-03

    I have never used, it, but nocoDB looks quite promising.

  • Appwrite

    Appwrite - The Open Source Firebase alternative introduces iOS support . Appwrite is an open source backend server that helps you build native iOS applications much faster with realtime APIs for authentication, databases, files storage, cloud functions and much more!

  • Prisma

    Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB

    Project mention: Authentication and DB access with Next, Prisma, and MongoDB | reddit.com/r/reactjs | 2022-06-24

    Next.js is an amazing framework. So, I wrote an article on how you can directly access your MongoDB database with Prisma ORM directly from your frontend with authentication.

  • Directus

    The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.

    Project mention: In Praise Of WP-Rocket | reddit.com/r/Wordpress | 2022-06-08

    Backend/CMS: Directus.io self install with node process / database / storage on separate Digital Ocean services.

  • 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.

    Project mention: Comparing 4 popular NestJS ORMs | dev.to | 2022-06-22

    MikroORM is another TypeScript ORM for Node.js based on the Data Mapper, Unit of Work, and Identity Map patterns.

  • denodb

    MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno

  • ElectroCRUD

    Database CRUD Application Built on Electron | MySQL, Postgres, SQLite

  • JetBrains

    Developer Ecosystem Survey 2022. Take part in the Developer Ecosystem Survey 2022 by JetBrains and get a chance to win a Macbook, a Nvidia graphics card, or other prizes. We’ll create an infographic full of stats, and you’ll get personalized results so you can compare yourself with other developers.

  • kysely

    A type-safe typescript SQL query builder

    Project mention: Raw SQL vs Knex.js vs Prisma vs MikroORM | reddit.com/r/node | 2022-06-20
  • itwinjs-core

    Monorepo for iTwin.js Library

    Project mention: Session extension in SQLite allow you to create changeset | reddit.com/r/sqlite | 2021-12-13
  • @databases

    TypeScript clients for databases that prevent SQL Injection

    Project mention: what node ORM is worth it to learn | reddit.com/r/node | 2022-02-26

    I built https://www.atdatabases.org which has an ORM for node.js, but also supports writing SQL queries in a safe way. It is type safe, and has much simpler & more flexible transaction support than most node.js ORMs.

  • react-native-sqlite-2

    SQLite3 Native Plugin for React Native for iOS, Android, Windows and macOS.

    Project mention: A performant way to use [email protected] on React Native in 2022 | dev.to | 2022-04-30

    Oscar Franco created a great SQLite driver react-native-quick-sqlite, which provides a low-level API to execute SQL queries, fast bindings via JSI. JSI has a smaller overhead than the traditional RN bridge's. So, this is much faster than react-native-sqlite-2, which I made to get PouchDB to work on RN before.

  • trilogy

    TypeScript SQLite layer with support for both native C++ & pure JavaScript drivers. (by haltcase)

    Project mention: Trilogy – GitHub-built MySQL client library written in C | news.ycombinator.com | 2021-12-15

    Naming is hard and conflicts are easy, but this project clashes with my own project called Trilogy. Both for SQL-family, although mine is in the JavaScript realm. I'm not too surprised someone followed the logic did to get the name.

    Not a huge project but has some users, and I still try to work on it to get the typings (TypeScript) where I want them.


  • aurora

    CLI tool that orchestrates prisma files in a way that allows multiple .prisma files with cross-relations (by sabinadams)

    Project mention: Does Prisma work in production? | reddit.com/r/node | 2022-03-28

    Yes, there are a few ways to achieve this! It's not supported natively yet but in this issue lots of people list their favorite workarounds which you can draw inspiration from. One of the most popular ones is to use a library written by one of our community members (who we actually now hired as a Developer Advocate :D) called aurora.

  • vscode-sqlite

    VSCode extension to explore and query SQLite databases.

    Project mention: VSCode extension to explore and query SQLite databases | reddit.com/r/CKsTechNews | 2022-06-15
  • do-sqlite

    [Experimental] Persist SQLite in a Cloudflare Durable Object

    Project mention: Store SQLite in Cloudflare Durable Objects | dev.to | 2022-01-26

    tl;dr: A custom SQLite virtual file system and some WASM/WASI compilation magic allow to run SQLite on a Cloudflare Worker and persist it into a Durable Object. POC source can be found at github.com/rkusa/do-sqlite.

  • sqlite3

    Fast, native bindings to SQLite3 C API, using Deno FFI. (by denodrivers)

    Project mention: Deno Is Webby | news.ycombinator.com | 2022-03-16

    Not one that's up to date and maintained, as far as I can google.

    But there's a proper sqlite driver now using the new ffi api support in deno. This didn't exist last time I tried googling db support in deno.


  • scraper

    Nodejs web scraper. Contains a command line, docker container, terraform module and ansible roles for distributed cloud scraping. Supported databases: SQLite, MySQL, PostgreSQL. Supported headless clients: Puppeteer, Playwright, Cheerio, JSdom. (by get-set-fetch)

    Project mention: Most Used Individual JavaScript Libraries - jQuery still leads | reddit.com/r/javascript | 2022-06-14
  • spl.js

    SpatiaLite for browser & node

    Project mention: Combining several feature layers into 1 layer using ArcGIS JavaScript | reddit.com/r/gis | 2022-06-20

    https://github.com/jvail/spl.js Your use case could be good for doing this in spatialite Create a new geopackage Import GeoJSON from featureserver or mapserver layers -f=GeoJSON for each layer or use virtualgeojson You can make the import happen for new records or changes And then create new table and append the records Then you can execute SQL queries Counts or Distinct or where clauses

  • sqlite-viewer-vscode

    A quick and easy SQLite viewer for VSCode, inspired by DBBrowser for SQLite and Airtable.

    Project mention: Open source IDE for sqlite | reddit.com/r/learnpython | 2022-04-20

    There seems to be a vscode extension. No idea if it's any good though.

  • SQL-Play

    Learn & Practise SQL by running SQL queries in your phone

    Project mention: I finally added some end to end testing in my app using detox 😍 | reddit.com/r/reactnative | 2021-06-29

    The project is open source - https://github.com/ShivamJoker/SQL-Play

  • react-native-quick-websql

    Fast WebSQL-compatible SQLite driver for React Native

    Project mention: A performant way to use [email protected] on React Native in 2022 | dev.to | 2022-04-30

    I wanted to use it in my project, so I made react-native-quick-websql, which is a thin wrapper to make quick-sqlite compatible with WebSQL. It works flawlessly!

  • whatsapp-viewer

    A web interface and GraphQL API for your local unencrypted WhatsApp backup. (by niklaskorz)

  • graphql-pothos-server-example

    Example implementation of the Pothos (formerly GiraphQL) library to create a GraphQL server with queries, mutations, and subscriptions along with unit and integration tests.

    Project mention: What stack do you use with graphql? | reddit.com/r/graphql | 2022-02-03
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 2022-06-24.

TypeScript Sqlite related posts


What are some of the best open-source Sqlite projects in TypeScript? This list will help you:

Project Stars
1 TypeORM 28,566
2 nocodb 28,496
3 Prisma 23,575
4 Directus 16,390
5 MikroORM 4,692
6 denodb 1,674
7 ElectroCRUD 1,379
8 kysely 1,022
9 itwinjs-core 443
10 @databases 327
11 react-native-sqlite-2 305
12 trilogy 239
13 aurora 154
14 vscode-sqlite 150
15 do-sqlite 92
16 sqlite3 75
17 scraper 66
18 spl.js 65
19 sqlite-viewer-vscode 55
20 SQL-Play 46
21 react-native-quick-websql 26
22 whatsapp-viewer 12
23 graphql-pothos-server-example 11
Find remote jobs at our new job board 99remotejobs.com. There are 4 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
Less time debugging, more time building
Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.