Live data from Hacker News

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

supabase.com

71–80 of 116 posts

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

#72
post #52

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

Apparently it's already so common, it's become a pedagogical task for learning to code with Llms :

https://aws.amazon.com/blogs/machine-learning/build-a-robust...

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

#73

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…

[deleted]

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

#74
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.

Is there a way to query the local instance without using the AI input ?

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

#76

I really do think that software engineering as we know it is ending. It will take 3-5 years for tools like this to mature. But it will happen, and hard fought skill sets like SQL database design, query design, and maybe even ORMs will become obsolete. My biggest prediction is that ORMs will not be necessary when LLMs can generate SQL. Low level SQL is a better abstraction for LLMs than ORMs, and as people are removed…

Reducing barrier to entry is not a bad thing

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

#77

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…

We tested several models and GPT-4o was the most accurate and makes the most sense for our initial launch That said: it's 100% our intention to add local models. This is just our v1.

I think the point is that many of us would like this without any AI in it, just a simpler Postgres playground in the browser, much like the Rust or Go playgrounds.

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

#78

Earlier quoted context omitted.

We tested several models and GPT-4o was the most accurate and makes the most sense for our initial launch That said: it's 100% our intention to add local models. This is just our v1.

I think the point is that many of us would like this without any AI in it, just a simpler Postgres playground in the browser, much like the Rust or Go playgrounds.

> just a simpler Postgres playground in the browser...

Then you want pglite. This project uses it and provides a link to it.

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

#79
post #74
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.

Is there a way to query the local instance without using the AI input ?

at this stage there is not, but you can just write SQL and the LLM is smart enough to run it directly on the database.

I can see some situations you might want direct access to postgres, so we'll jot that done as something to look at too

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

#80

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

It can be annoying on IOS. For example OPFS only works inside worker threaders, so you may design your app to access OPFS from the app + OPFS from postgres and realize OPFS isn't working in half your app... Happened to me when I built https://cluttr.ai which uses SQLite WASM
Post reply on HN