Goodbye API. Hello RSQL
rSQL simplifies data access by enabling direct SQL usage, offering features like fine-grained authorization and version control. Currently in beta, it will introduce pricing plans for businesses.
Read original article
rSQL is a new product designed to simplify data access by allowing users to utilize SQL directly across their applications, eliminating the need for REST or GraphQL APIs. It offers features such as fine-grained authorization, version control for data schemas, and secure authentication through JWT and OAuth integrations. rSQL is stateless and can be self-hosted, providing flexibility for developers. The platform is currently in beta and free for use, with plans for a standard pricing model for smaller businesses and variable pricing for larger organizations. The product includes an admin UI for managing queries and authorization, as well as a JavaScript SDK for handling registrations and real-time database changes. While rSQL is not open-source, the team is considering this option for the future. The focus is on providing a powerful, declarative language experience while ensuring ease of use and control for developers.
- rSQL allows direct SQL access, eliminating the need for traditional APIs.
- It features fine-grained authorization and version control for data schemas.
- The platform is currently free in beta, with future pricing plans for different business sizes.
- rSQL can be self-hosted and includes an admin UI and JavaScript SDK.
- The product is not open-source yet, but the team is contemplating this option.
Related
The Ultimate Database Platform
AverageDB, a database platform for developers, raised $50 million in funding. It offers speed, efficiency, serverless architecture, real-time data access, and customizable pricing. The platform prioritizes data privacy and caters to diverse user needs.
Taking the Drizzle Challenge
Rado is a rewritten Typescript query builder that offers immutable queries, simpler typing, and universal database support, targeting users seeking a lightweight alternative to Drizzle ORM, despite limited documentation.
Launch HN: Roe AI (YC W24) – AI-powered data warehouse to query multimodal data
Roe AI is developing a query engine that allows SQL queries on unstructured data using LLMs, simplifying analysis for teams and offering a free trial with AI credits.
Show HN: Visual DB – Web front end for your database
Visual DB is a no-code database form and report builder that simplifies data management, supports integration with relational databases, and offers real-time reporting, with free and business pricing options available.
Show HN: Sequel – Effortlessly understand your data
Sequel is an AI tool that enables natural language queries for databases like PostgreSQL and MySQL, enhancing data accessibility for users while prioritizing security and offering SQL editing options.
8 commentsNot sure how this got into onto HN. Maybe hackandthink can explain.
This product does not actually exist. I wanted to see if there was demand for something like this so I created a landing page for it a few years ago. It only got bad responses. Mostly worries about how authorization rules would work and that it could never be done securely, so I never ended up building it, even though I didn't fully agree with that concern.
I should probably take the page down.
How are these companies using this technology? Are they using it in prod? Is it in one of their main apps or just an internal tool?
What happens at scale? How do I separate read and write pools? How can I tune query configs and wait times?
yes, it looks a little crazy and there are certainly serious security considerations (they support ACLs it looks like) but this is the logical end point of JavaScript-based applications that jettison the hypermedia infrastructure of the web
REST (so called, see[1]) was the first step, GraphQL the second step and now this completes the move of pushing the expressiveness found on the server side over to the client side.
[1] - https://htmx.org/essays/how-did-rest-come-to-mean-the-opposi...
Related
The Ultimate Database Platform
AverageDB, a database platform for developers, raised $50 million in funding. It offers speed, efficiency, serverless architecture, real-time data access, and customizable pricing. The platform prioritizes data privacy and caters to diverse user needs.
Taking the Drizzle Challenge
Rado is a rewritten Typescript query builder that offers immutable queries, simpler typing, and universal database support, targeting users seeking a lightweight alternative to Drizzle ORM, despite limited documentation.
Launch HN: Roe AI (YC W24) – AI-powered data warehouse to query multimodal data
Roe AI is developing a query engine that allows SQL queries on unstructured data using LLMs, simplifying analysis for teams and offering a free trial with AI credits.
Show HN: Visual DB – Web front end for your database
Visual DB is a no-code database form and report builder that simplifies data management, supports integration with relational databases, and offers real-time reporting, with free and business pricing options available.
Show HN: Sequel – Effortlessly understand your data
Sequel is an AI tool that enables natural language queries for databases like PostgreSQL and MySQL, enhancing data accessibility for users while prioritizing security and offering SQL editing options.