Top 23 TypeScript Sqlite Projects
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.
🔥 🔥 🔥 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 - 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!
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDBProject 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.
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.
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.
MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno
Database CRUD Application Built on Electron | MySQL, Postgres, SQLite
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.
A type-safe typescript SQL query builderProject mention: Raw SQL vs Knex.js vs Prisma vs MikroORM | reddit.com/r/node | 2022-06-20
Monorepo for iTwin.js LibraryProject mention: Session extension in SQLite allow you to create changeset | reddit.com/r/sqlite | 2021-12-13
TypeScript clients for databases that prevent SQL InjectionProject 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.
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.
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.
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 extension to explore and query SQLite databases.Project mention: VSCode extension to explore and query SQLite databases | reddit.com/r/CKsTechNews | 2022-06-15
[Experimental] Persist SQLite in a Cloudflare Durable ObjectProject 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.
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.
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
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.
Learn & Practise SQL by running SQL queries in your phoneProject 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
Fast WebSQL-compatible SQLite driver for React Native
A web interface and GraphQL API for your local unencrypted WhatsApp backup. (by niklaskorz)
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
TypeScript Sqlite related posts
VSCode extension to explore and query SQLite databases
1 project | reddit.com/r/CKsTechNews | 15 Jun 2022
VSCode extension to explore and query SQLite databases
1 project | news.ycombinator.com | 15 Jun 2022
Building a To-Do List Using Hotwire and Stimulus
3 projects | dev.to | 22 Feb 2022
How to use SchemaDirectiveVisitor with Apollo-server-express?
1 project | reddit.com/r/graphql | 25 Jan 2022
What is something you wish you had that would make GraphQL experience much simpler?
1 project | reddit.com/r/graphql | 24 Jan 2022
GiraphQL server example with directives, subscriptions, unit and integration tests
1 project | reddit.com/r/graphql | 17 Jan 2022
SeaOrm : any feedback ?
3 projects | reddit.com/r/rust | 6 Jan 2022
What are some of the best open-source Sqlite projects in TypeScript? This list will help you:
Are you hiring? Post a new remote job listing for free.