mfsqlchecker
xql
mfsqlchecker | xql | |
---|---|---|
3 | 1 | |
56 | 17 | |
- | - | |
0.0 | 0.0 | |
11 months ago | over 5 years ago | |
TypeScript | JavaScript | |
MIT License | The Unlicense |
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
xql
What are some alternatives?
pg-to-ts - Generate TypeScript interface definitions from your Postgres schema
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.
sqlc - Generate type-safe code from SQL
vramework
sql-athame - Python tool for slicing and dicing SQL
ts-sql - A SQL database implemented purely in TypeScript type annotations.
sql-assassin - Unfancy node.js SQL builder for ES6
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.
pgtyped - pgTyped - Typesafe SQL in TypeScript
postgres-typed