2021/09/21
That the IANA suggests 49152–65535 (215 + 214 to 216 − 1) for dynamic or private ports. source: https://en.wikipedia.org/wiki/Ephemeral_port#Range
tags
2022/05/31
That sql has assertions:
CREATE ASSERTION <Constraint name>
CHECK (search condition)
[ <constraint attributes> ]
see https://crate.io/docs/sql-99/en/latest/chapters/20.html#create-assertion-statement.
h/t https://www.scattered-thoughts.net/log/0024/ for bringing that to my attention.
Also, from the weekend: in postgres, at least, you can call TABLE :table_name; directly to SELECT * FROM :table_name;
Also: how to look up a domain name from an ip:
reverse_ip_lookup() {
ip_address="$1"
dig -x $ip_address +noall +answer
}
Also: how to audit AWS VPC flow logs from CloudWatch Log Insights: use the example queries in the right sidebar.
Also: python can execute .zip files directly, like so:
:; echo 'print("Hello, World!")' > __main__.py
:; zip hello-world.zip __main__.py
:; python3 ./hello-world.zip
## Hello, World!
h/t https://pradeepchhetri.xyz/til/pythonzip/ for pointing that out.
2022/08/31
That linux has a capability system: https://man7.org/linux/man-pages/man7/capabilities.7.html
I heard about this in a discussion of privileged ports on linux, specifically about PRIV_NET_PRIVADDR.
2022/09/30
that OCSP stands for Online Certificate Status Protocol. See https://en.wikipedia.org/wiki/Online_Certificate_Status_Protocol
2023/05/15
That powerline networking kits exist: they send signals over home electrical wiring to extend your home network. Similarly, MoCA (Multimedia over Coaxial Alliance) sends signals over coax cable.
2024/10/15
What an anycast IP is:
Anycast is a network addressing and routing methodology in which a single IP address is shared by devices (generally servers) in multiple locations. Routers direct packets addressed to this destination to the location nearest the sender, using their normal decision-making algorithms, typically the lowest number of BGP network hops. Anycast routing is widely used by content delivery networks such as web and name servers, to bring their content closer to end users.