Update learning

[rbdr/txt] / learning.md

diff --git a/learning.md b/learning.md
index e9e60741ac84547f3b69a8bee643eb1b43127fbb..d1f18ce3e687e4ab191ee43d4ddef396a77660e1 100644 (file)
--- a/learning.md
+++ b/learning.md
@@ -1,3 +1,8 @@
+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-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.