Postgres

“In an era where you can build an, you know, a website and a web application with a Postgres database behind in 30 seconds, Software is just commoditized. Software is just tokens. Code is tokens.”

“Misconception right now is that you can just have, you know, Postgres database and APIs, and then bam, like you can replace SAP. That's like absolutely not true. That piece around the logic and everything else that is in captured in SAP is way, way more import…”

“This is sort of the holy grail of database engineering is, why not build a single system that can do both of this? But it ends up just being a lot of compromises. And one, I think one of the first issue is that, hey, each, they say Postgres has a massive ecosy…”

“And as a matter of fact, once you transcode the data compresses better. So from those services writing to, for example, S three or other data lake, like object stores, you can actually write them faster because now they are now smaller. So there's no. Overhead…”

“We run on our own software and all of that software sits on one Postgres database that has everything that's important to YC's world in it.”

“The answer is it's Postgres. My Postgres bill is the thing that's gone up the most. It's databases.”

“I think neon neon was first to, and they're trying to retrofit it onto Postgres. And then they built this whole architecture where you have it in memory, and then you sort of like, you know, mmap back to S-III, and I think that was very novel at the time to do…”

“Like at some point, cursor moved like 20 terabytes of Postgres data into Turbo Puffer, because it's like, it's there, it works, and these particular query plans we know work well, and so they just moved it all to defer sharding.”

“And I think we're sort of rapidly moving towards a world where the UI, which largely was the entire business model of SAS for the last 10 years, most of SAS was like, I'm going to build this complex UX on top of a Postgres database, then I'm going to sell it t…”

“Everyone that's going to build a web app going forward is going to build on Supabase. It's, it is the default choice to how to host and manage Postgres in this world.”

“So if you're doing like work in Node or Python, Postgres, MySQL, it works in any REPL and it's a it's a pretty differentiated and cool feature of Warp.”

“So yes, in some cases there are, for many use cases, you can use a general purpose database. People have built stuff on Postgres. People have built time series on Mongo. Like those are highly useful. But if you're ingesting huge amounts of data, you want the q…”

“And I think the race with those is going to be around, like, who can reduce friction the most? Who can spin up a new Postgres database faster?”

“For the longest time, where Notion runs on one instance of Postgres database, and then we find the beefiest machine, we keep scrolling, find a beefier, beefier machine to scale our user base. But then we were running off the, even the largest instance there is…”

“To go and implement a database that's better than Postgres is a, like, Sisyphean task, whereas building tools that are better for Gen.ai than some of the stuff that's about now is not very difficult. Putting the actual models themselves to one side.”

“Like I think what usually I see happens is like initially people just report off whatever their transactional system is. So if you're using Postgres or something and you're, you know, cause you're you've got some application layer. You can report off that for …”

“I mean, it is a flat JSON file. This is stored in a Postgres database. It's not even, A graph database.”

“My conclusion is that this is a very real problem for a very small number of companies, and that is why Datadog, Splunk, Honeycomb, et cetera, built their own database technology, which is, in some ways, it's sad because all of the technology is a remix of pie…”

“So SurrealDB can run as an embedded database, like SQLite. It can run as a single node, like Postgres. Or it can run as a distributed cluster, and you can scale the storage layer, and you can scale the compute layer.”

“At some point, every company gets the scale, every successful company gets the scale where Postgres is not cutting it. And then you migrate to some sort of NoSQL database.”

“Surprisingly there were a lot of Postgres issues when ChatGPT came out because the accounts for like ChatGPT were tied to the accounts in the API. And so you're basically creating a developer account to log into ChatGPT at the time, because it's just what we h…”

“Those other products don't work. They don't work either because they don't scale in terms of the efficiency scale, cost, the trade-offs that they can offer, because they're not designed to do this. They're designed to do something else. They kind of thought ab…”

“I recommend doing this early and often because it gets harder and harder to add missing indices, the bigger tables get. As you start getting into the tens of millions, adding, you know, you basically have to be able to load the table into memory to add the ind…”

“It's just add water GraphQL for Postgres. So if you've got a Postgres database, then you can point Hasura at it and extremely quickly spin up a GraphQL API for it. And subscriptions, queries, mutations, like you get all of those things. It's all code gen. So t…”

“From the point of view of the application developer, it looks like they're talking to a single Postgres database, but it just so happens to be elastically scalable.”

“And so five years from now, the grand vision would be To think about like running your own hiring process versus just using triple byte as being as outdated as hiring engineers to build a database from scratch versus just using MySQL or Postgres.”

“All of our production data is in Postgres, and we will read from the secondaries in AWS. We push all of the Postgres data into Redshift and do a lot of more intensive batch computations off of Redshift. The data science teams are using either Python or R we do…”

“Whenever you go with MM-SQL on EC-II, for example, you will see, like, one millisecond response times, and a Postgres or a MySQL is on the order of 60.”

“We looked at the traditional stuff and we thought, well, you know, could we take something, can we take Postgres and start changing, you know, changing code and make something we like? And we felt like we would never, Land where we wanted to get to if we did t…”