🐛 Statically validate Postgres SQL queries in JS / TS code and derive schemas. (by andywer)

Postguard Alternatives

Similar projects and alternatives to postguard

  • drizzle-orm

    47 postguard VS drizzle-orm

    Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅

  • aiosql

    Simple SQL in Python

  • SurveyJS

    Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

    SurveyJS logo
  • squid

    2 postguard VS squid

    🦑 Provides SQL tagged template strings and schema definition functions. (by andywer)

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better postguard alternative or higher similarity.

postguard reviews and mentions

Posts with mentions or reviews of postguard. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-03-29.
  • Don't use your ORM entities for everything – embrace the SQL
    4 projects | | 29 Mar 2024
    I guess I failed to set the context correctly given that you presented solutions for Clojure and Python, where it isn't as much of a problem since from the start the language fails to provide compiler guarantees you usually come to expect out of a SQL driver wrapper in typed languages (even though Clojure macros are probably powerful enough to allow this).

    As a comparison, DX-wise this is no safer and is indeed very similar to the usual idiom in Go for example, where you just concatenate (pre-interpolated) SQL strings. But when you actually want the compiler to prove the correctness of your queries even in a rudimentary way, these .sql file solutions usually (if not, everytime) fail to provide the necessary external checker that processes templates and uses an accurate model of your database and SQL to verify that all used combinations make sense.

    The closest thing to a proper take on this I've seen is with which, although the SQL is inlined in the code, it uses the right approach for verifying correctness as far as I could tell in the little time I experimented with it.


Basic postguard repo stats
about 1 year ago

andywer/postguard is an open source project licensed under GNU General Public License v3.0 only which is an OSI approved license.

The primary programming language of postguard is TypeScript.

The modern identity platform for B2B SaaS
The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.