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
-
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
-
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.
-
Sequelize
Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.
-
Directus
The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.
-
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.
-
plane
🔥 🔥 🔥 Open Source JIRA, Linear and Asana Alternative. Plane helps you track your issues, epics, and product roadmaps in the simplest way possible.
-
full-stack-fastapi-template
Full stack, modern web application template. Using FastAPI, React, SQLModel, PostgreSQL, Docker, GitHub Actions, automatic HTTPS and more.
-
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 😅
-
beekeeper-studio
Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
-
crystal
🔮 Graphile's Crystal Monorepo; home to Grafast, PostGraphile, pg-introspection, pg-sql2 and much more! (by graphile)
-
openreplay
Session replay and analytics tool you can self-host. Ideal for reproducing issues, co-browsing with users and optimizing your product.
-
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, MS SQL Server, PostgreSQL and SQLite/libSQL databases.
-
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.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Project mention: Mastering Real-Time Collaboration: Building Figma and Miro-Inspired Features with Supabase | dev.to | 2024-05-11Supabase is a backend as a service visual platform that allows you to create postgres DB with minimum code. Their documentation is so good that it feels like home and you can get your project online in no matter of time.
In the world of software development, there are two kinds of developers: those who have never had to complain about ORMs and those who have actually used them. Whether it’s Django ORM for Python, Active Record for Ruby, GORM for Golang, Doctrine for PHP, or Prisma for TypeScript, a common issue persists: writing simple queries is straightforward, but constructing complex or optimized queries can take hours, if not days.
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.
Sequelize - modern Typescript and NodeJS ORM for Oracle, Postgres, MySQL, MariaDB, SQLite, SQL Server+docs
Cal.com is an open-source event-juggling scheduler for everyone, and is free for individuals.
Project mention: How to Deploy Directus as a Backend-as-a-Service (BaaS) on Koyeb | dev.to | 2024-04-25Directus is an open data platform built to serve as a headless CMS, API, or Backend-as-a-Service (BaaS) for other applications. It is designed to make data accessible to people of all technical levels and to make it easy to build data-centric applications. Directus is extensible and can be integrated with many different frontend technologies to create stable, well-structured development and user experiences.
Project mention: Plane, open-source Jira alternative, got to 100K+ Docker and 44K+ K8s deploys | news.ycombinator.com | 2024-05-15Hi HN,
Vihar here, one of the maintainers at Plane (https://github.com/makeplane/plane).
Last time, we shared how we reached 15K stars on GitHub in less than a year, pushing Plane to the top spot in #project-management. The post received great feedback from the HN community, and we noticed comments about lapses in self-hosting.
We took on the challenge, rethought the entire Docker setup, made it single-click, and provided a maintenance script.
Now, we share our journey to over 100K+ Docker pulls and 44K+ K8 deploys in this blog. Please let us know what we could improve.
Hope you enjoy the article. Feedback welcome!
Thanks,
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
Enter Drizzle, a lightweight typesafe ORM for TypeScript that comes with one promise: If you know SQL — you know Drizzle.
If we access a client like PgAdmin or Beekeeper, or accessing its container via bash and checking via CLI, we can see that the table was created successfully:
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...
The most interesting JS DB lib I came across was https://github.com/kysely-org/kysely but still didn't feel as good as EF Core.
Uncover frustrations, understand bugs and fix slowdowns like never before with OpenReplay — an open-source session replay tool for developers. Self-host it in minutes, and have complete control over your customer data. Check our GitHub repo and join the thousands of developers in our community.
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: Show HN: I just made my profitable online form builder open-sourced | news.ycombinator.com | 2024-04-01I use nestjs in my open source no-code database https://github.com/teableio/teable, and I really like it, especially the dependency injection capability.
Project mention: Docusign updates terms of service, training proprietary AI using user data | news.ycombinator.com | 2024-02-29Unknown 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.
TypeScript Postgresql related posts
-
Show HN: Text-to-SQL Focus on Semantics and UI/UX
-
WrenAI: Make Your Database RAG-Ready. Text-to-SQL Focus on Semantics and UI/UX
-
Less Code (-75%) & More Power (💪) with Remult
-
Wasp x Supabase: Smokin’ Hot Full-Stack Combo 🌶️ 🔥
-
Make your database RAG-ready
-
A Software Engineer's Tips and Tricks #1: Drizzle
-
WrenAI: Open-Source Natural Language Interface to Your Data
-
A note from our sponsor - InfluxDB
www.influxdata.com | 16 May 2024
Index
What are some of the best open-source Postgresql projects in TypeScript? This list will help you:
Project | Stars | |
---|---|---|
1 | supabase | 66,748 |
2 | nocodb | 42,702 |
3 | Prisma | 37,436 |
4 | TypeORM | 33,450 |
5 | Sequelize | 29,076 |
6 | cal.com | 28,907 |
7 | Directus | 25,581 |
8 | plane | 24,393 |
9 | full-stack-fastapi-template | 23,404 |
10 | drizzle-orm | 20,089 |
11 | beekeeper-studio | 15,388 |
12 | crystal | 12,427 |
13 | kysely | 9,428 |
14 | dogehouse | 9,124 |
15 | openreplay | 8,889 |
16 | azuredatastudio | 7,460 |
17 | logto | 7,308 |
18 | MikroORM | 7,202 |
19 | teable | 7,010 |
20 | documenso | 6,142 |
21 | slonik | 4,398 |
22 | sql-translator | 3,994 |
23 | datastation | 2,854 |
Sponsored