RSS has long had the element that can be used to include the contents of an . For example, you could use it to include the entire contents of a blog post; or just a summary of it. However, the RSS element is only suppose to be used to include plain text data. This obviously lim … | Continue reading

PostgreSQL queries can be sped up by creating the right indices, and making sure that the indices are being used. It's a tale as old as SQL databases - there's a critical code path being hit many times per second, but its queries are inexplicably slow. ⚠️ This post links to an ex … | Continue reading

I've been using GitHub's Dependabot since it was released around 4 years ago, and to a large extent, it's been great. Except for one thing: the sheer amount of pull requests Dependabot would open for dependency updates. For some of my repositories it became more of a chore to kee … | Continue reading

When I worked as a contractor to the US government at ad hoc, I was fortunate enough to get the opportunity to design large parts of a relaunch of medicare plan compare, the US government site through which hundreds of thousands of medicare recipients purchase their health care p … | Continue reading

The following are instructions for using the erlang core plugin. This is used when there isn't a git plugin installed named "erlang". The code for this is inside the mise repository at ./src/plugins/core/erlang.rs. ⚠️ This post links to an external website. ⚠️ | Continue reading

Documentation for FakerPHP / Faker randomDigit# Generates a random integer from 0 until 9. echo $faker->randomDigit(); // an integer between 0 and 9 randomDigitNot# Generates a random integer from 0 until 9, excluding a given number. echo $faker->randomDigitNot(2); // 0, 1, 3, 4, … | Continue reading

I probably hate writing code in your favorite programming language, whatever it may be. This is because I get frustrated by basically all of the top 10 languages you'll find listed anywhere for various reasons. Do I hate programming in Python? You bet I do. "But it's Python! Pyth … | Continue reading

We spend a lot of time advising startups. Though one-on-one advice will always be crucial, we thought it might help us scale Y Combinator if we could distill the most generalizable parts of this advice into a sort of playbook we could give YC and YC Fellowship companies. Then we … | Continue reading

The 2-page login pattern is becoming pervasive. Here are the reasons behind this design choice and alternative solutions to create a more efficient and user-friendly authentication experience. ⚠️ This post links to an external website. ⚠️ | Continue reading

When working on multiple tasks, it's important to consider performing them concurrently. However, when using concurrency, we need to be careful not to overload our system resources. In this article, we will cover the following: What is concurrency? How can we use concurrency in E … | Continue reading

At Octomind, we use AI agents with multiple LLMs to automatically create and fix end-to-end tests in Playwright. Until just a few months ago, we did it with the LangChain framework. In this post I'll share our struggles with LangChain and why replacing its rigid high-level abstra … | Continue reading

Today, I was having issues connecting from a Laravel app to a PostgreSQL database on Digital Ocean. The error message I was getting was the following: SQLSTATE[08006] [7] could not connect to server: Resource temporarily unavailable. The weird thing was that it was not happening … | Continue reading

I was doing performance testing on a Laravel application and wanted to see the SQL queries that were being executed. As I was running the tests in a terminal, I wanted to see the queries in a nicely formatted way. I found a package that does this, but it's not Laravel-specific. I … | Continue reading

Sometimes, you have these .pkg installer files on macOS. Today, I needed to extract them to see what's inside. Here's how you can do it: 1xar -xf MyInstaller.pkg If there is a file called Payload in there, you need to unpack it again: 1cat Payload | gunzip -dc | cpio -i Inspira … | Continue reading

You can uninstall the Panda Adaptive Defense or Endpoint Protection software manually from the operating system?s control panel, or remotely from the Computers area or from the Computer protection status and Licenses lists. ⚠️ This post links to an external website. ⚠️ | Continue reading

I wanted to demonstrate the relationship between the logical model and a physical model. We're going to design a commonly seen use case: many yes/no attributes of a single anchor (in our case, Restaurant). Then we'll discuss how the physical tables would be designed. We'll see th … | Continue reading

To import CSV files into SQLite, you can do this in your terminal: 1sqlite3 mydatabase.db 2SQLite version 3.43.2 2023-10-10 13:08:14 3Enter ".help" for usage hints. 4sqlite> .import --csv mydata.csv table_name If the table already exists and the field names don't match the heade … | Continue reading

When we first got the personal computer, we didn't worry much about how things worked. We were, frankly, stunned that we even had such a thing. You had to learn some arcane lingo to type into a DOS prompt. That the computer might be difficult or awkward to use didn't occur to us. … | Continue reading

Most people think that we format Go code with gofmt to make code look nicer or to end debates among team members about program layout. But the most important reason for gofmt is that if an algorithm defines how Go source code is formatted, then programs, like goimports or gorenam … | Continue reading

In this database design tutorial (~9000 words) I'm going to show how to design the database tables for a real-world project of substantial complexity. We'll design a clone of Google Calendar. We will model as much as possible of the functionality that is directly related to the c … | Continue reading

Many LLM applications involve retrieving information from external data sources using a Retriever. A retriever is responsible for retrieving a list of relevant Documents to a given user query. The retrieved documents are often formatted into prompts that are fed into an LLM, allo … | Continue reading

At work, I recently had the need to use the Laravel migrations for multiple databases. Long story short, our main database is MySQL but we also use PostgreSQL as an AI vector store. I wanted to use the Laravel migrations to create the tables in both databases. It turns out to be … | Continue reading

Today, I learned how to purge the binlogs from MySQL: 1PURGE BINARY LOGS BEFORE now(); You can read more about it in the MySQL documentation: 1PURGE { BINARY | MASTER } LOGS { 2 TO 'log_name' 3 | BEFORE datetime_expr 4} The binary log is a set of files that contain informat … | Continue reading

If you want to stream a HTTP download to a file when using the Laravel HTTP client, you can do this: 1$resource = \GuzzleHttp\Psr7\Utils::tryFopen('/path/to/file', 'w'); 2 3Http::withOptions(['sink' => $resource])->get('url'); You can read more about the sink option in the Guzzl … | Continue reading