skysight-inc/HackerNews huggingface dataset:
Some home NAS systems have decent photo organization capabilities as well.

1. https://www.synology.com/en-us/dsm/feature/moments
2. https://www.qnap.com/en-in/how-to/tutorial/article/managing-...
Availability heuristic
>AT&T wouldn't be allowed to buy Verizon or T-Mobile for example.

Interesting that you say that, because there was a period of time where AT&T nearly merged with T-Mobile. Now T-Mobile and Sprint are merging.
At first I thought that they might be using Electron for each app which would concern me as well, but they are using React Native for almost every build except for win32 which will get Electron. I'm curious to see how React Native performs, especially on desktop, for such large scale applications like the office 365 suite. I'm cautiously optimistic
There are various buffers that were* not variable length in query execution (sorting, temp tables). It is not just about the on-disk format in this case.

* Use MySQL 8.0 :-)
For me, it's because my school librarian DID fit that description, and I never met my University librarians (everything was automated).
Any python hacker interested in automating processes and processing data? :-)
That’s assuming the current system speeds are being met - as I recall the New York subways are run at lower and lower speeds than capacity to avoid other problems and accidents.
Not knowing what PANDAS is made for an interesting first read.
I know I read somewhere he said there is one source code that compiles to all platforms. And that source code is written in JS.

https://mobile.twitter.com/TheLarkInn/status/100676113439583...
Some useful background info in https://www.kartar.net/2017/10/prometheus/ on why Turnbull wrote the book, despite being one of the maintainers for a competing monitoring tool, Riemann.
Do you have an example of what R would look like without the C-like syntactic sugar? It doesn't need to be complex, I'm just intrigued about what it might look like.
Can't reply to the sibling comment by Chris, but there isn't a "utf8 character set". There's just different encodings of a character set.

Even after hunting around after going to the 404 you pointed me to, I still get this:

utf8mb4: A UTF-8 encoding of the Unicode character set using one to four bytes per character.

utf8mb3: A UTF-8 encoding of the Unicode character set using one to three bytes per character.

So I don't think they are "different for SQL", whatever that means.

Sorry - not trying to sound snarky but terminology is important and this is an area people easily get tripped up in. Especially me.
> I think that if interlock-free software scheduled CPUs allowed us to reach 20GHz clock speeds where complex superscalar machines were stuck at 3GHz we'd all be jumping ship - but they're not

Additionally, realize that clock speeds are not a relevant performance metric. Maybe, perhaps, it's possible for a software scheduled CPU to run at 2*n GHz, but that's not interesting, if it's slower in real-world workloads than todays tech at n GHz. And for breadth-deployment in data centers we're mostly looking at throughput per Watt. CPUs with high clock speeds don't do well in that area because semiconductor physics.
There's a scene in Roald Dahl's autobiography part one, Boy, that describes the process of getting his adenoids removed without anaesthesia. Sounded terrifying enough that I'm glad we knock people out for that sort of surgery.
I didn't get the reference. Some help?
What was the issue in the end? And how did you solve it?
Do you have personal experience doing this?
This is supposedly fixed in databases created with MySQL 5.7 and up.

> MySQL 5.7 (2015) added some optimizations such as a variable length sort buffer, and also changed InnoDB’s default row format to DYNAMIC. This allows for indexes on VARCHAR(255) with utf8mb4; something that made migrations more difficult prior.

https://mysqlserverteam.com/mysql-8-0-when-to-use-utf8mb3-ov...
Hate to be that guy, but I'm pretty sure this book is still under copyright; the author passed away in 2002. HN is probably not the right place to post this...
Pentester’s Windows NTFS Tricks Collection
I was a big fan of google docs 10 years ago. But have lost interest as they have stagnated. Sheets is slow for anything over 100 rows compared to Excel and there’s a lot of 20% functionality that’s been missing for years in functions, charts, pivot, etc.

It’s great for lists, but I want an Excel clone on web. Fortunately, MS has been building this.

If MS ever simplified their license, I’ll switch.
There is usually a good reason for doing these kind of things. But then don't call it UTF8 encoding! It doesn't do that. It stores the most popular characters out of a larger address space. Call it UTF8-MB3 maybe from the start and let the user decide if having varchar(255) is worth the tradeoff. Thats the trouble with MySQL: doing silently the wrong thing, and thus violating the principle of least surprise. There is software where this might be ok, but a database is not that kind of software.
A portfolio page is very different to a resume page. Your portfolio is your professional landing page. It might include a blog, relevant profile links, recent projects etc.. A resume _could_ be a part of this, but it's only one part of many. A portfolio is generally intended to drive traffic. For example, if you begin blogging about a particular technology, you can expect to start getting traffic from people searching that technology. This might lead to recruitement and inquiries. You will generally want to it show first on Google when someone searches your name.

If you just want a single-page resume, you don't need to do anything as fancy. Create an index.html and get a nice clean stylesheet to format it. Host it for free on S3 and off you go. I wouldn't overthink the "features". Who is going to CURL your resume?

For reference, I have a pretty active portfolio site that receives a lot of traffic via the blog from Google:

- https://timmyomahony.com
This might be a better intro http://ucidatascienceinitiative.github.io/IntroToJulia
For me:

Lift weights and perform intense physical activity to exhaustion.

Don’t smoke tobacco or cannabis. Don’t really drink either.

Meditation.

12-step work.

Wellbutrin (bupropion) has helped me out of holes.

Have close friends to confide in.

Say what you’re thinking. Don’t say what you’re not thinking.

Follow pointless dreams in some measure. For me, being able to buy a legendary Husaberg FE 570 motorcycle was an impossible dream, until I tried going for it. Managed to do it on a startup salary over the course of a year. It has brought me deep spiritual satisfaction.

Help others.

Be humble. Ask to be humble. Ask for your ego to be smashed.

Read books. Listen to music. Make music.
I'd agree with this, there is some overlap, but mostly these are distinct skills (people skills vs. technical skills).
>Honestly, I think law enforcement believes that they need more tools. I don't think they want unsolved murders any more than the citizens do.

The US Constitution makes it clear that the rights of the people to be secure in their persons and possessions is paramount, but for a narrowly defined list of exceptions. That crimes may go unsolved because the state is kept on too short a leash, or because modern technology has made their job more difficult, is a feature, not a bug. A government with perfect knowledge about its citizens behavior and correspondence, or one that can perfectly enforce its laws, is indistinguishable from tyranny.

>So telling law enforcement officers, "you can pry open my iPhone from my cold dead hands" tends to ring hollow, especially if they really are of the honest kind and really do want to put criminals away as well as respecting your privacy.

They can pry my iPhone from my cold dead hands, or my live warm hands will hand it over if they have a warrant, but it will remain encrypted either way, for no other reason than I have the right to do so, and they have no right to demand otherwise.
Best 10 Cybersecurity Books 2018 – S Book List
Seek professional help.

Threads like these are typically filled with unverified claims, anecdotes, well-meaning tips and what others think helped them or someone they know in what they believe are similar circumstances.

Some people aren't diagnosed, but make their own assumptions. Others don't differentiate between a mood (sadness) and pathology (clinical depression).

TLDR:
There are too many variables, unknowns and right-sounding wrongs out there. A professional third party is better suited to interpret your situation than anyone else - including yourself.
Ironically, the way to handle communication break-downs is to communicate about them!

Have a conversation with the PM or whoever wrote the ticket. Tell them exactly what you wrote here. Problem solved.
I feel sorry for your experiences.

I had my adenoids removed, twice actually, but my first surgery was quite memorable.

Post-soviet Estonia, 90's. I was nine, my nose was pretty much constantly blocked or snotty. The Doc said I had my adenoids enlarged, and advised my mom to agree to an operation. And so, couple months later, I remember sitting in the Doc's reception room, while nurse was slowly screwing long (half the size of knitting) needles with local anesthesia really deep into both of my nostrils. I had no clue about lobotomy back then, he-he, however this part alone was enough to injure my childhood psyche. And I didn't yet image what kind of fun will come next.

Two hours later they came for me. I was taken to the operating room, in the middle of which stood a red faux-leather (torture) chair. My hands were strapped to the armrests. I was kindly told to sit still and open my mouth. Long story short, I was operated with huge weird scissors inserted deep into my throat, cutting off pieces of my flesh, while I was in full consciousness that whole time.

Couple years later, I was repeated this operation in a regional hospital of Kyiv, this time under general anesthesia (I echo OP's counting up to 7 max). The chief surgeon said that my first operation was an act of inhumanity.

Twenty years later, I don't blame anyone. Nowadays we have much better NHS (better than in Ukraine so far). I understand that this was a confluence of unfortunate circumstances—it happens and it could be much worse. Today, thanks to science, I know this episode a) should have never happened, and b) will affect my future life. I was already wondering why I got allergic symptoms several years ago. Let's hope that scientific and technology progress will catch up and fix all the mistakes that we had to go through :-).
The fact that I need packagist, and the basic structure is really easy to copy? If not packagist, then someone will have set up a package repository with a different name.
Cost-effective seawater uranium extraction promises limitless nuclear power
Would love similar study on circumcision...
There was a mildly popular submission two days ago: https://news.ycombinator.com/item?id=17292623.
Is the company liable for the fee if they lose?
Exercise. That's it. Get outside and walk/run/jog/bike everyday and get healthy, it will change everything. Sounds too simplistic, but it works.
My idea for a solution would be to offer better pay/benefits opportunities for your good developers, at the same time giving them also more creative freedom when they rise the ranks in a technical role.

Making management the only option for having a "career" is the issue.

Another option to avoid the downsides of the Peter Principle is to test drive people in their new roles. Basically you slowly add responsibilities that look more like the post-promotion job, if they do well they get the promotion and they've already proven to be able to do these things. If at some point you notice it isn't working, well then you don't promote them, or promote them to a different position.
I can understand but coming from IntelliJ, vscode feels light and fast :D
Recently got caught in a loop of trying to create an Office 365 account and being told that my email is already in use, then trying to say that I forgot my password and was told that my email is not associated with an account.
Everything's Not O.K
My blogs are a good example of that one. I don't have certificates installed as of yet.
Thing A having specific advantages over Thing B in no way implies that Thing B is not clearly superior overall.

I have used both MySQL and Postgres, although admittedly I haven't touched MySQL for a few years (the last time I tried to use MySQL for something, I found it would happily serve me up an arbitrary result for a clearly nonsensical query).

I thought this comment on an earlier thread summed up my feelings about the two systems rather beautifully: https://news.ycombinator.com/item?id=15173100
While I agree with you, as I understand the SQL standard defines the N in varchar(N) as characters (not bytes).

There is a pathological case which is not common: max length of all 4-byte characters. Indexes are used to enforce features like unique constraints, it's important that everything can fit in the buffer length.
I think they're providing contrast against the hilarious suggestion that "a school is supposed to instruct kids in the truthful ways of life".
Not all laws are just.
> you can easily add in an additional 24 or 56

No, you can't. If you have an MBP, for example, RAM is soldered onto the mother board and cannot be upgraded. If you have a Thinkpad x220 or x230 like a lot of us do, you can only go up to 16GB because the BIOS doesn't support any more.

And regardless of which laptop you use, RAM is expensive in a lot of places. You can't expect everyone to throw hundreds of dollars at RAM just so they can run VS Code. Not to mention the "throw more hardware at it" attitude is the reason why we have bloated inefficient software in the first place.
The article mentions it, but one of the massive frustrations with this issue is the huge amount of misinformation surrounding it (at least back in 2013), with many well-intended users on StackOverflow and the MySQL forums giving the exactly wrong advice on collation. Naming things, and not getting confused by bad names, is damned hard. This issue led me to quit MySQL for good, I can’t think of a more trivial issue that caused me such confusion and frustration as a software engineer.
Universal JavaScript Route Parsing in 1.3KB
To pro-alternative folks like myself it just means "not in the medical textbooks yet". Most 'alternative' approaches do have rigorous studies backing them up, just recent and ignored by a lot of people.
> Again, nothing manual

Yes, sorry for being inexact/overusing the term--I understand the tests drive the recording.

What I meant by manual is getting the e2e system into your test's initial state.

E.g. tests are invariably "world looks like X", "system under test does Y", "world looks like Z".

In record/replay, "world looks like X" is not coded, isolated, documented in your test, and is instead implicit in "whatever the upstream system looked like when I hit record".

Which is almost always "the developer manually clicked around a test account to make it look like X".

This is basically a giant global variable that will change, and come back to haunt you when recordings fail, b/c you have to a) re-divine what "world looks like X" was for this test, and then b) manually restore the upstream system to that state.

If no one has touched the upstream test data for this specific test case, you're good, but when you get into ~10s/100s of test, it's tempting to share test accounts, someone accidentally changes it, or else you're testing mutations and your test explicitly changes it (so need to undo the mutation to re-record), or you wrote the test 2 years ago and the upstream system aged off your data.

All of these lead to manually clicking around to re-setup "world looks like X", so yes, that is what I should have limited the "manual" term to.
What's the latency like? Live broadcasts are hard enough to keep realtime without mixing in P2P problems like buffering and limited upstreams.
Therapy.

Anecdotally:
plenty of sunlight,
a vitamin D pill,
enjoyable sex with your partner,
frequent bouts of intense exercise,
plenty of vegetables,
few processed foods,
a probiotic supplement,
and healthy bowel movements 1-2 times a day.
"At every level, from the microcellular to the psychological, exercise not only wards off the ill effects of chronic stress; it can also reverse them. Studies show that if researchers exercise rats that have been chronically stressed, that activity makes the hippocampus grow back to its preshriveled state. The mechanisms by which exercise changes how we think and feel are so much more effective than donuts, medicines, and wine. When you say you feel less stressed out after you go for a swim, or even a fast walk, you are."
-John J. Ratey, Spark: The Revolutionary New Science of Exercise and the Brain

And another

"we sometimes lose sight of the fact that the mind, brain, and body all influence one another. In addition to feeling good when you exercise, you feel good about yourself"

Reading this book opened a door out of depression for me using the prescribed medicine, which is exercise and definitely wasn't easy.
> While I’m contemplating why people might have thought utf8mb3 was wise in 2004

Because this is 2004 MySQL, they weren't exactly known for technical acumen and forward thinking. The root of their decision is that behind the scenes "UTF8MB4" stores codepoints in fixed-size areas.

And MySQL could not index columns larger than 767 bytes.

Guess what doesn't fit in 767 bytes? VARCHAR(255) in UTF8MB4. Anything above VARCHAR(191) would not be indexable.

Meanwhile VARCHAR(255) with 3 bytes per codepoint fits just right.

So rather than fix their crap, they just decided to limit their "UTF8" to the BMP and voilà no problem.

> The only thing it had going for it was that it was roughly compatible with UCS-2; but was UCS-2 that popular at the time?

The foundations of major systems (e.g. WinNT or Java) had long been laid out (in fact WinNT was released in 1993), and while UTF8 did exist there were few use cases for going beyond the BMP; and people had (and by and large still have) the misguided view that O(1) indexation in a string is a valuable property, and so their POV was that their choice was UCS2+surrogates (which few people would ever encounter) or UCS4.

> Possibly the most helpful description I have is from https://en.wikipedia.org/wiki/UTF-16#History, but even that doesn’t explain why it became popular. Why did Java adopt it, Windows, browsers, &c.? Why?

What they adopted was UCS2, this was "backronymed" to a bastard (non-transparent, you'd see every code unit) UTF16 later on. Java didn't even support getting codepoints out of strings until Java 5 in the mid aughts: https://docs.oracle.com/javase/8/docs/api/java/lang/String.h...

I'm pretty sure most string processing in Java and C# remains unaware of surrogate pairs and can corrupt proper UTF16 data rather interestingly. That is most definitely an extant issue in Javascript (not that properly handling that is even remotely sufficient to do actual unicode-aware string processing).
Well played.

Antithenes is referring to this classic Clarke and Dawe bit: https://youtu.be/3m5qxZm_JqM
I do, and it works great! I normally work a desk job, alternating between the two is amazing. Working that hard every day of the year isn't sustainable, but physical labor in shorts bursts of a week or so can boost my mood for months.
>Elon Musk's Boring Co. is the winner in a bid to build a multibillion-dollar high-speed express train to Chicago’s O'Hare International Airport. The result gives the young company a big boost in legitimacy as it tries to get transportation projects underway in Los Angeles and Washington.

So, basically, they've won the right to make a proposal to finance their own construction of an airport link--which understandably just about no one else was interested in doing.
YOU NEED TO FIX CREDIT, THEN READ THIS
HackWest is what I call a god-sent. Literally they’re saving my life by saving my credit. I have been denied for the most basic credit cards and keep digging myself deeper even when I try to fix it.
I got into terrible situations where my credit was wrecked by fraud and other bad situations where my car got reposessed.
They made a very realistic and affordable plan for me, for me to pay off my bill for 3 months at a very minimal price.
Their credit repair firm is legit. When I got started, the professionalism I recieved from day one on the phone with HackWest, to how responsive they are every day. I have no doubt I will get great results. I have worked with other repair companies who were super rude and expensive. This is by far the best thing that has happened to my credit. HackWest customized a plan to help remove all my collections that were unfairly placed and rapidly increased my score. I have been struggling with an uphill battle to fix my score ever since my repossession not even caused by me, so I am so grateful for the patience and expertise they gave me!
They are literally always available to listen to any concerns you have. HackWest is the loveliest. . Reach out to them for help now [HACKWEST@WRITEME.COM,	+1 424 307 2638]. They are affordable.
You could start them with little investment, but your time is also worth (a lot of) money. That's not coming from anywhere if you work for any startup, including your own. You might make that money back later, you might not. In the end that is part of your investment and it's a gamble. If you do not have the financial cushion required to sustain you for the amount of months it needs to become profitable for you, you cannot do it.
I think the point is that while the economics might be sound in terms of anticipated risk, risk management, and expected growth; the 'folklore' that arises to relate that learned experience in a convenient, easily understood way is often only a shadow - a poor construct - of the experience that actually keeps these systems running.

Whether that's because 'trade secrets' or 'elevator speeches', whatever the reason, information gets lost, exaggerated, and permuted along the way. So sometimes it can easily become kind of batshit because of how far removed from reality - the actual guiding forces that sustain that economy, are.

I don't know if you can point out concrete examples, because for every concrete example there's probably a successful startup out there that followed that model. But the exception doesn't prove the rule in systems that are fundamentally opened, like the relationship between culture (consumer, startup, academia, enterprise) and the economy. That's because those rules (advice) influence the system.

You can't simultaneously account for the effect the advice will have on the system while following and dispensing the advice, unless the advice and it's effects on the system are immutable. But that's not how capitalism works.
With utf-8 you give up any hope of O(1) string operations. With utf-16 you can get O(1) string operations at a cost of doing them on code points rather than graphemes. If greater than 95% of the strings your language/program will ever see are going to be a single code point that trade off seems worth it.

I think a lot of people totally discount the enormous cost that Latin-1 users are paying for CJK (etc) support they don’t use. Maybe it’s the right call, but it isn’t obviously so.

Personally, at least for internal use, I like the idea of specialized implementations. At (immutable) string creation time decide whether to construct a Latin-1 string or a UTF-8 string (and possibly other fixed width encodings) depending on what code points are present. Expose the same set of operations (i.e. slicing on grapheme clusters) but with better performance characteristics where possible.

For storage at rest and especially communication with external programs I agree you probably should emit UTF-8.