TypeScript Postgres

Open-source TypeScript projects categorized as Postgres | Edit details

Top 23 TypeScript Postgre Projects

  • GitHub repo 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: Do i really want to mess with OpenTelemetry, or just hook straight into Datadog | reddit.com/r/devops | 2022-01-18

    Thanos or Cortex are basically required to run an HA, resilient storage/query/cache layer for Prometheus. Grafana isn't a huge pain to run in HA, you can connect to the same database (Grafana doesn't support multi-master DB yet unfortunately https://github.com/grafana/grafana/issues/13497) , but in theory you should strive to have dashboards/alerts configured through the Grafana provisioning subsystem or through some other means of configuration management - such that the DB isn't the _only_ source of truth.

  • GitHub repo supabase

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

    Project mention: Creating JWT token auth yourself - is it secure? | reddit.com/r/csharp | 2022-01-18

    Thought I would just mention https://supabase.com, the project is heavily inspired by firebase but allow for self hosting etc.

  • SonarQube

    Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.

  • GitHub repo postgraphile

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

    Project mention: Are there actually better alternatives than Apollo server? | reddit.com/r/graphql | 2022-01-16

    If you’re open to learning Postgres, I’d recommend postgraphile (https://github.com/graphile/postgraphile). Been using it for the past 2.5 years and only have good things to say.

  • GitHub repo PostHog

    🦔 PostHog provides open-source product analytics that you can self-host.

    Project mention: PostHog VS fugu - a user suggested alternative | libhunt.com/r/posthog | 2022-01-13
  • GitHub repo relay-starter-kit

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

    Project mention: What is the consensus about using ORM in node js applications? | reddit.com/r/node | 2021-11-28

    It also helps to have a REPL shell for Knex.js — https://i.imgur.com/P5bVdoC.gif

  • GitHub repo slonik

    A PostgreSQL client with strict types, detailed logging and assertions.

    Project mention: Recovering XAMPP developer looking to make a Node CRUD app. What Node database tools are easy to learn? | reddit.com/r/node | 2021-12-30

    When I need CRUD-like interaction with application clients I use Graphile, which serves a GraphQL server based on your Postgres schema. My service layers more often use Slonik for highly customized queries and the elusive SQL syntax highlighting in Node/TypeScript.

  • GitHub repo 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: Ask HN: Good open source alternatives to Google Analytics? | news.ycombinator.com | 2022-01-11
  • OPS

    OPS - Build and Run Open Source Unikernels. Quickly and easily build and deploy open source unikernels in tens of seconds. Deploy in any language to any cloud.

  • GitHub repo pgtyped

    pgTyped - Typesafe SQL in TypeScript

    Project mention: Recommended type-safe npm package? | reddit.com/r/node | 2021-11-30

    Hey there, I'm Nikolas from the Prisma team. We have a section about this in our docs: Should you use Prisma? where we explain when Prisma is a good use case for you and when other alternatives might be better. It sounds like you could look into tools like Slonik, pgtyped, Zapatos, postgres-schema-builder which are all great type-safe SQL libraries.

  • GitHub repo nhost

    Serverless backend for web and mobile apps.

    Project mention: Alternative to Firebase? | reddit.com/r/Firebase | 2021-11-02

    site: https://nhost.io

  • GitHub repo ElectroCRUD

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

    Project mention: How to go from spreadsheet to “app”? | reddit.com/r/QuantifiedSelf | 2021-04-21

    Another great option (and potentially better than the first) is ElectroCRUD: https://github.com/garrylachman/ElectroCRUD. Unfortunately I don't have first-hand experience with this either, so it's still hearsay but worth a look.

  • GitHub repo zws

    Shorten URLs using invisible spaces

    Project mention: URL shortener using invisible spaces | reddit.com/r/golang | 2021-09-27

    I am basically looking for a URL shortener. Is there a go equivalent of what this does? GitHub - zws-im/zws: Shorten URLs using invisible spaces

  • GitHub repo node-pg-migrate

    Node.js database migration management for Postgresql

    Project mention: Postgres: What is the development process? | reddit.com/r/PostgreSQL | 2021-10-17

    You’ll probably want something like this too: https://github.com/salsita/node-pg-migrate

  • GitHub repo schemats

    Generate typescript interface definitions from SQL database schema (by SweetIQ)

    Project mention: Preferred SQL ORM | reddit.com/r/node | 2021-10-16

    Using a library such as that one https://github.com/SweetIQ/schemats

  • GitHub repo boilerplate

    Fullstack boilerplate using Typescript, React, Node & GraphQL

    Project mention: What UI Framework/Library do you use for your React projects? | reddit.com/r/reactjs | 2021-07-16

    We built our own, we have our own boilerplate which uses it for example, it’s in the admin package.

  • GitHub repo zapatos

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

    Project mention: Prisma ORM: how to use the great database mapping package | reddit.com/r/programming | 2021-05-14

    Take a look at https://github.com/gajus/slonik and https://github.com/jawj/zapatos

  • GitHub repo deno-nessie

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

    Project mention: anyone know how to use nessie with sqlite? | reddit.com/r/Deno | 2021-09-06
  • GitHub repo sql-lint

    An SQL linter

    Project mention: How to validate if a SQL query is valid or not in ansible? | reddit.com/r/ansible | 2021-07-02
  • GitHub repo @databases

    TypeScript clients for databases that prevent SQL Injection

    Project mention: Can you use Joi with SQL database? | reddit.com/r/node | 2021-12-29

    If you’re using TypeScript and don’t have untrusted user data, @databases can generate static types, which can be a good alternative to runtime validation.

  • GitHub repo stator

    Stator, your go-to template for the perfect stack. 😍🙏

    Project mention: Ask HN: Which tech stack is the most pleasurable? | news.ycombinator.com | 2021-12-20

    Working on new projects has been fun for me ever since I started using https://github.com/chocolat-chaud-io/stator

    This allows me to quickly start coding while not focusing on the tedious configuration tasks that usually accompany a new project. I've been using it for over a year for personal and professional projects. It's not perfect, but it helps. I wrote this open-source template, so I am, of course biased :)

  • GitHub repo flan

    A tasty tool that lets you save, load and share postgres snapshots with ease (by sdelements)

    Project mention: Flan – A tasty tool that lets you save, load and share Postgres dumps with ease | news.ycombinator.com | 2021-10-29
  • GitHub repo stripe-sync-engine

    Sync your Stripe account to you Postgres database.

    Project mention: Need help with my flutter apps database. | reddit.com/r/flutterhelp | 2021-12-03

    I've heard good things about Supabase, but I haven't used it myself. If you're in a position to deploy the DBMS and backend software yourself, you could consider setting up PostgreSQL and a gRPC server service yourself. You can even write the server service in Dart.

  • GitHub repo vscode-postgres

    PostgreSQL extension for vscode providing explorer, highlighting, diagnostics, and intellisense

    Project mention: What is bad about pgAdmin4? | reddit.com/r/PostgreSQL | 2021-03-04

    this is the github project, note the gifs:https://github.com/Borvik/vscode-postgres

  • GitHub repo node-starter-kit

    Node.js / GraphQL project template pre-configured with TypeScript, PostgreSQL, login flow, transactional emails, unit tests, CI/CD workflow.

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

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 46,479
2 supabase 26,619
3 postgraphile 11,014
4 PostHog 5,772
5 relay-starter-kit 3,399
6 slonik 2,926
7 jitsu 1,992
8 pgtyped 1,752
9 nhost 1,405
10 ElectroCRUD 1,349
11 zws 1,080
12 node-pg-migrate 995
13 schemats 894
14 boilerplate 720
15 zapatos 645
16 deno-nessie 471
17 sql-lint 330
18 @databases 287
19 stator 248
20 flan 172
21 stripe-sync-engine 146
22 vscode-postgres 145
23 node-starter-kit 73
Find remote jobs at our new job board 99remotejobs.com. There are 28 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
Less time debugging, more time building
Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.