what kind of data load are we talking here? I know it gets stored locally. So, is it limited by my local disk size?
How will it perform if I have 1TB of data?
Postgres.new: In-browser Postgres with an AI interface
21–30 of 116 posts
Re: Postgres.new: In-browser Postgres with an AI interface
#22From a quick play this is pretty cool! The design choices it made all seemed pretty sensible to me. For example I asked it to create a schema to support a chat application and it came up with something that works pretty well. I then asked it to modify the schema to support various different bits of functionality (e.g. adding support for images in messages, and soft deleting participants from chats) and it was able to handle all those. In addition it was suggesting sensible constraints (foreign keys, nullable, unique) where you'd expect them.
Good work
Re: Postgres.new: In-browser Postgres with an AI interface
#23Hey 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…
[deleted]
Re: Postgres.new: In-browser Postgres with an AI interface
#24I 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…
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".
Re: Postgres.new: In-browser Postgres with an AI interface
#25> 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!
Why not just display a warning and let me try anyway? How sure are they that their filtering out absolutely every device that can't run it successfully. Why risk denying it unnecessarily?
Re: Postgres.new: In-browser Postgres with an AI interface
#26> 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!
I was getting that in firefox on my desktop as well. I had it in a half sized window, but making it full screen let me move past.
It throws an error when its full screen though. There is more to the error, but it wont let me copy it.
indexDB.databases is not a function.Re: Postgres.new: In-browser Postgres with an AI interface
#27> 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
#28> 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!
Why not just display a warning and let me try anyway? How sure are they that their filtering out absolutely every device that can't run it successfully. Why risk denying it unnecessarily?
I think it checks for the APIs it needs, and bails when they are unavailable. Atleast, that’s what I feel given the brief flash of the application before the warning replaces it.
Re: Postgres.new: In-browser Postgres with an AI interface
#29This is seriously impressive. I asked it to create 3 different databases:
- a customer orders database with products with a timeseries of prices, and multiple fulfilments per order. - an issue tracking system with a reflexive user/manager database - a family relationship model
In each case I got it to put in sample model and then asked postgres.new to answer some questions about the data it had inserted. I thought the family model would trip it up, especially when I told it to put in cousins and uncles. But no, it was pretty bang on.
The only thing it didn't quite manage is that some of the relationships are reciprocal (i.e. my sibling also has me as a sibling).
I asked postgres.new to review the data and it fixed some, and i asked it to check again and it fixed the rest. This is a very useful tool that I can see myself using!
Re: Postgres.new: In-browser Postgres with an AI interface
#30I 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…
LLMs don't have the context to make good decisions though. You need all of that hard fought skills to make those decisions. And people are the only ones that can have the context enough to actually make decisions. Not only that, but AI is way more expensive than we think. We're currently in a hype bubble funded by last ditch effort VC money. When that money runs out, and it will eventually, AI is going to get WAY mor…
I personally think LLMs make much better decisions than me. I often have a design in mind and then when I prompt Claude it gives me a much better one, and also takes a lot of edge case into account that I didn't even think of. Maybe I'm a useless programmer but I'm sure I'm not the only one.