swe

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.

Struggling to come up with a data engineering project idea? Overwhelmed by all the setup necessary to start building a data engineering project? Don't know where to get data for your side project? Then this post is for you. We will go over the key components, and help you understand what you need to design and build your data projects. We will do this using a sample end-to-end data engineering project.

Blog about linguistics, programming, and my projects

If you don't often look beyond established comfortable defaults, you might be surprised to learn just how far the world of frontend has moved away from React, and how big that gap continues to grow.

A deep dive into the evolution of React from client-side view library to application architecture.

A collection of bad practices in HTML, copied from real websites.

We know we should do it, but do we know how?

Latest: 12/16 version: 0.7 First published 10/26. This is an amalgam of TTP's on different offensive ML attacks encompassing the ML supply chain and adversarial ML attacks. It is focused heavily on …

Site Reliability Engineering, incident management, learning, lessons learned, SRE

Last weekend I had a chance to talk with some students who just got their degree. They are pursuing their first software engineer job. In conversation with them, I learned that they have a pretty wrong perception of this job. This is because the reality for these new kids is so skewed.

A list of JavaScript engines, runtimes, interpreters · GitHub

Build a time-series graph or plot to quickly visualize data using Postgres materialized views and their upgraded version, continuous aggregates.

A collection of bad practices in HTML, copied from real websites.

Hey, I'm [Fabio](https://twitter.com/fabiospampinato) and I've been contracted by the Prettier team to speed up Prettier's command line interface (CLI). In this post we'll take a look at the optimizations I've discovered, the process that lead to finding them, some exciting numbers comparing the current CLI with the new one, and some guesses about what could be optimized next.