TypeScript Postgres

Open-source TypeScript projects categorized as Postgres
Edit details
Topics: TypeScript Postgresql NodeJS SQL Database
Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App
With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.
surveyjs.io
Sponsored

Top 23 TypeScript Postgre Projects

  • supabase

    The open source Firebase alternative.

    • Project mention: AI Inference now available in Supabase Edge Functions | dev.to | 2024-04-16

    Semantic search demo

  • 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: Golang: out-of-box backpressure handling with gRPC, proven by a Grafana dashboard | dev.to | 2024-04-03

    To help us visualize these scenarios, we'll build a Grafana Dashboard so we can follow along.

  • SurveyJS

    Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

    SurveyJS logo

  • Prisma

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

    • Project mention: Deploy Full-Stack Next.js T3App with Cognito and Prisma using AWS Lambda | dev.to | 2024-04-15

    generator client { provider = "prisma-client-js" binaryTargets = ["native", "rhel-openssl-1.0.x"] } datasource db { provider = "postgresql" // NOTE: When using mysql or sqlserver, uncomment the @db.Text annotations in model Account below // Further reading: // https://next-auth.js.org/adapters/prisma#create-the-prisma-schema // https://www.prisma.io/docs/reference/api-reference/prisma-schema-reference#string url = env("DATABASE_URL") } model Post { id Int @id @default(autoincrement()) name String createdAt DateTime @default(now()) updatedAt DateTime @updatedAt createdBy User @relation(fields: [createdById], references: [id]) createdById String @@index([name]) } // ... rest of the schema

  • Hasura

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

    • Project mention: Ask HN: How Can I Make My Front End React to Database Changes in Real-Time? | news.ycombinator.com | 2024-04-17

    [4] https://github.com/hasura/graphql-engine/blob/master/architecture/live-queries.md

  • 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: Get started with Drizzle ORM and Xata's Postgres service | dev.to | 2024-04-16

    Drizzle ORM is a very popular TypeScript ORM that provides type safe access to your database, automated migrations, and a custom data model definition.

  • payload

    The best way to build a modern backend + admin UI. No black magic, all TypeScript, and fully open-source, Payload is both an app framework and a headless CMS.

    • Project mention: Headless CMS: Directus vs Payload vs Strapi in 2024 | dev.to | 2024-04-05

    Despite being a relatively newer player, Payload's GitHub repository has accumulated 18.8k stars and 1.1K forks as of April 2024, reflecting its growing community. The project has also secured $5.6 million in funding, positioning it for continued growth and innovation.

  • crystal

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

    • Project mention: Ask HN: What Underrated Open Source Project Deserves More Recognition? | news.ycombinator.com | 2024-03-07

    I didn't see a v5 tag in order to know, and I have no idea what "utils/graphile" does for the project, but one will want to ensure they are aware of its licensing scheme https://github.com/graphile/crystal/blob/db8894c74eb0ec3fe96...

  • WorkOS

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

    WorkOS logo

  • nhost

    The Open Source Firebase Alternative with GraphQL.

    • Project mention: Database Review: Top Five Missing Features from Database APIs | dev.to | 2023-09-14

    Hasura ❌ (technically yes with Nhost)

  • openblocks

    🔥 🔥 🔥 The Open Source Retool Alternative

    • Project mention: Why I'm skeptical of low-code | news.ycombinator.com | 2023-12-30

  • teable

    ✨ A Super fast, Real-time, Professional, Developer friendly, No code database

    • Project mention: Show HN: I just made my profitable online form builder open-sourced | news.ycombinator.com | 2024-04-01

    I use nestjs in my open source no-code database https://github.com/teableio/teable, and I really like it, especially the dependency injection capability.

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

  • 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

  • sqlchat

    Chat-based SQL Client and Editor for the next decade

    • Project mention: FLaNK Stack Weekly 12 February 2024 | dev.to | 2024-02-12

  • pgtyped

    pgTyped - Typesafe SQL in TypeScript

    • Project mention: Type-Safe Printf() in TypeScript | news.ycombinator.com | 2024-03-24

    There is an implementation of SQL that operates on a table shaped type, entirely at type level. For your amusement: https://github.com/codemix/ts-sql

    There are a bunch of more practical takes that codegen types from your database and generate types for your queries, eg: https://github.com/adelsz/pgtyped

    To me the second approach seems much more pragmatic because you don’t need to run a SQL parser in a fairly potato interpreter on every build

  • 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

  • Keyv

    Simple key-value storage with support for multiple backends

  • database-lab-engine

    DBLab enables 🖖 database branching and ⚡️ thin cloning for any Postgres database and empowers DB testing in CI/CD. This optimizes database-related costs while improving time-to-market and software quality. Follow to stay updated.

    • Project mention: Pg_branch: Pre-alpha Postgres extension brings Neon-like branching | news.ycombinator.com | 2023-10-01

    Underlying DBLab Engine is FOSS (Apache 2.0), with API, CLI and UI https://github.com/postgres-ai/database-lab-engine

  • 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 as Queue | news.ycombinator.com | 2024-02-09

    Big fan of Graphile Worker to handle this job. https://github.com/graphile/worker

  • zws

    Shorten URLs using invisible spaces

    • Project mention: Creating an advanced search engine with PostgreSQL | news.ycombinator.com | 2023-07-12

    https://supabase.com/blog/openai-embeddings-postgres-vector

    https://supabase.com/blog/chatgpt-supabase-docs

  • slashbase

    In-browser database IDE for dev/data workflows. Supports PostgreSQL & MongoDB.

    • Project mention: Generate and run SQL with GPT in Database Client (built with go - wails) | /r/golang | 2023-07-02

  • safeql

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

    • Project mention: compile-time SQL validations and type generation in TypeScript & Node | /r/typescript | 2023-08-27

    Cool. How does this compare to SafeQL, PgTyped, and Postgres language server ?

  • zapatos

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

    • Project mention: Zapatos: Zero-Abstraction Postgres for TypeScript | news.ycombinator.com | 2023-10-14

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

    InfluxDB logo
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-04-17.

TypeScript Postgres related posts

Index

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

Project Stars
1 supabase 65,456
2 Grafana 60,196
3 Prisma 37,076
4 Hasura 30,799
5 drizzle-orm 19,510
6 payload 19,199
7 crystal 12,399
8 nhost 7,499
9 openblocks 5,541
10 teable 5,035
11 slonik 4,367
12 jitsu 3,831
13 sqlchat 3,698
14 pgtyped 2,797
15 supabase-js 2,782
16 Keyv 2,475
17 database-lab-engine 1,893
18 worker 1,633
19 zws 1,602
20 nextjs-openai-doc-search 1,486
21 slashbase 1,291
22 safeql 1,220
23 zapatos 1,217

Sponsored
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.
www.influxdata.com