skysight-inc/HackerNews huggingface dataset:
Two big pitfalls seem to hit almost all of these "low-level optimization of how the database handles..." type posts: the importance in optimizing the system, and the use of other technologies.

Write activity impacts database query caches. Many applications do not require realtime-accurate results from the database and generate a substantial number of the same paginated queries. For these cases, it is very important to consider higher-level caches within the system -- CDN, page-level caches, page block-level caches, etc. as caching your 99% traffic pattern will provide DB platform headroom to support your 1% traffic pattern.

Where the results you are paginating are based on any sort of matching (SQL WHERE), most read applications see a sizable benefit in integrating a search platform. Data selection for display is handled in the search layer, and underlying data retrieval for display happens either from the search layer or via the backing database using inexpensive lookups via primary key.

One of the key considerations not covered in the article is the need for result consistency when paginating, e.g. if the underlying data changes. It is the need for this consistency, not the desire for performance, that I see as the primary reason to include primary key identifiers or timestamp values in your pagination strategy.
"Some days you are the dog, some days you are the tree / fire hydrant" is the canonical quote.

I would assume the fire plug is the name of one of the things that failed while he refueled. Doesn't quite go together in my head, but once you understand the original quote it makes sense. Some days you're on the giving end, some days you're on the receiving end.
The Usefulness of Useless Knowledge by Robbert Dijkgraaf
I can't access bitbucket.org, so...

Edit: / works, repos don't
First, my HDMI port blows up and have to work on a small laptop screen.

And now I can't access my repositories..

Not happy.
The page shows that git over https is still up, so hopefully it's just a peripheral problem rather than a fundamental one.
Will be interesting to hear about what happened/went wrong...
How did your wife and kids take it when you lost your house and you all had in move in with your mother?
God would not use an imperative language.

p.s.

Look, imperative is most of what I've done and ~understand. I am not making it out to be inferior, rather questioning fitness for the job. Time and Place peekaboo thinking just seems pedastrian for a transcendent entity devising a world. (That's even an inside joke in Genesis with God looking for Adam.) Short scripting of little bits, sure, but blueprints and stuff, no way.

But, yes, this is just an opinion.
Vinod Khosla on A.I., Health, and the Future of Working (or Not)
I can vouch for pygal, if you can find what you need in the set it provides. I found it quite hard to customize some elements of it (ended up doing post-processing on the output SVG).
The jellyfish was always beautiful to watch.

https://www.youtube.com/watch?v=mKMN-dz8n3k
Sorry, sarcasm alert. They are showing "We ran into a minor glitch.". I definitely don't agree with their assessment.
As a Parisian driver, I think I understand exactly what he means. Other Parisian drivers violate the rules with a nicely predictable scheme where non Parisian may respect the rules but are very dangerous and get horned continuously.
No one should care about a community that agrees that releasing silent patches is a good idea. This is exactly the same behavior that created the need for full disclosure in the first place. And no, there aren't just two options nor are processes binary. It's rather mind boggling how "the community" has managed to go full circle in such a short time and themselves become the opinionated people they were supposed to be the alternative to.
> you can't preload the whole internet

"You wouldn't HSTS the whole internet, would you?"

Google: "Hold my beer..."

https://nakedsecurity.sophos.com/2017/10/03/google-is-making...

Right now it's mostly unimportant new domains, but it's a start, and they could convince other domain registrars to follow-suit.
Downvote? Even more miserable.
I'll take both as TL;DRs.
What are the rules for if following them makes them dangerous?
> lifting your foot off the brake right as the car stops

You can do that even if you're braking very hard, and it doesn't have to make your stop slow. All you want to avoid is that bounce back right at the end, and backing off the pressure a bit just before the full stop will be enough to achieve that and create a very smooth ride. Of course you will always have the deceleration but for passengers that's far less jarring than the bounce that happens when the front suspension unloads when the car has stopped.

Fortunately it's easy to practice as stop signs are everywhere.
Understandably different benchmarks have different measurements of success (scores vs. time spent in seconds, etc) but I agree this could be displayed better some way.

Perhaps simply outlining/indicating by colour or a visual marker for the better performer on the chart.
I've said it before and I'll say it again... It makes zero sense to centralize something that was meant to be decentralized.

We need issues, pull requests, comments, milestones, wiki, etc... all to be decentralized.
No reason this stuff cannot be modeled using existing Git objects.

GitHub, GitLab and BitBucket are extremely similar. Almost 100% overlap, you could use the lowest common denominator between the 3 and you'd still have 95% of the features.
This is why it is important to keep backups of backups ^.^

EDIT: I upvoted you twice, HN just loves to downvote anything ;)
And before that, it hit a high of $31 and crashed to $2, and slowly recovered to $13 over the next year.

Ethereum crashed from $21 to $7 last year after the DAO theft. A couple months ago it went from $420 to $130.
How to Choose the Right Cross Training Shoe
Best cross training shoe choosing and buying guide and reviews. This article will talk about how to choose the right cross training shoes.http://syedtutul.me/right-cross-training-shoes/
I'll up the ante, there is a hurricane in Ireland.
Because you are replaying the packet, which doesn't need the key.
Often there's no preservation of past failure states so people can see (for whatever reason) what the failure looked like. Here's what https://bitbucket.org/chromiumembedded/cef/ (a totally random repository that was in my history) looks right now: http://archive.is/g0I6O
Code analyzer turned out to be smarter than a creator
For most of them the day after, when I get a notification from my RSS app...

No. I also don't expect them to choose device based on security. That is very bad as vendors won't care about patching their older devices (look at Android devices, home routers...) and vendors won't care about patching their flagship devices fast as they have the possibility to request very long embargos.

Making compromises for those vendors and giving more time for security agencies and other bad actors to silently exploit the vulnerabilities (where FOSS projects would have made patches for users that care) is not the way to go. That philosophy actually makes everybody less safe.
You're right, my mistake, I didn't check the speed of the OP's
I can’t read the whole story without paying money. Is there a link to a free version?
What is Functional Programming?
>Given the kind of unreasonable demands, people do crack.

Haha. As in mentally or the drug? :D

P.S.

Awesome video, thanks for sharing.
OK. What is I taught chemical warfare to SS? Would your opinion be the same?
Right, just give them a C plate.
Instant Approve Article Submission Site-Syedtutul.me
Yeah but when that happens you probably look for weapons, not GPUs :)
let light = true

?
This once again shows why complexity is evil in cryptography. The likelihood of a vulnerability in a cryptosystem increases exponentially with the number of state transitions it has.

http://cr.yp.to/talks/2015.10.05/slides-djb-20151005-a4.pdf
At least it’s not running with the cringe titles this article had on CNN: “Don’t tell kids, Santa is dead!” I’m being serious.
Yea but time degredation of TCOX etc after losing a signal is a thing
We evolved in small communities where whatever germs existed were likely shared by the whole community, and contact with strangers was rare compared to today.
Thanks for the link! WebGPU looks like it could be quite powerful for ad-hoc grid compute ;)

https://www.w3.org/community/gpu/

https://github.com/KhronosGroup/WebGLNext-Proposals/tree/mas...

https://github.com/google/nxt-standalone
With traffic, agreement often matters more than the specific rules.
The modern over-reliance on statistics and "expert opinions" for things that should be plenty obvious by mere observation is infantilizing and detrimental to thinking. It's like we only experience the world through ready-made conclusions.

Even so, we do have studies that have already tracked levels of various symptoms of decreased social interaction / cohesion / etc spanning over decades.
> Further, I realize that this award might bring some additional eyes on me who will watch how I act and behave. I intend to keep trying to do the right thing and act properly in every situation and I know my friends and community will help me stand straight – no matter how the winds blow.

That's a great attitude.
https://sealevel.nasa.gov/understanding-sea-level/projection...

It's actually 1-6 feet in 80 years, now, and current models predict slower rise that is being currently observed, ie, risk to upside.
That horseshoe effect you mention just goes to show how limited the bipolar-spectrum representation of political stances really is. Anarchism can be implemented all sorts of ways, and can easily be considered orthogonal to the conservatism-liberalism axis, in the cosmopolitan as well as the American-appropriated senses. s/anarchism/{communism, socialism, authoritarianism, fascism, *ism} and you have an equally valid statement.
Well first you're conflating a few things that are totally safe and reasonable corner cutting measures versus things that are actually illegal and should be.

Second, we're not going to replace all cars with autonomous cars overnight, so autonomous cars need to be able to deal with unpredictable human drivers, even if only temporarily.

Thirdly, in my experience, it is oftentimes the overly cautious driver that causes more accidents than anyone else. If the self-driving cars are emulating the people who do the exact speed limit on the highway in the left lane, this is not a good thing because the deviation from the established norms of any given highway is the best indicator for where accidents are going to occur.
1. Businesses need a "halp everything is on fire" button that costs them $1000 a second but will fix EVERY issue, (virtually) guaranteed by SLA. Ultimately that is what these orgs provide; the hosting is kind of almost secondary to that.

2. Actually building real-world implementations of "Issues, pull requests, comments, milestones, wiki, etc..." requires top-tier engineer[ing] time and energy to build and maintain. The current Git-on-steroids-aaS approach provides a very successful way to fund that undeniable cost.
> No reason this stuff cannot be modeled using existing Git objects.

That's the easy part.

The hard part is discovery and keeping stuff like teams and moderation when you decentralize it. Advancements in Blockchain-tech, IPFS and similar will make this viable soonish-ly, but I think we are not quite there yet from a technological standpoint.
Sounds like you might like Fossil. [0]

I don't see git reaching beyond what it does right now, but a few others do, though they all involve a learning curve.

[0] https://www.fossil-scm.org
There are already regulations allowing for that, but they are not used everywhere because some people abuse the privilege of being allowed to use their own judgement. If (and only if) everyone practiced good judgement and restraint, the regulations would not need to be so prescriptive (Full disclosure: I don't always practice what I preach.)
Exactly, the "correct solution" would be my first attempt as it uses the (clustered) index scan to count pages/records, it's likely to be the fastest option whereas the first method should not even be an option. This should be immediate for someone who understands how to develop in virtually any RDBMS.

This is also, more broadly, something I've been thinking about recently. It feels (to me) like industry knowledge is getting lost somewhere, because you see people trying to reinvent the wheel in a lot of technical areas. One of them is data: there are proven approaches to most problems faced by the average organization, especially when it comes to designing and managing a data platform. Yet, you see people rolling their own approaches/designs/methodologies to basic things like ingestion, ETL and data modelling when the traditional approaches would suffice and would take half the time to implement and one third of the effort to maintain. It's great that people try to innovate, but what I see regularly is more like people trying to solve a solved problem without bothering to educate themselves on how it was solved so far.
Great. I need to push some stuff real soon now. In the last 12 months Bitbucket had an uncomfortably high number of issues. But whenever I think about moving our company code to GitLab or GitHub I envision going into a world of pain with my eng. team.

Has anyone got some advice for pain-free migration to GitLab or GitHub?
That sounds glorious.

Nothing is more frustrating than coming to an intersection with full line of sight for miles in both directions, where you know there is no car that is close enough to hit you, and having to come to a full stop anyway.[1]

In my part of the US we have a lot of rotaries (round abouts). Thousands of cars go through them every day, no stopping and no accidents... it can be done.

[1] This is of course hyperbole. There are much more frustrating things.

Edit: In fact I thought of something better. Waiting 10 minutes at a red light when there is no one else on the road.
What does work is

git clone https://username@bitbucket.org/organization/repo.git

so you can probably still get by. Just the website is down.
What software aside from Git Appraise (decentralized code reviews) and Git Dit (decentralized issue tracking - alpha quality) do you know of that could be used to move more of what is kept in GitLab/GitHub/BitBucket databases into Git objects and Git tree in order to make Git decentralized again?
39 JavaScript Open-Source Spreadsheets and Data Grids
Came across this on 'Hot Network Posts' on the Stackexchange network: https://aviation.stackexchange.com/questions/44740/why-cant-...

Asked because of reading this article.
Visualize and compare trends with vastly varying scale with ease
It's back for me.
The surprising damage smart workers can cause
As Niels Bohr reputedly said: stop telling God what to do.
When you have to painstakingly earn the right to downvote, you just can't feel bad about using it once in a while.
There are quite a few places like this out there, typically technology has a muted role in decisions in these organizations, quality takes a backseat for the crunch for the next meeting demo, ad infinitum.

A smell of these types of places is they always blame the developers that just left, almost like a scapegoat or two minutes of hate rally. Another smell is estimation is rarely respected i.e. if you say it will take a month they should expect it to take that long or even twice as long as the programmer estimate, but at places like this, about halfway through they say it has to be done in a few days for a very important meeting or deal, if it is that important you want a solid product not a one off.

As a developer you also need to manage balance and workload. Consistent work discipline and good sleep/health are important. Take on challenges but be sure each project is a focus and you aren't spreading yourself too thin, work quality goes down when you don't have some buffer. A good developer would never design a system that is constantly pegged, don't do the same to your schedule/self as that is a single point of failure.
The next big thing in the internet world?
What is predicted to be the next big thing in the internet world in the next 5 years?
1. Do you want to be the local politician who says "hey, let's raise this to 55 MPH" and then on a bad weather day or just out of sheer bad luck soon after there's a major pile up and then said politician gets roasted?

1. The traffic lights need to be coordinated and that means presuming a certain speed. Now the problem is a lot of traffic lights are close enough that changing the programming of just one should ripple through the entire system and this recently (especially on a regulation making time scale) was a problem consuming extraordinary amounts of computing power.
How is blockchain related to this?
> We need issues, pull requests, comments, milestones, wiki, etc... all to be decentralized. No reason this stuff cannot be modeled using existing Git objects.

https://www.fossil-scm.org/ pretty much does this.
Morale, sometimes just everything goes wrong.

But if you stay calm, despite thinking it is hopeless and take your small chances, once they arise - you might actually succed and survive ..
Tracking device makers that issue fixes for WPA2
Hi, I've always been curious what the quota/threshold is. My last account (i336_) got to 1000+ (before I accidentally locked it...) and I never saw the downvote button. Is it like 10,000 or something?
Conservancy Applauds Linux's Promotion of Principled Copyleft Enforcement
In other words, bad drivers tend to run into things. It isn't really the case that no one ever conservatively follows the rules of the road while driving manually.
Intro to SQL for Data Science
And you started a lousy off-topic thread where you and others are competing to complain about downvoting and the weather.
> It reminds me of Bit Torrent in the early 2000s. Sure, it had a decent impact on the Internet, but not really as revolutionary as everyone was hyping it to be.

It forced two gigantic industries (music and movie) to re-invent themselves, how can you say it only had a decent impact?
Location: Paris / Poznan

Remote: true

Willing to relocate: no

Technologies: JavaScript, React, Vue, Angular, Ruby, Ruby on Rails, Elasticsearch

Résumé/CV: https://nukomeet.com/work/

Email: bonjour@nukomeet.com
Oh! Interesting, this is good!
Special gear isn't all that expensive. From a cursory view of the video and a skim of the paper, they're using hostapd, which means that they simply need a wifi adapter with a sufficiently-good driver. Anything with the RTL8188CUS seems to be pretty nice (that's what I'm using in a raspberry pi project, myself).

So - I agree with you that there's a barrier to entry, but it's not that big of a barrier.
Also understand what author means, coming from Pittsburgh where the roads are simply not meant for cars. There are many intersections so confusing where it takes too much time to even interpret the rules. You regularly find yourself in situations where eye contact and gestures inform your driving more than the rules.
Ah, thanks for the clarification :) all good then
I just used AdBlock Plus's "Block Element" feature. I was able to remove the two items stuck on top of the article.
bad charts link is broken.

Missing gantt charts. These are good for plotting logs in distributed systems so you can line up the events. Sadly you have to use hbox in matplotlib which isn't ideal (but it works).
Why Is It So Hard to Find a Good Harley Dealer?
Its holiday today in Ukraine. Yet I am at work... Trying to push some code...
What I did when I had a similar problem was to have a completely separate visualization program and pass data messages to it (using Celery and RabbitMQ). But that was in a setting where I was already using Celery for other tasks. Setting up a message queue for just visualization feels a bit over-engineered. Maybe you can just write to a text file, or a Sqlite db, and have the visualization program poll for changes.
Didn't you get the memo? If you stamp enough buzzwords on everything, it magically works, regardless of their relevance to the application.
You can use a tuple in that case, as in:

if let (Some(a), Some(b)) = (check(param0)), check(param1)) { ... } else { ... }
Put the Command Line in Your Menubar
Yikes. What happened to the HDMI port, out of curiosity?

And I presume macOS? If Linux, X11 can do some interesting hacks with scaling and panning. (`xrandr --output ____ --scale` and `xrandr --output ____ --panning`)
WPA/WPA2 Hacked
Mojaloop: Open-source software for financial services by the Gates Foundation
Not sure why this was down voted, but this was my first thought too.
Wow, that was FAST. It's back for me too!
Debian repos and inherently Ubuntu's repos also have wpa_supplicant 2.4, we will see if they update to 2.6 or release a patch. Probably patch before 2.6.

It would be nice if there was a rule which package repos and distros would adhere to. The rule would adapt, such as all the packages that have had a security issues, will always be required to be updated to the latest versions in the next release or sooner. As vulnerabilities are discovered, the list of packages would grow and hopefully would prevent some future attacks. Obviously it's not full proof but every little bit counts.
The Wi-Fi Alliance has published an official statement:

'There is no evidence that the vulnerability has been exploited maliciously […].'

That is probably about to change …

https://www.wi-fi.org/news-events/newsroom/wi-fi-alliance-se...
Nobody thinks airplanes are indestructible, but it is counteractive to those not familiar with commercial aviation that not only is the market for licensing new airframes regulated, but that older airframes are expected to be retrofitted to the latest safety standards or lose their license.

This isn't how e.g. trains, buses and even taxis are regulated. E.g. I believe in most of the western world you could still operate an antique car without seat belts as a taxi.

This is how I read the GPs comment of "I take it 747s have been safe up til now". The only way the bus/train/taxi in my example would lose its license is if it could be shown if the vehicle didn't adhere to the safety standards at the time, whereas the same isn't true for airplanes at all due to how the FAA & EASA regulate them.
Works fine in uBlock Origin, default settings.

It's actually a lovely, very readable article. Pausing the blocker and refreshing does show some disguisting animated AdChoice ads inserted right in the middle of the content. Ugh, not getting whitelisted here. On reloading with uBlock Origin enabled, I can barely see where the extra line breaks are.

What adblocker are you using?