With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js. Learn more →
Top 20 TypeScript Sqlite3 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 😅
-
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.
-
SurveyJS
Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.
-
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.
-
quick.db
An easy, open-source, Node.js database designed for complete beginners getting into the concept of coding.
-
UFO_FastAPI
Converting a flat file to a database and creating a REST api using FastAPI. Front end to come later...
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Enter Drizzle, a lightweight typesafe ORM for TypeScript that comes with one promise: If you know SQL — you know Drizzle.
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:
Project mention: denodb VS denodata - a user suggested alternative | libhunt.com/r/denodb | 2023-11-29
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?
Project mention: Show HN: Nebra – Type-Safe NoSQL with Node and SQLite | news.ycombinator.com | 2023-08-18The source code is available on github: https://github.com/aerotoad/nebra
Project mention: Easy, lightweight, relational database using SQLite and NATS | news.ycombinator.com | 2024-01-07
Project mention: Ask HN: Tell us about your project that's not done yet but you want feedback on | news.ycombinator.com | 2023-08-16I have been working on this podcast transcription project for a couple months and it's been super rewarding.
I listen to a podcast called No Such Thing As A Fish, where some researchers talk about their favorite facts they learned that week. Then they riff on it and are generally smart and funny. I listened to the series so many times that I decided I wanted to listen to the show on shuffle, not at the episode level, but at the fact level.
Since I have been playing around with whisper.cpp in python this seemed like a perfect way to combine some technologies I've been wanting to play with.
I ran whisper over the entire podcast and transcribed all the episodes. I had to do this multiple times because I kept messing up. It eventually took like 7 straight days of my M1 processing to get through ~490 episodes.
4 million words, and an 800Mb SQLite database later, I got the transcriptions done and have put up a nice site for searching through the data.
https://transcript.fish
Now I just need to figure out the rest. Breaking it up into facts. Getting the audio working. Highlighting and linking to words, phrases, etc.
Some cool info about the process so far:
1. The SQLite database is chunked up and stored as static files, and the frontend queries the static files directly using HTTP range requests, so it only downloads a couple hundreds kbs when querying.
2. I've been proper using ChatGPT 3.5 free version to help me write python and SQL. It's been pretty game changing as I feel basically no pain from not knowing what I'm doing.
The code is here: https://github.com/noman-land/transcript.fish
Please help if you know how to get whisper speaker diarization working!! I would really appreciate the help.
TypeScript Sqlite3 related posts
-
Show HN: Nebra – Type-Safe NoSQL with Node and SQLite
-
undb - open source self hosted no code database
-
Undb – Private first, unified, open source no code database
-
Undb – Private first, unified, self-hosted no code database
-
Undb – Private first, unified, self-hosted no code database
-
GitHub - undb-xyz/undb: 🚀 Private first, unified, self-hosted no code database.
-
Undb open-source airtable alternative
-
A note from our sponsor - SurveyJS
surveyjs.io | 8 May 2024
Index
What are some of the best open-source Sqlite3 projects in TypeScript? This list will help you:
Project | Stars | |
---|---|---|
1 | drizzle-orm | 19,921 |
2 | MikroORM | 7,174 |
3 | datastation | 2,854 |
4 | denodb | 1,909 |
5 | undb | 1,618 |
6 | deno-nessie | 524 |
7 | react-native-sqlite-2 | 366 |
8 | quick.db | 321 |
9 | sqlite3 | 226 |
10 | electron-vite-boilerplate | 201 |
11 | neboa | 165 |
12 | leftonread | 159 |
13 | nodeMyAdmin | 89 |
14 | great.db | 71 |
15 | nest-typeorm-custom-repository | 51 |
16 | nqlite | 32 |
17 | sendight-backend | 32 |
18 | transcript.fish | 16 |
19 | knex-tree | 10 |
20 | UFO_FastAPI | 1 |
Sponsored