skysight-inc/HackerNews huggingface dataset:
PacketStream | Various Engineering Positions | https://packetstream.io | Onsite | Los Angeles | Full-Time

PacketStream is a peer-to-peer powered residential proxy network. PacketStream lets residential & mobile ISP customers resell their bandwidth through the PacketStream desktop client. PacketStream has applied the “sharing economy” model to residential bandwidth. Business customers purchase access to the proxy tunnel for use-cases such as web scraping, automated business intelligence, ad fraud detection & brand safety.

Our codebases are mainly Golang. We use some nodejs for the electron client wrapper and a few bash/makefile scripts for internal devops tooling.

Infrastructure is k8s/aws/terraform/psql.

Email ronald@domain
I am! SQL is the language of data and analytics and it can be quite a joy to use. But maybe I've just Stockholm'd myself into liking it.
You don't create statements by concatenating strings. Use prepared queries with placeholders and pass values. Databases will compile the query once, then can run it many times.

Sometimes you have to concatenate, e.g. to specify order by clauses. This is something database vendors need to fix. There need to be ways to tell the database to modify a prepared statement without changing it's SQL. You might be able to do it with a crazy IIF, but then it's likely not to use indexes well.
New concept of the day: Object-Relational Mapping, converting an object, with all its members of diverse types, to a format suitable for storage in a database, roughly a table of scalars.
You'll have to pry Hibernate and Spring Data JPA from my cold, dead hands. Extending CrudRepository and getting a ready to use repo for an entity type, combined with annotations for customer JPQL queries? Yeah, I'll take that over any hand-rolled, low-level SQL interfacing for almost anything.

But, as always, "use the right tool for the job." I have gotten tremendous value from ORM's over the years, but I'm not going to insist on using one for everything just "because".
It's great when you have good database ci systems and have your database schema versioned + sprocs in source control.

But I've worked places where dba refused to use version control.
A lot of the symptoms of sleep apnea look like Chronic Fatigue Syndrome on the surface. If you feel tired all of the time no matter how much you sleep, get a sleep study. Sleep apnea is pretty treatable. You don't have to be overweight to have sleep apnea.
Yeah, accepting anonymous invites is dumb.

I definitely don't want my email application looking at my contacts' contacts, though. That would leak information. And would only work within the same provider.
unless you turn off images, sound and video and probably javascript, I'm afraid you're gonna have a bad time with that "5kb" news article.
Contacts of contacts would be a privacy violation.
Location: Antalya, Turkey

Remote: Yes

Willing to relocate: Yes

Technologies: C++, C, CMake, Linux

Website: p1v0t.gitlab.io/posts

GitHub: github.com/p1v0t

Email: adembudak[at]outlook.com

I'm a 25 years old C++ programmer, looking for a position my hands dirty with C++. More information about me available on my website, please feel free to checkout.
Garbage is garbage.
Since the deal did not exist before the original vote, it would be hard for people to understand less about it now.
It'll be interesting to see how long Bluetooth headphones will last. You lose one vulnerability (the darned cable) and replace it with another (battery).
A System for Sustainable FOSS
I recently had this problem in an old Samsung phone. The spam was not directly coming from email, but from some other installed app which was somehow tricking S planner (Samsung's calendar app) into adding the events to google's calendar, even though the original spammer app had no calendar permissions.
I agree. I've been a Pocket user for years longer than Mozilla has owned them. The New Tab page should not be making any external requests. If I want to see Pocket content I'll look at Pocket.
> ORM protections against SQL injection attacks are worth the clunky syntax. Change my mind.

Is there a driver out there that doesn't support parameter substitution?
This is a large but hardly the only aspect of compatibility:

- Can I use friends'/family's chargers? Can I use public chargers?

- Are my cables going to become difficult to find? Can I pick one up at the corner store in the middle of the night because mine failed?

- What's going to happen when I need to interact with old hardware? Are converters available?

Compatibility problems don't arise in perfect conditions, when you're at your desk with all your own current equipment. They arise in all the edge cases you will have to deal with over the at least several years you have a device.
I'm going to project my naivety here and ask how does one write raw SQL queries in code? Should said queries live in their own files and be referenced when needed or are the queries usually written where they are called?

Bonus points for open source examples.
Btrfs: Add sha256 as another checksum algorithm
> Glad to see it's on GitHub now!

Ah, that github link is not the official repository. The following link appears to be the official repo:

http://git.annexia.org/?p=jonesforth.git
Two channels, one showing a story of a victim, another of the perp. I'll watch the perp, because their story is more relevant to me. I might learn about how they select their victims, or some detail about how it could have been prevented, something I could get behind. Maybe I can at least salve my psychic pain by categorizing the murderer and so feeling a measure of control over the chaos.

But when I watch the victim I just get to relive the horror from my own life and so many past media circuses. My own experience is that I don't get a lot of motivation from wallowing in that kind of loss.

I want to know why, and the perpetrator has more to tell about that than the victims.
There is nothing particularly impressive about the Apollo program, at least not these days. You are essentially comparing today's frontier of High-Tech research with 50 year old "needs to work reliably" technology, which had different requirements even back then.
Mainstream news is to a degree more problematic when they formulaically follow a narrative and don’t bother checking the assumptions and present misleading or overreprsenting information.

That’s because people are apt to believe those sources and not critically question them.
Almost all, except the old php mysql interface. Unfortunately, that happened to become one of the most popular and influential ones.
USPS comes daily to my house anyways (usually to deliver junk that I don't want)... seems like it should be feasible without causing chaos...
It's unreasonable to expect one cable type, because the additional costs for cables that support very high data rates or very high power delivery are prohibitive for cheap devices that don't need those.

What they do need to do, though, is minimise the different cable options and make them easy to distinguish. My suggestion would have been to have a basic USB-C cable with exactly two optional designations: +FAST and +POWER. It's then easy enough for a device to say "this requires a USB-C+FAST cable" and consumers to then look for the same.
The central metaphor of this essay reminds us that 2006 was a long time ago.
The ‘somehow’ is usually a half-baked migration tool

Maybe don’t use a half baked ORM.

I’m experiencing schadenfreude that someone is having ORM problems in 2019 long after the NoSQL hype died.

I can remember on zero hands the number of times my not half baked ORM was the source of my problems such that I wanted to say “fuck it lets just write SQL”. ORM patterns are pretty well laid. Hell they haven’t changed much in at least a decade or more and they work great for the problem they solve. Which makes me think maybe a relational store is not right for whatever you’re using it for.

tl;dr If you have ORM problems I feel bad for you son, I got 99 problems but SQL ain’t one.
ORMs are for suckers.
DB Drivers are for suckers.
I interact directly with the port 3306. ;-)
can't wait for USBS
The sweet spot for me is a query builder: a tool to generate SQL and treat queries like code, and not get in the way like a heavy ORM. Shout out to http://knexjs.org/ for Node.
Interesting indeed considering it has E2E encryption and RCS does not.
But you're not actually answering SketchySeaBeast's point. The point isn't that "some record will be broken in some part of the world". The claim is that more records are being broken in more and bigger parts of the world. That claim should actually be statistically testable.

And it has nothing to do with NOAA's inability to accurately predict six months out.
Bingo. Only clarification I'd make is to this:

>This means your government can only take rights away from you but it doesn't have the power to ever grant you a right.

My understanding is that the government is unable to grant nor deny you the right, only infringe upon it. The right is always there by virtue of your existence, so it can only be infringed upon.
What do you run docker on?
"...they force you to design schemas in your implementation language (python, javascript, java) and then export them to SQL ‘somehow’."

No, they do not. If yours does, throw it away.
> I doubt anyone wants to read white text on a black background.

I do! Much less eye strain and easier to read for me. In fact, I read your comment in white text on a black background. My eyes are very sensitive to light in general though.
Who's privacy is being violated if a friend of a friend invites you to do something?

The system in my mind wouldn't tell contacts of contacts "hey, did you know you can invite this person that you've never met with the email@gmail.com that you were previously unaware of (and knows Susy and John) via google calendar?"

It would just whitelist contacts of contacts, and would probably cut out 99.9% of the spam with little to no impact on the user.

It's much less intrusive than Facebook saying "hey, these two friends of yours know this person who is not your friend, do you know them?", at least.
This is hacker news, please try to keep your comments constructive
I would agree with this idea… except device manufacturers can't even manage to not put the port in backwards, or print the labeling on the wrong side of the connector. (Yes, the standard mandates a particular orientation for the ports. But there's so many non-compliant devices out there, good luck knowing that.) I don't think they'd get such a thing even remotely close. There's just too much low quality crap out there.
Doesn't look like they've actually stopped.

https://lepinworld.com/
The truly crazy ruling was US v Miller [0], the case that is the foundation for essentially all gun regulation from the National Firearms Act onwards. A ruling where only the government presented an argument, because the defendant was in hiding after testifying against the rest of his gang.

> It was a crazy long hard won battle to make that sentence mean something it clearly and obviously doesn't.

I'd like "shall not be infringed" to have meaning again, thanks.

0: https://en.wikipedia.org/wiki/United_States_v._Miller
Humans went to the moon. I'm impressed.

Magic box I hold in my hand to communicate near-instantaneously with the other side of the world... somehow less impressive.
Thank you for clarifying. Didn't know you could do that! Then again, I haven't played around with Android developing in a few API versions.
So GOPROXY is like AMP for my Golang codebase?

Edit:
:)
Elizabeth Warren embraces Jay Inslee's climate change platform
Every orm I know about has a raw interface for doing this
They literally have democratic representation, though. They vote. They exercise that power all the time.
A new paper on kinase inhibitor discovery is not an AI breakthrough
Lulubox for Free Fire
Are you a free fire player? Or any other mobile game lover? Guys try this app right now! You will get the premium gaming experience just for free. Read this article for a complete guide.

https://lulubox.download/en/Lulubox-for-free-fire.html

#luluboxdownload #lulubox #luluboxforfreefire
People hugely exaggerate this IMO. If you're writing a lot of queries that can't be composed, with sufficient performance, in ActiveRecord, but can be in raw sql, then you've probably done something hair-brained else-where.

And for those special (and IMO pretty rare) occasions, you can drop down to arel or raw SQL anyway. Why throw away the consistency and readability of something like AR for edge cases, when you can just treat your edge case as an edge case with raw sql and still keep AR for your other 95% of queries.
My cousin has being diagnosed formally with MCS and co-morbid CFS, both illnesses with some controversy. I've spent time with them, and learnt that the "psychosomatic school" has always been the prevailing school of thought on the subject, and this presents many hurdles to their every day life, and potential treatment.

The possibility that there's at least a component of the illnesses that aren't psychosomatic is worth considering, but such a school of thought has always been on the fringes, and serious funding to examine actual causation has always been a challenge for illness communities that have offhandedly been thrown straight into the looney bin.
> What does git history has to do with the database?

Hopefully a lot. Non-versioned database schemas are the devil.
Everyone is downvoting you but the pizza gate conspiracy seemed ridiculous when it came out, and now it just seems like what they got wrong is that it probably wasn't happening at Cosmic Pizza, and was happening at a way more massive scale than they'd assumed.

I think the reason people are downvoting your comment (aside from the obvious reason, which is that it's a little low-effort) is that people didn't like pizzagate. It had an altright, Trumpy 'beware the deep state satan pedophile illuminati' feel to it that we oppose being true for identity reasons (ie, we are not those people who say trollish, unintellectual things like that!).

Although pizzagate is false, it's not as false (in a kind of Bayesian way) as it was before the Epstein island entered the public conscience.
Randall Munroe on his new book and the joys of using science to build lava moats
Charge-Based Prison Term Prediction with Deep Gating Network
>The kernel teams at most large companies, even large tech > companies, are not that big.

It's not just about the kernel. You're talking about entire ecosystems of core utilities, filesystems, network stacks, security mechanisms, virtualization and resource-control subsystems (e.g. cgroups), performance profiling and tuning, etc. They're different systems from top to bottom, just like when I switched from 4.3 to V.2 thirty years ago.

> Commercial support

Stop right there. FAANG companies aren't going to buy support contracts. They'll hire the maintainers instead (like they did with me and hundreds of others like me at my current company). They're not going to split that effort across multiple platforms. They'll focus on one, then hire thousands of developers who don't even realize the tools and interfaces they use are Linux-specific. Then all of the wannabes will copy them, for the reasons I already mentioned. The network effect has gone way beyond any chance of reversal. Sorry.
Yes. The specific scenario GP described is about SuperMicro and Amazon if my memory is correct on the parties involved.

Edit: it was for sure SuperMicro and Amazon.

https://www.bloomberg.com/news/features/2018-10-04/the-big-h...
So, the drones spray Monsanto/Bayer insecticides.

I have to remind myself whenever I see Bayer, that they bought Monsanto so deserve any bad karma they got in the deal. Hear Bayer, think Monsanto.
> Climate change is hard to overlook, for example.

Yes, climate change is a significant exception.

> Income inequality is rising. That leads to more of the kind of statements you’re objecting to.

Income inequality is not a bad thing on its own, though. It is bad when the people at the bottom are struggling to get by, though. And it's the struggling-to-get-by people that are disappearing at an incredible rate.
A good idea, though I'm sure Harvey Weinstein disapproves.
Obv this is the most valid question.

Lets all marie kondo the fuck out of china: china does not spark joy.

So just minimalize the entire world.
Damn, I bet the success in education in Finland can be hugely attributed to just having actual recess between classes for all the classes and through the whole basic education (comprehensive school and upper secondary / vocational school).

Here's actually a somewhat recent news on the matter (in Finnish https://www.kaleva.fi/uutiset/kotimaa/aivotutkija-valitunnit...) and here's https://docs.google.com/spreadsheets/d/1UC_7A7Zpe-FEK__blB6g... a somewhat normal (though day length variation seems to not happen much in this schedule, it does happen all the time in that you can have shorter days by either going to school later or leaving earlier, too) timetable for an 8th grader.
While that's true...if you were to redistribute the wealth of the world's richest people to the world's poorest, you would accelerate climate change by at least an order of magnitude over night.
In most applications you're going to be doing both things, I remember Rail's ORM was always presented this way: it's the far better option for simple object relationships and CRUD style systems but you can still write raw SQL as needed for complex stuff or things requiring performance optimizations.

There's plenty of ways to manage complexity in software. Two or three different databases in a single app doesn't kill them, nor will two different DB interfaces.
If the race is predictable betting no longer involves a gamble and could be considered unethical.
Here's some Finnish 8th grade timetable I found and translated for you:

https://docs.google.com/spreadsheets/d/1UC_7A7Zpe-FEK__blB6g...
SQLAlchemy for Python can do this without having to use the ORM-side of it
> So you know one guy that quit over having and ORM instead of using SQL... do you have any idea how many quit due having to deal with thousands of lines of SQL string concatenations because some genius that also hates ORMs decided to do a giant project that way?

Those aren't the only alternatives. Query builders exist.
Correct me if I am wrong, but I think the insertion/deletion time complexity is incorrect. It should be O(N). If each DEQ is implemented using array instead of list, wouldn’t the insert/delete operation of IgushArray still take linear time? Since popping or pushing (pick one) of DEQ implementation with array still take linear time, that means, let’s say insertion is at position N/2, then N/2 ... N-1 elements still need to be moved to the right by one? Popping/pushing is only linear if the DEQ is implemented with linked list, but that would mean linear access time instead of constant.

Update: answer is to implement DEQ with circular buffer for O(1) pop/push.
The NFL requires teams to report all injuries no matter how minor.
https://operations.nfl.com/media/2683/2017-nfl-injury-report...
So I want to respond to this because there is a genuine question behind your rhetoric. And that question is "How do I cleanly do complex things in SQL without an ORM?"

And there is an answer to that. The idealistic answer is good DB design from the start. The realistic answer is by using views (sometimes materialized views) to create a clean representation out of odd tables.

The monster query can be decomposed into simple and clean operations against these views (and if necessary, views upon views).

The only caveat is you need a SQL expert to understand the performance if you want to do this at scale.
I personally believe that it's extremely unlikely that CFS has a silver bullet cure like stomach ulcers because CFS is an umbrella diagnosis for several distinct conditions manifesting with similar symptoms. The DSM condition is diagnosed through tests by exclusion rather than a single diagnostic test that shows up positive. More apt comparisons are, therefore, migraines or fibromyalgia than ulcers. Patients with CFS have a diverse range of symptoms and comorbidities. I have two relatives with CFS with radically different symptoms and health backgrounds. One has an autoimmune syndrome and has been through several sleep studies. He literally never experiences REM. For him, tiredness is a constant but sleep is never restful. This isn't a psychiatric condition; it's physical. It's also completely debilitating. For years he tried to power through it (he was a management consultant for years and destroyed his health trying to keep going) but this is not a condition that you can will away.

The other relative had a bad reaction to medication following a virus and never quite recovered. I will readily admit that her condition's roots could be autoimmune too, but she suffers from physical fatigue rather than tiredness. She has to be extremely careful not to overwork or overexercise, but her life is otherwise unimpaired. My relatives rather clearly don't suffer from the same condition but they're diagnosed the same way.

Having said all this I doubt I changed your mind, so let me make a slightly different point: what are the minimum and maximum amounts that you could sleep tonight? If you wanted to, could you sleep for 12 hours straight? How about sleeping for 12 hours for back-to-back days? I know that I can't! I'm literally physically incapable of it. I cannot sleep for more than 10 hours, even if I've accrued a massive sleep deficit (and usually it's more like about 5-7 hours). CFS is not laziness
It sounds like you will
Intel's been claiming that density for over two years.

https://spectrum.ieee.org/nanoclast/semiconductors/processor...
It is, but keep in mind that there are biological markers that are correlated with having chronic fatigue syndrome at p < 0.001 kind of levels.

e.g. if you happen to have blood work from a patient pre-CFS and post-CFS it's very, very common to see a raised T-cell count and an immune response against the Epstein-Barr virus (or some other retrovirus) in the post-CFS that isn't there pre-CFS.

Of course, it's not a great diagnostic tool because you need the patient to have had some blood work just before they got sick. But it does make the "it's all just psychosomatic for everyone" argument a bit unlikely.
One of the great things about a mechanical keyboard is the repairability. When I spilled a drink on my keyboard and a few keys got sticky, I just ordered a few switches online and replaced them with some basic soldering. You probably won't be able to find any replacement parts for most keyboards.
Also, while it's not best keyboard, it's fairly easy to find replacement key caps for Apple keyboards as well.
And (as you know, if you've read the linked article) nondeterministic parsing is not fast.
There’s an old saying that in America we have socialism for the rich and capitalism for the poor.

Maybe cronyism is a more correct term, but I don’t see why it’s such a problem to use the above phrasing.
I love when people blame video games yet they forget that the majority of mass murders
are happening in the US.

People play GTA in Bulgaria, Israel, Russia, Egypt, Thailand, Australia etc. Everywhere. Switzerland even where 70% of the population has weapons at home yet they don't kill each other every single week.

You know what's the difference? The access to weapons. But I guess that's the founding fathers wanted so it's all good
I am already a minimalist.

I can do this.

The problem is i still need a small amount of things (which i already have, which were made in china (crock pot, etc), but ill have to work even harder to stick to my statement)
And - fun addendum to this - Active Thunderbolt cables don't work as basic USB cables - https://appleinsider.com/articles/17/08/15/psa-thunderbolt-3...
I don’t think we need to change human nature. I think we need better (more democratic) institutions that people can rely on.
> SQL should be the source of truth

There are frameworks like JOOQ or MyBatis that work this way.