kwillets

15 ms·

121.
by kwillets 5y ago
+1 for comparing wind tunnel capacity. Also TX has no dirigible hangars.
122.
by kwillets 5y ago
Snowflake perplexes me. From what I can see of my own org it's a data tool with a database behind it that you can't swap out for another or run on your own cloud account.
123.
by kwillets 5y ago
A Bloom filter with 1% FPR would fit in 285 MB and need 7 accesses per key.
124.
by kwillets 5y ago
That's hilarious -- I worked on Zynga's analytics system in the early days, and we made it (hopefully) very easy to instrument code and get up and running. We created patient zero I guess.
125.
by kwillets 5y ago
This question is becoming critical right now, as nonrecoverable deletes are required within 30 days for both GDPR and CCPA. Most products do the asynchronous rewrite, especially if they're based on immutable storage. That's fine,
126.
by kwillets 5y ago
I did the work that Lemire links there. It started with realizing that Lemire's rejection method becomes more likely to need a division/modulo as the range maxes out (the gate on division is fraction < range, so as range ->
127.
by kwillets 5y ago
This may save random bits, which are generally more costly than the range reduction.
128.
by kwillets 5y ago
I see, this is one of several posts on this topic. There is a link near the end to the unbiased method, which is more original, but as you note fixed-point multiplication is not new.
129.
by kwillets 5y ago
What is new here is the method to remove bias.
130.
by kwillets 5y ago
It's easier when there are more bits available than in the original operand. For 64, a variable shift may work. Powers of 10 have a lot of trailing 0 bits.
131.
by kwillets 5y ago
Originally I used a macro: // this increments the upper 32 bits (log10 T - 1) when >= T is added #define K(T) (((sizeof(#T)-1)<<32) - T) (T is 10,100, etc.)
132.
by kwillets 5y ago
Snowflake tries to auto-sort its containers to fit the query pattern; most of these platforms use at least one data ordering. Vertica allows multiple projections on a table with different orderings and distribution keys. On top of that BRIN
133.
by kwillets 5y ago
Generate a temp table with a sufficient number of random values and join. Add an ORDER BY RANDOM() to those results to subsample. Another approach would be to create a table with a small sample of the main one and refresh it periodically --
134.
by kwillets 5y ago
You're not from here, are you?
135.
by kwillets 6y ago
That confused me as well -- where I work we have a legal dept. approval for IP issues, and that's it. Academic review doesn't make sense in that context or time frame.
136.
by kwillets 6y ago
SF has had generations of this type of politician. I can't count the number of times I've seen the phrase "fighting for real change". Finally on Preston's flyer I tore the "for" out.
137.
by kwillets 6y ago
The city requires housing producers to sell a percentage of their output to low-income buyers at a government-set price. So middle-class housing buyers pay significantly more to cover that cost.
138.
by kwillets 6y ago
The government has an exclusive right to run mass transit?
139.
by kwillets 6y ago
Me three. HP just gave me a bad feeling.
140.
by kwillets 6y ago
There have apparently been some injection attacks where an overlength ";" or something has been missed by a string sanitizer. Overlength means eg a 7-bit ASCII character is encoded in two or more bytes, neither of which would be
141.
by kwillets 6y ago
Drug overdoses are far ahead of CoVid.
142.
by kwillets 6y ago
Just learning the words sounds great until you find out that Korean is agglutinative, and Koreans don't even agree on where the word boundaries are.
143.
by kwillets 6y ago
What features are you looking for? Wifi range/bandwidth? Security? Advanced routing? I upgraded my range by adding a couple of Unifi AP's to my existing ISP router. It was less of a commitment than a UDM, and I originally just
144.
by kwillets 6y ago
It might be worth it. There are already programs to collect biomass, but not much is done with it.
145.
by kwillets 6y ago
They should do what my employer does: give everybody 16 hours per day to discuss politics, religion, or any other topic.
146.
by kwillets 6y ago
One thought on timing is that, when generating a whole batch of numbers, it makes sense to calculate the modulo exactly once in advance rather than on-demand.
147.
by kwillets 6y ago
You are correct; it's a transformation from an RNG to a range. I have a version (actually 3 versions) that works with std::random here: https://github.com/KWillets/range_generator . That framework is a bit mor
148.
by kwillets 6y ago
see also: Malthus.
149.
by kwillets 6y ago
That's an interesting look at their internals; I wasn't aware of their dynamic sorting feature. At read time, though, Snowflake's zone map is the same as Redshift's and Vertica's; you'll see similar pruning for
150.
by kwillets 6y ago
SQL Server had too much political pull within the org for such a deal to succeed.

More ›