Notes
Atom FeedFixing Mariadb --Column-Statistics Errors
Recent versions of mysqldump include a config to include a COLUMN_STATISTICS
table. While StackExchange answers
recommand passing a --column-statistics=0 flag to mysqldump, this isn’t
always possible, e.g. when some
code like Django is running
mysqldump for you.
Instead of patching your mysqldump calls, if you recently upgraded from
using mysql to mariadb, you should check if you’re still using the Oracle
mysql version of mysqldump. Switching to the mariadb version of
mysqldump may solve your problems. On ubuntu/debian, you can do so with
apt update
apt remove mysql-client
apt install mariadb-client
Geographic Geometry Simplification
Simple explanation: Remove points PX that are less than the distance between the significant points P<X and P>X.
Simple explanation: Remove the point PX that forms the minimum area triangle with PX-1 and PX+1. Repeat until the area is above a threshold.
Linters
A list of linters that I use for my projects:
| Language | Linter |
|---|---|
| Python | black |
| Python | flake8 |
| Go | GoVet |
| Go | Staticcheck |
| Go | Errcheck |
| Go | Golangci-lint |
| Javascript | eslint |
| Bash | Shellcheck |
| Makefile | Checkmake |
| Dockerfile | Hadolint |
| Nginx | Gixy |
| Vimscript | vint |
| LaTeX | chktex |
Installing Mysqlclient in Python Slim Docker Image
Installing the mysqlclient python
package in a python:3.11-slim
docker container fails because the slim version leaves out the libraries needed
to compile mysqlclient. Rather than using the full python:3.11 base image
that is much larger, you can install the mysqlclient dependencies manually:
FROM python:3.11-bullseye
# Install mysqlclient debian package dependencies
RUN apt-get update && apt-get install -y --no-install-recommends \
libmariadb-dev-compat gcc `: MySQL client` \
&& rm -rf /var/lib/apt/lists/*
# Install mysqlclient python package
RUN pip install --no-cache-dir mysqlclient
Processor Trends
42 Years of Processor Data
Permalink