skysight-inc/HackerNews huggingface dataset:
Great idea as the article notes, subpar execution.

I took a similar format course offered by IBM in data science on Coursera, and my goodness, I found a lot of pure junk work in the peer review process. Either that, or it was straight up copy and pasted from somewhere else online.

Online classes might definitely work, but they need more iterations to make it work.
I need to know more about Tom Pritchard apparently, but I've been embarking on my best attempts to upgrade my bikes on my own. When I saw that 6-speed with down-tube shifters and the camo road bars! God, it's so fun. I need to redo the paint on my SE Draft Lite so I can take some pictures and at least try and feel like I have a cool classic bike.
Value Pricing Calculator
SQLite has foreign keys, but they are disabled by default for backwards-compatibility reasons. https://sqlite.org/foreignkeys.html
You just have to write

PRAGMA foreign_keys = on;

each and every single time you want to do an operation that requires an FK constraint, like `INSERT`.
Maybe the AI is biased against Rust.
Wow the rate of improvement is impressive! I really need to sit down and play with this, it looks great.
If they had a domain controller with ports opened to the internet they would have been hit some other way already (not to mention suffering from constant account lockouts from random brute forcing), so this would probably not be the initial vector. Once the exploits are more polished this will make things easier for ransomware to escalate privileges but they already had effective ways to get to domain admin that work on most networks.
What Makes People Fall for QAnon? – The Dispatch
More about the tokens[1], [2]. I don't know where the BBC is getting the idea that the tokens record location data.

[1] https://www.bunniestudios.com/blog/?p=5820
https://news.ycombinator.com/item?id=23601180

[2] https://hackaday.com/2020/06/25/teardown-of-the-singaporean-...
I have a friend who works at a place where all their IT is outsourced, who's accounts payable stretches every invoice out to 120 days, and who's outsourcing company downs tools on all 90+ day delinquent accounts.

Every 3 months for at least the last 18 months, they've ended up with no updates/patching for a month. Friend informs compliance and risk manager, compliance and risk management scream at accounts payable to get the outsourcer paid in full to get this month's security update done, and the circle of life repeats.
And it's very good indeed at those things!
And it's not possible to enable them by default - there is no existing configuration setting to override that design choice. They hope to include the feature in SQLite4, as I understand it.
tpmx: I can't respond to your post since it's dead.

There's probably not a way I can convince I'm not lying, but I'm not.

"Not supposed to be negative of anything technical even if it's flaming crap".

I honestly still don't know which flaming crap you're referring to. All I know is that it's technical. For all I can tell, it could quite conceivably be OP. Your entire point is lost on me. I don't see any reason not to solve the technical problem at hand. On the contrary, I think that's a great idea.
It’s hard for me to express how deeply I disagree with this philosophy. I started out in the hard sciences with a MS in biochemistry, so I certainly don’t use any of the direct “skills” I learned in my major-specific courses in my current career as a programmer. Micropipetting, mass spectrometry, and gel electrophoresis have yet to come up in writing software (at least in the jobs I’ve had).

What is continuously useful are three main categories of skill: general critical thinking, analytical writing, and empathy. The first is helpful when solving any problem at all, the second when proposing solutions to new problems, and the third when understanding what problems need to be solved, both at a code level (what does the user need, what documentation do my coworkers need) and at an interpersonal level (how should I focus pairing sessions with this colleague, what projects and teams would they function well on, how can we help to ensure their professional growth).

I have to say that, on average, the humanities courses I took did a much better job of teaching these skills than the science courses.

Of course, even outside of immediate practical benefit, I learned a lot of really interesting stuff in those classes! A lot of them helped to shape the way I still see the world today.

Sure, we can try to pare down “higher” education to what has historically been called vocational school (in the US) or similar, but I think we’re potentially losing a lot along the way.
what I find most frustrating is that finance institution buy extremely overpriced and brittle software from renowned vendors not because of technical excellence but for risk management: they want a supplier to blame when something goes wrong.

the problem with this is that nowadays suppliers are stronger in defending themselves from such blames than they are in writing good software.

furthermore, the software being sold is very pricey and the cost of customising it often exceeds the cost of the software itself.

then, 9 times out of 10 the issues lie in the customisations, and that doesn’t surprise, as the institution will be using most the custom parts as those are the ones they need most. here the vendors have even more grip in demonstrating that it’s the customer requirements’ fault, and not their crappy software, that confuses the concepts of “database” and “application server”.

I try to counter this by writing solid, robust software using open source components, giving back when possible, perfectly filling the company’s requirements, well integrated and reasonably cheap to maintain. slowly, this can help in abandoning vendors and building in-house know-how.

I find this crucial because the quality of software sold by some vendors is very very low, and getting worse.
Model fitting. How to do?
Except that’s completely untrue. College degrees are well worth the investment — the earning potential increases of having a college degree vastly dwarf tuition costs. When people are young, debt is a problem, but those same people continue to see (exponential) income growth over the course of their careers and eventually beat the debt, and then some. Folks without degrees struggle with income growth.
Agreed, but how much debt should one take on to learn these other skills? (Scott Galloway has been talking about this a lot lately - university degree cost inflation, which has skyrocketed without a commensurate increase in the quality of the product/service.)

There are other ways to pick up these skills, which are much more cost effective.
We have no idea if mammals can sense magnetic fields.

Maybe bats. And maybe many mammals including dogs and humans.

But we don't actually know.

Which makes me sad. It should not be hard to do properly. Harder than looking at dog poop, but possible.

None of the studies done have been done properly. Many have been disproven.
This seems like more of a problem with our system of financing college than with the idea of college itself. Plenty of places manage to make college education more affordable than in the US.
I am also in the market for a docsis 3.1 modem. What are you going for?
Getting to Inbox Zero without declaring Bankruptcy
While I've beleived this for years, I've begun to doubt it and myself. I interact with many very intelligent developers in all sorts of online spots. People working kn very complex systems and projects, and most of them seem to have at least a solid handle of some mathematics fields.
I ran into a similar issue with a Linksys consumer router. Needless to say, that was back in the box and to the retailer in a new york minute.

I ended up going with Ubiquiti equipment for now, since it was available locally. Much more expensive and complicated but Linksys convinced me it was worth any cost to get the hell away from them. But I will definitely be looking into the Turris Omnia, pfSense devices, and maybe even reusing my current Ubiquiti AP with OpenWRT, next time I need to muck with networking.
> On the wider subject of the essay, I do note that languages like APL that really embraced symbolics for expression do not seem to have gained much ground

Comparing APL's popularity to Python's and assuming the difference is due to solely to an embrace of symbolics for expression does not take into account the many differences of the languages.

APL had barriers to entry that Python didn't; for example, APL cost money (you had to license it from IBM) and you needed a special keyboard. Python didn't. (Later versions of APL didn't require a license or keyboard).

APL was good at numbers, poor at I/O (I'm generalizing). I wouldn't want to write a webserver in APL; I'd use Python, but if I was doing matrix multiplication, I'd use APL. Or maybe a tool like Octave or Matlab.
There's really no better choice than Arris SURFboard if you want a DOCSIS bridge that just sits there and works all the time.
Lifespan? Don't make the mistake of anthropomorphizing Mark Zuckerberg.
This. It's a handwavy familiar term (without defending its usage).

Remember that nowadays people call soundless videos "GIFs", browsers curtail web adresses, and companies report leak passwords as being encrypted when they were actually hashed.
A comprehensive implementation of something akin to the German vocational training system is what the US needs.

It has been discussed across the political spectrum. The US needs to finally take concerted action toward this, with big investment behind it.

It was widely floated as an approach a few years ago by Benioff (and countless others) and the government made some basic motions in that direction:

https://www.inc.com/suzanne-lucas/trump-wants-to-create-5-mi...

It's not nearly enough. The government has to go a lot bigger to make a dent in a job market the size of the US.
I really appreciate the breakdown here but this comment smells like a giant plant for DuckDB.
That argument also applies to CS skills. There are lots of successful self-taught programmers out there.

Boot camps are the software equivalent of vocational/trade schools and they are looked down on for a reason.
Is there a resource online that breaks down the types of equipment and facilities needed for this sort of production?
I recently learned that runes are a semitic script, akin to Phoenician and Hebrew. A bunch of hebraic words came into Scandinavian words along with them.

History gets stranger the more you learn.
I’m amazed you could say this without mentioning that US companies, too, have no right to withhold data from the state.

We have irrefutable gag orders which force compliance with the NSA [1].

FISA warrants are a joke, a rubber stamp at best. Only every 12 in about 33,000 are denied [2].

[1]: https://www.eff.org/issues/national-security-letters

[2]: https://en.m.wikipedia.org/wiki/United_States_Foreign_Intell...
It's always awesome to see early, potentially unfruitful decisions workout in a project.
Startups are a complex multivariable equation
The Flight Goes Nowhere. and It’s Sold Out
Merits including forcibly nationalizing foreign IP under vague “national security” concerns?

Today it’s TikTok, tomorrow it will be Telegram.
> - Each database is a single file on disk

Are these architecture independent? i.e. If I create the database on x86_64 and move it to ARM64; would it work seamlessly?
Many vulnerable organizations do not have "engineers who fix bugs", they have teams of accountants and bookkeepers who run Excel and Xero, or teams of lawyers and paralegals who run Word, or medical practices or marketing firms or chemical wholesalers, or or or... The nearest thing most of them have to "an IT department" is the admin person who liaises with their outsourced IT provider and the manager who signs of on the bills every month.
No, that's why programming languages have syntax for comments.
Try this link if you don't want to subscribe to the Tampa Bay Times to read one story:

https://archive.vn/QyMnG
It does not. Spreading conspiracy is exciting and makes people feel smart. If you use Frida to bypass cert pinning and see what’s sent, TikTok doesn’t collect anything of note in the realm of social media.

Google (and the NSA by extension, via PRISM) has magnitudes more information on you.
Well, I'm running a SB6190 right now. I guess I'm going to go with either an SB8200 or a motorolla MB8600.

One thing I like about the SB8200 is that if I ever go back to running a "business" connection at home I can have a second IP assigned to the second WAN port it has.

I also plan on modifying the modem to fit into my network rack without a shelf like so: https://www.reddit.com/r/homelab/comments/ft579e/finally_got...

So the actual internal matter a little bit to me as well.
..for free. Would you have paid $60K - to $100K plus for the same? That is what students are facing now.

Very few would disagree with the intangible benefits of a university education. They question is, how much is it worth, and how much debt should you take on to obtain those benefits?
I would just create a per-test-file database (and delete it the next time the test runs). The overhead is very small (compared to booting Postgres) and it works exactly like production because it is exactly production.

In general, I am not comfortable using an "almost equivalent" database for tests. Every database engine has its quirks, and if you don't know what they are, your program that passes its tests only "almost" works in production, which is annoying.
Madness. I can’t imagine missing flying! Truly the word part of travel.
The average student loan debt for a new grad is about $33k, and the median is about $17k. $33k is a little bit less than the average price of a new car sold in the United States.

It sucks to owe money after college, but it is by no means a plague. It's a burden that many adults take on willingly each year just for a new car -- surely 4 years of education is worth as much money as a new Toyota Camry with leather seats.

On top of that, there are a lot of studies that show that college grads have better health outcomes throughout their lives.
As someone that grew up playing with other kids on the net, kids have always been vicious unempathetic little shits.
Soviet block country here as well. However, profession training schools are not communist invention and have their place in educating people for useful jobs. At least, I don't know how to build a high-quality bathroom and I don't think that people who can should not be valued less than someone who can make a terrible electron app. My UX in the former is much better tbh. :)

My issue is that this stuff now pretends to substitute for colleges which is totally different category. Six months of youtube videos are just professional training for office workers of the disposable type, not the creative/problem-solving variety that needs broad understanding of the field.
This is just... not true? At least not among anyone I’ve ever known who didn’t go to school for CS, law, or med school.
Yea, that's what I'm leaning toward at the moment. I already have a Cisco 2921 router and cisco switches in various places throughout my house.

So something dumb and performant is what I want. What I liked about the netgear modems is they do have models with a router built in without it being wifi which I would like to use as a failover. But I'll just keep my 2921 around as a failover if my new mikrotik router fails for some reason.
I see a lot of negativity in this thread. What’s wrong with Google giving a bunch of people a taste and the opportunity to grow?

I prefer to believe in the ability of people to reach beyond their station in life. Sometimes all they need is inspiration. If Google can provide that it’s great.
> Would you have paid $60K - to $100K plus for the same?

Average new grad loan debt in the US is about $33k and the median is about $17k. It's not that bad.
That’s air quality, not co2. Air quality usually means particulates and VOCs.
in related news Cottonelle and Quilted Northern now require registration before use.

Charmin declined to comment.
SQLite 4 was killed off in favor of just bringing a few changes to SQLite 3 iteratively.

https://www.sqlite.org/src4/doc/trunk/www/index.wiki
> The kids I was talking to were born around 1980, and one of them spoke up to say that she had never worried about nuclear war.

A related trick for predicting the future; things that everyone is worried about are likely to get solved. It is the stuff that people dismiss as impossible that is scary, because when it happens everyone is caught out in the same way at the same time.

That also leads to a decent heuristic for figuring out if someone is overconfident: listening to see if they can articulate a thoughtful list of things that could go wrong. If they don't have such a list then it is likely they won't have countermeasures in place when something goes wrong and will fail for no good reason. Or worse, they won't pick up on the early signs of failure when there is still time to react and salvage the situation.
Ok but in reality you need a degree to get a decent job so they are de facto trade schools whether you realize it or not. Your assumption that electives somehow make someone more 'rounded' is also laughable. That comes from being curious.
While I agree our Presidents often abuse the office's power to use a defense of national security as a legal justification, I honestly don't think this particular situation is one of those instances.

I should also point out that Congress has passed a bill which bans TikTok (and I assume similar Chinese owned communications apps, I havent read the bill) from Government owned devices. So it's not like Congress is at odds within itself when it comes to understanding the overall potential security threat TikTok imposes on it's users when the CCP is allowed direct and unimpeeded access to user's data.

I also think that trying to pursue legislative routes when implementing policies that aim to protect not just America's but our allies best interests when conducting business with China is too slow and too political of a process when it comes to
trade negotiations.

That is one of main compelling reasons why I believe the founding fathers decided they needed to have a powerful executive despite the fact that they didn't want one.

Negotiations are difficult enough as it is when it's the Government trying to get their government to act in it's own best interest. It would be virtually impossible to try and have our legislative branch negotiate with every other nation's legislature/executives directly.

It would be too difficult to offer terms you couldn't guarantee are concrete.

For these reasons I think it's fair if the President uses national defense as an argument to use aggressive tactics during trade negotiations.

It's important to note that as the People it's easier for us to reverse policy the popular majority of the nation as a whole doesn't like because the executive is the only branch of Government everybody gets a say in who gets to run it.

This allows us to avoid situations in the legislature where the people we vote into Congress make concessions across the aisle on things we elected them to be against. Or when the individual parties themselves can't come to a common concession on issues.

This is also why you also need an executive to act as commander in chief.

The legislature should be deciding who to declare war on but if you tried to make every single individual strategic move conducted in war something that first had to be passed as legislation, our government wouldn't be able to defend itself because it can't keep up with the fast paced, rapidly changing dynamics of war.

Trade and warfare are very similar in this respect.
I don’t think that it’s reasonable to assume that Simon would risk his reputation by coming here to astroturf.
Oh yes, let my project be managed by someone with a 6 mo course. I'm sure that will work just fine
> I need to redo the paint on my SE Draft Lite so I can take some pictures and at least try and feel like I have a cool classic bike.

Or not! To learn from Tom, he had the adventures but wasn't outspoken about them - the stories were told by others. With a bike, the point is to enjoy it! I have an 80s steel frame, not as unique, but it gets me around, fast, and I've had tons of fun with it over the past 15 years. Camping in the woods with it chained to a tree, riding through 6" of slush on slick tires, wiping out and learning multiple times... I've touched up scrapes and dings with not-quite-matching shades of nail polish, my handlebar tape is falling apart, my bottom bracket sticks out a bit because I did a shit job of replacing it 5 years ago. But I love it anyway. Or as the article said,

> “Bicycles are not built to be used as status symbols,” Eisentraut himself wrote in a chapter on framebuilding for a book called Bike Tripping, published in 1972. “The cyclist should ride his chosen bike, instead of bullshitting about its angles or its chain stay length.”
> general critical thinking, analytical writing, and empathy.

I wonder if there is a more direct way to aquire those skills.
Oh you’re right. I didn’t think carefully enough. Thanks! This does seem like a major factor to tease out.
The author seems to exist in a permanent state of enthusiasm, for mega corps and their corpy things.

https://duckduckgo.com/?t=ffcm&q=Justin+Bariso

Just an observation.
I took the IT Support Specialist in early 2019 and it only took 1 week of dedicated video watching and test-taking to do (I did this so that I wouldn't need to pay the Coursera membership fee) (but that was because I already had a strong background in IT support/troubleshooting, software development, cybersecurity, and was intermediate in networking). I feel like the course is solid for explaining the concepts that it talks about, but I can't attest to how well it works for people with very little experience in IT.
Base 65536
Bill Gates has said that predictions about technology tend to overestimate the near term and underestimate the far term.
Color Wheel Frustration
Thankfully I create all my projects on the CLI first, so my immediate workflow isn't currently going to be upended by yet another SaaS putting a gun to my head and telling me its making a change and I better play along if I don't want to lose everything!

A little overly-dramatic for this particular instance, but this and the following results should be a very good signifier at just __how much__ power GitHub (i.e. Microsoft) has over the entire OSS/Non-OSS/Developer community (how many package/plugin-managers and other pieces of software pull from GitHub first/by default?), and how wantonly they will wield it. This change is going to most likely break a non-zero amount of workflows (and could you blame people for expecting what has been the standard convention since the dawn of time (exaggeration) to stay the same?), and for what? Something with no technical reason whatsoever!
UX: Infinite Scrolling vs. Pagination [Summary]
A giant plant as in someone from their team planning this out and then planting this as a comment..?

simonw wrote Datasette[1] which makes extensive use of SQLite and acts as a viewer, allowing you to create interactive websites and APIs from arbitrary databases. He'd be a very long term plant and it instead seems far more likely he's interested in the possibilities of DuckDB compatibility within the context of Datasette and other similar projects.

[1]: https://github.com/simonw/datasette
I think a lot of the issues on that front stem from the Chinese side where the CCP has placed vast restrictions on internet and application use.
Razer has done something similar with their peripherals. I remember buying a Razer keyboard that I later realized required an online account and some Synapse software to configure in any meaningful way. Quickest return I ever made. Razer's privacy policy is dicey and then there's this[0] which inspires loads of confidence.

[0]: https://www.pcmag.com/news/razer-accidentally-exposed-custom...