skysight-inc/HackerNews huggingface dataset:
So, isn’t this the premise for Starship Troopers and how Zerg/Tyranids operate in StarCraft/WH40k?
Makes sense. I agree.

DuckDB is pretty phenomenal. I enjoyed reading its source code and playing around with it.

Another open source nice C++ codebase is Typesense for Hyperfast text search (algolia competitor).

It’s been on my mind for many months how to build indexing like this as postgres extensions.

I love how versatile postgres is with so many indexing datastructures.
It will produce a lot of nuclear waste though (neutrons activating and damaging the hull)
Serious answer: buy a PinePhone and contribute to Mobian.
G.fast is common in older blocks where rewiring with ethernet or fiber isn't feasible.
Those have a role in the energy landscape to be sure, but they don’t offer the benefits of fusion because they don’t have the same power density.
What is meant by "I stayed in one of the motors"? Was it part of a wheel well, a jet engine, or what?
Long Short-Term Memory for AI Applications in Spike-Based Neuromorphic Hardware
Why do you seek an alternative to Make? It does the job, brilliantly. I’m not a fan of the syntax, however, especially the need for tabs. Is that your main concern?
It serves as a notice, like "Look out for a this sharp, hidden edge!"
Gotcha. Targeting musl instead of glibc with Zig CC should get you a statically-linked binary, though, unsure if duckdb and its deps play nice with musl.

Personally, a duckdb golang binary interests me. But: I haven't yet mustered enough patience to sit through a time-consuming duckdb build.
Presumably because it would already have all the necessary code to find/enumerate existing resources.
Interesting. Thank you for the details. Most of the audio world and purchasers are wrong about how this amplifier works haha.
I am using a half blood knot but seeing the palomar knot makes me want to try this because it seems a lot easier than threading the line through the loop five times (or did I thread it five times already?).
Both CRDB and Planetscale are.
Should the all uppercase be something CSS like text-transform: capitalize, and not affect screen readers?

Where something is explicitly visual-only, I agree that there can be cases.
Yes, tell me about it. I once got sent from London UK to Newark NJ to attend a one hour meeting in Princeton NJ and then got flown back (to be fair, all Virgin First (Upper) class). The senior accountancy partner I was there to support went on Concorde. Anyway, it must have cost god knows how many thousands of GBP, and didn't resolve anything.

And then in another gig, I got sent to Boulder Co, via Denver for something like a three hour meetining, which once again resolved nothing, though this time I was in the back of the plane. I liked seeing the Rockies, but really...

Perhaps Covid has made things better now, at least with such idiocy as this?
One of the founder of TiDB/TiKV here from PingCAP (https://pingcap.com)

I have been thinking about this problem with my peers when I started to build TiDB (https://github.com/pingcap/tidb) seven years ago. At that time, nearly all of us were familiar with Go language, so we decided to use Go to build the SQL layer of TiDB. Thanks to Go, we could develop TiDB very quickly and released the first MVP in half a year. I remembered clearly the sense when we ran TPC-C successfully, although the TPMC was just 1 at that time, this was a good start for us.

But Go had some problems, e.g. the GC was not good before, the fair scheduling might cause some latency problem, or data racing may happen sometimes. So when we decided to build a distributed storage (aha, TiKV (https://githbu.com/tikv/tikv), we wanted use another language to guarantee safety. I really admire our courage - we chose Rust which was just released 1.0 and missed lots of libraries at that time. Now it seems that this is an awesome choice, TiKV has been graduated from CNCF, and been used as building block not only for TiDB, but also for other distributed systems. Thanks Rust.

When TiDB started being used in many companies, we found that our customer not only ran lots of online transactions in TiDB, but also they wanted to ran some realtime analytic queries directly because the data has been in TiDB already. So we decided to build a HTAP database, to introduce a column storage beside TiKV, this is TiFlash (https://github.com/pingcap/tiflash). We build TiFlash based on Clickhouse, so of course, we use C++.

As you can see, to build only one integrated database - TiDB, we at least use three languages, every language has its own reason to be introduced. We can treat the distributed database as a service system, each service can be built with your favorite language and the services are linked by gRPC like TiDB does now. You may doubt that - “hey, guys, you are building a database, performance is very importance”. Yes, this is true, but we also build a complex distributed system, especially on the cloud. Scale-out, elastic, user experience must be important too. This is trade off for an engineer :-)
> The training data may come from unethical sources or processes.

That is an oft-overlooked point. In this instance, I think many forget how exploitative pornography actually is. And sex work in general.
You do because the metadata on the resource might get changed.
It's important to remember that you don't need to be near the car during charging. In cities, chargers aren't in desolate locations pretty much by definition. You can leave and do something else while it's charging. Chargers are increasingly common in parking lots of fast food chains and supermarkets.
Show HN: Inclusive Design: an activity to bridge empathy with Neurodiverse ppl
> - You're recommending a maximum meta description length of 320. That's no longer what Google recommends.

Thanks, can you provide a link that gives a length recommendation? On https://developers.google.com/search/docs/beginner/seo-start... they say:

"While there's no minimal or maximal length for the text in a description meta tag, we recommend making sure that it's long enough to be fully shown in Search (note that users may see different sized snippets depending on how and where they search)"

This one is tricky because the maximum number of characters Google displays is open to change (and there's more search engines than only Google too).

> I got all green ticks for mobile scaling on a site with "maximum-scale=1". Maximum scale should ideally be avoided.

Thanks, I'll look into this. Rule https://www.checkbot.io/guide/seo/#rule-set-mobile-scaling is only checking for `width=device-width, initial-scale=1` right now (cited from https://developers.google.com/search/mobile-sites/mobile-seo...) and not looking at `maximum-sale`, so this falls under being a decent baseline but still more you could do.

What range of `maximum-scale` should be allowed if any? Off the top of my head, `1.1` is probably just as bad but `100` is probably okay. I'm curious what the typical values used are.

In general, I've been pretty conservative about what rules I've added, sticking to ones that are generally agreed on and generate minimal false positives.
Rural areas in the U.S are unwalkable (not just rural areas, but most of the U.S), not to mention probably devoid of people and community. People value community and walkability.

Also degrowth doesn't imply living in rural areas.
I think you want "thinkest" (2nd person) rather than "thinketh" (3rd person).

https://en.wiktionary.org/wiki/thinkest
Fixed. Thank you for catching in. Renaming a company is hard even pre launch :)
I actively tried to switch to Firefox this year, but couldn't due to issues with saving tabs on sudden shutdown. Due to a separate issue, my apple laptop was crashing and restarting a couple times a week. Several times Firefox was not able to restore the browsing session, and I lost all of my tabs :(
The most important job of VACUUM is usually to make sure that queries remain responsive -- it's roughly comparable to a "full scan" within generational garbage collectors (for managed language runtimes). VACUUM does reclaim space in various ways, but that's often considered to be of secondary importance.

In Postgres, the on-disk representation is virtually the same thing as the in-memory representation used by pages stored in the buffer cache. In a system like Aurora or Neon, the representation of pages in the buffer cache is identical to that of Postgres (or has very minimal divergence to deal with one or two isolated problems). That part doesn't really change, which makes it possible to have a very deep level of compatibility without much effort. So it's radically different in one narrow, scoped way, but otherwise very similar.

While the storage knows how to materialize pages on demand, these are not transactionally consistent pages -- they often need to be interpreted by using metadata about transaction commit status, just like in Postgres.
You could also use data: URLs to make it a true Serverless(c)(tm) experience
data:text/html,<b>hello world</b>
> Real estate is leveraged […]. Stocks aren't.

Leveraging in stocks:

* https://www.investopedia.com/terms/m/marginaccount.asp
I’d take it further: offset based pagination failure modes look different based on the implementation. If you have API clients, you’re exposing that implementation detail to them.
I mean, the whole point of entrepreneurship is to focus on the upside and have protection from the personal risk of ruin, so it's not surprising that it would distort their thinking generally.

> entrepreneurs create a decision rule comprising a limited set of factors (e.g., the potential for growth) and selectively focus on these factors while paying less attention to and/or ignoring others (e.g., risk of going into default, period of underperformance).
Key statistic: 33% increase in incidents 2019-2020, 52% increase 2020-2021:

2019 - 30

2020 - 40

2021 - 61

OTOH, the spike in number of incidents isn't really reflected in casualty numbers:

2019 - 258

2020 - 164

2021 - 243
So there is a script or something with the book that you can run on your Git repo to see a chart of the hotspots?
1) Bandwidth is pretty irrelevant now. Even players on cellular networks have megabits of bandwidth. I stopped spending a large amount of time optimizing for packet size while building the networking for Dota 2. Nobody is playing a 14.4k modem anymore.

2) Server placement is still an issue. It's still ~200ms round trip from New York to Sydney for example. Fortunately, cloud infrastructures can make getting servers to closer your players much easier now. You don't have to physically install servers into data centers in the region.

3) Packet loss still occurs, but is incredibly rare that the gap between using TCP and UDP is narrowing. Modern TCP implementations like Microsoft's are amazing at handling loss and retransmission. However, I'd probably use QUIC for game networking if I was to write an engine from scratch these days.
I think there is still a lot of benefit in a first-party library which provides shared abstractions like `Color` and `Bitmap`, even without any fancy manipulation capabilities.
> because we live in Japan

May I ask why you're using them at all? Every time I look at Japanese cities they seem to have PM2.5 levels in a second-digit microgram range. A bad day seems to be something like 15 µg.
We keep it there for a short duration, until the changes are confirmed to also be written to S3.

Writing to 3 instances in 3 availability zones is considered persistent enough while also maintaining a high performance, and even though it does not provide the 11 9s of durability that S3 has, 3 availability zones dropping out with loss of all instance-local storage is considered rare enough that we do not think that it will impact our availability and durability guarantees.
Most people with a browser limitation are using a very old personal computer or device which cannot run the latest browser or OS, or does not have sufficient resources to do so adequately.

And yes, much of the modern internet is broken for them, but the basic and essential services are not, and that's what they can afford to use.

They'll get an updated device eventually, when they save enough cash and the annoyances justify the spend for a replacement (perhaps second-hand), or when a friend upgrades and gives away their old kit for free. Either way, the replacements are often years old when obtained, so the wheel turns again.

There are a lot of people running old devices. You can see this in the OS version web request stats looking at old OS versions people would not run if they had recent devices. More subtly you can see it in the screen resolution stats.
This is all really complicated, and telling the difference between those things is the hard part, even when you think you might know the answer.

This has been on my mind a lot because of some circumstances I found myself in that ended up being disastrous. When I complained to a good friend, he would often characterize me as just being too negative or something. For years what I would do is the stoic thing, sort of tell myself I was just making too big of a deal about it, and so forth and so on.

At some point though I realized my problem was the opposite, that I wasn't making a big enough deal about it, I wasn't taking enough action, and by the time I understood what was going on, it was basically too late.

In my case, I think the problem was that I didn't know how bad things really were, because I didn't have any frame of reference for anything else. I didn't know how it should be, so I didn't understand how far things were off. And my friends projected, assumed that where I was, things were like where they were at, that if I complained about Serious Problem X, I really meant Less Serious Problem Y, even though I actually meant Serious Problem X.

When this goes on long enough, and no one really knows what's going on -- you can't help yourself because you don't recognize what's happening, and no one around you is helping for whatever reason -- it can look like you're wallowing in victimhood when it's really just that no one is really identifying the actual source of the problem. There might not be any real victims involved, or maybe everyone is a victim. It doesn't matter.

At the risk of sounding pedantic, this is the essence of classical Western tragedy: no one is really a victim, they're just screwed in ways no one forsees.
This applies for any media filter. VFD drive on the motor can keep airflow constant and increase energy usage instead, but for most fans the increase in static pressure means less air volume. Heavily loaded filters can also have more air bypassing the filter, which may or may not be significant depending on the application. For this kind of air filter bypass just subtracts from the airflow through the filter media.
> comparison that was shared here recently: https://privacytests.org/

The Librewolf project appears to be the best of all! I will try it.

edit: Statement below is incorrect, Brave is a Chromium fork.

I do note that Brave, Tor, and Librewolf are forks of Firefox. This in my opinion is an additional reason to support Firefox. Everyone else appears to be plundering naive users' browser telemetry.
EA reportedly looking for a buyer and has spoken to “Disney, Apple and Amazon”
Having enough computing power to be able to write crappy software is an enormous productivity boost. Writing software with crappy performance is way easier than writing software with good performance and takes less time and less experienced developers. Writing crappy software is often better at achieving business goals as cheap as possible.
The feature I use most is Firefox Sync and the ability to not only send browser tabs to instances of Firefox running on other machines but also to look at and load tabs from another machine, even when it is offline.

Routinely I'll be reading something on my laptop in the evening and want to reference it from my Dev VM the next day. With Sync I can just pull up the list of open tabs on my laptop that's asleep and retrieve the URL.
Please don't take HN threads into nationalistic flamewar. That's among the dumbest and most hellish kind of writing we end up with here.

https://news.ycombinator.com/newsguidelines.html
The air purifier people must have met some printer ink people at a conference.
I agree. I was unsure if the author meant db cursors which would be keeping transactions alive. That has obvious scaling issues. But reading the comments here has me convinced they are talking about application generated cursors. I think this is a pretty reasonable confusion and it would benefit from added clarity, like naming them differently.
I really dislike the concept of "rationality", or at the very least the way it gets used. I'm sure there are cases where everyone would agree that someone is behaving irrationally, but a lot of the time the label of "irrational" hides assumptions about value and tolerance for risk.

If an entrepreneur decides to prioritize certain factors over others, who's to say that's "irrational"? Is there an objectively correct way to run a business? I just find the whole idea so tiresome.
Does it not reflect reality to recognize that time spent feeling sorry for yourself could be better utilized in any number of other pursuits? Why the hostility to this basic notion?
Hey thanks for breaking it! :) the templating lang is definitely brittle right now and will need to be revamped for anything close to real usage.

I managed to add emoji support last night, which ended up increasing my encoded payload size by about 30%.

I need to add some debouncing to the block updates as it’s real time right now but with all of the encoding seems to overwhelm the page if you type too fast.
The state's budget grows a lot faster than inflation. Property tax revenues aren't growing anywhere near as fast as income tax revenues. The trend is clear. The state is more and more dependent on income tax.
if anyone is curious, the link data is the following in base64:

1;1|fig:MemLink;5;2;c|h2:In-memory micro web pages;5;3;c|p:MemLinks are self-contained, micro websites that are fully generated at the edge.|p:Use a MemLink to easily share lists of links, contact details, project overviews, and so much more.|h3:The link is the web page.;1;3|p:Memlink pages are composed of blocks that can be added, removed, and rearranged to make unique and creative content.|p:Create your own Memlink now by clicking Edit this page below.

is this a bespoke markup format or just something i don't recognize?
Makes total sense. It also seems trivially automatable on the surface. Echoing GP: Is this an existing DBMS feature? If not, why not?
Show HN: A fast, vanilla, customisable select/text plugin for modern browsers
> Once you understand how they look up modules from which to import things you need, you are set and can deliver a working program

Sure, being restricted to a single paradigm can simplify things in this regard but it comes with its own set of problems. I've used build systems and package managers for C/C++, Nim, D, Python and a number of others and they all come with their own headaches, learning curves, bugs, and WTFs. Software is never perfect, documentation is incomplete and inaccurate and sometimes shit just doesn't work the way you need it to. You can write terrible code in any language, if you need proof just do a filtered search on GitHub for your language of choice and page through some of the projects. I don't think JS is any more at fault than the rest, it just has more people learning it and hacking things together so you see more of it. It's not the programming language's fault if you write bad code, that's always up to your own proclivities and time constraints so I don't think we should try to pin it on the existence of such and such a module or library or the design of the package manager.

The hugely positive side is that there are a large number of people in the JS ecosystem actively trying to solve these problems and also educating others on how to solve their own. It's a bigger tent than any other programming language I've used, more active, welcoming, less judgemental and more beginner friendly. For people just beginning programming I'd still recommend starting with JS for those reasons.
Same for me. I never use wi-fi for my mobile. I've got enough data on my tarrif, the speeds are pretty good and I really dont trust the wifi much.
That’s a neat idea, I’m gonna have to play around with that! Thanks for the tip.

I’d imagine the length issue would become much more of a problem sooner, and any interactivity via JS will add to the size of the link considerably. The benefit of the block mapping is you can house relatively complex components behind a simple string map without adding that bloat to the url itself.

The idea is that once you have the renderer - whether it’s the hosted site, a native app packaging similar to a “browser” of sorts - you could load and view any Memlink page entirely clientside. The current app is a static html/JS SPA sitting on a small VPS and only handles serving the initial renderer code if not cached locally already.
Fibre to the Cabinet, in the UK
CommunityFibre, the ISP that works of some of the most un-necessarily aggressive marketing I've ever seen.

Experience round some of my friends in their catchment area was their reps will attempt endless rounds of doorstop selling, on top of that they will then bombard you with marketing letters (which are carefully addressed "To the occupier" so as to avoid being caught by anti-junk legislation). I've seen the junk, and I've been round people's houses when the greasy sales reps have knocked on the door touting their wares.

If you call them or write to them to ask them to stop, they ignore it and continue.

That alone would put me off Community Fibre for life. I have a policy of not dealing with spammers.

I would also encourage people to read the small print.
If 50% of voters are ever non-homeowners, prop 13 will probably get repealed. I'm not sure if that will ever happen.
Soooo how many libraries remember to do it? And how many people remember to check the library they chose does it?
30-Second Deliveries? This Startup Wants to Build a Hyperloop for Packages
“Cross layer comprehension” - what is that? Wanna move computation to the NIC ?
how do you jump to arbitrary pages with cursor pagination?
Furniture is an especially good example where DIY is still possible to home handcraft, and desirable for individual fit, as well as many other reasons. Done that.

"appliances" too. moreso if you count frankenstein abominations that only I can run safely. there's some things I could sell to others and expect them to use without dying, so that counts.

"Laptops" meh. but I've had mobile computing things that featured structural duct tape and were indeed mobile, so I think that counts too.

"Car" ... I've assisted with the construction of go karts, dune buggies, and the repurposing of mass market cars into nasty perversions of their original functions. So I'll say "done that" too.

So yes, I think on reflection I can answer "I do."
Could you please stop posting unsubstantive and/or flamebait comments to HN? You've been doing it a lot lately, in several threads, including crossing into personal attack. We ban accounts that do that kind of thing because it's not what this site is for, and it destroys what it is for.

If you wouldn't mind reviewing https://news.ycombinator.com/newsguidelines.html and taking the intended spirit of the site more to heart, we'd be grateful.