skysight-inc/HackerNews huggingface dataset:
Show HN: An Open-Source MySQL HTAP Database for OLTP, Real-Time Analytics
After the release of StoneDB V1.0 on GitHub, we have received lots of feedback from our community members and users. As shown in the TPC-H test reports, StoneDB V1.0 provides 10 to 100 times higher performance than MySQL, with only one tenth the total cost of ownership (TCO).

Though StoneDB V1.0 provides inspiring performance, it still has some drawbacks that are rooted in its design, including long execution time for TPC-H query 16, unsatisfying performance in processing transactional workloads, and comparatively long latency in populating latest changes to analytics workloads.

Therefore, we are redesigning StoneDB to eliminate these problems in our next version — StoneDB V2.0. StoneDB V2.0 will be based on MySQL 8.0. It aims to achieve at least 10 times higher query performance on TPC-H than that of V1.0, with a more concise architecture and a query optimizer that can intelligently offload query workloads to corresponding storage engines.

The design philosophy of StoneDB V2.0 is modularity and performance-cost balance. The following outlines the new features that will be implemented in StoneDB V2.0. To learn details about each feature, see the relevant chapter.

StoneDB V2.0 will still be an open source project, which is a counterpart of close source service, MySQL Heatwave.

At first, an in-memory column-based engine (IMCE) will be used. Secondly, a cost-based query engine will be developed to automatically offload transactional and analytics workloads. Thirdly, StoneDB V2.0 will provide a vectorized execution engine and support massive parallel processing. In this way, the execution performance of StoneDB V2.0 will be at least ten times as that of StoneDB V1.0.

StoneDB will load the data into memory from InnoDB, just the same as MySQL Heatwave.
Someone probably told them that money is fungible.
I’m assuming the poster meant refinance with the same terms. So the borrower can get another 40 years to pay back the remaining balance anytime they like.
For this batch... most of the memory safety issues look to be in kernel code or adjacent, followed by Safari/Webkit. The Android Linux kernel is still pure C (for now), and I'm pretty sure new Chrome/Blink code is still primarily C++. The codebase as a whole certainly is…
No, I think you are right. I think it is a very important function of a society to decide on things that should not be public or even illegal. This has always been the case and child abuse is the most obvious example.
humble pie
except the fact that you spent $$$ compared to the $ he spent for just the hardware to run vim. And you are still slower.
In a sea of lowercase prose, all caps stands out from the rest.
M2 Macbook Air has an accelerometer!
I am still learning, but in my experience, it has been impossible to estimate actual value because the information is never fully available.
That Cookie popup doesn't event fit on my screen! And the buttons are below the fold. What's more I can't tell if "No" or "Yes" is selected, there's no visual identifier other than a slight colour differentiation which I struggle with.
> what you want

I think this is the key point. Because saying "this is what you want" hides a part of the problem: who says it.

The implication is that when you chose what you want you are in control. You may miss stuff, but you are the one deciding. When, on the other hand, it is chosen for you, the algorithm may be the best ever but you're not in control.

For some people "being the decider" is more important than for some others.
Interesting, I guess I forgot that the game of life includes edge neighbors and had no idea of the cycle time. Why isn’t it 2^8 neighbors though?. Maybe just running 2^8 simulations is the way to go? Or that’s 9 megabytes * frame size per so maybe that ends up being small enough with compression

Edit: the author has said that it’s non periodic apparently which seems like it would make this whole thing a lot harder and probably require more state
See this post: https://news.ycombinator.com/item?id=33980431
When I did code dilligence, I just add it to a list of possible risks... or areas we'd like deeper investigation. Usually go back over it in follow up.
Study: Over half of car crash victims had drugs or alcohol in their systems:NPR
China had concrete laws its local competitors adhere to that Twitter etc elected to not adhere to.

Are there concrete laws that local companies adhere to that TikTok can follow besides "don't be Chinese"?
I thought it was a town square for the world?

The most important town square for the world.
A few weeks back, I installed Tailscale on a Friday and the following Sunday my machine (ubuntu 22.10) was hacked and running mining/tracking software and rsyslog. I only noticed because my fans were spinning harder than usual.

caveat emptor
8" disks predate chip tunes (clack clack brrrrr smack)
I will never look at cats the same way again.
The founders might have been able to take money out by selling some of their preferred shares in later financing rounds though.
Not in practice no. People don't sideload "arbitrary binaries" also on android they install other app stores and these app stores have vetting. The vetting guide lines there might have less censorship than apple, but this "attack vector" is just completely made up in reality.
Seems like he was very clearly a Trump supporter:

https://www.cnn.com/2022/10/28/politics/pelosi-attack-suspec...

Do you have any sources for your claim? Some people are spreading misinformation that DePape was a leftist and not aligned with Trump, so maybe you should check your sources on this.
Artists Protest as ArtStation Allows AI-Generated Art on Site
With the plus, isn't every number and prefix/suffix unique across countries?

I have no idea if that holds true not knowing if a country code is attached.
> If I create something, but nobody ever sees it, did I create it at all? Doesn't feel like it.

You have been trained to require external validation for your work. Maybe it's a modern thing with upvotes and twitter and likes and whatnot.

If you create a thing, then you have drawn on your skills, probably improving them. Whether the thing is seen by others is irrelvant. What is relevant is your experience in creating it, and the use of it (whether it has a use, or just has aesthetic value).

Maybe practice by creating something, then destroying it, as if it had never existed. What remains? Memory and skill, both of great value.
I read that with a bit of nuance, like "only the original author or someone who has taken control of their resources" or something although you're right that some care would be needed in considering a statement like that.

I understood the statement relative to the case where someone else centralized ultimately has control of your content, like Twitter. The other extreme is some decentralized equivalent to the case of hard-encrypted files that are only openable to a person with special knowledge. There's lots of grey there, and decentralization opens up lots of questions, like "does any one person really have control over content in a decentralized system?"

I guess the comment seemed too fuzzy to me to be interpreted in much detail, so I was willing to flow with it, at least to some level.
Meanwhile what’s left of European nuclear industry is keeping the lights on
I'm not paying Google to track me while I watch videos with hardcoded sponsor segments and product placement.
A few years ago Valve integrated Wine directly into Steam under the name Proton, and started some serious development work on it. As a result you can now play thousands of Windows games on Linux by just clicking "play" in Steam and maybe a bit of tweaking now and then. Years later Valve recently launched the Steam Deck which makes use of all this.

It's not perfect, of course, many games still don't work at all, but if you only know Wine you will be surprised how much better the compatibility and experience is now.
https://github.com/piku/piku - dozens of projects in various languages in the same tiny VPS.
If there are clear boundaries, there would be no need for interpretation. Interpretation is needed to resolve questions that arise because the boundaries are not clear.
Pistachio health benefits: Know why you should include it in your diet
> it’s just that: a niche.

There's a paradox at play. Or maybe a distortion in our thinking.

I like my niche. You like your niche. My family, colleagues and
friends like their little niches. Ask around and you'll find that
everybody, barring a small slice of 13 year old's who talk about "what
everybody is doing", is quite happy in their niche. Indeed that's what
social media is all about. If everybody was 13 and wanted to attend
the universal party, and not be "left out", we'd switch back to
broadcast technologies.

It leads me to the conclusion that the mentality around social media
is really that of an insecure teenager, and that it's caused society
some degree of arrested development.
> They'd strongly object to being called racist as well.

Every racist objects to being called a racist.
Sigh. I get it AI is a threat. But it won't go away. Banning it from Artstation or from Stackoverflow is not going the help anyone.

I use Gpt3 now in my day to day work. I'd better see the possibilities and find a way to integrate it in my workflow, or my competitors will. Really, in the end my clients don't care whether a human wrote it or a computer. I dine better I guess, but in the end it's the work that matters.
Its a pretty big leap from "you cannot withdraw this particular stablecoin at the moment, use another one" to "you cannot withdraw your cash". Devil is in the details.
Balloon framing also either generates a waste stream of sawdust and offcuts, or requires a complementary industry to use that material profitably. Which today is engineered wood products and wood pellets for heating.
You might (not) enjoy CGP Grey's video about runway numbering https://www.youtube.com/watch?v=qD6bPNZRRbQ then, instead.
> As confusing as that was, he always called lunch dinner into the modern age.

This is still a thing in parts of the UK (and possibly other places):

"The divide between different meanings of "dinner" is not cut-and-dried based on either geography or socioeconomic class. The term for the midday meal is most commonly used by working-class people, especially in the English Midlands, North of England and the central belt of Scotland."

https://en.wikipedia.org/wiki/Dinner#Modern
I know it is contrary to HN guidelines to discuss comment votes, but this is weirdly my most downvoted comment of all time. In almost 13 years of commentating I have never had a comment receive -4 points before.
People were asking chatgpt multiple times, and then taking the most common working answer. Guess that's kind of a method to estimate it's confidence.
Interpretation is exactly where the boundaries become fuzzy.
Marketing matters more than the game if you're an indie, and I don't say that in a cynical way.

Unfortunately I've seen so many people pour their hearts and souls into a game thinking they can just start marketing it when it's ready: You should be engaging with your future audience well before then.

You don't have to take money from them, you don't have to make empty promises, but in the current landscape you need people to be waiting for your game, not you waiting for players, because odds are they won't come.

For every lucky game that gets the right streamer there's 10 more that are truly great games that just never get traction and die.
But Berkeley has been, and as a result thousands of hours of high quality course content has been permanently removed.

> In 2016, the US Department of Justice (DOJ) received letters of complaint stating that UC Berkeley’s MOOC media content was riddled with accessibility issues including low-color contrast, missing and inaccurate (automatically generated) audio and video captions, and screen-reader accessibility issues — all violations of Title II of the Americans with Disabilities Act (ADA).

https://www.3playmedia.com/blog/uc-berkeley-removing-educati...
Why is selling $15k “Fully self driving” capability not fraud? It’s not fully self driving. If they charged more for “fully battery powered” but it had a gas engine that would also be fraud.

I have a feeling that if Musk didn’t already have tens of billions he would be in the same position as Elizabeth Holmes.
At some point, people will still be predicting fusion in the next 10 years, and then it will happen in the next.
What does restart ready mean?
hope he posts an update anytime soon, sounds very interesting!
In Europe we use Fermacell, which is like drywall but much more substantial. It is made from recycled paper and cement.
I was thinking about asking here if anyone could give a brief yet full overview of what exactly tailscale is and who/how it benefits. I've read about it, but I still don't get it.
Ask HN: How to test ability in finding information?
We need to assess new hires in terms of problem-solving on things they 100% can't have prior knowledge about.

How do you assess the ability of solving a problem by being capable of finding the needed information and applying it?
wow, really impressive!
That it can handle device restarts?
> A flaw in OP's assertion is that I feel that most of what we have today wouldn't exist if it weren't for the GPL licensing.

That is pure RMS rethoric. The narrative that free software exists because of GPL is a compelling one (and sounds plausible), but its not based on reality. It was quite common in the end of the 70's and beginning of the 80's (specially after the creation of the C language) to distribute software in source form, instead of binary packages. Some early examples of this that still exists today are the BSD utilities (granted, now without the Berkeley clause), laying in the ground the notion that GPL is determinant in preserving OSS as an ecosystem.

The "trigger story" about not having access to a printer driver source code is also often simplified. The printer was a prototype of a commercial product, and he was offered the source under an NDA. More details on this in https://www.oreilly.com/openbook/freedom/ch01.html

> If the Linux kernel, or the GNU software suite hadn't been GPL'd in the first place

While there is no arguing that GPL is at least in part responsible for the success of Linux, it wasn't GPL until version 0.99. The major reason why you use Linux today is because of the "unix wars" (https://en.wikipedia.org/wiki/Unix_wars) - the lack of a free i386 unix system is what drove Linus to write one in the first place. If AT&T was less beligerant at the time, you'd probably be running some form of BSD :)
Thanks for the writeup! Agree on SAR being vastly different to interpret, and I can imagine the priciness. I also understand that the capacity/demand is another complicating factor now over Ukraine.

As you explained SAR phenomenology is not straight forward at all (pun intended). If I could suggest an option to explore a SAR-based damage proxy indicator, it would be interferometric coherence. This suggests however that you get your hands on InSAR data, both timely (to avoid decorrelation, which can happen over the span of a few days) and at good resolution to get relevant information at building-level.

As you can imagine this is not easy nor cheap to get. I am unaware if Capella is InSAR-capable; COSMO-SkyMed and TerraSAR/TanDEM/PAZ are the usual suspects when it comes to SAR constellations with InSAR capability and good frozen orbits. ICEYE I believe is trying to get there, but things are evolving rapidly. Sentinel-1 is a wonderful mission with solid InSAR capability, but I am not sure C-band delivers the resolution you need. Maybe NISAR is worth keeping an eye on in the future?

Fascinating work that matters, good luck with it!
I think you have this backwards; GCR flux increases with distance from the sun.
The batteries do exist, but it’s better to use them in cars. If we start diverting our battery supply for grid storage it will drive up the price of EVs.
Ouch.

CVE-2022-41924
Severe 9.6

A vulnerability identified in the Tailscale Windows client allows a malicious website to reconfigure the Tailscale daemon `tailscaled`, which can then be used to remotely execute code. In the Tailscale Windows client, the local API was bound to a local TCP socket, and communicated with the Windows client GUI in cleartext with no Host header verification. This allowed an attacker-controlled website visited by the node to rebind DNS to an attacker-controlled DNS server, and then make local API requests in the client, including changing the coordination server to an attacker-controlled coordination server. An attacker-controlled coordination server can send malicious URL responses to the client, including pushing executables or installing an SMB share. These allow the attacker to remotely execute code on the node. All Windows clients prior to version v.1.32.3 are affected. If you are running Tailscale on Windows, upgrade to v1.32.3 or later to remediate the issue.

Published November 23, 2022.
Maybe we should build a scaled-up version for human executions.
A follow up on this - I came up with an interesting strategy to achieve this. Still a prototype, but I think it looks very promising:

https://github.com/ggerganov/whisper.cpp/pull/271

The source code is in the `command.cpp` and I will soon write some more details how it works. If you give it a try, definitely let me know if it worked for you.
These figures aren't limited to cancer, they include the risk of (also poorly understood) heavy ion radiation induced cardiovascular disease.
This lacks the most important specs:

FPS of the video stream?

Button to Display latency?

Average needed upstream / downstream?
> If it pays more to work for a crypto exchange or the next data-stalking start-up than to cure cancer then most of the knowledge people will work on them.

Building stronger morals could also help.
Not surprised, but wouldn't there have been made some significant improvements since 2007? Or am I reading this wrong?
> of most economic value creation.

As Schumpeter observed, value creation is accompanied by creative destruction, and right now it looks like we're in the "creative destruction" phase when it comes to fintech.

It was one thing when in the early 2000s creative destruction was involving entities like pets.com, no-one was really hurt by those companies going down, but it's another thing when the company going down might hold your "savings" or owe you money as a SME, like Revolut or Klarna.
While an interesting effect, this recursive nature of this game can not be seen unless one has a mouse scroll wheel. I think it would be good to allow zoom in/zoom out to be done a different way (such as page up/page down or +/-). Not everyone has a mouse scroll wheel.
Ask HN: Why is there no open platform for reviews of places?
Google Maps seems to have the monopoly on data when it comes to user reviews (and ratings) of places/locations, at least as far as I’ve seen (I live and travel mostly in Europe). There are lots of efforts to have maps and navigation services from other providers (e.g. Apple Maps and OpenStreetMap with all of its different clients/apps) and I really prefer some of them to the relatively slow Google Maps. But one of the main reasons I still use Google Maps is for the crowd-sourced reviews and user photos, e.g. to see restaurant’s insides and menus before going there. Why is there no more open alternative platform to host this kind of information? Were/are there any attempts that just didn’t get any traction yet? Curious if some peeps in the mapping community know more about this.

Slightly relaxed toot: https://mastodon.social/@herrherrmann/109507042998753454

Edit: There does seem to be Open Place Reviews (https://openplacereviews.org/), but it’s using a blockchain to “avoid scalability issues”. So, still wondering if there are other projects with more sensible technology choices!
This sounds a bit like a basic version of AWS' Nitro - specialised chips that deal with the storage, networking, etc. leaving only the actual customer workloads on the actual CPUs. If Microsoft are buying to add this to Azure, that would indicate they're pretty behind AWS on that front (among many others).
Just to put this in perspective, FTX was at the crunch time in serious negotiations to get enough liquidity to effectively hide the 8B$ hole they had.

The fact that Binance can handle this outflow which is small compared to their total holding proves nothing. Know what would prove something? An audit. But obviously that can’t do that, as it would expose them.
Micro Services
I wonder why not he but his wife thought about improving their material circumstances? So content with his life, or so focused on the code, or something else?
I love that too, only wish auto-scrolling speed could be adjusted (would like it to be slower).
Through "secondary sales"?
> If there are clear boundaries, there would be no need for interpretation

You can't prosecute someone for murder just for insulting you. You can't prosecute someone for robbery if all they did was jaywalking. Media laws have clear boundaries sufficient for legal professionals to do their job. Building codes have clear boundaries sufficient for legal professionals to do their job.
I just started using Flickr again, I've kept a pro account for years and years, as I didn't want to lose what I uploaded and forgot about. I wanted to share some photos from a holiday, I tried to upload an album on FB and it just didn't seem to be able to do it from the phone, madness.

I don't much use FB or instagram anymore, I go through instagram every so often,
when I don't check things for months, and I scroll a few times and it tells me I caught up! FB and Instagram are mostly just sponsored or commercial posts on my feed, instagram just stops showing stuff from friends after a few scrolls, FB is maybe 1 in 3 posts are from my friends.

I share an album from Flickr and people get an ad free view of what I wanted to share, far superior.
That's what's really awesome about it. In essence there's nothing but the rules of the game of life.

I wonder if it's the same for reality. Everytime we've been looking at some particles we deemed fundamental they appear to be made of even smaller ones.
You think that employee that work for nothing in exchange of worthless options are also working for a charity?
> If you don't want to discuss specific numbers, then don't state specific numbers, say that "More people do X than Y" without trying to get specific about how many people do either.

No. It was a fleeting thought in a casual conversation about video games, not a wikipedia entry. Read more charitably. Assume good faith. And maybe consider not arguing with someone unless you understand their point well enough to be confident you disagree with it.

> I've said all I care to about this topic, you can have the last word[s]

Nerf Zerg!
China does not recognize patent law, therefore they could not have stole anything. I am all for recognition of one's discovery but the patent law in "the west" went too far and is more a retarder rather than accelerator of progress.
How to remove your personal phone number from the internet
Interesting article! So Brady took "an equity stake in the company and [got] a signing bonus in crypto", then went on to make advertisements even though "The NFL has banned cryptocurrency and NFT sponsorships for its teams". Seems that he, or likely his lawyer and/or financial adviser, will have been evaluated the legitimacy since he's deep into caveat emptor territory. Like innocently buying a stolen car: you're unlikely to be in legal peril but you will lose the car (and gain a claim against the thief that sold it to you)
"A single round being short" is exactly what they're talking about.

Edit to add: whether that's a big enough effect for the use case they're talking about, I don't know. This sort of thing is definitely significant in cryptographic code, though.