skysight-inc/HackerNews huggingface dataset:
> There are two issues I know of with SQL where it isn't super great IMHO.

There are many more issues, you've just gotten used to eating SQL turds. Hierarchical data is solved by CTEs, so that's not a big deal.

The bigger deal is that relations themselves are impoverished second-class citizens. This means you can't write a query, bind it to a variable and then reuse that query to build another query or store that query in a table column. Something like:

var firstQuery = select * from Foo where ...
var compositeQuery = select * from firstQuery where ...

create table StoredQuery(id int not null primary key, query relation)
insert into StoredQuery values (0, firstQuery)

That's something like relations as first-class values. This replaces at least 3 distinct concepts in SQL: views, CTEs, and temporary tables, all of which were added to address SQL's expressiveness limitations. Relations as first-class values not only improve the expressiveness of SQL beyond those 3 constructs, it would also solve many annoying domain problems that require a lot of boilerplate at the moment.

Then there's pervasive NULL, inconsistent function and value semantics across implementations, and a few other issues.
I think there is no way they would claim they are not
under any gag order if they were forced to never confirm
such an order

I've always thought such denials are pointless.

You think everyone at Google knows every secret gag order they're under? Of course not, that would get leaked within minutes.

If I was the NSA I'd find a "patriotic" mid-level or junior employee with the power I wanted to subvert, and give them a gagging order that stopped them telling their boss.

That way the Google PR can honestly say that the CEO and legal team haven't seen or heard of a gagging order.
Five Tricks for Debug-Logging in JavaScript
It might be helpful to take a look at what Graham called a “Net-Net.” If other investors perpetually undervalue your investment in a company that produces earnings, eventually the cash generated from those earnings could be given to shareholders as a dividend, etc. In an extreme example, imagine a company that the market values at $1B with $1B in assets that produces $1B in earnings. The following year, the company would have an extra billion on its balance sheet even if the share price didn’t change.
Antitrust violations?
Does Amazon copy or undercut successfull products?

A few years ago I bought some high quality monitor arms; heavy duty cast aluminum, etc. for about $150 each.

A couple years later I go to buy another, and now there is an Amazon branded clone for $100. The only difference is black painted vs. the original polished aluminum.
Will Your Business Strategy Benefit from Personal Branding?
Maybe we should treat the root cause and not the symptom? If people don't remember stuff because they don't need it then maybe the tests should not depend on remembering useless stuff?

At my job for some reason I never need to force myself to remember stuff; it comes naturally as I look up the same thing over and over again because I use it frequently.
> Maintainability is a feature, so to speak.

Yes, but lets be clear, this is not lack of maintainability... this is very clearly _anti_maintainability, there is a big difference.

There is nothing inherent to the hardware design here that makes replacing components impossible, just the addition of this one chip for the single purpose of preventing it.

And it's not surprising, we all know Apple's position on Unofficial or user repair options.
Ask HN: Downside of exporting SDK per microservice and best practices
Every microservice, exposes APIs. I've read somewhere that, it's a bad practice to export an SDK to other microservices because it limits the independent deployability. But is it true? What are other downsides of this approach?
The problem is that, without the SDK, every microservice will need to request the same data, and validate it in some way - which is some boilerplate code which in general one would like to have automatically filled.
Yes, the point you're referencing is wrong. Your last point is correct. We can't extrapolate the fact that indices are designed to return averages of some market to the claim that indices can't be beaten without assuming the EMH first.
Here’s my “Get file” shortcut: https://www.icloud.com/shortcuts/6b2c54340ed6432e932e61bc886.... It looks at its input and passes it through if it finds anything (to allow it to be used in the share sheet, where items are already specified), otherwise it brings up the system file picker and outputs the selected file.

I have two shortcuts that rely on this one. One uncompresses the selected archive to the destination of your choice: https://www.icloud.com/shortcuts/d4de9ed40aec42baa6b920f6da7.... The other allows you to glance at the selected property list file, which is strangely something that the built-in preview cannot do:https://www.icloud.com/shortcuts/68db9e02bf9448f394312b36d7e....
Not under warranty, Apple provides the shipping both ways.
It is the case for the 13-inch ones.
My amazon usb hub blocks the wifi whenever turned on... I should have returned it. Junk.

They are such a mess. The amount of items that have changed the product but kept the reviews, often from a phone case but now its a video projector pretending the 200 reviews belong to it. Not to mention one items page can have multiple sellers selling different varieties of the item.
The products banks sell to punters are never good value compared to direct investment in ETF's iShares or what have you.
I know it's a divisive show (I didn't like it), but considering the names involved (Emma Stone, Jonah Hill, Cary Fukunaga), it seems to drag them down more than be elevated by them.

Having Emma Stone in a TV series should feel like a much bigger deal than that show does.
I see what you did there. And I approve.
Is there any better alternatives to SQL for requesting data !?
Blurb Blast Updated 5 October 2018
Steve Jobs didn't (2011)
I got an HDMI cable and an audio cable that were Amazon's brand. They have both since broken. It may not have been fake but it was bad quality.
I understand what you're getting at, but do people actually buy those items with the understanding that they are getting something of a higher quality? If you pay $2 for headphones and all the ones in the store cost $10+, it's hard to argue that you thought the quality was going to be higher.

I know we're in the tech bubble so most of us probably do research before buying anything online, that's why I ask.
Right, that's what I'm asking. Don't forbid commercial use, just use the GPL so nobody else has an unfair advantage over the source code.

I think a lot of people have an unfounded fear of someone else making money when a share-alike license would assuage most of their fears, without forbidding money.
This is completely anecdotal, but I'm on several mailing list for bulk buyers of off-lease server equipment. Typically these list are 90% Dell, HP, IBM. About 6 months ago I started to notice a huge percentage of SuperMicros being sold. Sometimes the whole list was nothing but SM servers.

Obviously could be many factors, but does strike me as odd.
The article mentions they're setting up their own brands in order to get a better grip on product quality. I'm quite sure Bezos does not want to be Aliexpress.
Isc-Projects/ethq: Ethernet NIC Queue Stats Viewer
The Inevitable Volumetric Future
Dubious quality is one thing, but dubious legality is the stuff that worries me the most.

I ordered some food processing gadget, but it does not come with any kind of EU certification (i.e. not stamped or anything) and it is shipped direct from China in a box that says "gift". The same product on Alibaba have different seller and some claim they are selling the "food-safe" one and not others.

The brand from China are all mysterious from a foreign buyer point of view, so I cannot even buy from a brand and trust that the brand is serious about its reputation. Anyway, on Alibaba/express, there are often several brand claiming the same product despite using the same picture than another.

That's a mess, and indeed if I bother buying from Amazon (instead of Aliexpress), I hope the stuff coming to be at least legal. I can understand some amount of counterfeiting, not the current level though.
Yeah, I've been browsing with Firefox and adblockers for years on Android.
Just got a replacement on a hub that seemed to have a faulty power-switching “feature” that would cause any connected hard drives to lose power whenever my computer woke up from Power Nap. At least getting the replacement was easy…
Semantics are hard. There's a long-running slow-burning debate in the Lojban community about the degree to which BPFK, a guiding body for Lojban, is expected to formalize the semantics and philosophy of the language.

That said, this sounds like a shitpost. Syntax and morphology aren't solved problems for natlangs, and while Lojban's parsing might be messy, it is nonetheless far less ambiguous than English.

Maybe a few Lojban words will enlighten you as to the power of the language?

{ga'i} a marker for formal rank and formal register/diction

{ko'a} a variable

{goi} reassign names and variables

{ce'u} a marker for holes under {ka} abstractions

{ka} definitely not lambda! An abstractor for relations

{ti'e} "I hear that..." a marker for unverifiable hearsay

{da'i} "supposing..." a marker for counterfactuals

Finally, here's something that SSC doesn't have (yet?), a tutorial: https://mw.lojban.org/papri/la_karda
I don't think so. I think selling the game together with non-free assets without which the game would be unplayable is a tighter combination than "mere aggregation". It seems to me like that would be derived work.
> They were the ones who started AJAX and Mozilla reverse engineered it for example.

Yes, Microsoft even invented DHTML(which wasn't in the DOM spec). But Microsoft also stalled web standards and Ecmascript effort for a whole decade as well.
There have been plenty of attempts over the years. But even if you have the exact same feature set, looks, ux, etc., you still have an empty room. You need an incentive for people to actually switch. That's what's missing.

Decentralized is an implementation detail for most users that they don't really understand or appreciate.

I do believe there is an opportunity for something new to displace facebook. FB is not a healthy network at this point. It's shrinking and users are disengaging or even afraid to use it.
"Various outlets" sell desire to consumers and advertisers.
Neat article, thanks!

RE: Netflix US, if this site is accurate the US is actually worse than the UK for films from the 1950s https://unogs.com/?q=-!1950,1962-!0,5-!0,10-!0,10-!Any-!Any-...
Most places I know of isolate their OOB management network, requiring a vpn or jumpbox to access it. However, if someone did let their OOB network full outbound access, I could see this slipping through. I could imagine that simply going to a CDN or cloud provider like AWS/Cloudfront/cloudflare/akamai with a dns lookup along the lines of updates.supermicro.cdn-front.com wouldn't be too suspicious. At that point, you'd be looking for dns lookups and not firewall hits.

If you are blocking outbound, I could still this going unnoticed if you're not actively reviewing denials.

But, if you are properly watching dns lookups from OOB and it's anything other than necessary services (ntp, ldap, syslog), then this would get picked up pretty quickly.
Eh, that distinction is ambiguous at best. There's a far larger overlap between speculation and investing. It would be more accurate to say that value investing is different from speculation - but even then, speculation is fundamentally inseparable from investing.
You can run a SMSF here in Australia if you want to make your own investment decisions.
Access your AWS infrastructure behind SSH bastion host with ease
Best value for money online team collaboration tool?
Hi, I'm looking on the market for online team collab. tools. New gen. ones, multiple platforms support (android/ios/pc), web based, secure, integration with remote storage (e.g. dropbox and the like), searchable, meetings/calls and the like. But -as usually- my (medium size S/W house) company is very much concerned with maximizing the value for money factor but on the other hand we want to go with a known company. So long I'm peaking into:

1. Slack (the market leader AFAIK)

2. Google business hangouts

3. IBM Watson Workspace

4. Microsoft Teams

Are you using any of them? Happy? Not happy?
Any reviews/commends/pointers welcome.

Thanks
Many state-of-art models won't train well on FP16. But for inferencing it's extraordinarily good. 2x1080Ti is the sweet spot for FP32 training on "budget" at the moment.
this is fine, and probably true, in benign markets. the risk is in stressed markets. the reduced diversification can result in amplified shocks.
One of the available garbage collector implementations in D (version 1) (and there's a work in progress to port it to D2) is a concurrent garbage collector which performs a mark phase in forked process going over the address space.

Also I've seen a project which persists large amounts of data to disk by forking and using a consistent snapshot of the data structures (which the new process will not mutate, so there's no need for locking).
Yeah those don't bother me too much, you pretty much know ahead of time when you buy super cheap crappy products. Counterfeits are the real problem, and to an only slightly lesser extent fake reviews.
Agreed. There's a real art in promoting yourself without resulting in everyone hating you. Not everyone manages that - or even tries to avoid the "annoying one's peers" part.

In business unlike socially it's actually part of the job - or it should be if you want to achieve certain goals: bonus, promotion, peer recognition. Even avoiding layoffs could come down to how well you communicate the good work you're doing.

This does not come naturally to many of us in this sector, but once you are aware of the need for it, there are ways to promote yourself authentically and without being too much of a show-off.
being English, every Christmas there was always a box of Turkish Delight on the table (and dates of course).
>>> There's research to be done on what makes plants tastier, and there's work to be done in applying such research.

there's earth, rain and sun and millions of years or R&D already done and proven successful. I really wonder what kind of research youo want...

What you may want is : tasty food for everyone on earth. But that's not science, that's much more politics.
Depends on whether or not they are above/below the line

https://www.quora.com/What-does-above-below-the-line-mean-in...
but now it's no longer a declarative query. What if you want to include grand children? or if you want to fetch just one child but include it's parent and it's siblings of another type like a product, it's category and the categories tags:

{id: 23, name: 'Trackpad', category: {id: 42, name:'Equipment', tags: [{id:...}, {id:...}]}}

Now instead of just adding two joins you have to build a custom loop with hand crafted conditions. Sure you can find a way to generalize that loop and put it into a library but still the query itself is separated from some kind of post processing that has be kept in sync.
I am not sure if this is a thing you regret not doing `as a child`?
Badly implemented USB 3 can jam your wifi easily. Check if rf shielding of usb lines is done properly.
Forking from a setup environment n times is much faster than setting said environment up n times (=fork+exec)
I'm no expert, but from what I've heard, site owners can be held liable for hosting copyrighted material now. If you're running a site with lots of user generated content, it could be difficult to distinguish what is 100% user made vs copied from somewhere else.

Someone correct me if I'm wrong.
aka white van speaker scam https://en.wikipedia.org/wiki/White_van_speaker_scam
I think you meant its (like his or hers) instead of it’s (it+is).
Sp_execute_external_script, entry point into SQL Server external engines
The masses want one place to buy from a variety. Marketplace models want to offer these masses, a vast assortment. A fully functional ecosystem is now online.

This is particularly beneficial to brands with little to no presence. They invest in these marketplaces, buy prime spaces on the marketplace.

Once you have the masses captured, you have a lot of people looking for low-priced, value-for-money products.

Now, when you have the prime product positioning in your control, for free, and the enormous margins in place for your private labels, you can start reeling in the bumper prize.
Another option is the attacker has those companies "by the balls". They knew that the supply chain was completely compromized, and has been for a while. Admitting this, after so much time, is financial suicide in the best case. Maybe the companies are even being blackmailed by the attackers.

Another twist, maybe someone in the government does not want this to come out officially, because they would be forced to take action against China.

On the other hand, maybe this is exactly what the government wants, so they "leak" this information - be it true or false - on purpose.

In the end, the world is so messed up currently that every conspiracy theory seems to be equally plausible.
Internet Archive is adding in-browser emulation support for Commodore 64
Sounds like many things would have to go right in the defender's court. Optimism is not a good defense strategy :)
Nitpick: it would be more correct and precise to say that index funds tracking the total market beat the average aggregate performance of hedge funds on a long enough timeline. In practice that timeline tends to be quite short in the current market climate.

I mention this because (regardless of your intention in particular) Warren Buffett's famous bet is extremely overused and cited as evidence for many claims it doesn't really support. Someone's takeaway from your comment could be that all hedge funds fail to beat the market - but that's not even what Warren Buffett believes (Buffett doesn't believe in the efficient market hypothesis).

This is to say that index funds are generally a superior investment vehicle for modal investors. But that shouldn't be used to extrapolate broader truths about active versus passive management, except that active management is a lot harder.

An (imperfect) analogy I like to use is that of a kid whose dream is to get drafted into the NBA. You'd probably tell them to have a solid backup plan for a more realistic way to make a living, because approximately no one is drafted into the NBA. Vastly more people try and fail than are actually drafted. But that doesn't tell us the NBA is itself a fiction.

Similar parallels exist in venture capital investment, startup success, acting and making music.
I'm going to be in Istanbul in 3 weeks for the first time. can you tell me where I could buy some please
I scanned through that list. Granted, I don't buy much coffee, candy, bottled water, cookies, yogurt, cosmetics, or processed foods in general. But I think I could avoid their brands quite easily. Maybe I'm and outlier.
Hmm. The top results for me are:

Gritin - China - 12 Euro ~ 5 stars / 310 reviews "Amazon Choice"
KLIM - China - 20 Euro ~ 5 stars / 864 reviews
Panasonic - Japan - 8 Euro ~ 4 stars / 1.335 reviews
Beats by Dr. Dre - USA - 22 Euro ~ 3 stars / 172 reviews
qubbi - USA - 10 Euro ~ 4 stars / 48 reviews
Anker - China - 20 Euro ~ 4 stars / 1176 reviews
Mpow - China - 20 Euro ~ 5 stars / 463 reviews

ALL of these companies manufacture most of their products in China.

Anecdotally chinese companies appear to outperform foreign companies on quality among the popular choices - if review scores are anything to go by.
This probably needs to be fixed in POSIX with the gradual deprecation of fork(2) over decades. If we start now we might be done by 2038. Maybe start by deprecating fork-after-multithreading, since that's extremely hard to get right in the first place.

fork/exec was a convenient hack for singlethreaded small programs on the PDP-11. Its semantics interact badly with all kinds of subsequent features, and it interferes with porting to other operating systems.
That's not my experience with "AmazonBasics" products, I almost always go with those when I look for cables or very basic electronic devices and they generally do the job just fine at a very reasonable price. I'm sure it's just rebranded "china-made crap" but as long as they have decent selection and quality control that's not necessarily an issue.
I'm not sure about that - this could really bolster the MAGA crowed, and I can imagine calls in the near future for manufacturing to be moved to the US. I doubt much will actually move, but it's a possibility.
I love 3D fractal exploration, especially when it can be realtime.

It's a few years old now, but this is still the best demo I've seen: http://sub.blue/fractal-lab
>I'm quite sure Bezos does not want to be Aliexpress.

I'm sure he really wants to! Otherwise why would he sent his people to China to beg major Taobao/Aliexpress operators to get on the Amazon train?
I had never even heard the phrase until this thread. A quick google/wikipedia shows me it's the British term for what we in the US call "telephone". I guess I learned something new today.

https://en.wikipedia.org/wiki/Chinese_whispers#Etymology

> As the game is popular among children worldwide, it is also known under various other names depending on locality, such as Russian scandal,[3] whisper down the lane, broken telephone, operator, grapevine, gossip, don't drink the milk, secret message, the messenger game, and pass the message among others.[1] In France, it is called téléphone arabe (Arabic telephone) or téléphone sans fil (wireless telephone).[4][better source needed] In Malaysia, this game is commonly referred to as telefon rosak, which translates to broken telephone. In the United States, the game is known under the name telephone – which in this use is never shortened to the colloquial and more common word phone.
Deep understanding
If you love the idea of Dickens’ Ravens, check out Drood by Dan Simmons. It’s a fictionalized account of the last five years of Dickens life told through the opioid addled haze of fellow author Wilkie Collins, a Dickensian-David Lynch mashup dripping with Victorian detail and luscious shadows.
Having your prevalent online store push its own branded product instead of giving you a clear view of the overall market?
The Awful German Language (1880)
"Inference" or "inferring". "Inferencing" isn't a word any more than "defencing" is.
The line between IDE and "text editor" is fuzzy these days. Mainly I think many people, such as myself, have an editor of choice. The editing process itself is what makes the editor their preference, so that's what they build their experience around. This is why (imo) you get text editors like sublime, vim, emacs serving such an IDE-centric experience. People don't think of it like IDE vs not-IDE, it's all an IDE, if you enjoy it you try to add features you want. Switching to a fully fledged IDE may have better language experiences, but for many that's the lesser factor.

Hell, Vim has a lot of this stuff, but I switched to Kakoune a long while back, giving up a ton of my addons/plugins for languages. I can still write them (and am working on it), but the point is Kakoune is not nearly as widely supported on tooling as Vim is. Yet, the editor reigns supreme to me, and I prefer Kakoune.