Top 23 TypeScript Postgresql Projects
The open source Firebase alternative. Follow to stay updated about our public Beta.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
🔥 🔥 🔥 Open Source Airtable AlternativeProject mention: [Darksouls] Remaster pour PC Controller ne fonctionne pas ? | reddit.com/r/enfrancais | 2023-03-14
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!
The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.Project mention: Correct way to use pinia stores | reddit.com/r/Nuxt | 2023-03-19
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.
Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database!Project mention: v4.13.0 | reddit.com/r/PostGraphile | 2023-01-12
Taking voice conversations to the moon 🚀Project mention: Test | reddit.com/r/u_bestonecrazy | 2022-09-22
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: SQL Database Project - Intellisense error issue? | reddit.com/r/MSSQL | 2023-01-28
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?
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: MikroORM v6 gets a strict partial loading support | reddit.com/r/node | 2023-03-04
More about v6 development can be found here.
A type-safe typescript SQL query builderProject mention: Full-Stack TypeScript with tRPC and React | news.ycombinator.com | 2023-03-14
A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.Project mention: TIL that you don’t shouldn’t be generating TypeScript declarations for a distributable library | reddit.com/r/typescript | 2023-03-16
💥 Monorepo template (seed project) pre-configured with GraphQL API, PostgreSQL, React, Relay, Material UI.Project mention: Ask HN: Who wants to be hired? (June 2022) | news.ycombinator.com | 2022-06-01
App to easily query, script, and visualize data from every database, file, and API.Project mention: Code coverage for Go integration tests | news.ycombinator.com | 2023-03-08
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?
TypeScript ORM for SQLProject mention: Drizzle-team/drizzle-ORM: TypeScript ORM for SQL | news.ycombinator.com | 2023-03-06
Build Full-stack, End-to-end Type-safe CRUD Apps without the BoilerplateProject 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.
MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for DenoProject mention: MariaDB API Recomendations | reddit.com/r/Deno | 2022-09-29
Postgres Explain Visualizer 2Project mention: super-slow query | reddit.com/r/PostgreSQL | 2023-02-13
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 👍
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.jsProject mention: Ask HN: Solo Dev Stack of 2022? | news.ycombinator.com | 2022-10-01
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.
Database CRUD Application Built on Electron | MySQL, Postgres, SQLiteProject mention: After few years, ElectroCRUD is coming back | reddit.com/r/opensource | 2023-01-19
development branch: https://github.com/garrylachman/ElectroCRUD/tree/develop
An in memory postgres DB instance for your unit testsProject mention: Ask HN: How do you test SQL? | news.ycombinator.com | 2023-01-31
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 :
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: How to schedule tasks in a Node.js app 🕙 | reddit.com/r/node | 2023-01-25
See also graphile-worker: https://github.com/graphile/worker (lower latency than pg-boss because it uses LISTEN/NOTIFY)
Node.js database migration management for Postgresql
CoCalc: Collaborative Calculation in the CloudProject mention: Math on GitHub: Following Up | news.ycombinator.com | 2022-06-28
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).
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.
TypeScript Postgresql related posts
Multi-tenant implementation approaches with Prisma and ZenStack
6 projects | dev.to | 18 Mar 2023
TIL that you don’t shouldn’t be generating TypeScript declarations for a distributable library
2 projects | reddit.com/r/typescript | 16 Mar 2023
Drizzle - An ORM that lets you just write SQL
1 project | reddit.com/r/node | 15 Mar 2023
Introducing Remult: The Open Source Backend to Frontend Framework You Always Wanted
1 project | dev.to | 14 Mar 2023
HEROKU ALTERNATIVES TO HOST SERVER AND DB.
2 projects | reddit.com/r/webdev | 13 Mar 2023
Automate Docker Image Builds and Push to GitHub Registry Using GitHub Actions 🐙
7 projects | dev.to | 11 Mar 2023
Remult: Fullstack typesafe CRUD framework adds zero-boilerplate live queries
2 projects | reddit.com/r/node | 6 Mar 2023
A note from our sponsor - Sonar
www.sonarsource.com | 20 Mar 2023
What are some of the best open-source Postgresql projects in TypeScript? This list will help you: