Stripe provides https://stripe.com/sigma which allows users to write their own SQL. If you had a multi-tenant Postgres DB, how would you build a system such as Stripe Sigma? Where each tenant can only query their own data obviously. Thanks for any recommendations! More notes that could be helpful: - dozens of tables. - Source: Hacker News / 10 months ago

We're currently grappling with trying to build a system similar to https://stripe.com/sigma with a single multi-tenant Postgres db as the source and an SQLite read replica per tenant. Currently we re-generate the world every night. We need fine-grained control over the SQLite schema (it's a public api we let users write sql against). Any related projects would be great to point me towards! - Source: Hacker News / 10 months ago

Https://stripe.com/sigma lets you create custom reports (but on extra costs) and schedule them. Source: almost 2 years ago

Stripe Sigma allows you to build custom queries using SQL and comes up with some very helpful report templates with some important exceptions like Monthly Recurring Revenue (MRR). - Source: dev.to / over 2 years ago

If you're insistent on php, use Laravel Nova, or better yet, something like Odoo. Source: about 1 year ago

Laravel ecosystem itself provides you with Nova. It's perfect for. Source: about 1 year ago

But if this is simply "We need a CRUD app", you should look at Laravel Nova to cut down on a lot of work that people have done a million times before. Source: about 1 year ago

Laravel with an administration panel (Laravel Nova, Backpack for Laravel, Filament Admin are some of the top choices). - Source: dev.to / over 1 year ago

Laraval Nova is pretty great if you already know PHP. Tables are almost free to show and have CRUD around them. Metrics / Charts are easy to display. https://nova.laravel.com/. - Source: Hacker News / almost 2 years ago