Today I was reading the documentation for identifier limits for MySQL and MariaDB. Pretty much everything is 64 characters (not bytes) with Unicode support (UTF-8 internally).
MySQL/MariaDB Identifier Length Limits
Reply
Well. Turns out you can only chain up to five USB hubs. I know, because I tried to chain six. I feel like this is a life accomplishment, and it should unlock a secret level or something. After finding this limitation myself, ChatGPT confirmed it.
This via r/programming today: Recommended Pagination for APIs. Keyset pagination is an approach I’ve seen recommended a fair bit lately…
I had an error tailing my web logs, like this:
==> test.jj5.net-error.log <== tail: inotify resources exhausted tail: inotify cannot be used, reverting to polling
I found tail: “inotify resources exhausted” and/or “inotify cannot be used, reverting to polling: Too many open files” which said to edit /etc/sysctl.conf with:
# # 2017-05-03 jj5 - SEE: tail inotify resources exhausted: # https://nefaria.com/2014/08/tail-inotify-resources-exhausted/ # fs.inotify.max_user_watches=1048576
Then to apply the new settings:
# sysctl -p
Today I learned about LIMIT and OFFSET in PostgreSQL, which differs slightly from its MySQL cousin.