skysight-inc/HackerNews huggingface dataset:
If you don't need transactions, then MySQL with the MyISAM engine has several aspects I love:

1: Blazingly fast. As it simply hands DB writes to the OS and benefits from all the caching and optimization the OS does. Depending on your storage medium, insert/updates/deletes often are 100x faster then with an ACID compliant engine.

2: Simple data structure. Want to see the sizes of your tables? "ls /var/lib/mysql/your_database" and you see each table as two files. One for the data, one for the indexes.

3: Easy to copy the data "cp -r /var/lib/mysql/your_database somewhere" and you are done.
Ask HN: What are the best blogs and resources for starting as a contractor?
I'm about to start contracting in the UK and I would like to get a better understanding of the market, and learn how to find the most rewarding contract work.
So is lobbying for a bailout from Congress by that criteria.
Ah, so they should only release the contents of your doctor checkup if the doctor is a government employee, like in the UK.
Yes, and to be honest, insanely out of date. I'm not telling you Teslas are the safest car on the planet, just that the "Volvo = safe" is, I don't know, maybe an early 80s mentality?

It ignores decades of changes and infinite nuance into how cars are tested and evaluated for safety. There are all kinds of measures under which a car's safety can be evaluated, and to boil it down to "Volvo has the most safety features" is far sillier than even Tesla touting themselves as the safest cars. (Teslas do fare very well in current crash tests, though).
Of course you put supports under it. The point is the low amount of mass required.
> Atomic Rockets is mostly focused on propulsion rather than other aspects of vehicle design.

Are you sure about that? I remember reading some really interesting stuff about effective limits of laser range there, and the sections list shows ~5x as many non-engine pages as ones dedicated to propulsion.
You could upgrade to a 2015 -- those have no touchbar and the old keyboard.
New York is slowly rolling out a new payment service called OMNY.

I was curious to see what data privacy looked like in the new system. OMNY's Terms of Service does not say anything about how they might access your personal data from a NFC or contactless card payment until you register your account, which is optional. In that case, the following policy applies:

> In providing us with OMNY Account registration information, you confirm that the information is current, accurate and authentic. You agree to keep us updated if any of the information you provide changes. You authorize us to make inquiries, whether directly or through third parties, that we consider necessary to verify your identity or protect you and/or us against money laundering, the financing of terrorism, fraud, or any other illegal or suspicious activity, and to take action we reasonably deem necessary based on the results of such inquiries or investigations. When we carry out these inquiries or investigations, you acknowledge and agree that your personal information may be disclosed to prevent money laundering, fraud, the financing of terrorism, or any other illegal or suspicious activity to the appropriate authorities.

Curiously, it's unclear from anywhere on OMNY's website what the program's name stands for: https://omny.info
"Maybe we should just eliminate subsidies on both and see what happens."

I am completely in favor of that proposal.
who thought grey text on a white background was a good idea?
Agreed.

With caveats :D

They do know the expected expected min, max speeds of the riders, and the most likely time.

I assume that when they file their flight authorisations long in advance that they are declaring the time slots that they will need over airspace, and probably do have scripts for those min/max rider speeds so that they know +/- some margin of error the earliest and latest the helicopters should be anywhere.

Although I'm personally more interested in the plane circling above them for 4 hours :) It makes sense to have it, and has anyone a link to one of it's daily routes?
A very trivial thing (having used both PostgreSQL and MySQL in production for many years) , I find Mysql's EXPLAIN query much easier to grok than the postgresql's query plan.
Order Oxycontin Online
> Protect them from what? Public shaming by people who look them up in databases? Being racist isn't illegal.

Retribution, that was obvious to me.

Examples: Physical violence as retribution is illegal, while being kicked off of board seats and other areas of influence isn't. Being 86'd (banned) from private establishments isn't illegal.

All is possible.
MySQL now has window functions:

https://mysqlserverteam.com/mysql-8-0-2-introducing-window-f...

And MySQL has strict mode, which I believe is enabled by default on newer versions but available in any 5.x version:

https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mo...
there is always a bigger fish
911 calls are hardly limited to dispatching EMTs, though.
Well, Rust is closer to C++ than Lisp :)

If you look at the API https://blog.rust-lang.org/2018/12/21/Procedural-Macros-in-R...

it works on the level of raw tokens, not even the AST. So you have to construct your own AST via the parser if you want to manipulate AST.
I think this is an excellent idea that informs consumers and doesn't stifle developers. It would allow you distinguish between a one-time purchase game (maybe even with some DLC) from an endless money pit.

I see Game A and notice the maximum cost of play is, let's imagine, $30. I can then tap and see the base game costs $10 and there's some additional content I can buy. If I bought everything possible I'm out $30.

Next I see Game B. I can immediately tell that they'd willing take my entire life savings for some stupid candy-themed puzzle game and pass on it.
I've only bought 1 Pi, and it came from Canada. But RPi is based in the UK. Is there a story I'm not aware of behind why so many resellers are Canadian?
Ukrainian hacker sought by US arrested
> it is well known that apple products should not constantly stayed plugged in

I've never heard this before. What's the explanation? Is it related to battery health? Why does it only apply to Apple products?
> If you use your fingers to move a mouse, rather than your hand

This is called the "fingertip grip".

See this for more mouse grips: http://blog.logicalincrements.com/wp-content/uploads/2016/02...
To recruit doctors, California is paying off medical school debt
I think what it actually means is 'you will fly this route past this section of the parcours in this length of time' rather than 'at 3:20 you will be here'.
Probably not if there is a +/- of 10% error rate.
I suspect so-called facts when the framing is bonkers. The assumption that I'm a nationalist would be false, therefore the "facts" aren't really facts.
Current model designs, yes; but the series from roughly 2009-2015 (and the 2011/2012 models specifically [0]) are some of the most repairable and hackable models they've made: pull the bottom panel off the Unibody frame, and all the parts are laid out. Swap RAM, replace the optical drive with a 2nd hard drive, replace the battery, fans, whatever.

Whether the "sealed-airtight-with-glue" patterns of modern Unibody designs are truly necessary (or desirable) to achieve design goals of thinness and weight is hotly contested. :)

[0] https://www.ifixit.com/Device/MacBook_Pro_15%22_Unibody_Late...
If you don't want a source used in civil courts you can just tell the courts they are't allowed to use it.

That's what is done for accident investigation. Accident investigators need to understand what actually happened, not just a bunch of useless backside covering as everyone tries to avoid getting sued. So, their evidence just isn't admissible in civil courts. An investigation by, say, the NTSB or analogous organisations in many developed countries produces a public report, but you can't take that report into a civil court because it says in the law and on the report that it can't be used that way.

It would probably take more effort to ensure this was effective in the revenge-hungry United States of America than in countries where the mainstream zeitgeist incorporates the understanding that hurting somebody else doesn't fix anything, but it could be done.
If You Like 100-Degree Days, You're Going to Love Climate Change
Unmentioned is the insanely obvious: there should just be a way to use a standard contactless credit/debit card for occasional riders. Works in London, Singapore, Chicago, a few other cities.
As an MSSQL guy who rarely connects it to excel, if your workflow allows it consider pulling the entirety of the excel sheet into a table in the db and working on it just from there. What's huge for excel isn't for MSSQL.

As a decades-long user of MSSQL guy who is getting sick of being rpeatedly done over by MS, could you explain why you prefer postgres? That would be incredibly interesting, TIA
I would guess that the French government splashes some cash as part of their cultural budget too.
Technical Dynamic Book Publishing
> Seems like Audible DRM isn't a problem for pirates, 'cause I've seen a lot of their audiobooks on trackers.

I mean, is it ever? Outside of exceptional circumstances like Denuvo, and even that's usually temporary.

> Non-tech people doesn't care about DRM in general, they prefer discounts, and here Amazon plays well.

I could make a similar argument about data privacy. Does that mean we shouldn't bring it up?

But separately, isn't it a bit weird for the article to bring up DRM as a "dark side" of the audiobook industry, without mentioning that DRM-Free audiobooks are readily available?
I'm not sure what gives that impression, but Argo Workflows is under heavy development and is used by several large organizations, including Intuit (Argo team is part of Intuit).
this comment chain seems to be more focused on the moral aspects of privacy rather than the legal ones.

Sure. Fair. Valid.

Except it's really more nuanced than just saying "legality != morality", especially when the rubber meets the road, and when it comes time to actually implementing systems of recording (and potentially disseminating) the public's interaction with their local jurisdictions and municipalities, and I think those nuances get lost when sitting on the periphery of installing policy and reading about statecraft compared to being inside, operating the levers and pulleys and-as the phrase goes-"watching the sausage get made"..

That's why I'm being so willing to challenge some of the notions shared here today: I'm trying to be the voice of the insider and expose some of the reasons why certain things may be the way they are with regards to public data and open records.

You're right legal does not necessarily mean moral, but when it's time for measurable outcomes and results of human actions, and interactions between citizens and their local governments the legal framework does a much better job of delivering those outcomes and results on a consistent basis than most others, and is the framework we use of keeping the operators and participants equally consistently accountable (most of the time, anyway).

The focus, again, I say is warranted.
> The two women who claimed retaliation were organizers of the women's march.

I don't really understand this, the people accused of retaliation against Claire Stapleton are women as well. Why would they retaliate?
It's a webpage built on web standards and designed for web developers. It couldn't get any more webby.

Furthermore, it's fast and it looks good. What's the problem?
> If you are taking drugs with someone and they look like they are dying it should definitely be safe for you to call 911

In Washington state, this is how it is, and there are education programs, and statutes to this effect, telling kids/anyone "If you call 911 because you think your or your friends life is at risk because of alcohol or drug use, neither you nor they will be arrested for that".
A martini can be sweet vermouth (in its early days that was actually more common), but your point overall is valid.
I think WRC helicopter teams are way more impressive.

https://www.youtube.com/watch?v=C7h0OxsCCwA
> Actually Consumer Reports placed the Model S at the third-worst of 29 positions

It was Tesla as a whole that placed 27th of 29 on that list of average lineup reliability (tied with Cadillac at 28th). Tesla tied with RAM for the lowest "most reliable" model ranking at 49 pts, while squeaking by RAM and Volvo for lowest reliability of a model.
An IBM subsidiary worked on software to tabulate census results in order to classify individuals by degree of Jewishness. Is it alright to godwin in order to directly answer an obvious question?
The linked article is a good dive into the internals of Postgres vs MySQL.

However, Uber didn't really switch from Postgres to MySQL, they switched from Postgres to their home rolled document database which uses MySQL as the storage layer. [1]

[1] https://eng.uber.com/schemaless-part-one/
> Radical reduction in job responsibility and opportunity IS retaliation.

Is that generally illegal in the US? if not then what specifically does the retaliation have to in response to to become illegal?

e.g I would expect negative retaliation in response to poor quality work or slacking off etc, and would expect it to be legal. This person's actions would be considered intentional bad PR, so what specifically about retaliating to it is illegal?

(Genuine question)
The drones also can't provide drafts for the French GC riders :-)
That's not how anyone farms currently - you get a better productivity gain from a newer tractor or a better strain of crop then another kid.
If simulation of an entire universe is possible, there are likely many more simulated universes than there are real ones.

You could say the probability of our universe being a sim is much higher than otherwise.
>>Curiously, it's unclear from anywhere on OMNY's website what the program's name stands for: https://omny.info

Figured out from the wikipedia article[1] that the acronym stands for One Metro New York. You're right that they should really have that listed somewhere on the MTA OMNY homepage.

[1]https://en.wikipedia.org/wiki/OMNY
I don't think people are having trouble understanding it. I would rather say some of us have a broader view of it.

It's the same old discussion about whether something is right just because it's legal or allowed. Just because a company has a right -- and an incentive -- to do something, doesn't mean that's a morally or ethically right thing to do.

In my opinion, what Whittaker is doing is, in a way, analogous to civil disobedience. And, just like with civil disobedience, reprisals are expected. It's worth keeping in mind that those reprisals aren't automatically right by virtue of being expected, just as her actions aren't automatically right by virtue of being similar to civil disobedience.

In other words, some of us feel we can't afford to, as another commenter put it, "leave your politics at home and let me do my job in peace". I believe this attitude -- that science and engineering should somehow remain orthogonal to and decoupled from ethics and morality -- to be downright pernicious to the society.
you can't do multi-region failover with mysql either.
btw. multi-region postgres is also not that easy either.

i think the easiest solution would probably to maintain multiple clusters and put something in front of them, like pgpool and write to them simulatiously.

if one write fails rollback all clusters. and hope the read replica of cluster x will take over.
probably something like pgpool + postgres cluster on k8s(zalando, crunchy).

at the moment there is no ledger that can span multiple regions. so your on your own for that.

if people really need multi-region they should probably just buy citus data.
10% of $1000 is $100.

22% of $1000 is $220.

8% of $6000 is $480.

28% of $6000 is $1680.

$480 > $100.
I'm working at three projects with three languages and three different ORMs so you have my sympathy. They're the ORMs of Django, Rails, Phoenix. Rails' got the easiest ORM to use by far, maybe because IMHO it's now the closest to SQL. Phoenix's Ecto is needlessly complicated and Django's is as verbose as Python's libraries can get. Example: Model.objects.get(), because nobody could understand Model.get(), right? /s

So, along the years I felt sometimes like I have to relearn how to do SQL in arbitrary library X, for the sake of it.

However ORMs have an advantage: no need to change queries when adding/removing fields to the database. No need to deserialize data from resultsets. The usually migrate the database either by applying migrations to the database and infer models (Rails) or syncing the db with the model (Django). Weirdly Ecto forces the developer to both write the migration and the model.

My ideal ORM would be something that lets me write

sql("select * from employee join department
on employee.department_id = department.id
order by employee.id desc limit 10").each do |record|

puts("#{record.employee.id}, #{record.department.name}")

I don't know how that would play with static typed languages but if all ORMs would be like that we could know only SQL and be able to perform arbitrarily complex queries.
Thanks for pointer!
No, it's not Paul, but wouldn't it be ironic if it turned out that the designer and architect of the original Bitcoin protocol was (partially) responsible for putting him behind bars?
But how would they know who to ticket? Just because your car is moving, doesn't mean you're the one driving it. If they cannot prove who was operating the vehicle at the time of infraction, they cannot issue a ticket.
>I wonder if OP was referring to any of the more immediately concerning positive feedback loops

Yeah, that's why I prefaced it with it being a dumb question. :)

If the feed backs are accelerating global warming, it wouldn't be too distant a notion from the premise of runaway greenhouse gases.

I'll have to brush-up on my nomenclature to not ask such bone-headed questions in the future. :(
Suppose Google hired person X to take their mind off the market.

How would person X discover this?
I had that happen with the original Microsoft Ergonomic Mouse. The Magic Mouse has been fine. In fact it's my favourite mouse design ever, and I absolutely love the touch surface.

The bottom charging is kludgey, and there was probably a more elegant solution. But you only need to charge the mouse once ever couple of months, so it's not a huge problem.

However, I would guess my hands are not the same size as your hands. You don't have to be a design genius to understand there's a ton of variation in hand size, and one-size-fits-all products don't.

A genius product would be a resizable mouse with an auto-resizing guide to help you pick the right size and curve for your hand size and grip style.
Open Sourcing Brooklin: Near Real-Time Data Streaming at Scale
Forbes' Next Billion-Dollar Startups of 2019
Spy software? You should actually go to their website and inform yourself of their primary software offerings.
> should be such a low price point we laugh at it

Let the market decide the price
> Apple wants to prevent users from leaving the mouse connected with a USB cable all the time.

This happens a lot with Apple. Good, bad or otherwise, they constantly solve customer issues when the customer isn't really having an issue.
Here's a small video on the helicopters: https://youtu.be/2iiQiXsQDWU?t=14 (warning: LOUD)

on the relay plane: https://youtu.be/6by7a6FPZ58?t=14
There are also companies like The Flow that offer that data directly from mobile devices via an app.
It's totally fine until you show up in front of your computer one day and find that you can't use it because the mouse has run out of battery.
The question how surprising something is is useless. Ask what makes a good person, not what makes a person a good predictor of the human potential to be rotten.

> If my company started doing business practices that I didn't approve of, I would try my hardest to change the direction from the inside out or I would leave and then criticize

Or maybe you'd stay, and maybe you'd retaliate against whistleblowers. There is no way to know, it's moot speculation. What we do know is that if the people who retaliated against the whistleblower had acted like you say you would have acted, they wouldn't have been around to retaliate.
surprised they omitted the shittiest thing ever made: TouchBar
The averages include non-functioning alcoholics, drug addicts, retirees with no money to live on, who don't want to be a burden on their children, chronic gamblers, people in serious debt, people who are terminally ill, people who are too depressed to hold down a job, veterans with PTSD...

In short, not the same demographics as people holding down 'decent' jobs for the area.
Prism v3 Adds OpenAPI 3.0 and Goes Open Source
Sure, I was referring to the fact that the main reasons for the training is due to safety requirements.

In the original article it seems like the importance of the safety procedures were minor compared to the director's needs.

As a side-side note, several years ago I happened to be involved in a couple "normal" projects (construction) involving transporting machinery and materials via helicopter, and the guys doing the actual work, besides the helicopters pilots, the ones hooking/unhooking the loads (that we provided) followed (understandably) much, much more strict safety rules than "common" building crane operators and workers, including (much like - say - firefighters do) exercising on things like quick load release, communication (via radio), ropes/belts checks, etc.

It's risky business.
Deep Representation Learning with Genetic Programming (2018) [pdf]
Not just Linux, but ChromeOS is based on Gentoo Linux (originally Ubuntu); which is to say, much of the userspace stack was pre-exsting as well. The core of the operating system is the Chrome web browser, which was also a pre-exsting project, which a relatively clear business interest to Google (influence over the web platform).

Android has a bit of a better claim, as more of the userspace stack was written for it. It also wasn't started by Google (although they bought Android Inc. years before it was released publicly).
Normally, it would not be the input to be sanitised, but rather the output properly formatted. It's easier to make sure that ANY type of input is shown properly, as opposed to eliminating SOME of the known issues.
How about a Qi certified mouse and mouse pad?
Seriously, I take BART daily and it would benefit greatly from the biggest gates they can find. So many of BART's problems are caused by fare evasion.
* Subject to Tesla's definition of "good faith".

Another hacker who discovered references to the Model 3 in his car before its announcement:

* had his vehicle firmware downgraded to a version that contained no such references

* had his vehicle blocked from receiving further firmware updates

* had his vehicles ethernet port disabled

* [deleted] caught some commentary from Musk about his hacking behavior put himself, and other drivers at risk.[/deleted]
I have received on 4GB RPI 4. So it has been shipping...
Bingo! Clearly, with FOUR USB ports the I/O strategy of the Pi family has been quite USB-biased since the beginning. I'm pretty sure that means the Pi designers expected people to use USB to fill in the interface gaps!
Output sanitization is what you want to bet on. Only your website / app knows where a piece of data will be displayed, so that is when you should apply appropriate encoding of the output stream.
For some morbid reason I love those accounts of random law trolls, thanks for sharing.
Specifically referring to Western cities... Author does use Tokyo as an example of excellent fare control when needed due to usage later in the article, so they do agree with you there.
While perhaps legal I don't think I have seen a set of asbestos brake pads in my years since working on my own car (15+ years). Perhaps they are still made but I think you would really have to go out of your way to get them. Someone correct me if I am wrong.