InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises. Learn more →
Top 23 TypeScript Postgre Projects
-
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.
We need a way of monitoring our cluster, the most recommended stack (but not the only one) is Prometheus, Alert Manager and Grafana. Prometheus is a monitoring system, and Grafana is a visualization system that can work as the frontend for Prometheus. The Prometheus community provides and easy way to install these tools via the Kube Prometheus Stack. This chart has many parameters you can configure, so we will not get into much detail here. The easiest way to install it is the following:
-
-
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!
-
Hasura
Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
You could use something like PostgresT or Hausra for the database, and they will handle auth. Now you've reduced the problem to generating a crud app from a database, which things like appsmith claim to be able to do. I've never used any of them though, so I can't speak to how well they work.
-
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
This week, I focus on creating an initial schema for the project through using Prisma. This is for a MySQL database, and the PR for the initial schema is here.
-
postgraphile
Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database!
-
You can use Nhost (100% open source): https://github.com/nhost/nhost/tree/main/examples/docker-compose
-
relay-starter-kit
💥 Monorepo template (seed project) pre-configured with GraphQL API, PostgreSQL, React, Relay, Material UI.
-
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.
-
I think this is a really cool project, but for most use cases (not all, but most) I strongly believe query builders are an anti-pattern. I could go over the reasons, but when I saw this blog post, https://gajus.medium.com/stop-using-knex-js-and-earn-30-bf41..., from the author of slonik years ago I had a eureka moment, and it explains the reasoning better than I could.
Template strings in TypeScript allow you to safely write SQL directly, still with type checking: https://github.com/gajus/slonik#readme
-
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: Any examples of working activist, socialist, or community-organizing software? | reddit.com/r/socialistprogrammers | 2022-07-19 -
For Postgres there is https://github.com/adelsz/pgtyped, sounds pretty much like what you describe?
-
-
development branch: https://github.com/garrylachman/ElectroCRUD/tree/develop
-
-
Project mention: Fully featured Repository Pattern with Typescript and native PostgreSQL driver | dev.to | 2022-03-20
Why PG? For the clarity of the article to a large circle of developers, the entire explanation will be built by PostgreSQL and PG package. And in a real project, the database schema will change over time, and in order to be able to perform migrations, we will use Node PG migrate.
-
Project mention: GraphQL error handling to the max with Typescript, codegen and fp-ts | dev.to | 2022-03-07
:::note When using remote APIs, we often have the possibility to generate the types automatically from a JSON schema for REST APIs, from protobuf files for gRPC-based APIs, from a database schema, etc. You might even be using an external API through an SDK that already provides you with all types. In such cases, the creation of specialized Error classes is not mandatory. However, it might still be a good idea to do so to provide application-specific errors rather than bubbling up 3rd-party low-level errors. For such cases, the upcoming Ecma TC39 proposal for Error Cause is useful as it allows to chain errors. Polyfills exist: Pony Cause or error-cause. :::
-
-
-
If there was a tool that plugs into your linter (ESLint) and helps you find and fix these issues, would you use it? Luckily, I just wrote one - SafeQL.
-
I picked the first issue, which was a bug in the Supabase dashboard, where users could not edit a database column from a primary type to its array type. The dashboard was built with Nextjs and TailwindCSS, using the Supabase-UI components libraries. It looked like was a quick fix to me. After investigation, the error was not with the dashboard but it was an error of insufficient type handling of column type identifiers within the Posgres-Meta package, which was also written by Supabase Team. Then, I headed to the package upstream and fixed it. The PR got merged and released soon after.
-
Project mention: Which Postgres connector would you use; `denodrivers/postgres` or `porsager/postgres`? | reddit.com/r/Deno | 2022-05-08
https://github.com/denodrivers/postgres The official driver (AFAIK) Fewer features, but perhaps more longevity and stability
-
-
At Databases because you don't need ORM.
-
Project mention: sql-lint - A linter for SQL (finally hits version 1.0.0) | reddit.com/r/coolgithubprojects | 2022-06-24
-
InfluxDB
Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
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-02-04.
TypeScript Postgres related posts
- Easiest way to add an image to a row of data
- Building a Startup from Scratch: My Mistakes as CTO
- Aplicativos da Web totalmente tipados
- Supabase CDC Webhooks to Memphis REST Gateway
- No code with Python
- Why did the new GraphQL API for WordPress take 1.5 years to be released?
- Question about supabase self hosted
-
A note from our sponsor - InfluxDB
www.influxdata.com | 4 Feb 2023
Index
What are some of the best open-source Postgre projects in TypeScript? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Grafana | 53,769 |
| 2 | supabase | 44,841 |
| 3 | Hasura | 29,150 |
| 4 | Prisma | 28,710 |
| 5 | postgraphile | 11,782 |
| 6 | nhost | 5,958 |
| 7 | relay-starter-kit | 3,691 |
| 8 | slonik | 3,627 |
| 9 | jitsu | 3,078 |
| 10 | pgtyped | 2,210 |
| 11 | kentcdodds.com | 1,810 |
| 12 | ElectroCRUD | 1,442 |
| 13 | zws | 1,345 |
| 14 | node-pg-migrate | 1,117 |
| 15 | schemats | 990 |
| 16 | zapatos | 921 |
| 17 | boilerplate | 839 |
| 18 | safeql | 784 |
| 19 | postgres-meta | 579 |
| 20 | postgres | 551 |
| 21 | deno-nessie | 514 |
| 22 | @databases | 492 |
| 23 | sql-lint | 389 |
Build time-series-based applications quickly and at scale.
InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
www.influxdata.com