gfody

9 ms·

121.
by gfody 2y ago
each visitor brings their own cpu to do this work whereas the server bandwidth is finite
122.
by gfody 2y ago
most of this holds up really well except for > Do not worry at this time about acquiring the resources to build the house itself. Your first priority is to develop detailed plans and specifications. Once I approve these plans, I would ex
123.
by gfody 2y ago
we should leave it for backwards compatibility and adopt U+0085 as the standard next line codepoint. and utf8 libraries could unofficially support every combination of 0A 0D as escape sequences.
124.
by gfody 2y ago
xkcd949.com is serverless (azure only tho, github.com/gfody/webrelay)
125.
by gfody 2y ago
I think a general purpose programming language that was just SQL with some provisions for user input and rendering would be really cool. Having to model all your state relationally and implement all your logic declaratively ultimately leads
126.
by gfody 2y ago
"burnout" can be anything from mental exhaustion to stress induced psychosis, and should be treated like any bodily injury - like you're not going to be playing tennis soon after a severe ankle sprain, and possibly never agai
127.
by gfody 2y ago
in telecom resporgs query somos by directly connecting to their oracle database. it's pretty nice compared to say some rest api especially if you're integrating it into your own db as a linked server or remote table.
128.
by gfody 2y ago
there's probably some cost to having a bunch of unfinished projects occupy my mental bandwidth but I think there are some benefits: - having unfinished projects gives my mind a comfortable place to go think itself out when I'm
129.
by gfody 2y ago
I seriously wonder if the people who are so adament that sql is flawed have spent as much time using at as they have trying to "fix" it. After 20 years of sequeling I have come to believe that this language is so far ahead of its
130.
by gfody 2y ago
> what’s it gonna autocomplete? otoh if you selected something the from clause and potentially some joins could autocomplete
131.
by gfody 2y ago
not to mention https://xkcd.com/949 which inspired many and more of these
132.
by gfody 2y ago
80mb is nothing, I think it's a no brainer to keep it in git but they should've commited the .dump instead of the .db
133.
by gfody 2y ago
this is pretty much what Conway says about it too. we have about as much free will as fundamental particles.
134.
by gfody 2y ago
showing some image using fewer and fewer pixels is like trying to summarize some text using fewer and fewer words, at some point it requires intelligence, at another point it's an artform
135.
by gfody 3y ago
any good alternatives?
136.
by gfody 3y ago
Jim Keller gave a talk at Berkeley titled "Moore's Law is not dead" (2019) where he summarized a bunch of up and coming technologies that will enable the continued scaling of transistor density - https://www.youtub
137.
by gfody 3y ago
once you've done the work to implement parsing as branchless bitwise operations on integers I think that code can be extended automatically to operate on larger registers
138.
by gfody 3y ago
I imagine code like this gets auto-vectorized either right from the start or after Hotspot detects a hotspot
139.
by gfody 3y ago
in .net core there's no setting, you target the x32 abi by choosing a runtime or target platform ending in "32" or "x86"
140.
by gfody 3y ago
the 32bitpref corflag isn't part of a .net core target since those are always il, it is more properly a runtime concern as it should be it's still the default in .net as of 4.8.1 (has been since it was introduced in 4.5 roughly co
141.
by gfody 3y ago
we usually work with some page size anyways, 64 5-byte ints fit nicely into 5 512-bit registers, and ~1T is a pretty flexible cardinality limit after ~2B
142.
by gfody 3y ago
think of the primary keys in a database like typedef void* ie it's your fundamental pointer and the size of it will impact every aspect of performance throughout - memory/disk footprint and corresponding throughput bottlenecks, cp
143.
by gfody 3y ago
> 1 quintillion is equal to 1000000000 billions it is pretty wild that we generally choose between int32 and int64. we really ought to have a 5 byte integer type which would support cardinalities of ~1T
144.
by gfody 3y ago
I use rss for youtube and it's been great but lately a lot of "shorts" stuff has been junking up the feeds.
145.
by gfody 3y ago
the query plan says "key lookup" or "index seek" can we really assume anything about the implementation?
146.
by gfody 3y ago
> ..under the hood it’s still mostly just doing joins on b-trees! I could see the on-disk format needing to be simple and stable, but once the datas buffered who knows what structures and algorithms these proprietary engines are using? Y
147.
by gfody 3y ago
> It was invented over 40 years ago, yet it is still employed by the majority of modern databases. I wonder how true this is for the top commercial engines (Oracle, MS, IBM, etc.) whose internals are closed source and proprietary. Even a
148.
by gfody 3y ago
svd is not as good as dct for compression, but it's a good explainer setup
149.
by gfody 3y ago
(1992 ;)
150.
by gfody 3y ago
Peter Welch

More ›