Update learning

[rbdr/txt] / learning.md

diff --git a/learning.md b/learning.md
index 8b113eec908564234a84c90008b70cd91c9ba3fc..d1f18ce3e687e4ab191ee43d4ddef396a77660e1 100644 (file)
--- a/learning.md
+++ b/learning.md
@@ -1,3 +1,11 @@
+2024-01-23: AWS Glue has some very inefficient ways of composing queries, so it's sometimes easier to embed the query itself. In postgres it doesn't let you but you can add sources for each table and then run the query. This seems to work a lot faster.
+2024-01-22: ssl_early_data on; can mess up your responses in safari if you set it in more than one place. What's worse, because of the caching it uses it can be annoying to revert.
+2024-01-21: You can inject HTML and CSS to gitweb without modifying the default files by using $home_text and pointing it to a variable, and push @stylesheets.
+2024-01-20: App groups can let you share application data, but they will create a new container, so unless you have a remote data source it will erase your data. It's better to start new mac or ios projects with a group
+2024-01-19: You can rename the classes in xcdatamodel in order to avoid collisions, in case you named an entity something too generic.
+2024-01-18: MacPPP with modem initialization options works much better than ZTerm + FreePPP, and allows 115200 baud. You just have to set the modem to initialize with AT, and then dial PPP.
+2024-01-17: Mastodon will NOT auto-clean the media directory, which can quickly bubble in size, and you can't ask sidekiq to deal with this so you need to set a cron job. A systemd.timer can handle both cases.
+2024-01-16: With dnsmasq + tailscale you can easily combine your home lab with a remote server and make management a lot easier without exposing some services to the web. A local dnsmasq running on raspberry pi can make sure all local services have a nice name, and then can point an internal url to the vps. In firewalld you need to block connections unless they come from your 100.0.0.0/8 block.

 2024-01-16: You don't actually need the users in unix in some situations, you can use an arbitrary number of the id and if the other system expects it, then it will work. In fact, you can "sudo" into that if runas_allow_unknown_id (then run sudo -u \#9999 <your_command>)
 2024-01-15: SELinux provides restrictions to files I wasn't aware of, and can prevent execution in some contexts. With eza you can view it with -Z.
 2024-01-14: On linux you can see logical volumes inside a partition with lsblk, they're shown as lvm. If you resize a partition, you still need to resize the lvm (eg. with `lvresize -l +100%FREE` to take all remaining free space), AND the filesystem (eg. using resize2fs). This is important eg when installing an OS from an image as you might not be using your whole disk.
 2024-01-16: You don't actually need the users in unix in some situations, you can use an arbitrary number of the id and if the other system expects it, then it will work. In fact, you can "sudo" into that if runas_allow_unknown_id (then run sudo -u \#9999 <your_command>)
 2024-01-15: SELinux provides restrictions to files I wasn't aware of, and can prevent execution in some contexts. With eza you can view it with -Z.
 2024-01-14: On linux you can see logical volumes inside a partition with lsblk, they're shown as lvm. If you resize a partition, you still need to resize the lvm (eg. with `lvresize -l +100%FREE` to take all remaining free space), AND the filesystem (eg. using resize2fs). This is important eg when installing an OS from an image as you might not be using your whole disk.