TypeScript Postgresql

Open-source TypeScript projects categorized as Postgresql | Edit details

Top 23 TypeScript Postgresql Projects

  • GitHub repo TypeORM

    ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.

    Project mention: Setting up a basic TypeORM starter | dev.to | 2022-01-16

    TypeORM is a super popular system with a massive user base.

  • GitHub repo supabase

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

    Project mention: Supabase | reddit.com/r/devopspro | 2022-01-17
  • 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 Prisma

    Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite & MongoDB (Preview)

    Project mention: Debutur | dev.to | 2022-01-13


  • GitHub repo Directus

    Open-Source Data Platform 🐰 — Directus wraps any SQL database with a real-time GraphQL+REST API and an intuitive app for non-technical users.

    Project mention: VueJS Projects Examples For Inspiration | reddit.com/r/Frontend | 2022-01-06


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

    Taking voice conversations to the moon 🚀

    Project mention: What are some fullstack projects that are well-structured and can be studied to learn best practices? | reddit.com/r/reactjs | 2021-07-08

    Dogehouse by Ben Awad: https://github.com/benawad/dogehouse

  • GitHub repo 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: Tell HN: Microsoft forks MIT licensed repo, and changes the copyright to them | news.ycombinator.com | 2021-12-25

    Please consider https://github.com/microsoft/azuredatastudio/issues/102#issu...

    >SQL Operations Studio was built on the back of many open source projects that all use the MIT License for a reason: it's the right way to keep moving the community forward, empowering your users to do cool stuff and build useful things for the community.

    >We're just asking SQL Operations Studio to use the same license that Visual Studio Code does.

  • SonarLint

    Deliver Cleaner and Safer Code - Right in Your IDE of Choice!. SonarLint is a free and open source IDE extension that identifies and catches bugs and vulnerabilities as you code, directly in the IDE. Install from your favorite IDE marketplace today.

  • GitHub repo 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: What are your best Node tips/tricks/discoveries from 2021? | reddit.com/r/node | 2021-12-28

    Here is the issue I raised: https://github.com/mikro-orm/mikro-orm/issues/602

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

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

    Project mention: DenoDB | reddit.com/r/hackernews | 2021-06-17
  • GitHub repo pev2

    Postgres Explain Visualizer 2

    Project mention: Visualizing and understanding PostgreSQL EXPLAIN plans made easy | reddit.com/r/devel | 2022-01-15
  • 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 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: PostgREST v9.0.0 | news.ycombinator.com | 2021-11-29

    Someone called it: "hasura for adults”

    It's highly customisable, works directly with postgresql row levels security and the performance is quite good. It has a custom GraphiQL gui to work on queries/mutations.

    To really see how it all works together checkout the starter project: https://github.com/graphile/starter it has migrations, job queue, graphql-codegen etc.

    Benjie (https://github.com/benjie) is one of the greatest maintainers I've ever seen!

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

    The simplest, fastest way to integrate your app with an OAuth API 😋

    Project mention: Validate JWT token | reddit.com/r/reactjs | 2021-05-21
  • GitHub repo 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: Postgres is a great pub/sub and job server | news.ycombinator.com | 2021-12-17

    Anybody using graphile-worker[1] in production/heavy load? It looks awesome, and I coded up some simple prototype tasks (email, sms, etc), but question how it truly scales. They claim horizontal scaling is trivial.

    > it achieves an average latency from triggering a job in one process to executing it in another of under 3ms, and a 12-core database server can process around 10,000 jobs per second.

    [1] https://github.com/graphile/worker

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

    AdonisJS SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more (by adonisjs)

    Project mention: Création d'un utilisateur - Créer un blog avec Adonis | dev.to | 2021-08-21

    Pour en savoir plus : Lucid, Env

  • GitHub repo pg-mem

    An in memory postgres DB instance for your unit tests

    Project mention: Working with offline data | reddit.com/r/Supabase | 2021-10-24

    Postgres in the browser is possible through pg-mem: "pg-mem is an experimental in-memory emulation of a postgres database" but it also suffers from no persistence. If you can persist to a file somewhere then read it in on startup (and if your local data isn't huge) this might work.

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

    A type-safe Postgres query builder for TypeScript. (by Ff00ff)

    Project mention: Mammoth: A type-safe Postgres query builder pur sang for TypeScript | news.ycombinator.com | 2021-12-23
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-17.

TypeScript Postgresql related posts


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

Project Stars
1 TypeORM 26,782
2 supabase 26,318
3 Prisma 19,685
4 Directus 13,455
5 postgraphile 11,014
6 dogehouse 9,199
7 azuredatastudio 6,623
8 MikroORM 3,956
9 relay-starter-kit 3,399
10 slonik 2,909
11 denodb 1,579
12 pev2 1,352
13 ElectroCRUD 1,349
14 starter 1,345
15 node-pg-migrate 995
16 Pizzly 941
17 worker 903
18 schemats 894
19 lucid 752
20 pg-mem 683
21 zapatos 645
22 deno-nessie 471
23 mammoth 424
Find remote Postgresql jobs at our new job board 99remotejobs.com. There are 3 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.