AI Dev Tips 3.5: Review of AI Supabase “Postgres.new”
New, released today — I tried it out, here’s what happened…
This morning I was on Twitter and and there was a tweet by Paul Copplestone, the CEO of Supabase, about a new service that they have released, “Postgres.new”.
I tried it out, here is what happened….
Postgres.new is a service to take ChatGPT natural language input and produce a schema and deploy the database and do other awesome stuff.
tl;dr — Brilliant… Supabase Postgres.new is a very cool service, capable, usable, a good set of initial features, and I’m sure over time they will add more advanced features, and I really commend them. A great start. I have screenshots below.
Also- what a coincidence! I’m sure they’ve been working on this for a while but my main subject matter for AI Dev Tips (starting last week, see my new publication on Medium) was exactly the same topic idea!
On Medium, I’ve published 3 AI Dev Tips articles on the ideas related to Postgres, SQL, schemas, and ChatGPT — but actually… these were repurposed from tutorials I did last year on YouTube. btw, I already have 7 tutorials done (only 3 published on Medium so far) and about a total of 20 AI Dev Tips outlined already.
Quick promo: I wrote a book on Cloud metrics, check it out….
Store: Buy the full ebook / Sample / more info: CloudMetricsGuide.com
If you are into this kind of thing, I think you may be blown away by my AI queries with Postgres, article coming soon. Sign up for AI Dev Tips now. (free)
Ok, anyway, so I will pat my back 😅, when a big innovative company executes on a similar idea that I had, even if by coincidence, I take that as I’m ahead of the curve and on the right track.
He says in his tweet:
Postgres databases that run directly in your browser (and soon, deploy them to S3).
- Drag-and-drop CSV import (generate table on the fly)
- Generate and export reports
- Generate charts
- Build database diagrams (including ERD)
- Docs: https://supabase.com/blog/postgres-new
I went to Postgres.new and this is what I got (my red box):
I signed in with Github, the usual authorization required for a 3rd-party app, and just for private email address. Fair enough.
After login it asks What would you like to create?
I wrote the same as in my Ai Dev Tips article:
“I need to create a PostgreSQL schema for an online bookstore. The key feature is that users should be able to search for and purchase books. Please outline the tables, attributes, types, and keys needed for this schema.
Give 7 tables and attributes for each:”
The AI responds promptly with all the correct info, similar in my article:
For a moment I was not sure what to do next.
tbh, I wanted to see the diagram part — because I do an ERD diagram on AI Dev Tips 3 and I wondered if they do that too.
Then I saw the in light gray “Ask AI to create a table”. That must be it (suggestion: there might be better UI to prompt the user, and to perhaps say create a “diagram”?). I’m kind of dumb, but so are a lot of others.
So I type in “Create a Table for me”
I typed in 1 and this is the output, notice in the left column, the diagram:
Next I got the output for 2
Next I got the output for 3:
At this point I started looking for tools to diagram. But did not see what do.
On the new Supbase Docs for the service, it has a picture of them connected, but mine are not.
Maybe my keys are not connected, I need to work on that — probably I did something wrong.
I took a little diversion in the next couple steps to finally get an ERD, but yoru results may eb different, I am assuming since the docs say you can get it in Posgres.new that I did something wrong, or it does not work 100% of the time.
I wanted to get an ERD diagram like I had shown in my latest dev tips article AI Dev Tips 3: Create ER Diagrams from a DB Schema with Mermaid Markdown.
I typed in the AI chat box. I thought may be I have to tell it to connect it and it will just show up connected somehow.
“Can you connect these as an ERD diagram”
At first it tell me it cannot do it. It does give me a bunch of text related to the relationships — actually this is helpful.
You can use this info to put back into ChatGPT and for documentation.
Slight UX problem: It may turn off people from making the diagram.
However, I figured it out there is a way to make the diagram visually. See below.
Can you output in Mermaid Markdown:
Ok now we are brewin something…
I can take that output and copy/paste it into Mermaid live playground and it will output a an ERD Diagram:
Website: https://mermaid.live/ (click on Sample Diagrams > ERD), then you input the code produced above into the input (image below.)
There we go:
Like I said, it;s supposed to be able to natively do it in Postgres.new, so maybeit is user error on my part — I recommend looking into it more.
So back to Postgres.new — it says you can download and deploy.
I hit Deploy and I get this, I added to the waitlist.
There are charts too native in this thing! Awesome! I use charts with ChatGPT in Python, it produces Python code.
But this is cool — screenshot from their docs
This is as far as I got for this article. Postgres.new, try it.
Really promising. I hope this info was useful.
In coming AI Dev Tips…. I have more advancements on this using ChatGPT for ADVANCED QUERIES. And maybe I’ll look at this nerw Supbase servcie some more too.
Should be out in the next couple days — look for it.
If you are into Cloud Engineering… I wrote a guide to cloud metrics.
Store: Buy the full ebook / Sample / more info: CloudMetricsGuide.com
Cloud metrics covered:
- 190+ metrics in the categories of: User, Network, Reliability, Compute, Compute Scaling, API, Database, Storage, Events and Queues, Security and Cost metrics.
- 190 + cloud metrics in detail with insights!
- 800+ pages of valuable content, the ULTIMATE reference guide!
- PDF, Searchable, Linked Table of Contents (TOC) for fast navigation.
- Scenario/s giving example calculations, formulas and realistic situations.
- List of “Gotchas” for each metric usage, for better understanding.
- Best Practices and implementation suggestions for each metric!!!
Store: Buy the full ebook / more info: CloudMetricsGuide.com
About me
I’m a cloud architect, senior developer and tech lead who enjoys solving high-value challenges with innovative solutions.
I’m always open to discussing projects. If you need help, have an opportunity or simply want to chat, you can reach me on X/Twitter @csjcode and same username gmail. Also, can schedule a Zoom here (lower on page): https://systemsarchitect.io/docs/consulting
I’ve worked 20+ years in software development, both in an enterprise setting such as NIKE and the original MP3.com, as well as startups like FreshPatents, SystemsArchitect.io, API.cc, and Instantiate.io.
My experience ranges from cloud ecommerce, API design/implementation, serverless, AI integration for development, content management, frontend UI/UX architecture and login/authentication. I give tech talks, tutorials and share documentation of architecting software. Also previously held AWS Solutions Architect certification.
Recently I’m working on Instantiate.io, a value creation experiment tool to help startup planning with AI. I’m making progress writing a reference manual on cloud metrics.
Also, an enthusiast of blockchain, I’m active working on applications in the innovative Solana blockchain ecosystem.
Thanks for reading and hope to see you around!
