ERROR: invalid byte sequence for encoding
One common problem that a lot of people seem to have is when they encounter error message like this:
psql:test.sql:1: ERROR: invalid byte sequence for encoding "UTF8": 0xb3
Why it happens? What can be done about it? Let’s see.
Explaining 4K 60Hz Video Through USB-C Hub
USB-C promises to use one port for everything. USB-C converters to DisplayPort or HDMI are common and inexpensive. USB-C hubs with external monitor support are also common, but understanding their capabilities and limitations can be extremely confusing. Some are Mac-compatible and some aren’t. Some need driver software
Postgres is Out of Disk and How to Recover: The Dos and Don'ts
One frustrating thing that can happen to your database has nothing to do with performance and queries. Rather, it’s running out of disk space to store data. Today we’ll drill into some good practices you can put in place to help prevent such from happening. And if it does, show how to get you out of a bind as quickly as possible.
Boyer-Moore string search algorithm explanation and formal verification using CBMC
If a substring would be compared in reverse order, things may be different. For example, we search for a ‘CAT’ substring in ‘HORSE TURTLE CAT’ string. With naive algorithm, we will first compare ‘H’ and ‘C’, we see they are unequal characters and we will advance substring one character ahead. But if we start at the end of sub string
CAT we can jump back 3 character at a time.
SRE Case Study: Mysterious Traffic Imbalance
Given their large scale operation, if any bug in network that arise, ebay sure experienced it. So Charles ended up with many Sherlock Holmes stories to tell. And this post is a troubleshooting case of mysterious traffic imbalance.
Dynamic Programming vs Divide-and-Conquer
In this article I’m trying to explain the difference/similarities between dynamic programing and divide and conquer approaches based on two examples: binary search and minimum edit distance (Levenshtein distance).
Resources for Amateur Compiler Writers
This is a page for amateur compiler writers. Anything that I did not find practical is not listed here. (I also did not include the things that I do not yet know!)
Code to read
Geospatial data library for Ruby. They are also looking for a maitenance
a Golang library for spawning and managing a goroutine pool, allowing you to limit work coming from any number of goroutines with a synchronous API.
All Algorithms implemented in Python. I’m sure you will find some gem in here for your favourite algorithm.
Like tmux but written in Rust. Rust is started to being used in many low level CLI stuff. It has layout system and a plugin system that leverage WebAssembly. The plugin has hook in load update, render state to allow you control how to render certain thing. Such as writing a status bar.
Open source self-hosted web archiving. Takes URLs/browser history/bookmarks/Pocket/Pinboard/etc., saves HTML, JS, PDFs, media, and more…
high-fidelity infrastructure monitoring and troubleshooting. Open-source, free, preconfigured, opinionated, and always real-time.
The smartest (no)SQL database client
Move messages from one maildir to another. Useful if you spend lot of time with Postfix
Open-source vector similarity search for Postgres
an open-source abstraction layer library that turns easy apps deployment on AWS, GCP, Azure, and other Cloud providers in just a few minutes.
That's it for this round, have a great day! If you like this newsletter, please tell the world, or
tweet about this