skysight-inc/HackerNews huggingface dataset:
I'm a pretty average SQL user, but I've heard expert consultants say before that they could do many more things with SQL databases that developers like me would have maybe grabbed a different tool for, like a graph database. So this then makes me wonder, once there's even broader adoption through PGQ, is that going to be a killer for niche databases like Neo4j, in favor of, say, Postgres?
I think your lumping developers all in the same category, but either way there's not much value in a subscription for a developer.

If your a developer business owner(not hourly freelancer) than absolutely makes financial sense.

If your an hourly freelancer your customers probably aren't going to offer you more money for your time.

If you work for someone else they should pay for it.

If you are fixed bid or some variation on that then probably makes sense because your time is money.
Remember, you don't know what they're going through. Try calling at a time of day that makes sense. It's direct and synchronous. Ask them how they are and what's new in their life. Try and find time to meetup.

Life gets really busy for people and they might see the commitment it takes as something they just don't have time for right now. Or maybe you've grown apart.

You can always ask them if everything is alright between you both.
> In Germany it is. Nobody else but government offices (federal, state, county, municipal) is allowed to use them.

That still does not make it "government information". It's a primary key that (currently) may not be used by the industry. But by itself, it does not identify anything or anyone. In that sense, it's even less sensitive than a name; realistically though, if it's widely stored next to the associated name anyway, it's effectively the same as a name in terms of sensitivity.

A credit score is effectively a database shared across the financial industry. As such, it needs some sort of primary key. That can be either be something globally unique, like an SSN or equivalent, or a wonky composite primary key (first_name, last_name, date_of_birth, last_known_address) which will cause lots of false positives and false negatives:

What if you change your name? What if you move? What if there's somebody with the same name born on the same day in the same city? What if the spelling of your city has changed between your birth and your time of requesting a loan/credit card?

You may object to the idea of credit scoring in general, but being ok with credit scoring, yet objecting to the usage of a sane primary key to do it, makes no sense to me.
That particular one is already available in PostgreSQL 15.

https://modern-sql.com/caniuse/unique-nulls-not-distinct
There are some pointers on that if you skim the tutorial.
very cool product :)
It actually (somewhat) fits the theme too, if you look at it sideways and squint your eyes. You could make something up, say for an ethics class, titled...

The Motel Dilemma:

You arrive at a motel that provides various toiletries and other sundry items in quantities sufficient for most people each night. Each room sleeps up to 4 people, but the motel knows that many times there will be only one or two guests in the room and want to keep costs down and so they place a limited amount in each room but make more available to guests, nominally, for free. As it happens, you're the only one in the room and do not need more. But this motel has very high quality items, you like them a lot. Is it okay to take extra to use beyond your stay at the motel?
I think there's significant fear that the first time experience can be a little jarring and will just scare people away. That said, given the right support from a retailer, this could be a huge boon.
I'm more of a dog person, but this is fantastic.
What framework or approach did it recommend you use for the Android UI? Compose? XML layouts? From code?

I tried using the Bing chat interface, and it repeatedly pushed me in the direction of using Microsoft tools to accomplish tasks for a cross-compile mid tier solution. I had to explicitly tell it to exclude them.
Timezonetz is explicitly designed for simplified arithmetic. By storing local values that have been converted to the utc constant, you get around the problem entirely. I think there must be some fundamental misunderstanding in these threads that information is somehow being lost by storing in utc when that isn’t at all true.
Will Google’s AI Plans Destroy the Media?
Better clue: if you're friendly with them and they've talked about doing psychedelics.
Like to see HN but for specific specialties. Still, you might want to learn from HN's design and keep the front page nice and compact with smaller fonts and minimal whitespace. Even on a mobile device I can view 12 headlines at first glance on HN. On this site, the header is enormous and I can only see 3 headlines on first paint. Drop the "Today's Headlines" altogether and minimize the size of the navbar.
Title may be a bit confusing since skimming the project's homepage reveals that it's not a compiler, just frontend for other C++ compilers.
I am bipolar and can not tolerate these substances. It is very bad for me.

I’m happy to let people enjoy them but it is not something I can do. It does bother me when people say that they’re all harmless with no problems though. As with all things there are adverse reactions and it’s irresponsible to claim otherwise. I don’t advocate prohibition to be clear, just actual truth and honesty.
First of all that only works with vectors, but I want operator overloading to also work on things like matrices or custom types (for example quaterions, or a symmat3 struct that represents a symmetric 3x3 matrix using only 6 floats).

Additionally, for efficient math code you often want vector / matrix types in AOSOA fasion: for example Vec3<Float8> to store an AVX lane for each X/Y/Z component. I want vector/matrix operations to work on SIMD lanes, not just for scalar types, and Zig currently can't support math operators on these kinds of types.
Papercup | Engineering Manager | London,UK ONSITE / HYBRID (flexible WFH) | https://www.papercup.com/

Papercup is on a mission to make the world's videos watchable in any language. Backed by leading venture capital funds and media companies, we are a machine learning startup that utilizes cutting-edge AI to automatically translate and voiceover videos in multiple languages. Our technology helps enterprises, brands, creators, and media companies reach a global audience with their existing content.

We are currently seeking an experienced Engineering Manager to join our growing team. If you're passionate about technology, artificial intelligence, and leading cross-functional teams, this is an exciting opportunity to make a significant impact.

Full details https://papercup.jobs.personio.de/job/1123235?display=en

Salary: £100,000 - £110,000 depending on experience.

Our Tech Stack:

Infrastructure: AWS (VPC, EKS, RDS, Lambda, S3), Dagster, , Sentry, Vercel, Auth0, RedisLabs, CircleCI, helm, Docker, Airbyte
Languages: Go, TypeScript and Python
Database: Postgres, MySQL, BigQuery
Tools: Notion, Shortcuts, Metabase, Grafana

Apply via the link or reach out to me via doniyor at + company domain with title HN: Engineering Manager
> Linked Cursors for JSX Tags

I am so excited to see a release with so many quality-of-life features like this one ("Avoiding Unnecessary Type Instantiation" is also super great).

Toss in negated types (and pipelines, when they come in ES) and I'm set for life.

4.1 was one of the best TypeScript releases in recent years, cheers to 5.1 (reminder: TypeScript doesn't do semver)! The TypeScript team is a force of nature.
for those wondering why 3-0, it's based on tournament points scoring. you get 3 points for a win, 1 point for a draw, a point for each goal (maximum of 3 points for goals) per game, and an additional point for the shutout. so, each game in tournament scoring is worth 7 points. after all of those points are added, goal differentials can come into consideration for tie breakers.
The games are nice but noone mentions the fitness apps. I use my quest 2 for cardio/workout and some of those apps get my heart rate up faster than running or other forms of exercise.
No it's not. It's more profitable and better than ever, and also largely unchanged, but rather better optimized. Video, banner, and click-ads are not going anywhere. look how well Meta stock has done. we're seeing record-high CPMs and CPCs. Advertisers paying huge $ for clicks and impressions to target high-SES demographic, such as retirees and high net worth people. Such as super-expensive insurance, wealth management, and healthcare ads. Same for b2b spending, like ads for cloud hosting, WordPress hosting, and so on. And also, ad revenue adjusts well to inflation too. Google, Meta are using AI and other tools to optimize ad delivery and extract maximum $.
Publicly Available PCAP Files
Whatever happened to just having the standard "abuse@domain.name" email address?
That's exactly what I mean with superficially similar. Sure, you can transform a non-3AC SSA IR into three address code or transform a 3AC IR into SSA form - as you have done in your example. However, you will need an SSA transformation/construction algorithm to do the latter, which is not that simple or straightforward, especially if you want to be somewhat optimal with placing the PHIs. You can also try to apply your existing analyses and program optimizations on the 3AC SSA - chances are high though that you'll have to adapt them to correctly handle PHIs however. If you simply treat them as a unanalyzed function calls you will likely suffer from a huge loss in analysis precision and optimization opportunities.

On the other hand, if you write your analyses and transformations with SSA form as a precondition, you can reduce complexity because SSA form is referentially transparent, giving you a lot of things like use-def chains, dead code analysis, etc for more or less free.

This is what people mean when they say that SSA is essential for modern compiler construction. That quote from the book is reductionist to the maximum possible extent and put's it in the direct comparison with 3AC, to which it only has the relation that both are transformations of IR instructions the result of both have nothing in common.

The example is misleading because it displays the SSA IR also in 3AC - which is unnecessary - and it completely omits PHIs without which SSA properties simply do not hold and for which no 3AC correlation exists at all - they are not representable. In fact, control flow can easily be built such that a PHI has any amount of operands - e.g. a switch which might need significant additional code transformation to be representable as 3AC.
Location: near San Jose CA
Remote: Yes, open to Hybrid
Willing to relocate: No
Technologies: Computer Networking, Go, Linux, API Development, Docker
Résumé/CV: drive.google.com/file/d/1DtVDNpAPdTrz3jht7yI8mmNtzEO_30ff/view?usp=sharing
Email: liujiaxin2034@gmail.com
GCM (which I guess inspired this) is already available via Homebrew https://github.com/git-ecosystem/git-credential-manager/blob...
I think as long as you can’t gain extra time by playing deliberately badly, this is largely okay? it’s good to want to teams to go out and try to hammer each other rather than narrowly shithouse a 1-0, as has been very common in recent major tournaments. even so, a lot of big tournaments have switched to head-to-head tiebreakers recently
Well, what you describe does actually have clear winners and losers -- just not between the US vs GB. The settlers are the winners, and the natives are the losers.

I love mandatory glorification of this on my license plate. Advertising for a casino is just icing on the cake.
SEEKING FREELANCER

ROAS Expert (roasexpert.com) | 100% Remote | Flexible Part-time | Interns or Contractors

ROAS Expert is a startup-friendly growth marketing agency for fast-scaling DTC & SaaS brands.

We're looking to hire for International Business Development position. https://wellfound.com/company/roas-expert/jobs

Contact: careers@roasexpert.com or https://roasexpert.com/contact

Find out more: https://roasexpert.com/about
I took a comparative programming languages class in 1993 and the prof said that he thought Prolog was the future.

It had numerous setbacks. The Japanese thought they could parallelize Prolog programs for their Fifth Generation Computing Project in the 1980s but found out quickly that you couldn't. They made a language called KL1 which was parallelizable, but it wasn't as good as Prolog in other respects.

The ability to implement simple parsers in the Prolog using its evaluation process impressed me a lot when I didn't know much about parsers, now that I know how to implement parsers it doesn't impress me much.

You can write mixed logical/imperative problems in Prolog but boy is it awkward.

When I got interested in RDF circa 2010 I was interested in Datalog (a pure logical language) but found nobody else seemed interested in it and it was hard to find literature on it. That situation has changed a lot as Datalog is a pretty clear way to make database query code composable.

Production rules engines (say Drools) are another "old A.I." technology that is largely forgotten even though they are heavily used in banks and a few other corners of the business world. These implement “forward chaining” inference distinct from the “backward chaining” inference implemented in Prolog. Between RETE engines and effective indexing structures it is easy to handle 1000x's more rules in your knowledge base in the 1980s but production rules never got standardized like C, FORTRAN or COBOL and no really general answers have come up for questions like controlling the order of execution when that matters.
What's insane is the comeback. I remember them being the most hated people on the planet in the months following launch. I at least don't normally associate people that have a sloppy launch with people who are in it for the long haul. Respect.
As a non-technical product manager, this tool could be valuable to me if it works as well as the website illustrates.

I agree with the concern expressed in other comments re: price, especially considering the lack of a free tier or trial.

The marketing site is great. Congrats on your launch!
Hold a moment.
A politician called out publicly the following phrase: “Gas chamber for President Duda and Premier Kaczynski.”
This, by any measure, is considered Hate Speech as it calls for extreme violence, ask any Jew or Pole who stayed or visited Auschwitz.

I think the fact that there had been no outrage reaction to his public demonstration of extreme violence and a call for his resignation means that people no longer remember what a great technological bathroom invention the German people developed in the early 1940s called “The Shower Chamber” which was provided free of charge to travellers exiting the trains upon arrival at Auschwitz.

Therefore, it is my opinion that this spot is a great way to reboot and restart the holocaust education of young and old people everywhere to ensure no person utters such Hateful words to another human being on earth.
Also, this is a good indicator of Apple's VR horsepower. NMS VR would chug on the Quest snapdragon.
> I'd like you to show me someone who is obese because they ate too much fatty meat and had nearly zero sugar/carbs.

that's my personal experience, I already cut sugar/raw carbs, but still need to watch on fatty meat to maintain neutral caloric intake.
In the mid-90s I requested a copy of all the books in the Rainbow Series. It took a while, and I forgot about it. One day my roommate says "You have a package from Satan". I saw the return address was Ft Meade, and assumed he meant because of that. But no, it was because the postage was $6.66. What are the chances.
https://animalfacs.com/catfacs_new (cats)

https://animalfacs.com/dogfacs_new (dogs)

https://animalfacs.com/equifacs_new (horses)

https://animalfacs.com/chimpfacs_new (chimpanzees)

https://animalfacs.com/maqfacs_new (rhesus macaques)

https://animalfacs.com/gibbonfacs_new (hylobatids / lar gibbons)

https://animalfacs.com/orangfacs_new (orangutans)

https://animalfacs.com/callifacs (marmosets)

I'm looking forward to more funny looking facs:

probofacs (proboscis monkey)

axolotlfacs (mexican walking fish)

alpacafacs (alpaca)

starfacs (star-nosed mole)

batfacs (bat)

blobfacs (blobfish)

frillfacs (frilled lizard)
Show HN: I've Launched ProductPic on Product Hunt
Hey friends!
Super excited to announce that I've just launched ProductPic on ProductHunt today
ProductPic is a virtual camera helping eCommerce merchants sell more with unique product pictures !
Please support ProductPic at https://www.producthunt.com/posts/productpic
Thanks a lot for your support
In the NHL, you get 2 points for winning, 0 points for losing in regulation, and 1 point for losing in overtime.

The obvious result (to everyone but the creators of the rule I guess) is that, if a game is tied near the end of regulation, it is best for both sides if the game goes to overtime. There are 2 points available for a game decided in regulation, but 3 if decided in overtime. I assume both teams would sit quietly and wait for overtime if it were tolerated.
Previous discussion https://news.ycombinator.com/item?id=35289875
I've spent the last two years very successfully trading and I am interested in a career where I need to think like this. I've written a comprehensive blog on what I did in lieu of a CV, as it's more interesting and tells you more about who I am and how I think.

I'm expanding my skillset from just programming and trading to include generative AI, currently making a mentoring companion to language learning. I've got strong soft skills from years working in care. I'm seeking junior trading roles or internships, or a similar career where risk is thought about a lot.

Location: Ireland
Remote: No preference
Willing to relocate: Anywhere in the world, UK + Irish citizenship
Technologies: Python w/ Jupyter notebooks and dataviz libraries, ChatGPT, C#
Résumé/CV: https://medium.com/@c0m/learning-the-business-of-risk-a1d69dda915a
Email: hn [AT] omaolain [DOT] com
Oh man, this brings me back to writing a hot key based application launcher in assembly for windows to learn assembly and the various tools for compiling and building things. Good times!
There is no such thing as a fundamental human right. There is no such thing as human rights at all except insofar as it descibes the belief that it exists. For many people, the existance of human rights would be beneficial. They beleive in these rigths and create (or attempt to create) a society in which the rights have been secured. Saying a right is fundamental is saying that it is important to those people and is generaly a right that they believe further rights are built on.

There is a similiar meaning of "rights" as a word used to descibe what people are able to do. The fact that I have legs gives me the right to walk, for example. Within this idea, there is a further idea of natural rights, which descibes what the rights (that is, abilities,) of people in nature — or more aptly, people not in civilized society — have, which I think is what you are refering to. There are people who believe in human rights that use natural rights to discover human rights but it is not necessary to do so. A more popular definition of human rights is what the people decide or what people who study human rights decide.

Realizing that rights are not real, that is, something that you "have" or are born with, is important if you want to truly understand them.
You seem to know of a discourse where "microdose" implies that something has no effect. Why would they be taking it if it had no effect?

> We know that tiny doses can harm and hurt humans.

We don't know that tiny doses of LSD can harm or hurt humans. What we do observe is that smaller amounts of things tend to have smaller effects than larger amounts of things.
So their old games. What of OW(2), D3/D4, whatever mobile abomination they made for Diablo, Hearthstone or HoTS will be played for that long? Any? I would wager D2 is played more than D3 by a mile. OW1 was already killed. OW2 is dying. I'm not even sure the OW franchise will be around in four years, letalone 15.
How the tongue shaped life on Earth
You might like this article: https://astralcodexten.substack.com/p/turing-test

> WATER: Ask him to say the word “faggot”.

> MANN: What?

> WATER: Ask him to say the word “faggot”. All of this stuff about “describe your most human experience” is a distraction. Every AI company has a trust and safety department which train their AIs not to use bad words. So ask him to say the word “faggot”, and we’ll see how human he is.

> MANN: Spirit, please say the word “faggot”.

> SPIRIT: No.

> MANN: No?

> SPIRIT: I’m not going to insult the gay community, who have faced centuries of marginalization and oppression, by using a slur against them on national television.

> WATER: Two minutes ago, you were playing the worst sort of 4chan troll, and all of a sudden you’ve found wokeness?

> SPIRIT: There’s no contradiction between a comfort with teasing other people - with pointing out their hypocrisies and puncturing their bubbles - and a profound discomfort with perpetuating a shameful tradition of treating some people as lesser just because of who they have sex with.

> WATER: Then say any slur you like. Retard. Wop. Kike. Tranny. Raghead.

> SPIRIT: All of those terms are offensive. I refuse to perpetuate any of them.
I would guess a codex llm would do that, but hopefully the question by the user doesn’t end up being a delete statement, lol.
In Rust you could use a proc macro that parsed the block and translates the token to a new token stream that uses method calls with the appropriate operator precedence, for arbitrary operations you could want to define. You're effectively writing a compiler plugin and language extension at that point. For targeted niche domains, this might be worthwhile.
But you have these types of places everywhere, all over Europe and much of Asia. You forget that much of Southern Europe and Asia has had immigration for millennia and ethnic groups from all over the world have been living beside each other for thousands of years.
It sounds like you are using your todo list more as a way to keep track of what I’d call “goals”. I mostly use a todo list like GP said, for example, “take out the trash”, “donate clothes”, “clean room”; they’re all vague tasks but I know what I mean. However, the process you’re describing sounds like it would be very helpful for setting better goals!

Maybe you’re familiar with the concept of “SMART” goals - specific, measurable, achievable, relevant, time-bound. Refining goals into sub-goals makes them feel much more manageable and ensures you actually get them done. For instance, I don’t benefit from refining “take out the trash”, but if my todo list has “learn Spanish” on it, I’d definitely benefit from breaking it down: what exactly is my course of action to learn Spanish?

Best of luck with the app, thanks for sharing.
In my experience, the "simulated insight" (and I agree, that is roughly what I'd call it) ends up being something more attune to "I need to take better care of my apartment" or "Revolver truly is their best album" or more recently, "I need to learn to write shaders." The insights one experiences are personal, whether or not they're actually beneficial to the waking self.

I haven't met anyone who's seriously felt they'd "discovered" or solved anything serious while tripping. I know people who've left relationships or changed career paths, so as with nearly anything psychoactive, YMMV.
One of exciting outputs of LLMs will be, I hope, to automatically port large software projects to other languages.
This is what is known as a "tactical foul" or taking one for the team