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. Learn more →
Top 23 TypeScript Postgresql Projects
-
Project mention: How to Deactivate (not delete) user from login? | reddit.com/r/Supabase | 2023-03-20
Here is a GitHub discussion where it was talked about a little
-
Project mention: [Darksouls] Remaster pour PC Controller ne fonctionne pas ? | reddit.com/r/enfrancais | 2023-03-14
-
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!
-
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: [TypeORM] suggested TMP features for type safety and defeat Prisma | reddit.com/r/typescript | 2023-03-18 -
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
Project mention: [TypeORM] suggested TMP features for type safety and defeat Prisma | reddit.com/r/javascript | 2023-03-18 -
Directus
The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.
BUT, if you organize it correctly, you can create a single purpose store and have it handle everything for you. Here is a great example. This is the Auth store of Bryant Gillispie, for the Directus CMS.
-
postgraphile
Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database!
-
-
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.
-
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.
One thing to mention is I'm using Azure Data Studio with the (preview) extension SQL Database Projects. I already created a Bug on their Github, but was hoping to get some more feedback here. If I'm wrong, are there any good resources on how to work with Database Projects?
-
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.
More about v6 development can be found here.
-
-
Project mention: TIL that you don’t shouldn’t be generating TypeScript declarations for a distributable library | reddit.com/r/typescript | 2023-03-16
-
relay-starter-kit
💥 Monorepo template (seed project) pre-configured with GraphQL API, PostgreSQL, React, Relay, Material UI.
-
There was a technique that existed already where you could use `go test -cover` and the `-o` flag to produce a binary from `go test` rather than actually running tests. So you could build a binary that had coverage enabled. Then when you ran
Here's an example: https://github.com/multiprocessio/datastation/blob/main/runn....
I can't remember where I found this technique but it's been around for a while.
This new option is the same thing but a way to `go build` with `-cover` instead of `go test -cover -o $out`? Do I have that right?
-
Project mention: Drizzle-team/drizzle-ORM: TypeScript ORM for SQL | news.ycombinator.com | 2023-03-06
-
Project mention: Introducing Remult: The Open Source Backend to Frontend Framework You Always Wanted | dev.to | 2023-03-14
Check out Remult, and if you like it, give it a star. Let us know what you’d like to see next, and also feel free to contribute to the project.
-
denoDB? https://github.com/eveningkid/denodb
-
Yes, copy-pasting the EXPLAIN output and the query into a visualizer such as pev2 might help understanding bottlenecks the plan, and confirms the above 👍
-
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
I've been enjoying developing on top of PostGraphile. https://www.graphile.org/
Good starter: https://github.com/graphile/starter
I can add a column the the db, and my frontend gets that autimagically (in dev mode, it generates a graphql schema out of the db, and from that it creates composables for my frontend wiht graphql-codegen). On the frontend I use Vue 3, the starter is build with nextjs/react.
-
development branch: https://github.com/garrylachman/ElectroCRUD/tree/develop
-
I was wondering the other day how to classify tests that use a test double like pg-mem, which isn't a mock but isn't the Dockerized test DB either :
-
worker
High performance Node.js/PostgreSQL job queue (also suitable for getting jobs generated by PostgreSQL triggers/functions out into a different work queue)
See also graphile-worker: https://github.com/graphile/worker (lower latency than pg-boss because it uses LISTEN/NOTIFY)
-
-
Github's implementation is really lazy. There are many much better approaches to precisely this problem. E.g., Jupyter notebooks implement one that has matured in the wild over a decade. There's this very flexible markdown-it plugin that implements anther https://github.com/goessner/markdown-it-texmath, and my version of it here https://github.com/sagemathinc/cocalc/blob/master/src/packag... which I rewrote in typescript with a focus on the same semantics as Jupyter has, but for CoCalc, and I've been working on using unifiedjs to provide more general latex for Markdown (not just formulas) here https://github.com/sagemathinc/cocalc/pull/5982 Parsing math is much easier if you use a plugin to an existing markdown parser, rather than trying to do some hack outside of that (which is what Github probably does, and also what Jupyter does).
-
InfluxDB
Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.
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-03-20.
TypeScript Postgresql related posts
- Multi-tenant implementation approaches with Prisma and ZenStack
- TIL that you don’t shouldn’t be generating TypeScript declarations for a distributable library
- Drizzle - An ORM that lets you just write SQL
- Introducing Remult: The Open Source Backend to Frontend Framework You Always Wanted
- HEROKU ALTERNATIVES TO HOST SERVER AND DB.
- Automate Docker Image Builds and Push to GitHub Registry Using GitHub Actions 🐙
- Remult: Fullstack typesafe CRUD framework adds zero-boilerplate live queries
-
A note from our sponsor - Sonar
www.sonarsource.com | 20 Mar 2023
Index
What are some of the best open-source Postgresql projects in TypeScript? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | supabase | 46,827 |
| 2 | nocodb | 34,920 |
| 3 | TypeORM | 30,758 |
| 4 | Prisma | 29,877 |
| 5 | Directus | 20,667 |
| 6 | postgraphile | 11,848 |
| 7 | dogehouse | 9,162 |
| 8 | azuredatastudio | 7,084 |
| 9 | MikroORM | 5,693 |
| 10 | kysely | 4,041 |
| 11 | slonik | 3,730 |
| 12 | relay-starter-kit | 3,725 |
| 13 | datastation | 2,686 |
| 14 | drizzle-orm | 1,976 |
| 15 | remult | 1,938 |
| 16 | denodb | 1,876 |
| 17 | pev2 | 1,832 |
| 18 | starter | 1,521 |
| 19 | ElectroCRUD | 1,458 |
| 20 | pg-mem | 1,307 |
| 21 | worker | 1,218 |
| 22 | node-pg-migrate | 1,126 |
| 23 | cocalc | 1,039 |
Access the most powerful time series database as a service
Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.
www.influxdata.com