skysight-inc/HackerNews huggingface dataset:
One of the authors of DuckDB here: we use the PostgreSQL parser, and try to be generally compatible with the syntax used by SQLite, Postgres and MySQL. In some cases those are unfortunately mutually exclusive (e.g. null ordering - we have a PRAGMA to change this system-wide). Making the SQL dialect “as compatible as possible” with these systems is very much one of our goals, and if you find any incompatibilities feel free to open an issue :)
Buy a different washer? Send that one back? Don't make it illegal to fucking build IOT devices...
I really wish I could do this. SadlyiI constantly feel like if you don't try to take control, someone will take control of you.
This would be a more persuasive argument if graduates weren't faced with an entire horizon of corporations, that aren't very interested in candidates w/o job experience.
I have to disagree with that. I came into college as an engineering student with a strong interest in humanities. I really wanted to get a lot out of some sociology, philosophy, and psychology classes, and signed up for more than required. But the reality of it was, they were complete wastes of time and ended up turning me off of humanities.

For me personally, I'd have been much better off just following some curricula and reading the material on my own, not fussing with memorizing arbitrary details for a test and working on team reports with other disinterested students.

I think there's something to the apprenticeship thing, and would love to see this succeed. Even if it's not for everyone, I think it's good for lots of people. Six months seems a little short, for sure, but maybe 18 would be enough to learn the main algorithms, learn some project management, and push to be a productive team member. And I think working on "real work" is much more motivating than classwork for the average 18 year old, so that's going for it too.
Yup. I rather liked _Night Beat_ ("Copy boy!").
The certificate is via Coursera, which is entirely separate and only has a 'sign in with Google' option. You don't need a Google account to do it, get your certificate, or link it to your LinkedIn.
I made the mistake of buying a T14s to replace an aging POS Xiaomi (and get off the world of "switchable graphics" forever)

The colour accuracy on the screen given was something like 37%. When I enabled any sort of colour shifting program, it would go completely sideways. Comparing it to a $300 (AUD) Oppo cell phone https://i.imgur.com/Rnh6leC.jpg

/r/AMDLaptops has a surprisingly comprehensive guide of what is out there at what price points and markets

After Lenovo refused to replace the panel with the only part their own forums stated was the "good" SKU, I purchased the only other seemingly decent looking Ryzen 4000 laptop. The MSI Modern 14

I think the best description I can give of the laptop is "I like it but"

It has a nice screen, the keyboard is comfortable (and doesn't have an annoying layout like the Thinkpad with the FN/Ctrl keys)

But the tradeoffs for it are

- No USB-C charging. The USB-C port doesn't support power delivery (and is only 5Gbps, not 10Gbps)

- The SSD is utter garbage. 480 gig on a single NAND flash chip. I was having Linux stall on writing PNG icon files to the chip for 10~ seconds at a time while installing XFCE4!

- USB 2.0 in 2020 shouldn't be a thing on an "Ultrabook" laptop

- The Ryzen model only has a 6 thread(?) CPU, and it does get a bit toasty with the "meh" cooling fan in the laptop
While much of the full four-year undergrad experience is full of other priorities (ex. socialization, networking), there is usually a lot slow learning and almost traumatic adaptation that happens that I'm convinced can't happen on a shorter time frame. Being in a competitive learning environment with colleagues and resources specialized to help learning is hard to replicate. Many of the biggest and most interesting ideas require you to sort of soak your brain in them.

Unrelated to the four year undergrad experience, coding bootcamps and the like that are 3 month and 6 month courses do not work for building deep knowledge for complete beginners -- IIRC their most common usage was for people already in tech to make a change to different specializations. I think the claims that Flatiron School or a bunch of other coding bootcamps sold is basically fraudulent -- it would take over 6 months of high quality practice just to get a handle on HTML, CSS and Javascript, but they throw random new programmers into HTML, CSS, then JS by way of React (and sometimes even rails/backend stuff). Deep, stable knowledge is not built that way.

> Cynically, I'd say that Google is just trying to increase the number of qualified individuals to fill grunt-work positions so they can pay each employee less.

This is exactly what they're trying to do. I guess I could think about it as trying to vertically integrate employee education. This is also what Flatiron School and those other coding bootcamps were trying to do as well IMO, as well as getting at some of the funding that was made available for those efforts.

I don't think that's necessarily a bad thing though -- while people in those positions might see a drop in salary (or rather a slowing of growth in salary), more people with those kinds of skills is probably a net positive.
Six months of onboarding is plenty of time to form someone you'd want to keep around.
Fighting opponents in war, is not 'murder'.

Before American intervention, the Vietnamese Communists had already murdered up to a million of their own citizens in various purges and 'land reforms', including deaths in forced labour camps.

During the war, there were mass arbitrary detainments, forced labour and killings by the Communists both of their own citizens, and execution of S. Vietnamese families and officials by subterfuge. The North Allied Viet Cong routinely executed civilians for political purposes.

After the war, the North Vietnamese Communists dragged 10's of thousands of S. Vietnamese out into the streets and executed them in cold blood.

They then put 100's of thousands into forced labour camps.

By at least one historians estimation (see below), about 250 000 people died due to impoverished conditions.

That very often people don't know these things says a lot about the lazy, 'comic book' intellectualism regarding such past events that basically makes it impossible to take anything more seriously than a random reddit-thread argument. And even worse, that anyone would even dare compare mass murder on this scale to terrible events like 'Mai Lai' (which actually were isolated however terrible) or even US government action more broadly is completely ridiculous.

Here is the range of democide in Vietnam during this era [1]

and the tabulations [2]

And Vietnam in 2020, Human Rights Watch [3]
[1] https://www.hawaii.edu/powerkills/SOD.CHAP6.HTM

[2] https://www.hawaii.edu/powerkills/SOD.TAB6.1A.GIF

[3] https://www.hrw.org/world-report/2019/country-chapters/vietn...
Don’t systems normally want fairly tight bounds on when they execute and how long? (Genuine question)
It's certainly... a lot.

Kind of reminding me of a coworker who kept a secret tracker of everyone in the office's dogs and kids. She considered herself a networking genius, but imo it was kind of creepy.
I’d be surprised if they didn’t. If a crow can figure out how to drop nuts under the car path, then I’m sure early humans have figured out a bunch of stuff too.
I mean, they're descended from Phoenician. But they descended through the Greek branch, same as the Latin alphabet. And I don't think anyone would call Latin a Semitic script.
PEACE PRIZE [INDIA, PAKISTAN]
The governments of India and Pakistan, for having their diplomats surreptitiously ring each other’s doorbells in the middle of the night, and then run away before anyone had a chance to answer the door.
REFERENCE: Numerous news reports.
The concern is whether Google actually is giving them an opportunity to grow. As was mentioned downthread, most existing training certificate programs offer no real growth and exist only to create a stagnant job pool in service of the commercial interests of the company issuing them. I'm optimistic that this program will be different, but I understand why someone who distrusts Google might be concerned.
For most normal people, using Word and Powerpoint is pretty important. let me know when I can use and do word and powerpoint stuff on Ubuntu. No, the Librestack isn't a replacement.
That's a smart way to skimp on training costs and to produce employees that are very dependent on google and the affiliate corporations. Sure, some people may benefit from this especially the ones who'd otherwise get indebted with education costs and not have any job prospects once they graduate. But this is not real education, it's some kind of limited training with a certificate. Yes, it seems to me that they want to fill grunt-work positions and they'd get the higher level workers with degrees from real universities. What's not clear is whether this training is free of cost and what kind of classes they intend offer.
According the the relevant Netgear Knowledge Base article[0], config file uploads and downloads are supported without registration.

I'd expect (I do not own one of these devices) that configuration without restriction can be done by uploading a modified config file.

Perhaps someone who owns a NETGEAR Smart Managed Pro Switch could chime in to confirm or refute that.

[0] https://kb.netgear.com/000061174
The author doesn't seem to understand how supply and demand work. Unless there's about to be a massive increase in the availability of these jobs, this is going to create a bubble that will reduce these salaries and lower the skill level in these positions.
Todd or Ted was the first to buy Apple shares for Berkshire, but Warren Buffett made the decision for the bulk of Berkshire’s current stake in Apple. The $35 billion Apple investment (worth more now) [1] is larger than what Todd or Ted manage (about $13 billion each as of last year) [2]. Buffett has also commented publicly on the rationale behind his decision to own Apple.

[1]: https://www.cnbc.com/2020/07/16/warren-buffett-reaps-40-bill...

[2]: https://www.cnbc.com/2019/02/25/warren-buffett-says-berkshir...
I agree with you about PTUs having their place in planned and free market economies alike. I think you’re saying that if people have the option to go to a good “traditional” school and learn CS there (and meet a bunch of students and professors, etc), they shouldn’t throw away that option for something like this, is that right?

On the other hand, I feel like there are plenty of people who have either graduated with a humanities degree or simply do not have the ability to go to a good technical school: I would hope that this provides a new on-ramp for people like that, and it actually adds value to people’s lives. Even though as most people here have stipulated, this seems commercially motivated by Google’s interests.
I actually started looking at it today because someone was asking about it on the Datasette discussions board: https://github.com/simonw/datasette/discussions/968
Razer Synapse has removed that requirement now, you can use local guest account without registering.
Maybe enough to get a jr position and to demonstrate dedication? You can learn everything else on the job.

I found my studies were largely useless and a lot of it was just filler, fee justification material.

One of the mandatory elective credits was a course with a title “Role of a car in a North American society”.
I was reading the comment and was like, hey- I'm 39 and trips to the grocery store tire me out and I REALLY look forward to naps on the couch!
One of the authors here - portability of the storage is indeed one of our goals. We test that the same file can be loaded everywhere on different systems, including between ARM and x86.

I should mention the storage is still very much a work-in-progress. We are actively working on redesigning the storage to add compression and other extra features, meaning the storage format can change and be incompatible between different DuckDB versions. We plan to stabilize the storage format with V1.0, after which every subsequent DuckDB version should be able to read database files created by previous versions.
"you don't know that there won't be repercussions. perhaps when i say "America is already at dystopian North Korean levels of mass propaganda", my IP address is stored in XKEYSCORE and my cell phone billing info is cross referenced and my name is put on a Watchlist."

It's really sad how deep down the rabbit hole of delusional moral equivalence so much of the anti American bigotry on HN amounts to, and of course so ironic that this is all American-based.

If you want to work for US government spy apparatus, yes, there will be a loyalty test. And that is fine and normal, and it's the same everywhere.

Otherwise, you are free to say pretty much as you please, whenever you want, unless you're making bombs or calling for violence - even in the later case you can get away with it.

Thankfully, there are forces in the world that remain vigilant towards ensuring that you can do that. You can look on a map and it's fairly evident to see which places are fairly open and safe, and which are not.
> I don't know if SCons is still slow, but in 2018 it was definitely very, very slow. I doubt it has improved much, as its maintainers were in similar denial then.

And, at this point, its time has passed.

The big projects that were using scons all moved on to other systems for various reasons.

Better to move on to something that actually might generate a critical mass and community.
You solidified your knowledge with your prior experience. Without practice one may potentially get good scores on tests but can't magically skip the practice. Learning takes time
Some college degrees are worth the investment. The productization of college degrees being offered by second-rate institutions has created a race to the bottom. I see many young people graduating with little in the way of employable skills with (usually non-STEM) degrees that are merely a piece of paper that they paid tens or maybe even hundreds of thousands of dollars for. I was one of those people. It took me years of grinding away at entry level jobs and self-learning in my spare time to create income growth. When I look back, I wonder why even have gone to school at all? All the skills I learned were on the job or were through knowledge I knew I needed to learn to get to the next level in my career. Could I have made better choices with my degree? Sure. If I could do it over, I would. The common narrative is what you have said above, any Bachelors degree == good. I think the reality is much different for many of us.
Thanks for reporting that! We will have a look at fixing it :)
> I'm not sure what your point is. One doesn't need to overturn Roe outright to overturn Roe in practice for many americans. If there are no abortion providers in your state, and your state bans telemedicine medication abortion, you can't get an abortion. That roe still protects Californians isn't relevant to you in mississippi or georgia or nebraska.

Restrictions that eliminated every provider in a state likely would violate Roe itself, as would things like heartbeat laws. Yes, one imagines a 6-3 court would uphold more restrictions than today. But things like mandatory counseling, waiting periods, parental consent periods, 12 week limits, etc., exist in more conservative European countries like Germany, Italy, etc. Even insofar as Roe recognizes a right to bodily autonomy that precludes banning abortion entirely, why shouldn’t the most conservative states in the most religious developed country in the world be able to decide that they’re going to do the minimum required to protect that right, as opposed to something behind that one right.
https://nattaylor.com/blog/2019/snowflake-internals/
Raytheon?
Tesla Model 3: Explaining the Cult
This was a fascinating read
In hindsight, how would you have used the documentation of the Raspberry Pi architecture to determine whether UASP is supported?

Also, I'm really curious if your only problem with that Arcanite was only that it was a defective unit. If anyone reading has any other ideas for diagnosing that problem then I'd love to know them.

Great guide, Jeff. Really enjoyable (and informative!).
Show HN: AndIodine raw UDP mode on xfinitywifi
Generally no, for many reasons. I think the most important one here is that in a Windows server there’s a lot of software bundled together (AD services, the SMB server, IIS, RPC stuff like this netlogon interface, WMI, RDP, many others) that you can generally expect to find on any Windows server, giving you a wealth of targets and potential ways to exploit how different components interact. A base Linux system has relatively few services (just SSH in simple distributions) so to begin targeting Linux the same way you’d have to decide to go after RHEL or something, narrowing an already tiny share of servers down even further. Other reasons include the dominance of Windows outside the tech industry (which makes it a more interesting and lucrative target for vulnerability researchers and exploit developers), lack of comparable functionality to AD for Linux servers, and probably higher standards for code quality and cryptography in highly scrutinized open source applications like MIT Kerberos.
I think the takeaway of this article is that the english ale derives from germanic alu which also has the meaning "intoxicating beverage" as descibed in the WP-article.
Hey hey hacker techbros.

I discovered a way to open random UDP ports on xfinitywifi. Then I modified AndIodine to enable raw mode on random ports. So much speedier than DNS mode. Fun times were had.

I know Hacker News is The Number 0x01 Best Place because when I search for "xfinitywifi" and "iodine" Hacker News comes right up.

So to do this the way I did it you would need to build AndIodine which is open source and Android SDK is easy to install right? And you need an iodine server and a cloud account somewhere to host it and a DNS zone you can delegate. Oh and the host running your iodine server needs to redirect all incoming UDP traffic into port 53 with iptables. Whew! Too much preparation?

Or just adapt my changes to your favorite censorship circumventing UDP based VPN app. You know you want to.

There should be like a whole startup dedicated to a "residential neighborhood guest network road warrior" app for no reason.

Sorry I can code.
Foreign keys are not supported yet in DuckDB currently, but we do plan to add support for them in the future. If you have a need for them, feel free to post a comment on the issue. We tend to prioritize implementing features that many people ask for :)
it would be interesting to see some NVMe benchmarks for the Pi 4, both enclosure and drive
Speaking of increment/decrement architectures and Turing completeness, the Brainfuck programming language provides only one-byte increment, decrement, index via the single register and inc/dec, and branch-on-zero operations, and is Turing complete. It is very specifically designed to be unpleasant to program in, but to provide a glow of satisfaction at having succeeded in programming anything at all recognizable.

A Brainfuck interpreter in Brainfuck is around ~4-500 bytes. In C, it has been achieved (taking truly gross liberties with C semantics) in 144 bytes -- about two lines, necessarily including substrings "main(c,v)" and "putchar(".

Programming a nanoprocessor would differ from programming Brainfuck, but would feel curiously familiar.
More like you just have to accept that two options are sometimes mutually exclusive. Like which starter pokemon you pick, except you’ll only get to play life once.
Is there any sane reason for this whole trend? I immediately place the people who advocate for silly things like this in the stupid bucket, but is there any real reason to do this, apart from avoiding hurting the feelings of a few dandelions (which are few and have less contributions, because they spend more time bitching than working)?
This is something that worries me about this project. Is the focus more on hackability, or security/inspectability? The messaging is unclear, and this decision looks like a big sacrifice of the former for the latter. I'd maybe be interested in this device but only for the purposes of DIY messing around, I'm nowhere near so worried about security I wouldn't trust the linux kernel.
Yup. https://en.wikipedia.org/wiki/Lindy_effect
>rebrand it. Drop the word "nuclear".

I laughed at the thought of A/B testing new names of fundamental forces across different demographics.
This is coulda, shoulda, woulda type of question. I was raised in former Soviet Union and as a consequence was able to get great education without having to pay for it directly.

What it would be for me if I was born in the US - no slightest idea. I could've been rich or poor. It is useless to speculate.
oh, cool. thanks!
That's really disappointing as LG has been my go to brand for many of my appliance purchases including a washer and dryer a few years ago.
I've got you covered, at least for an XPG NVMe in a TDBT enclosure: https://www.jeffgeerling.com/blog/2020/fastest-usb-storage-o...
For the IT Support Specialist, really none at all is specific to Google products. The major focus is Windows and Linux. When mobile devices are discussed both Android and iOS are treated in equal measure. ChromeOS is mentioned but never used really.

A lot of the questions and examples mention competing products like Office365, they don't mention G Suite at all that I remember. The brief cloud section is pretty general and doesn't discuss GCP in specific.

I see it as an abbreviated version of A+, Net+, and Sec+ in one. For someone at a beginner level I think it's a pretty good introduction to IT support.
Roku and Comcast Reach Deal
The fun thing is, it probably brings these two countries closer to peace than war, the same way having children play together makes it easier to develop a friendship
> Experimental replication shows knives manufactured from frozen human feces do not work

Now that’s some solid science!
How might one go about using this in a language that’s not supported in the documentation such as golang?
This one deserves a special prize indeed.

Solid science though? Not solid enough to cut with it, apparently.
I pitched my startup to Y Combinator for $150k and got rejected (15 min vid)
I don't feel nearly as smart or "outstanding" as I did when I was younger. But I don't think it is because I have gotten much less smart or outstanding. I think my perception has become more accurate.
Thanks for the confirmation on portability, I didn't see Go support in the home page; Is there an official Go driver support planned as well?
Can’t you get a screen protector that makes it feel more like paper?
As an executive, your calendar will fill up fast with meetings, planned and unplanned. 1:1’s with direct reports, 1:1 with your boss, your staff meeting, your boss’ staff meeting. Meetings to manage down, meetings to manage up. Meetings with product, meetings with sales, meetings with operations. Various steering committee meetings to move larger initiatives forward. Meetings with customers and prospective customers. Meetings that need your decision, your expertise, or need to bring you up to speed on evolving issues.

And many of these meetings need preparation in advance to be productive. So your time is quickly depleted. Many executives do their deep thinking in the early morning or on the weekends since their day is a day of interruptions.

At least that has been my experience in my last 3 roles.
The first comment (umvi) in this thread I thought was great advice for those who are ambitious but also practical :)

https://news.ycombinator.com/item?id=24261826