SQL as API

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  • cel-spec

    Common Expression Language -- specification and binary representation

  • CodeRabbit

    CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

    CodeRabbit logo
  • expr

    Expression language and expression evaluation for Go

    You're basically creating an expression language: https://github.com/expr-lang/expr

  • json-api

    A specification for building JSON APIs

  • pgrx

    Build Postgres Extensions with Rust!

    I’m currently playing with PostgreSQL, foreign data wrappers, and pgrx rust extensions. My development experience has been surprisingly smooth and enjoyable.

    My main issue is that joins will be processed locally, so all the foreign data will be fetched before the join happens. But otherwise basic CRUD is easy.

    https://wiki.postgresql.org/wiki/Foreign_data_wrappers

    https://github.com/pgcentralfoundation/pgrx

    https://github.com/supabase/wrappers

  • wrappers

    Postgres Foreign Data Wrapper development framework in Rust.

    I’m currently playing with PostgreSQL, foreign data wrappers, and pgrx rust extensions. My development experience has been surprisingly smooth and enjoyable.

    My main issue is that joins will be processed locally, so all the foreign data will be fetched before the join happens. But otherwise basic CRUD is easy.

    https://wiki.postgresql.org/wiki/Foreign_data_wrappers

    https://github.com/pgcentralfoundation/pgrx

    https://github.com/supabase/wrappers

  • Sea-Quill

    Create Full Stack web applications in SQL

    It actually works! Here's the code on GH: https://github.com/seisvelas/Sea-Quill

    Sadly, I stopped working on it after only 1 or 2 weekends because I switched professions to cybersecurity and had too much to learn - every weekend thereafter was CTFs or bug bounties.

    Oh well! Someday I'd like to write a more intuitive, "conventional" style language for Urbit, maybe called HoonScript or something. So my affection for Racket's language oriented programming will (maybe, one day) not be in vain!

  • > What you have listed is not an actual solution, just a list of things you'd need to solve it

    Sorry. HN comments is a narrow channel and so I elected not to try to squeeze a full-blown actual solution through it.

    > I could say the only thing you need for the DSL to SQL solution is a programming language, my list would be one item

    Well...I enumerated the features of the language I'm using just as you could enumerate the features of your programming language. My list could have one item just as easily as yours can: "PostgreSQL DDL"

    > how to test this is a valid question as well

    My answer to that question has been to use pgTAP for testing and postgresql_faker to generate synthetic data

    https://pgtap.org/

    https://gitlab.com/dalibo/postgresql_faker

    > My tests also don't require a database to with data in it to test

    No, but they do require a runtime, be it in Scala or whatever. That's no different from my case where my test runtime is an ephemeral PostgreSQL database.

    > Do you have an example of how this works if you are performing joins between tables?

    You bet.

    https://asciinema.org/a/629243

    > Does every table need to have some sort of user id in it directly for that to work?

    It's common for single-database multi-tenant data models to add something like a "tenant_id" to every table. It's simple, more efficient, and more foolproof. You can however just join to other tables in the policy condition as I have done. Extra care should be taken as discussed in the PostgreSQL docs:

    https://www.postgresql.org/docs/current/ddl-rowsecurity.html

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Production grade databases in Rust

    14 projects | /r/rust | 21 Apr 2023
  • Create a blog using JStack(Nextjs, Neon, Prisma)

    3 projects | dev.to | 10 Sep 2024
  • Introducing DEV++

    1 project | dev.to | 29 Aug 2024
  • Postgres Foreign Data Wrappers with WASM

    1 project | news.ycombinator.com | 16 Aug 2024
  • We just launched DEV Challenges on product hunt

    1 project | dev.to | 8 Aug 2024

Did you konow that Go is
the 4th most popular programming language
based on number of metions?