swe

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.

On November 13th, we publicly launched Filecoin Station, a desktop app enabling everybody to participate in the Filecoin economy and earn FIL for contributing their spare computing resources & network bandwidth. (You can download the app here: https://www.filstation.app). The launch was a success, and our network grew from ~50 to more than ~1500 nodes in a few days. As of today, we have 4000 nodes running. We quickly discovered that our database was having a hard time keeping up with the increased load.

Frontend can be about more than just code—we’re also the last bastion helping our teams against pesky design bugs! We share 7 best design practices for frontend engineers.

Thanks for signing up to The Rundown built by @therundownai and @rowancheung! Enjoy our free Advanced ChatGPT Guide as a warm welcome into the world of AI!

Introducing River, a Postgres-based job queue designed for resilience and correctness through strong transactional guarantees.

Sign up for MightyMeld with code "COSDEN" → https://www.mightymeld.com/Join The Discord! → https://discord.cosdensolutions.ioVSCode Theme | Font → Material ...

Open source generative AI projects are a great way to build AI-powered features and apps.

Set up self-healing URLs with the App Router in Next.js for better SEO, accessibility, and usability

Color Lisa is a curated list of color palettes based on masterpieces of the worlds greatest artists. Each palette was painstakingly created by color obsessed designers, artists, museum curators, and masters of color theory.