Post #139903

So, we're building a data hub! But maybe someone's built it already? Most of what we need likely already exists, ideally as an open source product, and we'd much rather start from an existing product and community than just build from scratch on top of PostgreSQL of course. Anyone know of things that roughly meet these criteria?: Immediate needs:API (obviously)Support for attachments/files (some systems may call these "blobs"?)Migrations (both up and down)Easy to back up and to restoreNeeds coming soon:Authentication and authorization (including permissions at the table level)Web interface for viewing & editing data (we can write this ourselves if we have to, of course, but it's so much better if it comes out-of-the-box)Per-field documentation (again, we can build this, but some systems may have built-in slots for documentation of fields, and that'd save us some time)Nice-to-haves:Existing integrations with other systems (e.g., Airtable, Salesforce, WordPress)Permissions at the column levelAPI is RESTful (probably most are by default anyway?) The overall scale we're talking about is 500GB - 1TB over the next year or two, and probably going up from there. We're aware of Supabase (maybe the strongest candidate so far, but we just began looking). We're also aware of Appwrite (but, as the name suggests, it's more geared toward being an application back-end), Pocketbase (same, and optimized for real-time applications), and I recently ran across Snackbase (but haven't dug in much yet). Comments about any of these from people with experience are also welcome, though I am primarily posting to learn about new options. I'd be grateful for any pointers.