TypeScript Postgresql

Open-source TypeScript projects categorized as Postgresql

Top 23 TypeScript Postgresql Projects

  • supabase

    The open source Firebase alternative.

    Project mention: No more Mr. Open Source Guy | dev.to | 2024-02-21

    There are roughly 10 million downloads of my NuGet packages in total, all of whom are open source. This is 20 times more downloads than for instance SupaBase. SupaBase is evaluated at 1 billion dollars and have been given VC funding of more than 100 million dollars.

  • nocodb

    🔥 🔥 🔥 Open Source Airtable Alternative

    Project mention: NocoDB: The Open Source Airtable Alternative | news.ycombinator.com | 2024-01-27
  • 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.

  • Prisma

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

    Project mention: Taming cross-service database transactions in NestJS with AsyncLocalStorage | dev.to | 2024-02-21

    There have been multiple feature requests to add native support for AsyncLocalStorage to Prisma, but they haven't been met with much enthusiasm from the maintainers. Some people solved it by extending and overriding the client (which is arguably prone to breaking with updates).

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

    Project mention: NodeJS Security Best Practices | dev.to | 2024-02-19

    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

    Scheduling infrastructure for absolutely everyone.

    Project mention: JSONCrack Codebase Analysis — Part 4.2.1.1 — JsonEditor — debouncedUpdateJson | dev.to | 2024-01-07

    The next codebase to analyse is cal.com. This repo is larger than jsoncrack. It is a monorepo with packages and lots of stuff going behind the scenes.

  • 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: Form to DB | news.ycombinator.com | 2024-02-22

    I don't know, it's something I've wanted many times.

    Recently I discovered https://directus.io/ which comes pretty close and it's open source.

  • plane

    🔥 🔥 🔥 Open Source JIRA, Linear and Asana Alternative. Plane helps you track your issues, epics, and product roadmaps in the simplest way possible.

    Project mention: Projectmanagement | /r/selfhosted | 2023-12-08
  • LearnThisRepo.com

    Learn 300+ open source libraries for free using AI. LearnThisRepo lets you learn 300+ open source repos including Postgres, Langchain, VS Code, and more by chatting with them using AI!

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

    Project mention: ORMs are nice but they are the wrong abstraction | news.ycombinator.com | 2024-02-01
  • beekeeper-studio

    Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.

    Project mention: Document your database simply and easily | news.ycombinator.com | 2024-01-27

    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/

  • full-stack-fastapi-postgresql

    Full stack, modern web application generator. Using FastAPI, PostgreSQL as database, Docker, automatic HTTPS and more.

    Project mention: Building a Secure API with FastAPI, PostgreSQL, and Hanko Authentication | dev.to | 2023-10-30

    This project is a modification of the authentication flow of the awesome repository made by tiangolo at full-stack-fastapi-postgresql

  • crystal

    🔮 Graphile's Crystal Monorepo; home to Grafast, PostGraphile, pg-introspection, pg-sql2 and much more! (by graphile)

  • dogehouse

    Taking voice conversations to the moon 🚀

  • kysely

    A type-safe typescript SQL query builder

    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: Capture and replay React Native sessions | news.ycombinator.com | 2024-02-23

    - Optimize user experience: use insights to refine and improve your app’s usability.

    Interested? For more details, you can check out the GitHub repo [0] or documentation [1]:

    [0] https://github.com/openreplay/openreplay or documentation

    [1] https://docs.openreplay.com/en/rn-sdk/

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

    Project mention: azuredatastudio: NEW Data - star count:7321.0 | /r/algoprojects | 2023-12-10
  • 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: Rust GraphQL APIs for NodeJS Developers: Introduction | dev.to | 2024-02-08

    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:

  • logto

    🧑‍🚀 The better identity infrastructure for developers that works universally.

    Project mention: Logto v1.12.0 - Organizations, SSO, and MFA | /r/selfhosted | 2023-12-06
  • documenso

    The Open Source DocuSign Alternative.

    Project mention: Documenso – Open-Source DocuSign Alternative | news.ycombinator.com | 2024-02-05
  • slonik

    A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.

    Project mention: Sneakiest development trap: making easy easier... | dev.to | 2024-01-04

    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.

  • datastation

    App to easily query, script, and visualize data from every database, file, and API.

    Project mention: Code coverage for Go integration tests | news.ycombinator.com | 2023-03-08

    There was a technique that existed already where you could use `go test -cover` and the `-o` flag to produce a binary from `go test` rather than actually running tests. So you could build a binary that had coverage enabled. Then when you ran

    Here's an example: https://github.com/multiprocessio/datastation/blob/main/runn....

    I can't remember where I found this technique but it's been around for a while.

    This new option is the same thing but a way to `go build` with `-cover` instead of `go test -cover -o $out`? Do I have that right?

  • pgtyped

    pgTyped - Typesafe SQL in TypeScript

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

  • supabase-js

    An isomorphic Javascript client for Supabase. Query your Supabase database, subscribe to realtime events, upload and download files, browse typescript examples, invoke postgres functions via rpc, invoke supabase edge functions, query pgvector.

    Project mention: Chrome Extension MV3 Template : Supabase Auth, Plasmo, Tailwinds CSS & Shadcn UI | dev.to | 2023-08-13
  • remult

    Full-stack CRUD, simplified, with SSOT TypeScript entities

    Project mention: Remult.dev OSS backend to frontend framework | /r/opensource | 2023-03-30

    I really enjoyed reading this post from the creator of a new fullstack OSS framework called remult.dev which I think is super useful.

  • WorkOS

    The modern API for authentication & user identity. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

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 2024-02-23.

TypeScript Postgresql related posts

Index

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

Project Stars
1 supabase 63,158
2 nocodb 40,864
3 Prisma 36,254
4 TypeORM 32,952
5 cal.com 27,365
6 Directus 24,728
7 plane 22,703
8 drizzle-orm 17,395
9 beekeeper-studio 14,834
10 full-stack-fastapi-postgresql 14,624
11 crystal 12,322
12 dogehouse 9,129
13 kysely 8,634
14 openreplay 8,478
15 azuredatastudio 7,388
16 MikroORM 6,943
17 logto 6,839
18 documenso 5,407
19 slonik 4,271
20 datastation 2,841
21 pgtyped 2,724
22 supabase-js 2,653
23 remult 2,481
The modern API for authentication & user identity.
The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
workos.com