Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
gregw2
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
45 ms
·
511.
▲
by
gregw2
4y ago
They do. NIV 1984 is not todays NIV. (But having once reviewed a swath of inclusiveness edits via side by side comparisons first hand out of intellectual curiosity about what is going on, it was kinda a nothingburger was my takeaway.)
512.
▲
by
gregw2
4y ago
It’s weird you mention BSL4 and use present tense about Wuhan when discussing covid origins. The Coronavirus work at Wuhan was done in BSL2 environment; the BSL4 lab was still being built at that time.
513.
▲
by
gregw2
4y ago
If ChatGPT is able to emit output that is watermarked such that it can detect itself as Scott Aaronson and others are working on for OpenAI (source: https://techcrunch.com/2022/12/10/openais-attempts-to-waterm
514.
▲
by
gregw2
4y ago
Is this phenomena better or worse if you make your tech lead a product manager?
515.
▲
by
gregw2
4y ago
This author equates personhood with text. He makes some interesting arguments and observations but I think he is confusing personality with personhood. I disagree with a premise whose corollary is that deaf dumb and illiterate people are en
516.
▲
by
gregw2
4y ago
How much of your ETL is rust vs SQL? I agree pandas for ETL isn’t the fastest but why not isn’t SQL faster still? Or don’t you find yourself in the situation where there is so little logic in the ETL that rust performance/safety isn’t
517.
▲
by
gregw2
4y ago
Is there any plausible scenario where Ukraine did it, with or without help?
518.
▲
by
gregw2
4y ago
MySQL can do the analysis you need with the right indexing (I have worked with 100m+ row analytics in MySQL) but a columnar database as others have mentioned would be better, as would a columnar version of MySQL like infobright or infinidb.
519.
▲
by
gregw2
4y ago
This article is less concrete than the Bloomberg TV coverage I saw sometime this last week that discussed the same theme/possibility of Bitcoin manipulation in recent weeks. That coverage discussed that much of the pricing up-moves thi
520.
▲
by
gregw2
4y ago
As a boy in the early 80s age 10 in an American suburb, I rode my bike to school one mile and back. It was fairly safe. I also walked half a mile to a school bus stop when I was 12 and waited there (on a pretty busy street - not sure if tha
521.
▲
by
gregw2
4y ago
I almost missed the cleverness of this joke about making a dumb SQL error of dropping a table to solve a problem, until I had nearly finished writing my correction post for the two other SQL errors buried in the joke (DROP vs truncate, ord
522.
▲
by
gregw2
4y ago
My speculation is that they now have nitro encryption on all or enough of the servers supporting s3 so it’s now no marginal cost for them anymore since it’s inline ASIC encryption and not taking incremental CPU cycles anymore.
523.
▲
by
gregw2
4y ago
There is a business opportunity here IMHO for success for a player with much better aligned incentive structure with their users. (I perceive there's plenty of money in the market however much a monopoly it tends to be now.) Vanguard d
524.
▲
by
gregw2
4y ago
I have also seen the performance boost by using separate temp tables rather than CTEs (in my case in Redshift). My hypothesis is that while memory use my be the same either way, you don't have the same transactional/locking requir
525.
▲
by
gregw2
4y ago
Appreciate the more-informed observation, thanks…
526.
▲
by
gregw2
4y ago
I've said it before, also half-seriously ( https://news.ycombinator.com/item?id=33953367 )... it doesn't help that our best thinkers and engineers are trying ensure an AI passes the Turing Test, but the Turing Test
527.
▲
by
gregw2
4y ago
SQL doesn’t give you tools to break up code?? Err, I don’t agree there. I can think of four options just off the top of my head. Simplest is to use WITH clauses (common table expressions/CTEs). They can help readability a lot and add a
528.
▲
by
gregw2
4y ago
If you mean 5+-page SQLs are untestable, I don't disagree. Like any code you need to break it up once it gets past a certain size.
529.
▲
by
gregw2
4y ago
Regarding SQL being "untestable"... I have put SQL DDL+DML+stored procedures in version control, create/run stored procedure (TDD) unit/integration tests on mock data against other stored proceedures, had pass-fail testi
530.
▲
by
gregw2
4y ago
It's interesting... RSA, intent on commercializing the technology not just patenting it won out over someone more academic who "just" created a patent. Was that just? But in some ways, their commercialization also exposed the
531.
▲
by
gregw2
4y ago
Not speaking for the poster, I would rather trust a mainstream browser's crypto API than 1pass.
532.
▲
by
gregw2
4y ago
With diesel, you don’t have any upfront huge capital and brainpower expenditure of retrofitting each of your facilities as multi-vehicle charging centers. Going electric is a real commitment.
533.
▲
by
gregw2
4y ago
It’s a good thing if done right. But there is the risk of greenwashing going on if we don’t track the details. Two things to consider: First, when someone announces a huge fleet of trucks being purchased, take note of whether they are upgra
534.
▲
by
gregw2
4y ago
French intellectuals want us to divide by the number of fingers we have, because man is the measure of all things. They’re also in league with mathematicians and some foreign Arabian number system. English engineers much prefer a 12-based s
535.
▲
by
gregw2
4y ago
Tried it, I think the problem is the nfs io comes from the kernel and is not tied to a PID?
536.
▲
by
gregw2
4y ago
Agreed. I liked Quest2. It gave me noticeable mental fatigue/wore me out the first couple half hours I used it but it’s bothered me less since. I think the graphics qualify and UI is ‘good enough’ for the platform/tech to maintain
537.
▲
by
gregw2
4y ago
This. (Combine with sudo too!) Now if I could just track NFS client traffic on a client associated with a PID (without having NFS server access). All I can get is all-PID/client-kernel data info vi nfsstat, nothing tying to a PID, fil
538.
▲
by
gregw2
4y ago
The problem with AI is that people setting the vision don’t bake in ethics that are expected of humans. Perhaps because humans are so deeply not used to considering tools as capable of ethics? Or they just don’t care? Or it’s not in their i
539.
▲
by
gregw2
4y ago
Regarding excel and rfc4180… I avoided CSV for quite a while because I had excel-vs-CSV compatibility concerns like this. However, when I tested this for myself a few years back, Excel output to my surprise was rfc4180 or darn near it (it m
540.
▲
by
gregw2
4y ago
Now if ChatGPT had written that response I would be impressed!
More ›