Postgres to TypeScript Interfaces and Enums

• vramework

  2 8 0.0 TypeScript
  

This is awesome! the json types part is perfect. If I found your fork earlier I would have just used that as its what I need for jsonb.

The dates solution I fixed in a rest API wrapper on the client side. It's not great but it hides away the date serialisation issues

https://github.com/vramework/vramework/blob/243db4830d22c537...

Is it performant? Not really. But it stopped us from having to deal with the string issue which worked great.

• prisma1

  64 16,816 5.1 Scala

  Discontinued 💾 Database Tools incl. ORM, Migrations and Admin UI (Postgres, MySQL & MongoDB) [deprecated]

  

Seems like it generates TS types, but doesn’t help with data access? i.e. not trying to compete with tools that generate full data access layers, like Prisma https://www.prisma.io/ ?

If so, out of curiosity, what’s the use case for generating just the types? How are you actually getting data to/from the DB?

• SurveyJS

  surveyjs.io featured

  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.

  

• ts-sql

  28 3,114 0.0 TypeScript

  A SQL database implemented purely in TypeScript type annotations.

  

Maybe this may help as some inspiration https://github.com/codemix/ts-sql

• squabble

  1 64 1.8 Python

  An extensible linter for SQL queries and migrations.

• kanel

  10 799 9.0 TypeScript

  Generate Typescript types from Postgres

We are using Kanel[1] for this right now — is there an advantage to using this instead?

[1]: https://github.com/kristiandupont/kanel

• Paste JSON as Code • quicktype

  64 1,671 0.0 JavaScript

  Xcode extension to paste JSON as Swift, Objective-C, and more

  

doesn't it already exist? but it converts from your json https://quicktype.io/

• pgtyped

  34 2,807 8.7 TypeScript

  pgTyped - Typesafe SQL in TypeScript

• InfluxDB

  www.influxdata.com featured

  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.

  

• pg-to-ts

  2 88 3.3 TypeScript

  Generate TypeScript interface definitions from your Postgres schema

There are many forks of schemats out there that add various features. Here’s mine: https://github.com/danvk/pg-to-ts

It copies Postgres comments over to JSDoc/TSDoc comments, emits some data about foreign key relationships and supports TS types for json/jsonb columns via @type comments. Feel free to copy any of those feature if you think they’re good ideas :)

• sqlx

  144 11,822 9.2 Rust

  🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite. (by launchbadge)

  

sqlx is able to do this, but using compile time macros. For a typescript project you'd possibly need a running process reading your source files for queries and probing the database for what will come back.

https://github.com/launchbadge/sqlx/#compile-time-verificati...

• mfsqlchecker

  3 56 0.0 TypeScript

  Statically validate correctness of all your SQL queries. TypeScript, PostgreSQL

  

This library does exactly what you want: https://github.com/MedFlyt/mfsqlchecker

and it also validates the types of the parameters that go into the query

Suggest a related project