Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

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

supabase.com

Post reply on HN
Print view View original

51–60 of 116 posts

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

#51

Post by Kiro »

kolbe wrote: 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…

I don't know enough to endorse a specific one but there are probably hundreds of services doing text-to-SQL using LLMs. "Chat with your database" is one of the most popular products in the space.

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

#52

Post by Kiro »

TechDebtDevin wrote: post #35
kolbe wrote: 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…

I'm in the middle of building something like this but it's not ready yet. You'll just provide an openAI/anthropic api key and connection details to the db/schema. I intend for it to work a lot like postgres.new but with regular postgres instances.

I presume you've done your competitor analysis because it's a really crowded space.

https://news.ycombinator.com/item?id=41227656

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

#53

Post by CodesInChaos »

GordonS wrote: post #40

This is so cool, "just because we could", but I am curious about possible use cases for Postgres in the browser?

Playgrounds like this which don't need server resources.

Adding offline support (PWA) to an application which was primarily designed for use on a server. Though I'm not sure how well that'll work in practice, since the rest of the application will be designed to run on a server as well.

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

#55

Post by righthand »

ldjkfkdsjnv wrote: post #38
righthand wrote: post #14

Earlier quoted context omitted.

We already had SQL model and code generators well before LLMs. What does adding in random output do to improve that?

You havent been using these tools if you think this

Yes I don’t need to use these tools because I already have code generators. Wondering about config options I use documentation or a search engine. It’s cute to put them together in a single UI but it doesn’t make these tool inherently more intelligent. It just saves me a few alt+tabs.

An LLM is just taking prefabbed templates and swapping the possibilities in the answer for a statistically relevant solution. My code generator outputs a prefabbed template with a deterministic solution no statistical guessing required.

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

#57

Post by kiwicopple »

xyst wrote: post #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 com…

> at least give mobile a synopsis of what it’s suppose to do

agreed - we rushed this one a bit. we're working on some some updates now for mobile users

edit: we've shipped some changes for mobile which embed the video and link to the blog post so that it's a bit clearer. Thanks for the feedback

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

#58

Post by TechDebtDevin »

Kiro wrote: post #52
TechDebtDevin wrote: post #35

Earlier quoted context omitted.

I'm in the middle of building something like this but it's not ready yet. You'll just provide an openAI/anthropic api key and connection details to the db/schema. I intend for it to work a lot like postgres.new but with regular postgres instances.

I presume you've done your competitor analysis because it's a really crowded space. https://news.ycombinator.com/item?id=41227656

Well this is the second time Supabase has had a product announcement very similar to mine.

My implentation is more focused on data analysis and visualization via a natural language interface.However, the straighforward database operations that postgres.new tries to tackle are included.

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

#59

Post by astockwell »

jedberg wrote: post #24
simonw wrote: post #15

Earlier quoted context omitted.

Giving everyone a smartphone with a great video camera built in didn't obsolete the field of cinematography. I don't think giving everyone tools to help them build software will obsolete software engineering.

Are you sure? Most of the popular videos today do not have what one would call great cinematography, but it doesn't seem to matter. No one cares. Sure, movies still use cinematographers, but movie watching time is getting eaten up with Instagram/TikTok, where cinematography doesn't matter. I fear applications will suffer the same fate. "Good enough" will take over "well-architected".

I think you are 100% spot-on. Good enough has always been fine for the vast majority of people and the vast majority of use-cases.

Couple this with decreasing costs of storage (and ideally compute), and it doesn't matter if the data model is garbage, people can still get something workable that's better than the awful Excel files they curate now. It will still make errors, but eventually fewer than their spreadsheets.

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

#60

Post by foragerdev »

AlexErrant wrote: post #7

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…

Design does not communicate well; you need to sign in with your GitHub to create new database or even type into Input field. Infact it says "To prevent abuse we ask you to sign in before chatting with AI." Which they do not, you have to do it yourself. Why show create "New database" button and Input field before user sign in?
Post reply on HN