TypeScript Postgresql

Open-source TypeScript projects categorized as Postgresql

Top 23 TypeScript Postgresql Projects

  • supabase

    The open source Firebase alternative.

    Project mention: Building a Fast, Efficient Web App: The Technology Stack of PromptSmithy Explained | dev.to | 2024-03-26

    Here the thing that accelerated my development the most: Supabase. Thanks to its Database, Authentication, and Edge Functions, we were able to rapidly develop the app. Their JS library made development super seamless, and their local development stack made testing a breeze.

  • nocodb

    🔥 🔥 🔥 Open Source Airtable Alternative

    Project mention: Show HN: Teable – Open-Source No-Code Database Fusion of Postgres and Airtable | news.ycombinator.com | 2024-03-11
  • 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.

  • Prisma

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

    Project mention: End-To-End Polymorphism: From Database to UI, Achieving SOLID Design | dev.to | 2024-03-28

    Unfortunately Prisma hasn’t supported polymorphism yet. As such, you can't use inheritance to model the entity in the same way as in your programming language, as depicted in the above class diagram. The good news is that we could intimate it using table inheritance to imitate it.

  • 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: NodeJS Security Best Practices | dev.to | 2024-02-19

    If you use Sequalize, TypeORM or for MongoDB, we have Mongoose these types of ORM tools, then you are safe by default because these help us against the SQL query injection attacks by default.

  • cal.com

    Scheduling infrastructure for absolutely everyone.

    Project mention: Start your own (side) business with open-source in mind | dev.to | 2024-02-29

    Cal.com is an open-source event-juggling scheduler for everyone, and is free for individuals.

  • 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: Our repo hit a milestone today with 25k GH stars | news.ycombinator.com | 2024-03-12
  • plane

    🔥 🔥 🔥 Open Source JIRA, Linear and Asana Alternative. Plane helps you track your issues, epics, and product roadmaps in the simplest way possible.

    Project mention: Projectmanagement | /r/selfhosted | 2023-12-08
  • 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.

  • full-stack-fastapi-template

    Full stack, modern web application template. Using FastAPI, React, SQLModel, PostgreSQL, Docker, GitHub Actions, automatic HTTPS and more.

    Project mention: Building a Secure API with FastAPI, PostgreSQL, and Hanko Authentication | dev.to | 2023-10-30

    This project is a modification of the authentication flow of the awesome repository made by tiangolo at full-stack-fastapi-postgresql

  • 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: I Deployed My Own Cute Lil’ Private Internet (a.k.a. VPC) | dev.to | 2024-03-18

    Each app’s front end is built with Qwik and uses Tailwind for styling. The server-side is powered by Qwik City (Qwik’s official meta-framework) and runs on Node.js hosted on a shared Linode VPS. The apps also use PM2 for process management and Caddy as a reverse proxy and SSL provisioner. The data is stored in a PostgreSQL database that also runs on a shared Linode VPS. The apps interact with the database using Drizzle, an Object-Relational Mapper (ORM) for JavaScript. The entire infrastructure for both apps is managed with Terraform using the Terraform Linode provider, which was new to me, but made provisioning and destroying infrastructure really fast and easy (once I learned how it all worked).

  • beekeeper-studio

    Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.

    Project mention: Document your database simply and easily | news.ycombinator.com | 2024-01-27

    This tool doesn't let you run SQL queries or create tables. SchemaSpy describes and visualizes an already-created database.

    To work directly with SQL, I recommend https://www.beekeeperstudio.io/ or https://dbgate.org/

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

  • dogehouse

    Taking voice conversations to the moon 🚀

  • kysely

    A type-safe typescript SQL query builder

    Project mention: ORMs are nice but they are the wrong abstraction | news.ycombinator.com | 2024-02-01

    ORMs suck, but raw SQL embedded in your code sucks too.

    This might be good time to plug my TypeScript non-ORM: https://jawj.github.io/zapatos/.

    I should say I also like what I've seen of https://kysely.dev/ and https://pgtyped.dev/.

  • openreplay

    Session replay and analytics tool you can self-host. Ideal for reproducing issues, co-browsing with users and optimizing your product.

    Project mention: Show HN: How Cobrowsing Works in Session Replay | news.ycombinator.com | 2024-03-14
  • azuredatastudio

    Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.

    Project mention: azuredatastudio: NEW Data - star count:7321.0 | /r/algoprojects | 2023-12-10
  • logto

    🧑‍🚀 The better identity infrastructure for developers and the open-source alternative to Auth0.

    Project mention: Logto v1.12.0 - Organizations, SSO, and MFA | /r/selfhosted | 2023-12-06
  • 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: Rust GraphQL APIs for NodeJS Developers: Introduction | dev.to | 2024-02-08

    In my usual NodeJS tech stack, which includes GraphQL, NestJS, SQL (predominantly PostgreSQL with MikroORM), I encountered these limitations. To overcome them, I've developed a new stack utilizing Rust, which still offers some ease of development:

  • documenso

    The Open Source DocuSign Alternative.

    Project mention: Docusign updates terms of service, training proprietary AI using user data | news.ycombinator.com | 2024-02-29

    Unknown if it's better or worse but https://support.google.com/docs/answer/12315692?hl=en ("Send signature requests & sign documents with eSignature")

    and there have also been a bunch of alleged competitors submitted:

    https://github.com/docusealco/docuseal#readme https://news.ycombinator.com/item?id=36798593

    https://github.com/OpenSignLabs/OpenSign#readme https://news.ycombinator.com/item?id=38052344

    https://github.com/documenso/documenso#readme https://news.ycombinator.com/item?id=38404129

    but they're all AGPLv3 and the network effect is very real

  • teable

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

    Project mention: FLaNK AI Weekly 18 March 2024 | dev.to | 2024-03-18
  • 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.

  • sql-translator

    SQL Translator is a tool for converting natural language queries into SQL code using artificial intelligence. This project is 100% free and open source.

    Project mention: Storybook GPT | dev.to | 2023-05-08

    I started to see more and more applications that use the OpenAI API and I wanted to try it out. One of these apps is this one made by Kate.

  • datastation

    App to easily query, script, and visualize data from every database, file, and API.

  • 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

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

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-03-28.

TypeScript Postgresql related posts

Index

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

Project Stars
1 supabase 64,560
2 nocodb 41,502
3 Prisma 36,783
4 TypeORM 33,123
5 cal.com 28,031
6 Directus 25,113
7 plane 23,496
8 full-stack-fastapi-template 21,592
9 drizzle-orm 18,678
10 beekeeper-studio 15,085
11 crystal 12,381
12 dogehouse 9,128
13 kysely 9,022
14 openreplay 8,713
15 azuredatastudio 7,420
16 logto 7,058
17 MikroORM 7,055
18 documenso 5,725
19 teable 4,530
20 slonik 4,328
21 sql-translator 3,923
22 datastation 2,850
23 pgtyped 2,762
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