TypeScript Postgresql

Open-source TypeScript projects categorized as Postgresql

Top 23 TypeScript Postgresql Projects

  • supabase

    The open source Firebase alternative. Follow to stay updated about our public Beta.

    Project mention: How to Deactivate (not delete) user from login? | reddit.com/r/Supabase | 2023-03-20

    Here is a GitHub discussion where it was talked about a little

  • nocodb

    🔥 🔥 🔥 Open Source Airtable Alternative

    Project mention: [Darksouls] Remaster pour PC Controller ne fonctionne pas ? | reddit.com/r/enfrancais | 2023-03-14
  • Appwrite

    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!

  • 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: [TypeORM] suggested TMP features for type safety and defeat Prisma | reddit.com/r/typescript | 2023-03-18
  • Prisma

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

    Project mention: [TypeORM] suggested TMP features for type safety and defeat Prisma | reddit.com/r/javascript | 2023-03-18
  • 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: Correct way to use pinia stores | reddit.com/r/Nuxt | 2023-03-19

    BUT, if you organize it correctly, you can create a single purpose store and have it handle everything for you. Here is a great example. This is the Auth store of Bryant Gillispie, for the Directus CMS.

  • postgraphile

    Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database!

    Project mention: v4.13.0 | reddit.com/r/PostGraphile | 2023-01-12
  • dogehouse

    Taking voice conversations to the moon 🚀

    Project mention: Test | reddit.com/r/u_bestonecrazy | 2022-09-22
  • Sonar

    Write Clean JavaScript Code. Always.. Sonar helps you commit clean code every time. With over 300 unique rules to find JavaScript bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.

  • azuredatastudio

    Azure Data Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.

    Project mention: SQL Database Project - Intellisense error issue? | reddit.com/r/MSSQL | 2023-01-28

    One thing to mention is I'm using Azure Data Studio with the (preview) extension SQL Database Projects. I already created a Bug on their Github, but was hoping to get some more feedback here. If I'm wrong, are there any good resources on how to work with Database Projects?

  • 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: MikroORM v6 gets a strict partial loading support | reddit.com/r/node | 2023-03-04

    More about v6 development can be found here.

  • kysely

    A type-safe typescript SQL query builder

    Project mention: Full-Stack TypeScript with tRPC and React | news.ycombinator.com | 2023-03-14
  • slonik

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

    Project mention: TIL that you don’t shouldn’t be generating TypeScript declarations for a distributable library | reddit.com/r/typescript | 2023-03-16
  • relay-starter-kit

    💥 Monorepo template (seed project) pre-configured with GraphQL API, PostgreSQL, React, Relay, Material UI.

    Project mention: Ask HN: Who wants to be hired? (June 2022) | news.ycombinator.com | 2022-06-01
  • 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?

  • drizzle-orm

    TypeScript ORM for SQL

    Project mention: Drizzle-team/drizzle-ORM: TypeScript ORM for SQL | news.ycombinator.com | 2023-03-06
  • remult

    Build Full-stack, End-to-end Type-safe CRUD Apps without the Boilerplate

    Project mention: Introducing Remult: The Open Source Backend to Frontend Framework You Always Wanted | dev.to | 2023-03-14

    Check out Remult, and if you like it, give it a star. Let us know what you’d like to see next, and also feel free to contribute to the project.

  • denodb

    MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno

    Project mention: MariaDB API Recomendations | reddit.com/r/Deno | 2022-09-29

    denoDB? https://github.com/eveningkid/denodb

  • pev2

    Postgres Explain Visualizer 2

    Project mention: super-slow query | reddit.com/r/PostgreSQL | 2023-02-13

    Yes, copy-pasting the EXPLAIN output and the query into a visualizer such as pev2 might help understanding bottlenecks the plan, and confirms the above 👍

  • starter

    Opinionated SaaS quick-start with pre-built user account and organization system for full-stack application development in React, Node.js, GraphQL and PostgreSQL. Powered by PostGraphile, TypeScript, Apollo Client, Graphile Worker, Graphile Migrate, GraphQL Code Generator, Ant Design and Next.js

    Project mention: Ask HN: Solo Dev Stack of 2022? | news.ycombinator.com | 2022-10-01

    I've been enjoying developing on top of PostGraphile. https://www.graphile.org/

    Good starter: https://github.com/graphile/starter

    I can add a column the the db, and my frontend gets that autimagically (in dev mode, it generates a graphql schema out of the db, and from that it creates composables for my frontend wiht graphql-codegen). On the frontend I use Vue 3, the starter is build with nextjs/react.

  • ElectroCRUD

    Database CRUD Application Built on Electron | MySQL, Postgres, SQLite

    Project mention: After few years, ElectroCRUD is coming back | reddit.com/r/opensource | 2023-01-19

    development branch: https://github.com/garrylachman/ElectroCRUD/tree/develop

  • pg-mem

    An in memory postgres DB instance for your unit tests

    Project mention: Ask HN: How do you test SQL? | news.ycombinator.com | 2023-01-31

    I was wondering the other day how to classify tests that use a test double like pg-mem, which isn't a mock but isn't the Dockerized test DB either :


  • worker

    High performance Node.js/PostgreSQL job queue (also suitable for getting jobs generated by PostgreSQL triggers/functions out into a different work queue)

    Project mention: How to schedule tasks in a Node.js app 🕙 | reddit.com/r/node | 2023-01-25

    See also graphile-worker: https://github.com/graphile/worker (lower latency than pg-boss because it uses LISTEN/NOTIFY)

  • node-pg-migrate

    Node.js database migration management for Postgresql

  • cocalc

    CoCalc: Collaborative Calculation in the Cloud

    Project mention: Math on GitHub: Following Up | news.ycombinator.com | 2022-06-28

    Github's implementation is really lazy. There are many much better approaches to precisely this problem. E.g., Jupyter notebooks implement one that has matured in the wild over a decade. There's this very flexible markdown-it plugin that implements anther https://github.com/goessner/markdown-it-texmath, and my version of it here https://github.com/sagemathinc/cocalc/blob/master/src/packag... which I rewrote in typescript with a focus on the same semantics as Jupyter has, but for CoCalc, and I've been working on using unifiedjs to provide more general latex for Markdown (not just formulas) here https://github.com/sagemathinc/cocalc/pull/5982 Parsing math is much easier if you use a plugin to an existing markdown parser, rather than trying to do some hack outside of that (which is what Github probably does, and also what Jupyter does).

  • InfluxDB

    Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.

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 2023-03-20.

TypeScript Postgresql related posts


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

Project Stars
1 supabase 46,827
2 nocodb 34,920
3 TypeORM 30,758
4 Prisma 29,877
5 Directus 20,667
6 postgraphile 11,848
7 dogehouse 9,162
8 azuredatastudio 7,084
9 MikroORM 5,693
10 kysely 4,041
11 slonik 3,730
12 relay-starter-kit 3,725
13 datastation 2,686
14 drizzle-orm 1,976
15 remult 1,938
16 denodb 1,876
17 pev2 1,832
18 starter 1,521
19 ElectroCRUD 1,458
20 pg-mem 1,307
21 worker 1,218
22 node-pg-migrate 1,126
23 cocalc 1,039
Access the most powerful time series database as a service
Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.