Live data from Hacker News

Postgres.new: In-browser Postgres with an AI interface

supabase.com

41–50 of 116 posts

Re: Postgres.new: In-browser Postgres with an AI interface

#41
post #31

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.

Hey my guy, just letting you know that I'm pretty excited about the whole PGLite project (sorry if my comments above sounded overly negative >_>, managing expectations and all).

Re: Postgres.new: In-browser Postgres with an AI interface

#43

Hey 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…

which mobile browsers can this run on? seems like its not happening on Safari on iPhone. If it did that would be a game changer. Any status on whether ElectricSQL can run on mobile devices in general?

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

#44
Normally not a fan of the “AI/LLM” + {existing workflow} headlines that companies have been pumping out but honestly. This might be a decent case. In my experience, LLM is pretty good at generating on the fly data for inserting into databases. So instead of hand rolling or building a query to insert data, it would be easier to query LLM.

Overall, 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

#45
post #39
post #17

Basic 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.

Mine has been a little bit more along the lines of helping them understand how everything is linked. They can't really even understand the power of JOIN, which greatly reduces the power of what I set up. Basically, I'm sort of stuck in a place where I built something that's too powerful for them to use, and I can see an LLM finally bridging that gap

Re: Postgres.new: In-browser Postgres with an AI interface

#46
post #34

Earlier 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.

my bad - it has been a crazy week with lots of messages flying around. You're right about safari

Re: 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

It would be worth spending a few minutes improving this notice. Give more context for what the heck this is, and distinguish between "your screen is too small" and "you're using a browser that doesn't have the API we need".

Re: Postgres.new: In-browser Postgres with an AI interface

#49

Clicking "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…

> Clicking "New database" doesn't do anything for me...?

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!

There are way more than dozens. In fact, it looks like Safari is (probably) ahead of Firefox on desktop: https://gs.statcounter.com/browser-market-share/desktop/worl... (9.1% Safari, 6.6% Firefox), https://www.similarweb.com/browsers/worldwide/desktop/ (7.6% Safari, 5.7% Firefox), https://radar.cloudflare.com/reports/browser-market-share-20... (scroll to "Market Share by OS" and select "Desktop"; Cloudflare is the one that shows Safari behind Firefox at 6.6% marketshare compared to Firefox at 7.2% - but also 39% of Mac users are on Safari, a highly valuable demographic given the higher-income skew of Mac users as well as the fact that a third of professional developers are on Mac (and only 47% on Windows according to Stack Overflow's survey)).
Post reply on HN