|
|
|
|
|
by saltcod
668 days ago
|
|
Thanks Jake — these are great. Couple of quick questions: — "AI autocompletion & generation...." sort of like what https://postgres.new/ does, but built into the Dashboard?
- "Notebooks..." — like a Jupyter notebook kind of thing? We already have SQL Snippets you can share with team members, but you're probably talking about the combination of text and SQL?
— cmdk — we've just released a big revision of our menu last week, we should definitely add snippets and tables/views etc. Great idea. Love to hear anything else you've got in Supabase feedback! |
|
1) pg.new is neat, but honestly I don't see why I'd use it when I can do the same thing directly inside my drizzle schema dir using Cursor's Composer UI, which has full context on my project. I know not many are using Cursor right now, but it's hard to fathom these kind of features don't become part-and-parcel of code editors soon..
2) I actually find it painful to have to login to Supabase on the web to manage the database. I never use the table editor, snippets, etc. I want a native app I can CMD+Tab to.
Don't mean to be rude, just objective so you can feel my pain as a user.
In terms of the Notebooks, yeah I meant like Jupyter Notebooks. I've experimented with having a shared Notion or markdown files committed to repos in order to
A) save & search for snippets of SQL for the team/future me
B) document the "why" along with each step in a playbook.
The issues with this are
1) its detached from our normal workflow and quickly becomes outdated relative to our schema/business needs
2) to run the queries you have to copypaste back into a SQL tool
3) queries are hardcoded for certain values. If I have a report I run daily, every day I have to go in and manually update the `row.timestamp BETWEEN 'YYYY-MM-DD' AND 'YYYY-MM-DD'`, or if its a customer support workflow I have to replace the customer's ID everywhere. I'd rather have variables at the top I can reference throughout the queries, either as a code block like in Jupyter NB, or maybe some variable UI a la Insomnia/Postman