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

61–70 of 116 posts

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

#61

Post by breadwinner »

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…

If you want to use an LLM to type queries in English, Visual DB can do it: https://visualdb.com/

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

#62

Post by codingwagie »

righthand wrote: post #55
ldjkfkdsjnv wrote: post #38

Earlier quoted context omitted.

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…

You dont understand how powerful LLMs are. Go use claude sonnet 3.5. Paste in 1000 lines of code, and describe a code change you want to make. Iterate on the solution it gives. Do this for a week.

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

#63

Post by jgoux »

netcraft wrote: post #47

this looks awesome. Is it possible to create a database and load it with data and then share it with others? Would be amazing for teaching SQL, but also just many data collaboration tasks

Yes, we are working on it. It should be available very soon!

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

#64

Post by righthand »

codingwagie wrote: post #62
righthand wrote: post #55

Earlier quoted context omitted.

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…

You dont understand how powerful LLMs are. Go use claude sonnet 3.5. Paste in 1000 lines of code, and describe a code change you want to make. Iterate on the solution it gives. Do this for a week.

If I did that I would waste so much time. I know what code is in my codebase. Maybe if I was a novice this would be effective to help me learn it. Is the point of the exercise to wow myself for a week that an LLM can spit out solutions?

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

#65

Post by kiwicopple »

localfirst wrote: post #43
samwillis wrote: post #3

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

Everything is open source with the exception of the LLM at the moment, which we'll get to. Here are all the tools:

* postgres-new (https://github.com/supabase-community/postgres-new): The frontend. Apache 2.0

* PGlite (https://github.com/electric-sql/pglite): A WASM build of Postgres. Apache 2.0

* pg-gateway (https://github.com/supabase-community/pg-gateway): Postgres wire protocol for the server-side. MIT

* transformers.js (https://github.com/xenova/transformers.js): Run Transformers directly in your browser

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

#66

Post by codingwagie »

righthand wrote: post #64
codingwagie wrote: post #62

Earlier quoted context omitted.

You dont understand how powerful LLMs are. Go use claude sonnet 3.5. Paste in 1000 lines of code, and describe a code change you want to make. Iterate on the solution it gives. Do this for a week.

If I did that I would waste so much time. I know what code is in my codebase. Maybe if I was a novice this would be effective to help me learn it. Is the point of the exercise to wow myself for a week that an LLM can spit out solutions?

No its that it will code a days worth of work in a few minutes

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

#69

Post by kiwicopple »

fsiefken wrote: post #68

Nice! If it’s WASM it should also work on iOS, so why can’t I connect? Pg.dev works though. I wonder if postgresql wasm can be made to run on A-Shell, even though there is a working SQLite wasm port running on A-Shell, which should be enough

we're working on this right now - I don't know if we'll get it out for today, but it will certainly be available this week
Post reply on HN