skysight-inc/HackerNews huggingface dataset:
There are vector search solutions for sqlite that basically work, so if my project doesn't rely on that 100% then I'm willing to use those as stop-gaps until it does.

Of course, if there's a shortcoming of sqlite that I know I need right out of the gate, that would be a situation where I start with postgres.
Rich Programmer Food (About Compiler Construction)
> Not that major database versions are any simpler even if you just stick to CRUD for databases.

I mean, even LTS versions have EOL dates, so even at the least frequent, you'll need to do upgrades around every 5 years or so.
How to Manage Postgres Users and Roles
why is south korea another shade of green when the question is north korea?
This depends on what you want to do in your career. If you want to pursue a career in working in startups and early-stage tech companies, then working for a YC is better for you. A senior developer in TX is making way more than 50k. And working for an oil company in TX is good enough for your resume to get a serious look at 99% of the other traditional corporations.

Texas isn't some backwater. It's the second largest state with a long history in deep tech.
If you worked at EP then you should also know that they [I've heard] are very litigious. If I were the anonymous writer or op I wouldn't site any sources.

Most likely it was a quant in a pod. OMS could be loosely defined here as well or obscured to not dox themself too much. However EVE trade sounds very specific, I don't know what this means, EVE online trading?
Four-Bar Linkage
That's not how exactly once is defined for queue. We are talking about semantics of what queue systems is providing.
Yeah big influence... I may need to change my idea further before writing anything otherwise it's too close to plagiarism. Black Mirror got away with it tho with the Cookie episode...
Quarto - https://quarto.org

I've been searching for some time also, more or less the same requirements, and I settled on quarto. Give it a try, you won't be disappointed!
Due to network limitations and contract budgeting, I never got the chance to upgrade them to 10 Gb, but can confirm I could hit 1000 Mbps (100+ MB/s) on certain files on RAID-6. It sadly averaged out to about 55-60 MB/s writes (HDD array, Buffalo), which again, for this use case was acceptable, but below expectations. I didn't buy the unit, I didn't design the architecture it was going into, merely a cog in the support machinery.
It would cause a lot of localized damage but certainly not global.
Personal responsibility for individual choices isn't fashionable.

It's not avoidable; either: you will pay for your choices.

our society likes to use the promise avoiding consequences as bait for various systems of morality and demonstrations of tribal allegiance through behavior modification.
I used eleventy recently to build my website. What I liked:

- npm / js-based tooling, no fooling around with ruby
- plenty of great docs
- enough public adoption to find good answers to common things you’d like set up

Not sure why I hadn’t tried it before - I know it’s been around for a while.
agree. ethbr1 is 100% right about this being a problem; if politics is driving your criticality rating, it's probably being done wrong. it should be as simple as your statement, being mindful of some of those downstream systems that aren't always obviously critical (until they are unavailable for $time)

edit: whoops, maybe I read the meaning backward, but both issues exist!
If your instinct is to come into this of all threads with the attitude of, "but my special interest really is about protecting THE CHILDREN, look how many scary words I can use to frame it!" then you've missed the point of it.
It says, its says.... "Drink Ovalteenus"

In all seriousness though, I find this such an amazing project to follow regardless of the outcome(s)
There was a decent Netflix special on this - 13th amendment (I believe that was the name). Basically slavery never actually ended, it’s just hidden in the prison system now. Society is ok with it because we’ve somehow gotten this distorted view that prison is about punishment and not rehabilitation.

Then wonder why we have such a high rate of recidivism.
I think the book is better, it stresses the gap between innovation (particularly driven by startup capitalism) and government regulation. Per the book, when scientists are driven by a profit motive they have an incentive to be secretive to keep their competitors in the dark, and naturally, also keep government regulators in the dark. This mirrors a common observation on HN, that American tech startups profit by finding ways around traditional regulation (Amazon getting around local sales tax, Uber getting around taxi medallion systems, electric scooter rental deploying into cities faster than their sidewalk clutter can be regulated, etc.)
Others have mentioned static site generators. I like Hakyll [1] because it can tightly integrate with Pandoc [2] and allows you to develop custom solutions (such as `.pdf` downloads) if your needs ever grow.

[1]: https://jaspervdj.be/hakyll/

[2]: https://pandoc.org/
The canon energy levels given for Star Wars weaponry are so inconsistent with the presentation that one either ignores canon or accepts that the Star Wars galaxy has fundamentally different physics.

Extreme geek caution: I've been running a Star Wars pen and paper RPG since . . oh dear. . 2015, in an ancient simulationist[1] game system, and the only way I've been able to make anything consistent is dialing everything down to WW2 levels. 7.62x5X, .50 BMG, 46 cm/45 Type 94 capital ship weapons. All except for exceptional plot items, like lightsabers and doomsday weapons, which behave . . well, they're magic. Sensors are likewise pretty primitive, enhanced with canon exotics like Kronau radiation, so engagement ranges are (relatively) piddling, hostiles zip by each other all the time. Electronics and technology in general must be barely understood by literally anyone, with the powerful assemblies - hyperdrive cores, droid motivators, repulsorlift "sand" - being exotics, possibly xenotechnology from the deep past mined by xenoarchaeologists[2], but hooked together by varying degrees of "competent 1950s electrician".

In short, it's a fantasy setting with guns that players get excited about. And a community of worldbuilders that is, let's not dice words here, insane. That second point is huge if you're not 24 or otherwise gifted with a combination of hubris and spare time.

[1] All the kids today with their streamlined narrative-focused games! Seriously, though, I get it. The physics simulationist in me that brings me to HERO System says more about me as a person than my players.

[2] Archaeology a much more valuable degree in the Star Wars universe.
be careful going down the rabbit hole. rare books are very slow to move (aka inventory risk). you'll be stuck trying to sell the same books for years, sometimes decades. if you have something valuable and don't sell it, then your estate will only be able to sell it for a fraction of the market price. i would only recommend it if you are enthusiastic about books.
How can you know that you'll have the same e-mail address in 20 years?
We get to wear lineman's suits and take other precautions, or are we required to embrace st00pid in order to provide the proper example for Narrative purposes?
https://en.wikipedia.org/wiki/Light_cone

Basically reverse time.
Was also confused by this. I think "eve" is correct here but don't know what it means.
> In 20 years they would be money ahead by tearing down most buildings on campus and rebuilding to modern standards - assuming energy costs don't go up which seems unlikely) But they consider all those old buildings historic and so won't.

It has nothing to do with considering those building historic.

The problem is unless someone wants to donate a $50-100M, new buildings don't happen. And big donors want to donate to massive causes "Build a new building to cure cancer!" not "This building is kind of crappy, let's replace it with a better one".

It doesn't matter that over 50 years something could be cheaper if there's no money to fix it now.
I always kind of scratch my head at this kind of language extension. In my world there are legacy projects and new projects. Why would I want introduce this into a legacy codebase? If it’s a new project where async language features are important, why wouldn’t I use a language better suited for that?
Best thing is that it works in real time. No need to futz with fancy formulas. Just wait long enough and bam you're in the future.
Kind of reinforces the idea AI is going to lead to mediocrity in a lot of industries. I feel like our food, like the stuff at the grocery store is a great example. Our bread is made on a production line. It's good but not great. I feel like the real bummer is the option to get great bread tends to disappear overtime as everyone moves to the 80% solution and the training and economics needed for the artisan solution disappear.
There is a lot here that I find useful. Mastering multiple technologies: html, node, JavaScript, SQL, CSS - grids and flex, blah, blah, blah is simply impossible. Developing a working set of knowledge is not. The problem is that you don't know what you should know.

A working set raises another set of issues: how do the pieces relate? What is the proper role of each technology?

This gist is extremely useful to me both in helping me to understand more of what I need to know. The article https://sive.rs/pg was very helpful as one way to think about how postgresql could and should fit in.
Yo!

Opalstacker here as well, is it 16 years now? Wow, time flies!

Sending my greetings to Sean, best support I've ever had :D.
Meanwhile quite a few of us wound up in the US because back on the old continent they were trying to kill our people and erase our memory.
Sure, but Kuru doesn't transmit anywhere near as easily as scrapie does in sheep, which seemed to be the relevant comparison.
> We would love to have your thoughts on the compiler!

First thought. Where is the language definition for users?
Not open source and lacks a ton of features like editing sound waves
There are social benefits as well. Not only did you get to dodge some tax, you got to make a donation to a museum, they'll throw you a little party, you get to meet the mayor, etc etc
Poker to be an Olympic sport? Match-Poker takes the gambling out of Hold 'Em
Except it's not really known for all non-open-source licenses are allowed to be modified. I can similarly jailbreak a phone but it's not open source.
Doesn't Telegram use a web view via QtWebkit?
Googling 'patel scam' leads to https://www.reddit.com/r/TalesFromTheFrontDesk/comments/ot7r...

Not quite identical but close.
Cool and simple. Animal Crossing also has the ability to send letters to your fellow villagers (who might also be real people), including yourself. And as far as I can remember, you can specify an arbitrary date in the future.
Second this. The focus on security from GrapheneOS is a breath of fresh air compared to the (historically) questionable conventions in most of the third-party Android distribution ecosystem.

As an example, Graphene even recommends not using Firefox [0]. I actually still do, but I understand their rationale and it's very well presented. The way they explain such things in clear English is very helpful and hopefully indicative of a similar amount of consideration being made elsewhere in the project.

[0] https://grapheneos.org/usage#web-browsing
I'm not sure how this even needs to be said, but someone convicted of felonies is always subject to having their rights forfeited for the duration of their sentence. And I'm ok with that. You can't even put them in prison, were this not true.

Those who whine about how putting them to work amounts to slavery seem to do so out of pure reflex, and it's just tiresome. You're ok with locking them in a dungeon, but god forbid that they be put to work. You realize that most actually earn wages, and that none of them are doing it for free, right? There's just no point, the assholes usually sabotage products if forced.
> I would also make a point (vapid as it may be) that autism is a spectrum

I don't think that's a vapid point at all. It is however a widely misunderstood statement. Autism being a spectrum does not mean "you can have it a little, or a lot, or in-between". It means you can have any one of the symptoms a little or a lot or in between, individually.

Among other things this means being good socially does not trivially preclude autism.
Canon to ship this year new chipmaking technique 90% more efficient than EUV
well that's a stretch it has "5 minute window"
You can hold a lock on a row in PG queue for as long as you need
Meta Figures Out How to Sell the Metaverse
It's not a great DX for sure. Once you start stuffing a ton of application logic in Postgres triggers (or worse split logic between your application layer and triggers) your system will explode in complexity really fast. Developers will insert a row in an inconspicuous table and things will break in ways that seem mysterious because it's not obvious, looking at the application code, why the system is misbehaving.

There are commands in most postgres clients, even psql, to view the _currently_ defined functions... but when you go to debug those you will have to look through migrations to see how the function came into it's current state... bisecting through history here is not very useful since each change to the function is a new file. I think this can be fixed though and made much easier, it's just not there yet.

In general I don't think the developer tooling is up to par to push very much of your application logic into postgres itself. I recommend using triggers for consistency and validation or table-local updates (ie: timestamps, audit logs) but keep process-oriented behaviour (iow: when this happens, then that, else this, wait for call and insert here, etc) in the application layer (chasing a cascade of triggers is not fun and quite annoying).

... all that being said, you can do unit testing in Postgres. And there is decent support for languages other than pgSQL (ie: javascript, ocaml, haskell, python, etc). It's possible to build dev tooling that would be suitable to make Postgres itself an application development platform. I'm not aware of anyone who has done it yet.
I don't know man... implying people are publishing nonsense is what smacks the most here. If you think they are over fitting, show it, don't just air doubts idly.
whew lucky
>I heard that falls are lethal for the elderly.

falls are lethal in general. I personally know of a man who broke his back and neck (two separate occasions) with shower falls, the last fall leaving him quadriplegic, and a distant relative died from the same thing.

I don't care enough to go reference hunting but I remember at one point reading that taking a shower is one of the most dangerous singular and common things that anyone does on a daily basis.
US Army Mulls Adopting 'Telemaintenance' Method from Ukraine
Prior to NetBox I spent quite a bit time with RackTables. It was mostly manual documentation but really tickled my OCD itch (lovingly referred to as CrackTables), and it was really simple to use. https://www.racktables.org/
Yeah this makes zero sense. Unless this is not about saving taxes, but money laundering.
New kinds of padding could make football gear, bike helmets safer than
Correct.

It is probably a feature which isn’t necessary for the languages itself but Linux/POSIX.
Css modules would be great, except there’s bad tooling in VSCode. Autocomplete through Typescript is the killer feature of Panda / Vanilla extract, not that you can style.
Any comparison to PhpIPAM? That’s the only other open source IPAM I’ve used. Does this support scanning the networks as well?
Six Big Ways Climate Change Could Impact the United States by 2100
There is so much we don't know. But I would happily engage in speculation:

- Without needing to make it to the closest star, we have big problems here. If we solve those problems before we leave our solar system, we may be changed beyond recognition. We may not be biological any longer, for example, or at least not forcibly so, and traveling as solid matter may seem silly to our future descendants.

- We don't understand well enough the nature of reality. For all we know, our machines and organisms made of atoms and molecules may be, by far, more inefficient and wasteful than an equivalent process at some other layer or scale. Like somebody who discovers themselves living inside a match box in a forgotten attic, we may decide to move to the more spacious main floor of the castle.

- A variation of the above: maybe space-time itself is something we use inefficiently. It could be that a way to stop being troubled by the slow speed of light is by lowering our own "life" speed, increasing our volume to span entire solar systems, and decrease our density so much that your ancestors would confuse us with sparse interstellar matter. Or, at the opposite end, it could be that we find a way to move our entire future civilization to a cubic centimeter of space and a few microseconds that feel like eons.
Giant successor to Hadron Collider could uncover secrets of 95% of the universe
>....backend web dev was fully in scripting language, Python or Ruby...

Not on my bubble, it has been fully in .NET and Java since 2001, with exception of a couple of services written in C++.
As a Londoner this was the aspect of the piece I found most hideous. The whole city runs on a quiet attitude of 'money above all' that makes living here as someone on the outside of this world frustrating
My god, the vibes here are even worse. And when I say "vibes", I mean "sex appeal".
Agreed. In the very first example (fig 1), a G-B chord going to A-C has the network showing edges from G to A and C (B to A and C), whereas in music we look at G going to A and B going to C (just two moves). I.e., it makes more sense to consider this as just two edges, not four.
...in fact, one could argue that not only did it not read the rules — it has no conception of rules whatsoever.
Honored to be there!
It doesn't, but its significantly more actively developed than PhpIPAM. There are also scanning plugins you can add.
I don't get it. If the collect call from A to B is accepted, B pays the cost of the call. In your scenario B instead calls A directly... and B still pays the cost. Where's the savings here?

(And there's a pretty clear downside to this. What if it's an actual emergency from a different phone than the standard. E.g. the only time I can remember answering a collect call, it was my sister calling from a foreign hospital after a serious accident. Trying to call back at a different number wouldn't have been great. I guess you could have a protocol involving multiple collect calls, and hope that there's no record that the first one was rejected.)
> And if you look at the top spots and you're like "that guy really isn't our best employee" then you're going to be the first to go.

The solution, then, seems to be: Be one of the best employees, particularly if you're getting paid more than most of them.
Always good to see classic concurrency theory/process algebras on HN. But I do wonder why this paper specifically and not other, much more mature works (even by Milner himself!)
A response: https://codefaster.substack.com/p/postgres-is-enough-but-is-...
Implicit racial biases are lower in more populous more diverse US cities
Only that you are not accomplishing the same thing. You are accomplishing something inferior. And please don't make me explain to you how you don't get, by far, the same level of service, the same amount of destinations, 24/7 availability, etc with public transportation than with your car.
For people in Louisville, KY it wasn't their best ISP experience.
Does a Global Temperature Exist? [pdf]
I found the person who wrote the article on LinkedIn
Oibbb
I've hosted jekyll sites for a number of years. It's simple and gets the job done. The documentation is good, there are a lot of plugins written for it, and it's pretty configurable.
Nobody will understand it like that.
Visualising Extendible Hash Tables
I built a RAG implementation for 35k books/articles/wiki pages/web pages i collected over the years(it took about 6 weeks on 3070ti 100% constant usage). I query it with various steps of data extraction/narrative building/refining etc, over LLMs. Almost daily i figure out new steps to add to the pipeline and honestly, i could not imagine learning about niche topic x from so many perspectives/periods in such a short time(including the original source). I did not yet figure out how to package this, but i spend at least 2h of my free time daily with it. Ideas and feedback is welcome.
I wrote a little bit about extendible hash tables and put some effort into creating visualisations around them. Mostly because this is something I struggle with when learning about a new topic - how to "see" what's happening
> We just don't like crap on our face.

This slightly reminds me of when my grandfather told me not to get into computers because no one wants to stare at a screen all day.

Maybe the next generation will have less resistance to the idea?
I think there are several reasons for that. John Nash was right, and MAD has been a factor in global issues since then.

But some other factors could also have some influence:

The aftermath of WWII did show the world that for a nation, engaging in an all out war was no longer profitable. Wars have been profitable for most of human history, but now, with such reliance on technology and logistics, which are so much easier to destroy than to rebuilt, wars are a serious economic risk, with total economic destruction a very possible result.

Also, for many leaders in prosper nations, declaring a war would be a cause of political death, as the majority of the population would be against it, and continuing with the conflict would require a dictatorship or other forms of destruction of democracy.

I think the economic argument is very strong, probably stronger than MAD, and the democracy argument can have a small positive or negative influence, depending on the society.
There are Ansible and Terraform modules, the source of truth should be kept up to date by your automation.

There are also reports you can write to catch any data issues.
It's no surprise that Apple will use every dirty trick they can find to keep their advantage. Hopefully, the EU takes a short look at Apples proposal, laughs and tells them that if they want to sell their products in the EU they will have to provide choice for everyone.
> It's OK to make a choice in the beginning based on the current context and environment, and then change when it no longer makes sense.

Yep. And Postgres is a really good choice to start with. Plenty of people won't outgrow it. Those who do find it's not meeting some need will, by the time they need to replace it, have a really good understanding of what that replacement looks like in detail, rather than just some hand-wavy "web scale".
Aiui, you don't actually need a magnetosphere to get many of the beneficial effects on atmospheric retention, you just need the bit that's directly between you and the sun. Apparently that's a lot easier.
The average prison wage is less than $1 per hour.

Some pre civil war era slaves were also paid.

Getting paid is not a differentiator in the definition of a slave.
Finding New Mountains to Climb
*Grief is nature's most powerful aphrodisiac" -- Chazz (Wedding
Crashers, 2005).
Worth noting that Postgres has a pubsub implementation built in: listen/notify.

https://www.postgresql.org/docs/current/sql-notify.html
Is it self-sustaining?

mastodon.social is funded on Patreon where it makes 22,750 €/month. That's what, about 9 cents per active user on mastodon.social? And the Patreon isn't only for mastodon.social, but also for iOS/Android apps, mastodon.online (18K active users), and the Mastodon project itself.
Toronto's climate and winters is dramatically changing, the universal AC solution is almost mandatory due to the climate not being as cold in this area as it once was.