Supabase engineer here. This was a lot of fun to build with the Electric team. There were a lot of technical hurdles to jump over - I’m happy to cover any questions. We’ll continue shipping throughout the week. I see a lot of feedback in this thread already which we’ll get started with.
Postgres.new: In-browser Postgres with an AI interface
41–50 of 116 posts
Re: Postgres.new: In-browser Postgres with an AI interface
#42Re: Postgres.new: In-browser Postgres with an AI interface
#43Hey Sam from Electric here, I work on PGlite What the team at Supabase have built with postgres.new is incredible, it has been a lot of fun to work with them on it over the last month or so. It's fead directly back into the development of PGlite and helped us iron out some bugs and finish hitting the feature list required. SQL databases and LLMs go together so incredible well, the structured data and schema enables a…
also is the UI tool open source? id prefer to run it locally
edit: this is an incredible tool. its going to eat a lot of backend engineers billing hours.
suggestion: add a copy button for the generated SQLs
Re: Postgres.new: In-browser Postgres with an AI interface
#44Overall, looks pretty good. I’m on mobile but stumbled upon the blog post in comments.
Ask: I understand why it won’t run on mobile but at least give mobile a synopsis of what it’s suppose to do. I almost ignored this if it wasn’t for the luck of seeing your comment.
Re: Postgres.new: In-browser Postgres with an AI interface
#45Basic question. Is there a service out there where I can easily link my database to an LLM to do this exact same type of analysis, except on one of my own Postgres DBs instead of one backed by PGlite? My org has several non-technical people who would greatly benefit from being able to interact with our DB via an LLM, rather than SQL 101 queries. The PostgreSQL Explorer extension on VS Code helps some, but doesn't qui…
Another possibility might be to export the database (or a subset of it) to be loaded in a more ephemeral environment like PGlite so that you don't have to worry about non technical users running inefficient/unindexed queries taking down the prod DB.
Re: Postgres.new: In-browser Postgres with an AI interface
#46Earlier quoted context omitted.
fwiw this will show for 2 reasons: 1/ you're using a small window (even on Chrome/FF). We don't support mobile yet, so if you're seeing this on a desktop just expand the window 2/ you're on safari, which doesn't have support for OPFS yet: https://github.com/electric-sql/pglite/pull/130
The website works fine for me on Safari. Had it generate a 3-table schema no issues.
Re: Postgres.new: In-browser Postgres with an AI interface
#47Re: Postgres.new: In-browser Postgres with an AI interface
#48> Please connect from a laptop or desktop to use postgres.new. There's nothing wrong using Webkit / Safari on your laptop or desktop. There are dozens of us, DOZENS!
fwiw this will show for 2 reasons: 1/ you're using a small window (even on Chrome/FF). We don't support mobile yet, so if you're seeing this on a desktop just expand the window 2/ you're on safari, which doesn't have support for OPFS yet: https://github.com/electric-sql/pglite/pull/130
Re: Postgres.new: In-browser Postgres with an AI interface
#49Clicking "New database" doesn't do anything for me...? No changes in the UI, and no messages in the console. Admittedly I'm not signed in with Github, but isn't that only for the AI thing (that really I don't want to use). Edit: Okay reading kiwicopple's comment makes it clearer that chatGPT is not-optional. I'm... not enthused by this. Why would you take something that's local-first and gatekeep it with something as…
You need to start typing after clicking on the button. It needs some UX rethinking, but no bugs, just start typing on the chat
Re: Postgres.new: In-browser Postgres with an AI interface
#50> Please connect from a laptop or desktop to use postgres.new. There's nothing wrong using Webkit / Safari on your laptop or desktop. There are dozens of us, DOZENS!