mfsqlchecker
vramework
| mfsqlchecker | vramework | |
|---|---|---|
| 3 | 2 | |
| 56 | 8 | |
| - | - | |
| 0.0 | 0.0 | |
| 11 months ago | over 1 year 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
vramework
-
Postgres to TypeScript Interfaces and Enums
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.
What are some alternatives?
pg-to-ts - Generate TypeScript interface definitions from your Postgres schema
prisma1 - 💾 Database Tools incl. ORM, Migrations and Admin UI (Postgres, MySQL & MongoDB) [deprecated]
xql - SQL builder and utilities library for node.js (runs in browser as well).
Paste JSON as Code • quicktype - Xcode extension to paste JSON as Swift, Objective-C, and more
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
ts-sql - A SQL database implemented purely in TypeScript type annotations.
liveviewjs - LiveView-based library for reactive app development in NodeJS and Deno
pgtyped - pgTyped - Typesafe SQL in TypeScript
sqlx - 🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.