squabble
mfsqlchecker
squabble | mfsqlchecker | |
---|---|---|
1 | 3 | |
64 | 56 | |
- | - | |
1.8 | 0.0 | |
over 3 years ago | 11 months ago | |
Python | TypeScript | |
GNU General Public License v3.0 only | 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.
squabble
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?
pg-to-ts - Generate TypeScript interface definitions from your Postgres schema
pgtyped - pgTyped - Typesafe SQL in TypeScript
xql - SQL builder and utilities library for node.js (runs in browser as well).
vramework
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.
liveviewjs - LiveView-based library for reactive app development in NodeJS and Deno
sqlc - Generate type-safe code from SQL