Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Ayb: A multi-tenant database that helps you own your data

blog.marcua.net

Post reply on HN
Print view View original

11–16 of 16 posts

Re: Ayb: A multi-tenant database that helps you own your data

#11

Post by gavinray »

I'm not sure if I fully understand what exactly "Ayb" is. Maybe a diagram/visual image would help to clarify the flow and architecture?

From the example it seems like it is a CLI that will create SQLite databases, and then runs an HTTP server that passes through queries to the underlying database?

Not trying to be critical but a few questions:

- What is the appeal of a CLI for creating SQLite databases when you can create one by making a new file like "my_db.sqlite3"?

- If it's meant to make the DB setup process easier for students, how does it create and run Postgres or MySQL etc? It seems like you have to already have a running DB server and then configure the credentials, versus something like starting a server using Docker and auto-wiring the credentials.

- For exposing an HTTP API on top of databases, as a heads-up there are tools like Apache Avatica which let you query any DB that has a JDBC driver over HTTP, JDBC, and gRPC. https://calcite.apache.org/avatica/docs/json_reference.html

Re: Ayb: A multi-tenant database that helps you own your data

#12

Post by ubertaco »

marcua wrote: post #4
ubertaco wrote: post #3

So, you've built a CLI client and an HTTP API server that wraps around SQLite. How does this actually work in the real world, though? Like, if I run an ayb node somewhere, do I then share out individual tables (or slices of tables, or views) to other apps in an OAuth kind of way? How does that happen? What's the permissions/ACL model, and how do you keep that from getting too confusing for the average person? And eve…

(Hi there! Surprised author here---I hadn't realized this made its way to the front page) I love your questions because they get to the heart of how to make this stuff easier for more people, and in transparency, I only have some of the answers! :) > What's the permissions/ACL model, and how do you keep that from getting too confusing for the average person? (You asked a lot more here, but I think this is the root of…

Thanks for the candid answers -- sounds like this hit HN a bit earlier than you would've planned, which I realize can create a weird awkward tension between planned goals and current state and HNers' expectations.

I think it's cool that you're trying to tackle adding simplicity to managing a multi-user (if not actually multi-tenant, given the lack of row-level permissions management) SQL DB. My suggestion then would be to refine your pitch so that it matches your project a bit better -- that way you avoid the problem of people disappointed to find it doesn't do something they expected (but which it was never trying to do).

Re: Ayb: A multi-tenant database that helps you own your data

#13

Post by AndrewKemendo »

marcua wrote: post #7
AndrewKemendo wrote: post #6

I really love this project and exactly what it’s trying to do. There’s many things like this that I wish existed that make prototyping easier and faster and infrastructure a little bit nicer to use. My concern is that because it’s a Nerfed version of the most basic/powerful/flexible implementation that is expected for a RESTful LAMP/SOAP application, it’s not gonna find its way into production applications, and as a…

(author here) Thank you for your kind words and the great question! To your compliment: I agree ayb can help with easier prototyping today. To your concern: I would not use ayb in a production setting today. To be explicit, while the roadmap [1] is long, I think that ayb will be useful in production once we've implemented a v1 of auth, permissions, persistence beyond the node, and isolation. To "how to prevent that,"…

I mean the fact that you have, what looks to my senior engineering manager eyes as, a coherent technical roadmap, puts you further along than almost every hobby level prototype tool.

Excited to see where it goes and if there’s an associated space here for integrating some form of environment management to wrap up all those other loose ends around dev.

Re: Ayb: A multi-tenant database that helps you own your data

#15

Post by aae42 »

I think we need more go/rust HTTP wrappers around SQLite

Will keep an eye on this one, could definitely see myself using it once the access control stuff is sorted

we sorely need a go/rust postGREST equiv. for SQLite.

Until then, pocketbase, while perhaps heavyweight, might be the best option

Re: Ayb: A multi-tenant database that helps you own your data

#16

Post by ruslan_talpa »

aae42 wrote: post #15

I think we need more go/rust HTTP wrappers around SQLite Will keep an eye on this one, could definitely see myself using it once the access control stuff is sorted we sorely need a go/rust postGREST equiv. for SQLite. Until then, pocketbase, while perhaps heavyweight, might be the best option

There is a postgrest for sqlite in rust (with js bindings)

https://github.com/subzerocloud/showcase/tree/main/flyio-sql...

Post reply on HN