skysight-inc/HackerNews huggingface dataset:
Ask HN: Am I abusing Postgres? If yes, then what are the alternatives?
I have this requirement for an app(mobile and web) where the users can create different collections of data attributes. The attributes can be name, email, text etc. A collection itself can be an attribute. The users can then create relations between these collections. The relations also can hold attributes such as name, description, settings etc. Setting itself can be a collection of attributes. Users can create any number of collections and link then using various relations.

+--------------+ +------------+ +--------------+
| collection_a |---->| relation_x |---->| collection_b |
+--------------+ +------------+ +--------------+
^
| +------------+ +--------------+
+------------| relation_y |<----| collection_c |
+------------+ +--------------+

There are other requirements such as, a user should receive notifications if specified data changes. So the DB should support notifications. And the other requirements are that the DB should support auditing and be open source with active community.

So I chose PostgreSQL and came up with this DB design:

collection { id, name, json_data }
relation {id, collection_from_id, collection_to_id}

Just two tables.

Is Postgres the right DB for this or are there better alternatives? I considered CouchDB, but gave up the idea as audit support is challenging.
Blogs are still an underrated goldmine of knowledge, especially in tech. I find academic papers often too abstract or opaque, textbooks are good but generalized, and documentation is reference-like. Stumbling across a tech blog where someone explains some fairly specific and difficult problem they had, and an interesting solution they found, can be exactly what you needed to solve a problem.

The web has its problems for sure, but don't forget there are still gems out there which the web has made possible. I'd love to see a comeback of blogging culture, but I guess a lot of that has been sucked in to social networks now.
Of course the US Military wants to know what you're reading:

“I believe the perception caused by civilian casualties is one of the most dangerous enemies we face.” - U.S. General Stanley A. McCrystal in his inaugural speech as ISAF Commander in June 2009.

The publics' democratic attitude about America's war machines is a threat to Americas national security, especially if that public starts to question the nature of the crimes being committed in their name, and the costs ..

The Pentagon probably wants to get out in front of any populist rise against their war crimes. Makes sense, given the magnitude of the crimes but also the magnitude of ignorance. This blowback may be the one thing that topples the security-states vast, significant fortress ..
Unlisted youtube videos from 10 years ago are all gone... Google made the decision to delete every video 'shared by URL' because of the possibility that the URL generation algorithm had leaked. It was legally less risky to delete all the content than to risk leaking all the content to the open web.

IMO, they made the wrong call - it would have been better for the internet as a whole to notify all users that "We have a new 'share by link' option, and no longer consider the old links private. Please update all old links and then click this button to disable the old URL. If you don't click the button, videos shared by URL may be discovered by others in the future."
Hahaha that's true, lots of moving text.
Using a LLM as an agent will be comical, like a supervillain trying to explain a menial chore to a dimwitted henchman: “No, you fool, that’s not what I meant when I said bring me the head of R&D!”

Then, maybe LLMs will get more intelligent and it will be less comical, and more like having an actual slave. An agent intelligent enough to do all these things is probably intelligent enough make me queasy at the thought of being its master.
Humans have trouble finding a way to live in wet-bulb temperatures above 36C. Being in the shade and properly hydrated is not enough.
> Or maybe they could devise some sort of stacking system, with each GPU board separate and stacked.

Yeah, I remember those stackable/modular computer concepts that industrial-design students loved to put in their portfolios from the late-1980s to the mid-1990s; I get the concept: component/modular PCs are kinda like the modular hi-fi systems of the 1980s, except those design students consistently failed to consider how coordinated aesthetics are the first thing to go out the window when the biz-dev people need the hardware folks to save costs or integrate with a third-party, etc.

...it feels like a rare miracle that at least we have 19-inch racks to fall-back on, but those are hardly beautiful (except the datacenter cable-porn, of course):

https://www.reddit.com/r/RetroFuturism/comments/gioqrp/sovie...

https://en.wikipedia.org/wiki/Sphinx_%28home_automation_syst...
The sgi onyx reality engine "graphics card" was composed of like 5 motherboard sized pcb's.

https://hardware.majix.org/computers/sgi.onyx/onyx.shtml
What guarantee? Are you thinking of nuclear plants?

Gas turbine power plants are cheap to build. (They have to be, because they're used as "peakers", only operating 10% - 20% of the time.) The threat to them is battery storage, not renewable generation.

Combined-cycle gas turbines (combined with steam powered generation using the turbine exhaust for heat) are slightly less cheap, but nowhere near the same league as nuclear costs.

Even so, in some places it's now (2022) cheaper to build new PV than to pay for the gas to run a fully paid-for gas plant. Or so we are told.

Long distance high voltage transmission lines sometimes need government involvement, because 1) they affect many land-owners, at least some of whom won't be happy; and 2) the margins are low in the power transmission game.

The need for long-distance transmission and gas peakers could be reduced quite a bit in a year or so, if PV, wind, and battery storage prices continue on trend (downwards). Not off-grid, but local grid.
"The future was better in the past."

Perhaps this is one of the reasons retro is seeing such a resurgence (pun intended) these days.
It would be nice if they were able to emulate some of the more security focused interviews I've had. It consists of sitting in a room, and just a discussion about random things. For example, say an operating systems final, where it consists of you sitting with a professor and just having a conversation about the class, like "Tell me what you understand about access times for devices? What about x, y and z?'. I know there's biases, but I feel like when a person can use conversational computer science about the subject, it shows they understand the concepts enough and are ready for the real world.

At my current company, the security positions are focuses like that and actually test people, the Dev interviews are two leetcode questions and a conversation to make sure you arn't a complete dunce. I havn't met a single dumb person on the other side of the fence, but I have met alot of dumb devs here.
Unfortunately when I look through my old Favourites playlist, which at some point reached the limit of 5000 videos, I can see how many of those videos are now private, deleted, or blocked in my country. The worst part is that in many cases I can't even recover the video title, so I have no idea what has been lost. A possible solution would be to store the titles separately, but I didn't think about this while I added stuff to my collection.
I do agree though that the unique, unchanging URL is a huge boon, when I look at the situation in my browser's bookmarks for comparison.
not sure where I proposed a solution but if there is one, I can tell you it will not involve crying out exploitation when someone offers an impoverished person the opportunity to pull themselves up somewhere better in life, just because you think it's unjust for that poverty they live in to exist in the first place but yet also have no working alternative.
It could really do with a simple trick from minecraft: signboards.
More bandwidth, more processing power, more browser APIs and support for shiny CSS effects:

More sites taking advantage of them at the same pace of technical development, cancelling them out.

Otherwise if we had a website from 10 years ago it is faster to load with today's connections.
It's a different era now, but back in my day Altavista had just launched Babelfish and a few of us began using it for our French homework. My friend got "caught" due to the "peculiar" nature of his work, and while they couldn't figure out what was happening, we were all warned quite sternly to stop doing whatever it was we were doing. Lesson learnt: only use Altavista to read French ;-)
Same, back to the mid 90s at least. I provided Internet services to several, actual grass roots groups: regular people who had desire to make noise about a problem they perceived. Politicians would keep saying "tell your backers we can help for only $50k" and things like that; when there were no "backers" there was just a few people spending their own money and time to try doing "activist" actions.
I saw that too, and yet he didn't give any examples of "News that's disappeared". Feels very polemic to me
Very nice!

Not exactly the same thing, since it's a high-paced action game, but I was always fond of the DOS game Skyroads, which has a similar aesthetic. (I believe someone has now made a web-based version called OpenRoads.)
To different degrees? I'm not sure about that...

The right is significantly more dangerous now, but I don't see that as a historically universal truth.
Indeed. I never got to 2x/week, but in the late 1980s I was traveling about seven days a month. I switched jobs, and for a while would see jets heading in to the local airport and think how grateful I was not be on them.
Related, and more interesting (to me): https://en.wikipedia.org/wiki/Island_syndrome
[citation needed]

I've only heard of such high protein diets in bodybuilding forums.

https://www.mayoclinichealthsystem.org/hometown-health/speak...

https://www.nutrition.org.uk/healthy-sustainable-diets/prote...
US energy price hike of 50-100% in the past week. Whatever impact solar has on energy price: it is very much not the dominant effect.
Workstation cards are traditionally supported on 3 sides so don’t suffer this sag. In such systems there’s usually an extension bracket screwed into the card to increase the length, allowing it to reach a support slot to hold it steady.
Programming languages: It's time to stop using C and C++
We shouldn't assume that pro-nuclear people are climate skeptics, anymore than we should assume that anti-nuclear people are fossil fuel advocates. German renewables politicians voted to get natural gas declared as green, and on the opposite side of the political debate we had nuclear politicians, both accusing the other side of being climate skeptics.

We should not care what tech get us to cheap, abundant, emission-free power, and the current trends from nations around the world points in multiple directions. We don't see examples of cheap small modular reactors, but we also don't have national grids that operates exclusively on solar and batteries. Solar seem to have the best cost curve, while short duration batteries looks great in replacing natural gas when those are used in short (a few hours) duration. Battery technology is also looking great to replace grid stabilizers, ie something to temporary supply or take energy when energy plants on the grid boots up or goes winds down.

Skeptics of solar and batteries is generally directed towards the idea of replacing all worlds existing fossil fueled power plants. Replacing them all with nuclear looks conceptional feasible. Getting the solar capacity up to 100% seems also feasible, but batteries is generally were people start to have doubts.
i s'pose they're using a clinical definition of 'Dehydration' but I certainly feel that coffee does dehydrate me. For a start it, goes right through me. I always need a massive wee about 10 - 15 mins after having a coffee. And, without wanting to get too graphic. the amount that comes out seems to at least equal, if not exceed, what just went in.

I've also noticed that, a lot of mornings, I still wake up with a massive thirst on me, despite the fact that I stopped drinking booze last year. The same kind of symptoms as I used to get after a night on the sauce. I put this down to the fact that coffee has the same dehydrating effects, if drunk too close to bedtime as booze does.
Are You Ready for the Internet? (1994) [video]
They both also "support" Khronos - doesn't mean anything.
Full title: Programming languages: It's time to stop using C and C++ for new projects, says Microsoft Azure CTO
Ask HN: Internship for a Java Role
I got an internship with a startup in EU Central as an international and would be working remotely, the offer is around 200 - 300 monthly, I am just getting started in the profession and I like to know if it is okay.
Have you ever used any service from AWS? Then you were using Java.
This is in sense known since Snowden times. Google CEO and others got mad their data were taken "for free" due to lack of SSL within data centers. That was quickly fixed by industry major players, DoD was visited, and all were happy thereafter. DoD can get same data as before by paying for them now.
Wikipedia is less than trash. If I put wikipedia at the road, the garbage men wouldn't touch it. The raccoons would touch it but find immediate death.
That redesign to the new shittier reddit and their push to their dumb app was the second shark ollie over there.
On average, a human is a 100W heat source. It is much easier to insulate against excess loss to a cold environment than to refrigerate it in a hot environment.
I had heard the 1 ms number also and did some research some time ago. As far as I understood the 1 ms is for specialised low latency connections and devices not for the every day browsing.

Here are two sources which I found useful at that time
https://broadbandlibrary.com/5g-low-latency-requirements/
https://www.linkedin.com/pulse/we-need-talk-low-latency-dean...
You hit the nail on the head and I should have been more clear about that, thanks.
Is that assumption viable?
I find your focus on totalitarian left peculiar. It's not like they were somehow unique - plenty of totalitarian regimes of all kinds have arrested and executed countless people for whatever.

A few random examples:

* Ottoman genocide of Armenians, on ethnic/religious grounds. The Ottoman Three Pashas regime was as far from left as possible, but plenty totalitarian.

* US internment of "foreign elements", including those with US citizenship, during both World Wars. US was never even center-left, let alone farther, and totalitarian is a stretch. Less bad than the other examples here, but still.

* The many White and Red terrors in the Interwar and post-WW2 years, where vague association was guilt and execution.

* Of course Jews, Roma, Gypsy, dissident in Nazi concentration camps.

* The Herero and Namaqua genocide by the rightist totalitarian-ish Imperial Germany.

* UK mass internment of Boers. Not leftist, not really totalitarian.

Need i go on? Why did you feel the need to pain totalitarian leftist as worse than any other totalitarians?
This is amazing. Holy moly. The first sample audio clip could easily pass for a clip from an audiobook. And without knowing about this you'd find it hard to convince me that the Joe Rogan clip isn't actually Joe
Manifest V3, webRequest, and ad blockers
Your post is great, but I'm not sure about the aluminium smelters being dynamic - IIRC once they deactivate a pot, it's done, it can't be reactivated.
How to enable Private Access Tokens in iOS 16 and stop seeing CAPTCHAs
Ask HN: Ads triggered by WhatsApp “end to end encrypted” messages?
Hi all. We've been playing a silly little game with my wife lately: we send each other messages about some topic we never talk about and then wait for ads related to our conversation to start showing up in Instagram. As of the last month, they never fail to show up.

Please keep in mind that this is a conversation between two "personal" accounts, no business accounts involved. More so, we haven't accepted the new terms of use that "allowed" WhatsApp to access messages between personal accounts and business accounts.

Is WhatsApp scanning personal messages to target their ads as we are noticing? Weren't WhatsApp messages end to end encrypted? Is this a violation of their Terms of Use or am I missing something silly?
Perhaps it should.
I'm not the right person to answer the core question here, but this looks a lot like this: https://kevin.burke.dev/kevin/reddits-database-has-two-table...
Try beat:

1. Power on BBC

2. Type *EDIT[ENTER]

Though obviously not as fully featured as a modern word processor, or even some editors of the time.
But you also need to provide a systemd service for it. And statically linked against glibc or musl?
Why do you dont like freebsd?
It's more for flexiblilty and peace of mind, with a all-you-can-ride ticket, you can book all itinerary/reserved-seat tickets(when available) right when you land, and have the flexibility to bail on any single train connection when you couldn't make it, either because of emergencies, or you just like the place you're visiting so much that you'd like to move your tour schedule around a bit.

And it's not like you have to get the pass for all region, there are dozens of types of regional jr passes depending on the region you're visiting. Those are the ones that's of better value when travelling in-region, and covers most touristy places.
Personally I'd say tokyo-wide, kaisai, and hokkaido are the ones that's pretty no-brainer when in those regions.
I never argued that some researcher hasnt tried it out. I argued that electric ships and semis are not good solutions. Certainly not with the current grid.

The reason is straightforward, the grid has a certain thermal efficiency, one that ships basically match and semis approach.
"The mouse is a much faster input device than the keyboard: the latter is almost always stationary."

What ?
> recurring dream I have is that I am in the exam room ready to take a test, but did not study or I have mixed up the dates and came prepared for the wrong subject.

I get these exact nightmares. I wonder how common is this.
Halfway between Micronaut and Envoy
what is support like in the rural parts of Iran? from what I understand about modern history, we (USA / west) installed the Shah who was a serious piece of shit. they correctly overthrew him, but in the aftermath all that united a largely illiterate populace was islam and hence the militant theocracy that exists now?

let’s say the unrest progresses to a point where the gov is threatened, will the rural parts of iran support this action or come to aid the government again?
Not really going to help the unemployed or people on a low income though, is it?

ASIDE: yet another example of the spread of shoddy journalism there. The article says:

>He also said he would cut the basic rate of income tax to 19 pence in April 2023, one year earlier than expected...

without actually telling us what the current rate is. I see this all the time these days; an article will say something is changing to X, without telling you what it was beforehand.

"From now on I'm going to have 3 slices of toast for breakfast" is pretty meaningless if you don't know whether I currently have one or six!
This reminds me of back at university we had to use a platform called "Wiley Plus" for weekly physics homework.

To prevent copying, while the equations needed remained the same, the numbers (inputs to what you had to work out) varied across user sessions.

One lad in the course wrote a website that he updated weekly that mimicked the UI/UX, you would plug in the values WP gave you and it would emit an answer.

The following year I took over maintaining it, and ended up in a spot of bother with the administration.

There was also another homework website that some lectures made us use, which did all the shit client side in JS. You could just inspect element and get the answer.

I honestly still don't get the point of those additional homeworks, on top of assignment and lab report workloads at university. They seemed to only exist to loosely tick a box regarding "continuous assessment".

Relatedly, they also implemented 5% credit for attendance by proxy by making us rent these radio " clickers" from the university, each with a unique ID tied to a student.

During lectures, there would be multiple choice questions asked, where the answer was irrelevant - it was a means of counting attendance.

Naturally by the second month people were delegating their clicker to someone else if they needed to skip a class.

A couple of years later, smartphone apps replaced the clickers, and SDR became affordable, granting the university a near-miss from any radio shenanigans.
Working with strings in Rust (2020)
This happened a while ago. Before renewables actually.

Peaker plants only run some of the time. They charge more for their power because they need to cover their fixed costs.

That's partly why people use gas plants, theyre relatively cheap to build, which matters when you are effectively acting as a backup.

We could in theory let these businesses gamble on how often they will be needed but grids/governments already found it better to pay capacity fees to these generators to ensure they are available if needed.

Notably, that money goes to the people who build the plant, not the fossil fuel suppliers, unless the capacity is actually needed.

But even those people are having their business model challenged because batteries that are installed to shift daily solar peaks can bid for the same peaks.

And as the gas gets burnt less, the price goes up, in a vicious circle that leads to more and more battery deployment.
9p? Namespaces..
Exactly what we need. I’ve always wanted an api gateway that put traditional values first. /s
Knowledge does not imply intelligence. Nor is the opposite true.
You are changing the goalpost making a hyperbolic statement seem reasonable. Read what they said, its borderline hysteric.

You are agreeing with it not on the merits but on the premises.
There's plenty of videos on youtube that have been removed. Every few years when I look through my list of liked videos, a couple more are gone forever. Granted, this is likely by the creator themselves, but that doesn't matter when the purpose is archival.
Disco Elysium itself suffers from those problems. Spoilers ahead:

From the very first couple hours in the game you know the most important thing you should do is visit that 'island' - but the game does not give you any option to do so. You have to go through a very tedious grind to unlock the option, even though there is no real reason you shouldn't be able to. The game just doesn't allow you to do so.

Personally, after I managed to get there, I realised the rest of the game was pointless.
Okay dang, sorry. I must admit it's quite painful, as respecting these guidelines amounts to letting those who do not respect them have the last word, at least during the time when the story's got the more attention (because in the end we can hope their post will get flagged enough and be dead), but I also understand your point as a moderator here. I'll try my best not to get sucked into this sort of "conversation" again.
I interpret "hacked" as "compromised". Suspicious activity and vulnerability reports don't meet that criteria. In that case, only 2015 and 2022 would qualify.

The activity in 2011 was never confirmed to be a breach. It was a overcautious response on LastPass's part after seeing an outlier in the logs. The investigating party gave a report saying they couldn't find anything, and the CEO later gave a statement saying they overreacted to an outliter out of an abundance of caution.