sa46

8 ms·

61.
by sa46 2y ago
Composite types can be atomic--a string is a composite type. The point (123, 456) is a composite type but is atomic. Good discussion at https://dba.stackexchange.com/questions/2342/what-is-atomic-...
62.
by sa46 2y ago
I wish there were a way to specify the expected join cardinality syntactically for 1:1 joins. SELECT * FROM order JOIN_ONE customer USING (customer_id) Malloy has join_one: https://docs.malloydata.dev/documentation&
63.
by sa46 2y ago
This is essentially a prepared statement, right? https://www.sqlite.org/c3ref/stmt.html
64.
by sa46 2y ago
Link to the actual report [1]. The DOD estimates 4.3-8.4 percent of women experience unwanted sexual contact, based on 8,500 reports, extrapolated to 29,000 estimated incidents. The author argues that the actual rate is 24% of women, using
65.
by sa46 2y ago
Pi seconds is a nano-century. So 1 year = pi*10^7 seconds
66.
by sa46 2y ago
Just spitballing: could you change the database to a bool array? Guard it with a RWMutex and persist on server shutdown. The bottleneck probably moves to pushing updates from a single server, but Go can probably handle a few tens of thousan
67.
by sa46 2y ago
Interestingly, there is an app, Chatterbaby [1], that claims to detect why a baby is crying based on the acoustic features of the cry. I've used it with middling success. That'd be a neat integration: "Alexa, why is my baby c
68.
by sa46 2y ago
I need to map localhost:3000. Ports aren't a part of the hostname, so I can't use /etc/hosts.
69.
by sa46 2y ago
One downside of self-signed certs is that browsers will to upgrade all localhost ports to HTTPS thanks to HSTS. In practical terms, that meant: - we needed to upgrade all dev servers to serve both HTTPS and HTTP. - we downgraded server to s
70.
by sa46 2y ago
You’re likely thinking of Cap’n’Proto or flatbuffers. Protobuf definitely requires parsing. Zero values can be omitted on the wire so there’s not a fixed layout, meaning you can’t seek to a field. In order to find a fields value, you must t
71.
by sa46 2y ago
The HTML source code is a well-commented, fun read. - There's a fair bit of math to model drag, mass, and density using the specific gravity of ice and seawater (with tweaks to make it more realistic for 2d). - Try adding a polygon tha
72.
by sa46 2y ago
You'll get wildly different answers depending on who you ask. Most ex-Googlers appreciate Bazel. Folks used to ergonomic single-language builds dislike it. In my experience, Bazel works best when: - You have a monorepo. - You have one
73.
by sa46 2y ago
Microsoft is prone to severe breaches a few times per year. https://firewalltimes.com/microsoft-data-breach-timeline/
74.
by sa46 2y ago
https://instant.page/ is a take on this idea for web. On mouse down or hover for an <a> element, start a prefetch. This technique hides about 80 ms of latency when triggered on mousedown and up to a few hundred millis
75.
by sa46 2y ago
One interesting caveat is that Uber only uses the Zig toolchain, not the Zig language. https://www.uber.com/en-US/blog/bootstrapping-ubers-infrastr...
76.
by sa46 2y ago
I haven’t used Remix, but I regret choosing react-router due to frequent major version upgrades.
77.
by sa46 2y ago
Joshua Bloch, of Effective Java fame, used the term unintentional object retention as a more precise term for memory “leaks” in garbage collected languages.
78.
by sa46 2y ago
I used to be a logistics officer for an Infantry battalion. Most of the comments down thread underestimate water consumption. Depending on the climate, you'll want the following daily quantities [1]: - 2-3 gallons for drinking - 1.5 ga
79.
by sa46 2y ago
That’s a strong assertion. There’s plenty of status codes that indicate something bad happened at the HTTP level but don’t convey information about the RPC. - 404 might mean the URL was wrong - 405 might mean swapping POST with PUT
80.
by sa46 2y ago
I prefer to treat HTTP as a transport layer. A 200 means the transport succeeded but doesn’t indicate that the RPC succeeded.
81.
by sa46 3y ago
Is the set of integer sequences uncountably infinite? It seems like Cantor's diagonal argument would work here. 1. Number all sets from 0. 2. Construct a new set by picking the i^th number from each set.
82.
by sa46 3y ago
Pinch to zoom magnifies part of the page. That’s less helpful for text because you have to scroll the smaller viewport to read a complete line of text. On iOS, there’s a text scale button in the URL bar which does the trick.
83.
by sa46 3y ago
Is the pricing per user? $15/mo for an entire org sounds too good to be true.
84.
by sa46 3y ago
I suspect the author meant that gofmt doesn’t break lines, which dramatically simplifies the complexity. See https://journal.stuffwithstuff.com/2015/09/08/the-hardest-pr... for a fun, related read.
85.
by sa46 3y ago
I’ve been pretty happy with Slab. Straightforward shared wiki with a good editor, governance, and integrations. https://slab.com/ I tried using README files in the repo but there’s far too much friction to get most folks to
86.
by sa46 3y ago
Related discussion Why PostgreSQL doesn't have query hints https://news.ycombinator.com/item?id=2179433 (60 comments, 2011) The official stance from the Postgres wiki https://wiki.postgresql.org/wiki&
87.
by sa46 3y ago
Oh man, last week we had a small outage. Database queries took much longer than normal. I just so happened to be doing ad-hoc querying on the same table at the same time. “Luckily”, the problem was unrelated to my querying but two coinciden
88.
by sa46 3y ago
Reliably benchmarking optimizing VMs like Java and JavaScript is a research problem. See “Virtual machine warmup blows hot and cold”. The authors run a variety of benchmarks (with a pristine methodology) and find 43% of them provide “bad i
89.
by sa46 3y ago
Seems like a compiler should be able to convert division to shifts and subtractions. > u8 divmod 58 can be reduced to a u8->u16 multiply, a right shift, and three conditional subtractions; that's not great, but on a modern CPU it
90.
by sa46 3y ago
I worked with a framework like that inside Google in Java. Was okay. You’d write a bunch of methods and the framework would wire up annotated method parameters and return types. The main benefit was improved tail latency since the framework

More ›