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. Learn more →
Top 23 TypeScript Postgresql Projects
-
Project mention: Building a Fast, Efficient Web App: The Technology Stack of PromptSmithy Explained | dev.to | 2024-03-26
Here the thing that accelerated my development the most: Supabase. Thanks to its Database, Authentication, and Edge Functions, we were able to rapidly develop the app. Their JS library made development super seamless, and their local development stack made testing a breeze.
-
Project mention: Show HN: Teable – Open-Source No-Code Database Fusion of Postgres and Airtable | news.ycombinator.com | 2024-03-11
-
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.
-
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
Project mention: End-To-End Polymorphism: From Database to UI, Achieving SOLID Design | dev.to | 2024-03-28Unfortunately Prisma hasn’t supported polymorphism yet. As such, you can't use inheritance to model the entity in the same way as in your programming language, as depicted in the above class diagram. The good news is that we could intimate it using table inheritance to imitate it.
-
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.
If you use Sequalize, TypeORM or for MongoDB, we have Mongoose these types of ORM tools, then you are safe by default because these help us against the SQL query injection attacks by default.
-
Cal.com is an open-source event-juggling scheduler for everyone, and is free for individuals.
-
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: Our repo hit a milestone today with 25k GH stars | news.ycombinator.com | 2024-03-12 -
plane
🔥 🔥 🔥 Open Source JIRA, Linear and Asana Alternative. Plane helps you track your issues, epics, and product roadmaps in the simplest way possible.
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
full-stack-fastapi-template
Full stack, modern web application template. Using FastAPI, React, SQLModel, PostgreSQL, Docker, GitHub Actions, automatic HTTPS and more.
Project mention: Building a Secure API with FastAPI, PostgreSQL, and Hanko Authentication | dev.to | 2023-10-30This project is a modification of the authentication flow of the awesome repository made by tiangolo at full-stack-fastapi-postgresql
-
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 😅
Each app’s front end is built with Qwik and uses Tailwind for styling. The server-side is powered by Qwik City (Qwik’s official meta-framework) and runs on Node.js hosted on a shared Linode VPS. The apps also use PM2 for process management and Caddy as a reverse proxy and SSL provisioner. The data is stored in a PostgreSQL database that also runs on a shared Linode VPS. The apps interact with the database using Drizzle, an Object-Relational Mapper (ORM) for JavaScript. The entire infrastructure for both apps is managed with Terraform using the Terraform Linode provider, which was new to me, but made provisioning and destroying infrastructure really fast and easy (once I learned how it all worked).
-
beekeeper-studio
Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
This tool doesn't let you run SQL queries or create tables. SchemaSpy describes and visualizes an already-created database.
To work directly with SQL, I recommend https://www.beekeeperstudio.io/ or https://dbgate.org/
-
crystal
🔮 Graphile's Crystal Monorepo; home to Grafast, PostGraphile, pg-introspection, pg-sql2 and much more! (by graphile)
Project mention: Ask HN: What Underrated Open Source Project Deserves More Recognition? | news.ycombinator.com | 2024-03-07I didn't see a v5 tag in order to know, and I have no idea what "utils/graphile" does for the project, but one will want to ensure they are aware of its licensing scheme https://github.com/graphile/crystal/blob/db8894c74eb0ec3fe96...
-
-
Project mention: ORMs are nice but they are the wrong abstraction | news.ycombinator.com | 2024-02-01
ORMs suck, but raw SQL embedded in your code sucks too.
This might be good time to plug my TypeScript non-ORM: https://jawj.github.io/zapatos/.
I should say I also like what I've seen of https://kysely.dev/ and https://pgtyped.dev/.
-
openreplay
Session replay and analytics tool you can self-host. Ideal for reproducing issues, co-browsing with users and optimizing your product.
Project mention: Show HN: How Cobrowsing Works in Session Replay | news.ycombinator.com | 2024-03-14 -
azuredatastudio
Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
-
logto
🧑🚀 The better identity infrastructure for developers and the open-source alternative to Auth0.
-
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.
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: Docusign updates terms of service, training proprietary AI using user data | news.ycombinator.com | 2024-02-29
Unknown if it's better or worse but https://support.google.com/docs/answer/12315692?hl=en ("Send signature requests & sign documents with eSignature")
and there have also been a bunch of alleged competitors submitted:
https://github.com/docusealco/docuseal#readme https://news.ycombinator.com/item?id=36798593
https://github.com/OpenSignLabs/OpenSign#readme https://news.ycombinator.com/item?id=38052344
https://github.com/documenso/documenso#readme https://news.ycombinator.com/item?id=38404129
but they're all AGPLv3 and the network effect is very real
-
-
And sometimes invest instead in learning a technology rather than hide it: for example slonik encourages you to write normal SQL queries by making SQL templating easier and safer. In turn, your IDE would be able to understand those queries and give you support based on the database schemas you actually have.
-
sql-translator
SQL Translator is a tool for converting natural language queries into SQL code using artificial intelligence. This project is 100% free and open source.
I started to see more and more applications that use the OpenAI API and I wanted to try it out. One of these apps is this one made by Kate.
-
-
There is an implementation of SQL that operates on a table shaped type, entirely at type level. For your amusement: https://github.com/codemix/ts-sql
There are a bunch of more practical takes that codegen types from your database and generate types for your queries, eg: https://github.com/adelsz/pgtyped
To me the second approach seems much more pragmatic because you don’t need to run a SQL parser in a fairly potato interpreter on every build
-
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.
TypeScript Postgresql related posts
- Show HN: Teable – Open-Source No-Code Database Fusion of Postgres and Airtable
- Efficient Database Queries in Rails: A Practical Approach
- How to add Passkey Login to Next.js using NextAuth and Hanko
- Setup monorepo with pnpm, typescript and turborepo
- Implementing system-versioned tables in Postgres
- What's new in the Postgres 16 query planner (a.k.a. optimizer)
- ORMs are nice but they are the wrong abstraction
-
A note from our sponsor - InfluxDB
www.influxdata.com | 28 Mar 2024
Index
What are some of the best open-source Postgresql projects in TypeScript? This list will help you:
Project | Stars | |
---|---|---|
1 | supabase | 64,560 |
2 | nocodb | 41,502 |
3 | Prisma | 36,783 |
4 | TypeORM | 33,123 |
5 | cal.com | 28,031 |
6 | Directus | 25,113 |
7 | plane | 23,496 |
8 | full-stack-fastapi-template | 21,592 |
9 | drizzle-orm | 18,678 |
10 | beekeeper-studio | 15,085 |
11 | crystal | 12,381 |
12 | dogehouse | 9,128 |
13 | kysely | 9,022 |
14 | openreplay | 8,713 |
15 | azuredatastudio | 7,420 |
16 | logto | 7,058 |
17 | MikroORM | 7,055 |
18 | documenso | 5,725 |
19 | teable | 4,530 |
20 | slonik | 4,328 |
21 | sql-translator | 3,923 |
22 | datastation | 2,850 |
23 | pgtyped | 2,762 |