TypeScript Postgres

Open-source TypeScript projects categorized as Postgres

Top 23 TypeScript Postgre Projects

  • Grafana

    The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.

    Project mention: How to Deploy and Scale Strapi on a Kubernetes Cluster 2/2 | dev.to | 2023-02-03

    We need a way of monitoring our cluster, the most recommended stack (but not the only one) is Prometheus, Alert Manager and Grafana. Prometheus is a monitoring system, and Grafana is a visualization system that can work as the frontend for Prometheus. The Prometheus community provides and easy way to install these tools via the Kube Prometheus Stack. This chart has many parameters you can configure, so we will not get into much detail here. The easiest way to install it is the following:

  • supabase

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

    Project mention: Easiest way to add an image to a row of data | reddit.com/r/Supabase | 2023-02-04
  • 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!

  • Hasura

    Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.

    Project mention: No code with Python | reddit.com/r/nocode | 2023-01-28

    You could use something like PostgresT or Hausra for the database, and they will handle auth. Now you've reduced the problem to generating a crud app from a database, which things like appsmith claim to be able to do. I've never used any of them though, so I can't speak to how well they work.

  • Prisma

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

    Project mention: Startchart: Prisma Schema | dev.to | 2023-02-03

    This week, I focus on creating an initial schema for the project through using Prisma. This is for a MySQL database, and the PR for the initial schema is here.

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

    The Open Source Firebase Alternative with GraphQL.

    Project mention: Is there smth like firebase on-prem? | reddit.com/r/Firebase | 2023-01-25

    You can use Nhost (100% open source): https://github.com/nhost/nhost/tree/main/examples/docker-compose

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

  • slonik

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

    Project mention: Kysely: TypeScript SQL Query Builder | news.ycombinator.com | 2023-01-24

    I think this is a really cool project, but for most use cases (not all, but most) I strongly believe query builders are an anti-pattern. I could go over the reasons, but when I saw this blog post, https://gajus.medium.com/stop-using-knex-js-and-earn-30-bf41..., from the author of slonik years ago I had a eureka moment, and it explains the reasoning better than I could.

    Template strings in TypeScript allow you to safely write SQL directly, still with type checking: https://github.com/gajus/slonik#readme

  • jitsu

    Jitsu is an open-source Segment alternative. Fully-scriptable data ingestion engine for modern data teams. Set-up a real-time data pipeline in minutes, not days

    Project mention: Any examples of working activist, socialist, or community-organizing software? | reddit.com/r/socialistprogrammers | 2022-07-19
  • pgtyped

    pgTyped - Typesafe SQL in TypeScript

    Project mention: Kysely: TypeScript SQL Query Builder | news.ycombinator.com | 2023-01-24

    For Postgres there is https://github.com/adelsz/pgtyped, sounds pretty much like what you describe?

  • kentcdodds.com

    My personal website

    Project mention: Aplicativos da Web totalmente tipados | dev.to | 2023-01-30
  • 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

  • zws

    Shorten URLs using invisible spaces

    Project mention: Shorten URLs using invisible spaces | news.ycombinator.com | 2022-09-22
  • node-pg-migrate

    Node.js database migration management for Postgresql

    Project mention: Fully featured Repository Pattern with Typescript and native PostgreSQL driver | dev.to | 2022-03-20

    Why PG? For the clarity of the article to a large circle of developers, the entire explanation will be built by PostgreSQL and PG package. And in a real project, the database schema will change over time, and in order to be able to perform migrations, we will use Node PG migrate.

  • schemats

    Generate typescript interface definitions from SQL database schema

    Project mention: GraphQL error handling to the max with Typescript, codegen and fp-ts | dev.to | 2022-03-07

    :::note When using remote APIs, we often have the possibility to generate the types automatically from a JSON schema for REST APIs, from protobuf files for gRPC-based APIs, from a database schema, etc. You might even be using an external API through an SDK that already provides you with all types. In such cases, the creation of specialized Error classes is not mandatory. However, it might still be a good idea to do so to provide application-specific errors rather than bubbling up 3rd-party low-level errors. For such cases, the upcoming Ecma TC39 proposal for Error Cause is useful as it allows to chain errors. Polyfills exist: Pony Cause or error-cause. :::

  • zapatos

    Zero-abstraction Postgres for TypeScript: a non-ORM database library

  • boilerplate

    ⚡️Fullstack boilerplate using Typescript, React, Node & GraphQL

  • safeql

    Validate and auto-generate TypeScript types from raw SQL queries in PostgreSQL.

    Project mention: You may not need an SQL query builder or ORM | dev.to | 2022-10-06

    If there was a tool that plugs into your linter (ESLint) and helps you find and fix these issues, would you use it? Luckily, I just wrote one - SafeQL.

  • postgres-meta

    A RESTful API for managing your Postgres. Fetch tables, add roles, and run queries

    Project mention: Week 4 notes | dev.to | 2022-02-08

    I picked the first issue, which was a bug in the Supabase dashboard, where users could not edit a database column from a primary type to its array type. The dashboard was built with Nextjs and TailwindCSS, using the Supabase-UI components libraries. It looked like was a quick fix to me. After investigation, the error was not with the dashboard but it was an error of insufficient type handling of column type identifiers within the Posgres-Meta package, which was also written by Supabase Team. Then, I headed to the package upstream and fixed it. The PR got merged and released soon after.

  • postgres

    PostgreSQL driver for Deno (by denodrivers)

    Project mention: Which Postgres connector would you use; `denodrivers/postgres` or `porsager/postgres`? | reddit.com/r/Deno | 2022-05-08

    https://github.com/denodrivers/postgres The official driver (AFAIK) Fewer features, but perhaps more longevity and stability

  • deno-nessie

    A modular Deno library for PostgreSQL, MySQL, MariaDB and SQLite migrations

  • @databases

    TypeScript clients for databases that prevent SQL Injection

    Project mention: Node Core Dev Starter Kit | dev.to | 2022-10-21

    At Databases because you don't need ORM.

  • sql-lint

    An SQL linter

    Project mention: sql-lint - A linter for SQL (finally hits version 1.0.0) | reddit.com/r/coolgithubprojects | 2022-06-24
  • InfluxDB

    Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.

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-02-04.

TypeScript Postgres related posts


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

Project Stars
1 Grafana 53,769
2 supabase 44,841
3 Hasura 29,150
4 Prisma 28,710
5 postgraphile 11,782
6 nhost 5,958
7 relay-starter-kit 3,691
8 slonik 3,627
9 jitsu 3,078
10 pgtyped 2,210
11 kentcdodds.com 1,810
12 ElectroCRUD 1,442
13 zws 1,345
14 node-pg-migrate 1,117
15 schemats 990
16 zapatos 921
17 boilerplate 839
18 safeql 784
19 postgres-meta 579
20 postgres 551
21 deno-nessie 514
22 @databases 492
23 sql-lint 389
Build time-series-based applications quickly and at scale.
InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.