swe

Hacking on PostgreSQL is really hard. I think a lot of people would agree with this statement, not all for the same reasons. Some might poin...

Let's see how to navigate the Chrome Devtools Performance tab to effectively analyse and improve the performance of your JavaScript while avoiding common errors. Our use case will be improving the rendering FPS of a real-world canvas library.

GraphQL is an incredible piece of technology that has captured a lot of mindshare since I first started slinging it in production in 2018. You won’t have to ...

If you've ever wanted to learn about Rendering patterns on the web like Client Side Rendering, Server Side Rendering and other rendering patterns we have, th...

JavaScript Frameworks generally do a lot of DOM handling for you, but doing it yourself can be the most performant option, and there are quite a few best practices.

We like open source, we develop open source software, and we are very active and well known at Postgres community. We also develop custom products for clients, always around Postgres environment

Last month, we shipped a release candidate for v15, which starts to address some of the community feedback on caching. tl;dr many parts are no longer cached by default. In Next.js 15, if I make a fetch to some API, or make a… — Lee Robinson (@leeerob)

The author discusses the React 19 change that went unnoticed until last week that could potentially degrade the performance of websites that rely React.

Is it like the ocean?

Performance optimizations for the interaction to next paint metric and sharing the learning along the way

A boolean value should only contain two values, True or False, but is it correct? Usually people...

This course is designed for those new to web performance, a vital aspect of the user experience. It covers key web performance concepts and techniques for improving performance.

Learn the theory and the details of how to speed up PostgreSQL® pgvector queries using indexes IVFFlat, HNSW and traditional indexes

A technical look at how we optimized the performance of Hardcover over the last year.

Five viewer submitted ways that bad React practices and anti-patterns are killing their applications, and some solutions for each one.👉 Upcoming NextJS cour...

An overview of one of the most fragmented industries in tech

Best-in-class Design Systems with components and foundations references from top-tier tech companies and leading UI teams.

Explore this post and more from the selfhosted community

Speaker: Vagmi Mudumbai While PostgreSQL is a mature database, it packs a punch when it comes to features. This is a talk to talk about various features of PostgreSQL like. * Crosstab queries (Pivot Table) * Window functions * JSON operations * Full-text search queries * Row-level security

In this video I'm doing "magic" binary search. This search fallbacks to linear search when the number of tuples is small. Typically this is done to reduce number of branch mispredictions, but it's rather toy feature here. It's taken only for example. Resulting code https://github.com/x4m/postgres_g/commit/a66ff4e0669b01ea09eed734cf4e60c745527c5c https://wiki.postgresql.org/wiki/Compile_and_Install_from_source_code git clone --depth=5 --single-branch --branch=master https://github.com/postgres/postgres cd postgres ./configure --prefix=$PWD --enable-depend make -j10 to /dev/null make check

A new demand for storing an old data type in PostgreSQL.

Breaking down major databases like PostgreSQL by category and purpose.