mfsqlchecker
pg-to-ts
| mfsqlchecker | pg-to-ts | |
|---|---|---|
| 3 | 2 | |
| 56 | 88 | |
| - | - | |
| 0.0 | 3.3 | |
| 11 months ago | 5 months ago | |
| TypeScript | TypeScript | |
| MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
mfsqlchecker
-
Deepkit – High-Performance TypeScript Framework
Here is another TypeScript library for validating types of SQL queries: https://github.com/MedFlyt/mfsqlchecker
It uses the actual PostgreSQL parser against your project's database schema to give 100% accurate results. Guarantees that all of your queries are valid, and that all input and output types are correct (and will also auto-generate/quickfix the output types for you in VSCode)
-
Write an SQL query builder in 150 lines of Python
> In an ideal world (one I think we are getting very close to) I think we will end up having SQL queries validated in our code against the actual DB structure the same way we have any other compilation error.
This library for TypeScript works exactly like this
https://github.com/MedFlyt/mfsqlchecker
-
Postgres to TypeScript Interfaces and Enums
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
pg-to-ts
-
ADVICE WANTED - Typescript PostgreSQL without ORM
I have so far found: - kanel https://github.com/kristiandupont/kanel - and pg-to-ts https://github.com/danvk/pg-to-ts
-
Postgres to TypeScript Interfaces and Enums
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 :)
What are some alternatives?
xql - SQL builder and utilities library for node.js (runs in browser as well).
sqlx - 🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.
PyPika - PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.
kanel - Generate Typescript types from Postgres
vramework
pgtyped - pgTyped - Typesafe SQL in TypeScript
ts-sql - A SQL database implemented purely in TypeScript type annotations.
squabble - An extensible linter for SQL queries and migrations.
liveviewjs - LiveView-based library for reactive app development in NodeJS and Deno
slonik - A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.
kysely-codegen - Generate Kysely type definitions from your database.