Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
kyllo
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
16 ms
·
121.
▲
by
kyllo
7y ago
It's a cost model, they probably have a coefficient for what % of people they think will wait vs. go elsewhere while the website is down. When you're running a retail company, you have to at least attempt to quantify lost sales in
122.
▲
by
kyllo
7y ago
Love the use of quasiquotation here: import Database.PostgreSQL.Simple.SqlQQ (sql) ... let index :: Handler Markup index = do tweets <- query_ [sql| SELECT "user".name, tweet.c
123.
▲
by
kyllo
7y ago
This is time partitioning, not indexing, but it's commonly done in data lakes for raw telemetry/log data. mydata/ 2019/ 11/ 12/ 2019111200.csv
124.
▲
by
kyllo
7y ago
Most of the time it's not that data scientists think engineering is "unnecessary," it's that they're expected to deliver analyses and models without the help of engineers, because the engineers are on another team,
125.
▲
by
kyllo
7y ago
Optimization often requires knowledge of the behavior at a level of abstraction lower than the one you're currently working at, and exploiting leaky abstractions. Taking away the assumption of two's complement makes code more port
126.
▲
by
kyllo
7y ago
UB exactly means that it's up to the implementation to decide the behavior because the language spec doesn't. "Implementation-defined" == UB.
127.
▲
by
kyllo
7y ago
> A program with undefined behavior is trivially not compliant with the specification. Undefined behavior means doing something the compiler spec does not specify, therefore the compiler is free to do anything. There are plenty of progra
128.
▲
by
kyllo
7y ago
Nice. I find it pretty easy to get excited about any prospect of a more efficient and typesafe alternative to R and Numpy.
129.
▲
by
kyllo
7y ago
More likely about trust/security/privacy issues.
130.
▲
by
kyllo
7y ago
I always think this way, but once I make a commitment, now I basically have a deadline, which for me, causes the procrastination impulse to kick in, and it takes effort to fight it. I think that telling someone I'm going to do somethin
131.
▲
by
kyllo
7y ago
Wouldn't that make deletes super expensive, similar to deleting nodes from a doubly-linked list on disk in terms of complexity? How could it delete a node with millions of relationships if it needs to read all those blocks from disk to
132.
▲
by
kyllo
7y ago
Learn SQL, yes, and then use your ORM as a handy SQL generator library because life is short and you do not want to write that much SQL.
133.
▲
by
kyllo
7y ago
"the slowness of using b-tree indexes instead of direct pointers to neighbor nodes" If you don't use a b-tree, you still need some other in-memory data structure like a hash table to hold the pointers. "Direct pointers&q
134.
▲
by
kyllo
7y ago
It's valid to decide how many buttons the user is going to need, before having any idea what the users might actually want those buttons to do?
135.
▲
by
kyllo
7y ago
There's nothing essentially, inherently slower about recursive CTEs in SQL databases compared to graph database queries, it depends how they're implemented, particularly whether they take advantage of indexing and caching. They&#x
136.
▲
by
kyllo
7y ago
Anything where you need transitive closure, that is, you need all the nodes that are reachable from a given starting node. You can do it in SQL dialects that support recursive common table expressions. In a previous job, I dealt with Bill o
137.
▲
by
kyllo
7y ago
I don't think the parent was saying you can use Rust anywhere you can't use C++. I think they were saying, Rust is not only a good C++ alternative, but also a good C alternative.
138.
▲
by
kyllo
7y ago
Yes, exactly. Nail on the head. When I do have a datatype that needs to be handled differently based on some condition, I tend to use ABC's with only one level of concrete subclasses, just to make that implicit method interface explici
139.
▲
by
kyllo
7y ago
> you need a class where natural, convenient, consumer-friendly use of a data structure should leverage features like operators and standard protocols that rely on the existence of particular methods (often special methods.) I understand
140.
▲
by
kyllo
7y ago
These are minor annoyances to me. The major annoyance I have with Python is that most Python code makes such heavy use of classes, even when it only needs lists, tuples, and dicts. Why do I really need a class, when: - Instance fields can b
141.
▲
by
kyllo
7y ago
$170k is top-end for base salary at most tech companies, though--past that point the increases in total comp are all from stocks and bonuses, which are tied to your performance review. And yeah, a $200K house in Michigan is probably about a
142.
▲
by
kyllo
7y ago
Marxists have a term for what you're describing: "state capitalism."
143.
▲
by
kyllo
7y ago
All beef is grass fed until a short period before slaughter, where American ranchers fatten them up with a diet of corn-based feed. What we call "grass-fed" beef is just "grass-finished" instead of "corn-finished.&q
144.
▲
by
kyllo
7y ago
This "append-only" style also seems like it could lead to new code being added just to "undo" what the existing code is doing, which is obviously waste. Reminds me of a process I saw at work years ago. An employee was gi
145.
▲
by
kyllo
7y ago
This book is an _epic_ contribution to the field. I've learned a ton from it myself. I had gone through several other tutorials on how to write a parser, but I just wasn't getting how recursive descent works, and yours was the one
146.
▲
by
kyllo
7y ago
I like it--I'm a data scientist by day, and I've been following Rust with interest but I haven't found a good use case for it in my job yet. A Rust-based Spark competitor sounds like it could be exactly that excuse to use Rus
147.
▲
by
kyllo
7y ago
This is really cool! What do you see as ideally the primary API for something like this? SQL is great for relational algebra expressions to transform tables but its limited support for variables and control flow constructs make it less tha
148.
▲
by
kyllo
7y ago
> Meanwhile, most proper languages have the concept of types that only have two values and can easily use an underlying machine representation for efficiently representing these, without involving the programmer. Don't other languag
149.
▲
by
kyllo
7y ago
You mean if you create the pivot table from data in a sheet? It's not needed for that because you'll run out of memory trying to fit any more than about a couple million rows in a sheet first. Meanwhile you can easily load 10s and
150.
▲
by
kyllo
7y ago
The other thing people don't realize about Excel is that it has a compressed, in-memory, columnstore analytics database built into it. It was called Power Pivot then Power Query, not sure if it changed names again, but it's actual
More ›