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