skysight-inc/HackerNews huggingface dataset:
DuckDB offers a SQLite compatible interface; we use it extensively ourselves as it allows us to use the SQLite shell directly.

The internal design of DuckDB, however, is different and not directly related to SQLite. As you mentioned, it is entirely optimized for analytical workloads whereas SQLite is optimized for point-queries and point-updates. The main things we share is that we also have a single-file storage format and offer an amalgamation (i.e. single-source file compilation, duckdb.cpp and duckdb.hpp).
> I would love to switch to a better alternative

I would love to switch to Reddit from 2008.
Wait until people confuse that with NVRAM.
I meant finance and investment analysis, not programming.
This isn't 2003. Bots are litetally backed my humans that sit all day creating bit accounts. There is an industry behind bypassing simple things like this. Why cant bots register a million domains are receive a million account registration emails?
> Sure it sucks when mistakes are made, but fearing saying the wrong thing in an emotionally raw time around racial issues, isn’t even close to what really has counted as “mob justice” in American history.

This argument boils down to whataboutism if you dig down under the overly emotional packaging. This is not bringing anything to the discussion, it is an attempt to shut down the discussion. This is why you are getting downvoted.
As someone that has probed this community on different basic morality subjects for years and gotten downvoted to the lowest possible score (-4), I can reliably say that there's a portion of the user base that hold beliefs and perspectives that are not making the world a better place and sometimes make this feel like a cesspool.

Sometimes the lack of exposure to real-world problems creates people that are completely disconnected from reality.
Was ammo in Crysis controlled client-side? I've always assumed such counters were stored server-side and thus a server won't apply a "fire" event if the player's ammo counter is at zero until it receives a "reload" event to reset the counter.
Front-end / interace needs to be synchronously controlled, it doesn’t feel right otherwise. I followed xi-editor but it never was faster than emacs on opening really large files and editing them so it never had a use case for me
You're a man, right?

Traditional male power and status seems pretty baked-in. That's why it's traditional. You can try and repress it, but sovereignty is conserved: in the end, like 90% of young men all want sex, because those are the genetics, and they'll compete to be the ones to have it.

You can try and social-condition men to repress their drives, and you'll get a bunch of neurotic weirdos who lash out and/or commit vile acts in the darkness.
I think of multipath being about signals bouncing off other objects (reflection) and bending through media (refraction) before reaching the receiver. At the cosmic scale, I'm guessing multipath also involves gravitational lensing. Correct?
Maybe not as much left wing as rabidly anti Trump, beyond any semblance of reason. Even worse is their unrelenting amplification of divisive issues, especially on race and gender, always favoring the same side.
I buy metric screws from Home Depot all the time and have for years. How long ago did this happen?
Coca-Cola joins Facebook boycott, to pause all social media ads on July first
> Scunthorpe Sans censors out profanity

Failed at the first attempt. You'll need more than that to stop a mischievous primate
Hmmm does that also apply to dynamic libraries? Now that I'm thinking about the fateful day, I pushed an updated library, not an executable. I'm guessing it was on FreeBSD 8.x, but it could have been 9.x.
> Maybe I'm naive, but it seems pretty obvious that it's because technology is mostly full of leftists, so they tolerate their own extremists and ban their opponents. Deplatforming has been a tactic of the left for a while now.

I wouldn't say that technology is full of actual "leftists", more a group ranging from overly-myopic liberals who struggle to do what would actually benefit minority communities in a more positive sense to the libertarian types who only end up restricting what people say because it ends up affecting their advertising revenue. Simply by virtue of being in a position of financial power, it's very difficult to hold truly leftist views.
I find this disturbing. It's the changing nature of what's offensive that I find bothersome.

In the early 80s, one of the top-rated shows featured a Dodge Charger with a Confederate flag on the roof and a horn that played 'Dixie'. I don't recall hearing any objections, even from the brave men and women of the civil rights movement. Tom Petty (who tended to lean left, politically) toured with the Confedrate flat. I knew people with flag tattoos (usually with text like 'Born to raise hell' or something similar). Poltical candidates of both parties (including Bill Clinton) had backers that distributed campaign buttons with the flag.

But that changed. The flag became a divisive symbol. I recognized it myself when Dr. Ben Carson said he found it offensive. At that point, I changed my attitude towards the flag, but I remembered the time when it was not offensive.

I feel bad for people like Civil War re-enactors, or history buffs that invested in memorabelia. Their hobbies are now hallmarks of racism. I don't see where they have much choice but to give them up.

So today the 'ok' symbol is racist and can get someone fired. What comes tomorrow? Clicking a pen? Snapping your fingers? There's no telling.

Pepe the frog went that way, as far as I can tell. Is Kermit next? How about Bugs Bunny? There's no telling.

I hope it stops.
I'd be interested in if this is comparable to Gleam, a BEAM-based scripting language, that I discovered through HN.
SpaceX Satellite Internet Plan Hits Dish Ground Interference
Nothing wrong with communities like that as long as you keep them segregated like reddit does with each of its subreddits.

If those start creeping into your politics, memes, and video game subreddits, then yeah you’ve got a rough problem.
I have nothing against this model of sharing information. In fact, I think that Twitter has a very interesting way of getting people who wouldn't usually sharing information to post stuff you can't find elsewhere. But the UI for it…really sucks. It's awful. I and everyone else struggles through them because the content is just so good, but Twitter could do so much here to make the experience better.
I don't think you can blame this on an async design. Right off it talks about having the keyboard input as a separate process, not knowing what version of the buffer input should apply to, using timeouts and I guess, doing everything over local IP. It almost reads like a list of what not to do.

Why not put the input into the window, put a version number with the buffers and keyboard input and use shared memory? Of course something isn't going to work if you don't confront the problems you have at a fundamental level.
I heard the opposite. Sources?
In that sense,

” the heart breaks and breaks
and lives by breaking.
It is necessary to go
through dark and deeper dark
and not to turn.” - Stanley Kunitz
https://en.wikipedia.org/wiki/One-Dimensional_Man
> balancing different social interests

okay. how can you measure social welfare?

> seems like a pretty extreme position to just say that money and pricing is the only tool in the toolbox.

I never said that. You said it. You countered it.
It's the paradox of tolerance. If you tolerate the intolerant (e.g. right-wing assholes) they will push out other groups through their intolerant behavior. The only solution is to rabidly ban hate speech and similar behavior.
> you can't generally check the credentials of someone on the other side of the world very easily

If that were true, we would not have any trust in global trade. There are plenty of IT companies that have all American IT workforce and still have suffered data breaches. The issue at hand is not checking someone's credentials here. The issue is the political undertone that OP has taken.
The hard truth about the Facebook ad boycott: Nothing matters but Zuckerberg
Applied Category Theory 2020 is coming up soon
This sounds like a browser bug tbh.
Base 12 metric should be a real thing. Maybe when we build self sustaining O'Neill cylinders we can use that opportunity to switch.
24a2: An ultra-minimalist game engine
A free market is one where transactions take place absent fraud or force.

Slavery doesn't remotely qualify.
This is absolutely false. Exposure to a higher number of viruses might increase probably of an infection, but a single virus can certainly lead to a full blown infection in an individual.
There's nothing underground about it, the film screenings are organised by the makers of the game.

But if you want something a bit more underground, try the channels on https://cytu.be/ that pull content from google drive.
Why the home-working boom could tumble London's skyscrapers
or keep getting kicked off of the other platforms.

or duplicate accounts to give the illusion of larger numbers.

For example there are a lot of Reddit accounts created with in the 3 months or so very active on the same post pushing the same agenda.
> JavaScript is required for this page.

Yeah, I'm out. That was a problem with the federated reddit-alike notabug.io too. It was just one giant javascript application, not html. And doing "pre-rendering" of the javascript on the host machine made the VPS costs too much to be tenable for people to federate.
Stipulate that the current crop at No Such Agency are all cool ladies and gentlemen.

There are no guarantees about the people going forward, and the data live on.
> exclude the huge negative costs imposed on slaves

What slaves? That was a century ago.
Can I just use a different font for the disparaging parts? e.g.

"Goldman Sachs has consistently demonstrated they are a

bottom-feeding, tone-deaf, greed-driven

organization of the highest order."
> you counter the accusation that most of these loans are used for daily necessities and not for starting a business?

The article cites “consumption loans” which are often for things like water sanitation or home repairs.

> It doesn't help the hundreds of millions of people who don't have daily necessities.

Being able to buy capital equipment can dramatically improve food production.

> No one claiming to benefit the poor should ever charge, for example, 50% interest.

Why?

> Citation needed.

See Bangladesh, India, South Korea, etc.

> Is capital fixing the poverty, or is capital arriving because something else has already started fixing the poverty?

Capital arrives because a country fixes certain basic rule of law, education, etc., issues. But foreign aid can’t lift a country from poverty into middle income status.

> The US and India have waged wars on poverty with success.

False. https://www.vox.com/policy-and-politics/2016/12/29/14112084/...

https://www.brookings.edu/opinions/the-war-on-poverty-what-w...

There is a very timely comparison to the situation in the US with the black-white income gap. It is the same today as back in the 1960s when the country was still legally segregated. Decades of government education programs, etc., haven’t had any effect on the gap at all. It obviously can alleviate suffering in the near term. But only the infusion of capital can actually change their financial condition meaningfully.

The same thing is true for Bangladesh. Don’t get me wrong: foreign assistance has been a boon in terms of helping reduce mortality rates and malnutrition, increasing education, etc. But that, by itself, can’t reduce poverty. Educated labor is useless if there is no capital. Bangladesh has received foreign aid for decades. But in the last 20 years, it has liberalized its economy and started receiving significant foreign capital. It has added $225 billion to its GDP since 2000. Foreign assistance could never accomplish that, because no country is going to be sending $225 billion to Bangladesh each year. You need to increase the production capacity of the local economy, and foreign investment of capital does that.
>Deplatforming has been a tactic of the left for a while now.

Deplatforming has been the go to method of the right for at least a century (see mccarthyism) and longer if you include lynching/death as essentially equivalent (ie: you can't speak if you're dead). The left has simply finally got enough critical mass to do it themselves.
I think this is not about coding style for async code (coroutines vs. callbacks), but about general asynchronity between various processes/threads.

If you have any asynchronous background task it means the state of your application can change without the current thread having made any change. And your code needs to account for that possibility, which makes it a lot more complicated.
We Found a Piss Dungeon in a Pub
If you create value for others and they show there happiness with money. Congrats you are rich
Founders of YouTube, Tesla join forces to create first real MBA alternative
The filming of Stalker[1] was itself fraught with industrial contamination — possibly with to the extent of eventually claiming Tarkovsky’s own life, by cancer.

Zona by Geoff Dyer is an excellent discourse on the work, which I heartily recommend, and where I first read about this and many other fascinating details.

[1] ...or ker-tan-kep as my own ignorant tongue insists on pronouncing it.
Im too busy to lay it all out, but at this point it’s not really a conspiracy theory. There are arguments it’s not from a lab.
The “forgot password” link does not work. (On mobile so I did not dig in and see if there were any errors in the console.)
The reason Voat is so bad is because it's the only alternative so the extremists are all shunted there. If a federated group of many forums was available with different moderation policies, then there would be breathing room for non-extremists.
It seems to me that "traditional" HTML hypertext already can do this pretty well - people just don't usually make "traditional" hypertext websites, they write linear blogs or tweets.

Taking that as a given, my question is, why does the author of this post, and the people he's talking about, miss that hypertext can already do this?

It might be that the issue is UI, both on the producer and consumer side.

Production of hypertext is difficult if it requires writing HTML; WYSIWYG or "personal wikis" or other hypertext-production UIs like that improve this. Maybe they're still too cumbersome, relative to Twitter? Hosting is also an issue - there are a lot more places you can sign up for an account and post things in a Blogger/Twitter/Facebook-style linear feed than host free-form hypertext.

I think a more interesting issue is the consumer side. We have good UIs for consuming linear streams of content as they get created, but it's not immediately obvious to me how you'd make a similarly good UI for consuming updates to a web of hypertext. Maybe you could consume diffs? The problem seems somewhat similar to serialization of an object graph.

Of course, the notion of "consuming updates" to hypertext might be entirely the wrong perspective - again maybe there are some insights from the analogy to an object graph.
Implementing the Exponential Function
This trend is even more striking (and perhaps more convincing and verifiable) when you extrapolate it out over a longer time scale:

https://trends.google.com/trends/explore?geo=US&q=%22loss%20...

Edit: just to temper this a bit; trends can be misleading and I'm not stating that this query is a robust indicator. It'd be great to figure out how reliable these charts are.
Sure, but here it's support for hardware costing 4-5 figures being dropped after a paltry 7 years.

The latest version of Windows 10 runs great on 10 year old desktops, and will probably be supported for many more years to come.
I don't know, I'm a little worried about 2.0 as they've delayed it for so long.
Sure is!
Weak report.
If monkeys made music they would have a part of the brain that 'preferred' musical tones.
The point is we do, they don't, end of.
Humans are not tuned to the intricacies of monkey talk. I read that in monkey science daily dot banana.
> Industrial ecosystems don't spring out of the ground because of selfishness and greed, they're created by institutions.

barrin92 meet Charles koch.
Earth is perfectly capable to do it at home. Has created things more bizarre than viruses.
I would recommend one simple rule that has had a huge impact on me:

No mobile screens (phones, tablets, laptops) in a bedroom

I no longer lay on my phone at night. I sometimes stand in the kitchen and browse before I plug in to charge for the night, but when I go to my bedroom, I got to sleep or read a book. In the morning I don't reach for my phone. I lay there and stare or get up.

It took about a week for the urges to go away.
> The phrase "don't feed the trolls" is well-intentioned but it's difficult to scale the message when so many people are online and can witness and partake in minor and major conversations alike.

I wonder if it's possible to have a community where the moderation is more focused on educating people to identify trolling and discourage posters from engaging with emotionally charged/inciting posters. Instead of warning the troller, encourage people to just downvote and move on instead of engaging.

I consider a troll as someone who is seeking to create a strong negative (anger, hate, frustration, etc) emotion in a reader intentionally or unintentionally. I dont know if this is too subjective and impossible to enforce.
>Wouldn't you like to work with a more diverse group of people as well?

I don't think anyone would really like to work with a truly diverse group of people. A truly diverse group would
-all speak different languages
-all be different genders (their origin culture, from which they immigrated last week, has some alternate view of gender)
-all have different views on what's normal and what's tabboo
-all have vastly different religious/quasi-religious views

The hip, trendy open-plan office would be an open war zone between the eunuch sun-god worshipper and the revivalist post-truth anti-christianite on the first day.
For anyone interested in a standardised/Linux-compatible version of this, check out PKCS11 tokens. Smartcards can and do implement this spec, and if you use PKCS11, the secret is used from the token to sign an SSH login (for example), without being revealed.

This means the secret itself stays on the card. You can combine this with certificates if needed; the smartcard handles the authentication. Using PKCS11 tokens is supported in recent openssh versions. You can also use them for client certificate authentication in web browsers. For anyone familiar with DoD CACs, this is similar - I believe they use a particular card with a proprietary PKCS11 driver, but you can use opensc with any card running a PKCS11 applet.

Some refs:

https://zerowidthjoiner.net/2019/01/12/using-ssh-public-key-...

https://developers.yubico.com/PIV/Guides/SSH_with_PIV_and_PK...
This is sensational.
It's a virus.
They're all sinister.

Look into the absolute nightmare that the filovirus that destroys your blood vessels. Or retrovirus that integrate into the hosts genome.

Any disease with a pathology can be considered sinister. Sinister then loses its meaning. Sensational.
Most social sites lean left, and far-left dialog is generally tolerated in those places, while anything right of center is demonized in a gradient of intensity the further right you go.

Your own scenarios exhibit this, for example:

- You ask if the far-right are magnitudes more vocal, ignoring the comparison to the extremely vocal far-left which is heard regularly on mainstream social media

- You conflate "conservative" with "selfish", presumably ignoring the selfishness of the extremes at both sides.

Frankly, I think the left (and by extension, most social media sites) are WAY more comfortable with censorship, banning, hiding, etc., especially of ideas that don't align with the left. (Typically characterized as "evil".)

The far-right, on the other hand, I think is a lot more tolerant of at least the notion that "other" speech exists. They'll insult you, make fun, etc., but the compulsion to censor others is far less frequent.

So when you have a whole segment of the political spectrum treated as evil and silenced, they tend to gravitate to fora that enable speech, even if unpleasant speech. The far-right might be most noticable on those platforms, but if you look carefully, you'll see a whole gradient of right-ness.

And even some lefties!
I think of it, very generally, as: scripting language = writing a 10 line program isn't a chore; non-scripting language: writing a 1000 line program isn't a chore
Tangent/clarification: the regex slowness issue is almost certainly due to using Perl-style exponential time regexes (which are required by Sublime syntax definitions) rather than "regular languages".

The syntect library mentioned uses fancy-regex, which is explicitly different than Rust's default regex crate, in that it supports regex constructs that require exponential backtracking:

https://github.com/fancy-regex/fancy-regex

In particular, it uses backtracking to implement "fancy" features such as look-around and backtracking, which are not supported in purely NFA-based implementations (exemplified by RE2, and implemented in Rust in the regex crate).

I think "regexes" have gotten bad name so I call them "regular languages" now. That is, RE2, rust/regex, and libc are "regular language" engines while Perl/Python/PCRE/Java/etc. are "regex" engines.

In my experience, lexing with regular languages can beat hand written code. In the case of Oil vs. zsh, it's beating hand-written C code by an order of magnitude (9-10x).

http://www.oilshell.org/blog/2020/01/parser-benchmarks.html

https://lobste.rs/s/77nu3d/oil_s_parser_is_160x_200x_faster_...

---

First, TextMate / Sublime style syntax highlighting is not really all that great. It is quite slow, largely because it grinds through a lot of regular expressions with captures

pedantic: I think the issue is probably more lookahead than captures ? You can do captures quickly in a "regular language" engine.

It may be surprising just how much slower regex-based highlighting is than fast parsers. The library that xi uses, syntect, is probably the fastest open source implementation in existence (the one in Sublime is faster but not open source). Even so, it is approximately 2500 times slower for parsing Markdown than pulldown-cmark.
They believe USSR won WW2 by itself - there was no war before June 1941, no Lend-Lease, without Allies they would seize entire Europe. And no, not free, no self determination allowed [1]. Then they would certainly beat Japan by themself - it is just an island. Afghanistan was another territory that could be ours.

Putin plays on ideology created by USSR. Lie, lie, nothing but lie. Bolsheviks invented a lot in terrorism. It takes century to unfold. ISIS followed same book [2].

Sorry to bring it here, it is awful they want to start it again.

[1] https://en.wikipedia.org/wiki/Prague_Spring

[2] https://www.russiamatters.org/analysis/islamic-state-and-bol...
The VT102 can be configured up to 19,200, but the documentation says[1]:

> In applications using continuous 19,200 baud communication, occasional data errors may occur.

In my experience, setting the emulated VT102 to use 19,200 makes every keypress generate a data error. Even if it worked, though, the VT102 still runs at 6MHz and it still takes just as long to scroll the screen, and my host PC is still ~infinitely fast, so I think it would just make the problem worse.

[1]: https://vt100.net/docs/vt102-ug/chapter6.html#S6.2.7
Realistically, even if I tried to explain it in layman terms, none of those points would convince my girlfriend to stop using TikTok.
Yes - as the other commenter mentioned there are some docs from Yubico. Also worth looking at PKCS11, as this lets you do HTTPS clent certificate authentication, as well as SSH. And it's all standardised too under the PKCS11 standard, which is nice for portability or diversity of token providers.