Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
cldellow
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
29 ms
·
331.
▲
by
cldellow
7y ago
Any specific questions? My email is in my profile if you prefer thst. I'm currently on a five month break with my wife. The first two months were in an apartment in the south of France, currently hiking though Loch Lomond and then a co
332.
▲
by
cldellow
7y ago
S3's eventual consistency aside, how is it cheaper? It would seem to me that naively, S3 charges $5 per million POST requests, so it's 10x worse than SQS's $0.40 per million.
333.
▲
by
cldellow
7y ago
Specs here means specifications. It could include things like requirements documents, acceptance criteria, wireframes--anything to create a shared understanding of the precise shape of the work product to be delivered.
334.
▲
by
cldellow
7y ago
+1 on charging for specs. We had some landscaping done and interviewed a few contractors. Only one charged for the upfront design work, but theirs was the most detailed proposal. We ended up going with them. I think they rebated most of the
335.
▲
by
cldellow
7y ago
The query planner in 10 got a lot better at enforcing row-level security constraints efficiently for some common scenarios, like 10-20x speedups. See https://github.com/postgres/postgres/commit/215b43cdc8d6b4a
336.
▲
by
cldellow
7y ago
The US government has promised TurboTax that the IRS will not create a free e-filing service. In exchange, TurboTax will offer its software for free to some low-income taxpayers. The US legislature is considering extending this deal. In lig
337.
▲
by
cldellow
8y ago
The person in the linked tweet isn't one of the people affected. I'm drawing some inferences here, but she's contrasting the perceived lack of support from the company for those affected by the npm layoffs with npm's pub
338.
▲
by
cldellow
8y ago
Yes, I should have been more detailed in my response. You're right that all of them give a quantative score, not a qualitative score like "native". There are qualitative scales where one of the labels is "native fluency&
339.
▲
by
cldellow
8y ago
There are plenty of tests that achieve this. My university got a lot of international candidates whose first language wasn't English and who hadn't been educated in English up until that point. As a result, they established a proc
340.
▲
by
cldellow
8y ago
I'm not a recruiter, but I am a hiring manager and I'm impressed. I'm not going to go through the assembly with a fine-grained comb, but I don't need to. The existence of the final result demonstrates someone who perseve
341.
▲
by
cldellow
8y ago
It varies by case. For the particular example of time, some common approaches are to hook the sys call for time such that it returns a constant value, or to teach your tool to output a constant value. The Nix thesis ( https://nixo
342.
▲
by
cldellow
8y ago
Depending on your threat model, absolutely. Cognito supports issuing temporary IAM credentials, so you can have granular permissions, billing and auditing. I debated doing this for a side project but decided it was a little too risky for my
343.
▲
by
cldellow
8y ago
This is neat! My wife is beginning to learn some web design. Her laptop has a low-res screen (1366x768) so dev tools takes up a lot of space when open. When she's tinkering with layouts, she occasionally adds/removes borders to he
344.
▲
by
cldellow
8y ago
Because the article was written in 1997.
345.
▲
by
cldellow
8y ago
I'd suspect you'd have a hard time building it for other platforms, but once you got it to build, it'd work. It only uses the standard library and parquet-cpp. From what I can tell, parquet-cpp has a documented build experien
346.
▲
by
cldellow
8y ago
Squashing the SQLite file works pretty well -- it's a bit bigger and slower than Parquet, but maybe a reasonable trade off to not have to deal with Parquet. I added a section at https://cldellow.com/2018/06/22
347.
▲
by
cldellow
8y ago
I can't speak for MySQL, but I suspect the Postgres compression you're referring to is TOAST ( https://www.postgresql.org/docs/current/static/storage-toast... ). Its sweet spot is for much larger rows
348.
▲
by
cldellow
8y ago
Hey there - I'm the author. I think you may have missed the point of the article. This is essentially an FDW for SQLite so that it can read Parquet files, because CSVs are space inefficient.
349.
▲
Query Parquet files in SQLite
(cldellow.com)
84 points
by
cldellow
8y ago
|
19 comments
350.
▲
by
cldellow
9y ago
The table of times notes: > The shortest path query was not tested for MongoDB or PostgreSQL since those queries would have had to be implemented completely on the client side for those database systems. I can't speak for Mongo, but
351.
▲
by
cldellow
9y ago
It really is mostly just text. It's not _quite_ <Article>... [30 kb of text] ...</Article> but almost.
352.
▲
by
cldellow
9y ago
The third page of the study explains how they tested for humour. It's kind of fun to propose how they might have tested for each fo the 4 attributes they mention, then check to see how they actually did it.
353.
▲
by
cldellow
9y ago
I dunno, I think a country benefits when it imports talented people, full stop. Americans can be intelligent and capable, and companies can still benefit from hiring more people just like them (or, in some cases, more intelligent and more c
354.
▲
by
cldellow
9y ago
Yeah, "a lot more complex" is pretty sloppy. "A lot more annoying", perhaps. It's doable. The complexity comes when you aggregate tuples of (row number, value) instead of just aggregating value. To fit in the redash
355.
▲
by
cldellow
9y ago
We run a Spark cluster for distributed processing. Spark is awesome - makes it dead easy to parallelize work. But it's also easy to write bad Spark code that doesn't parallelize well. So I wrote a report to let us view key stats b
356.
▲
by
cldellow
9y ago
The simpler format is easier to generate, which can make the difference between having something and having nothing. An example: our company uses redash for sharing ad hoc data sets internally. It'd be easy to generate a SQL expressio
357.
▲
by
cldellow
9y ago
200m on 17b is 1.1%, not 0.1%. Why do it? Because the penalty for getting caught is both tolerable and much smaller than the reward if you are successful.
358.
▲
by
cldellow
9y ago
AWS supports publishing detailed billing information to an S3 bucket on an hourly frequency with excellent granularity as to which resource and operation is driving spend. Unfortunately, to make meaningful use of this you pretty much have t
359.
▲
by
cldellow
10y ago
This calibre of journalism feels like clickbait or, worse, incompetence. > computer programmers are no longer presumed to be eligible for H-1B visas. This is narrowly true based on what the linked document says. But the intent of documen
360.
▲
by
cldellow
10y ago
I think you're violently agreeing with Linus here. He says: > pdf's don't have that issue, they have a fixed header and you can fairly arbitrarily add silent data to the middle that just doesn't get shown. In other wo
More ›