PgTypedWhat is PgTyped?
It makes it possible to use raw SQL in TypeScript with guaranteed type-safety. No need to map or translate your DB schema to TypeScript, it automatically generates types and interfaces for your SQL queries by using your running Postgres database as the source of type information.
PgTyped is a tool in the Databases category of a tech stack.
Key Features
Automatically generates TS types for parameters/results of SQL queries of any complexitySupports extracting and typing queries from both SQL and TS filesGenerate query types as you write them, using watch modeUseful parameter interpolation helpers for arrays and objectsNo need to define your DB schema in TypeScript, your running DB is the live source of type dataPrevents SQL injections by not doing explicit parameter substitution. Instead, queries and parameters are sent separately to the DB driver, allowing parameter substitution to be safely done by the PostgreSQL server
PgTyped Pros & Cons
Pros of PgTyped
No pros listed yet.
Cons of PgTyped
No cons listed yet.
PgTyped Alternatives & Comparisons
What are some alternatives to PgTyped?
Slick
It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred.
Spring Data
It makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. This is an umbrella project which contains many subprojects that are specific to a given database.
Dataform
Dataform helps you manage all data processes in your cloud data warehouse. Publish tables, write data tests and automate complex SQL workflows in a few minutes, so you can spend more time on analytics and less time managing infrastructure.
