skysight-inc/HackerNews huggingface dataset:
Reminds me I was playing games at 320x240 and then going to 1024x768 resolution. Suddenly everything started looking "basic", whereas at lower resolution, brain could somewhat "fill in the blanks" so to speak so it felt better.

I guess it is similar for higher frame rates - it just shows the shortcomings.

I think if the film industry committed to higher frame rates we would have seen massive improvements over the years.
True, but going from there to "foreign keys are bad" is still quite a jump. There are other options available for migrations as well, but I understand that it can become a trade-off at scale, especially if availability and uptime are more important than data integrity. But as I said, it's a trade-off and I suppose in most situations you won't have noticeable downtime due to migrations or you can even avoid downtime altogether without ditching foreign keys.
Then you're better off using custom types - that way people will immediate know your type is non-default - as opposed to hiding your customization away in a makefile, pranking people who expect built-ins to behave a certain way.
> In my experience, about one third of the time the toy is all you need, you can stop there, and what you were going to build fully would be over-engineering.

On the flip side, the cases where the toy ends up being promoted to production service end up being riddles with technical debt, missing features, and buggy behavior that jeopardizes the whole project, also happen.

Survivorship bias is also a major problem. It's easy to presume that the winning bet you took is the right path.
Sure, I just mean that you don't need to directly do the payment in XMR. You can use monero to hide the provenance of your BTC/ETH/something faster without having to go through the pain of proving an XMR transfer.
Eh - sometimes you gotta solve hard problems and no amount of simplification is going to net good results.
So much of our industrial tooling has been optimized for mass manufacturing. It's incredible what can be done to push unit prices down for large volume production.

Because of the focus on mass manufacturing, hardware is incredibly expensive to change. The industry seems to have centered around doing more planning up front.

But we (software people), learned 20 years ago (from select Hardware companies) that this is backwards. If the cost of change is high, and that's where your pain is, change more frequently. Mitigate that pain and make it a strength. (See: Toyota Production System)

I have a product with an addressable market of something like 300 to 500 units per year. That puts me in the Defense/Aerospace/Medical area, where unit economics are completely insane.

And yes. It does feel like being ripped off when someone puts ~30 minutes ($20 max) of Western labor into something and then turns around and charges me $800 for the privilege of supporting an American company.
> Weird pricing: PlanetScale prices you on row-reads and row-writes per month. What is weird is that row-reads is something that nobody controls. It is the SQL query planner which determines the query plan, which results in how many rows you’re reading internally. Remember that row-reads are not row returns. You can write a wrong query that returns 0 rows but can still do a full table scan of 1M rows and PlanetScale will charge you for it.

This is expected pricing. The pricing is based on the load on the db, not based on results.

Usually there are two ways working with this:

DB supports showing estimated query plan , which explains how query would be ran without running it. Allowing to capture any missing indexes or filtered indexes.

DB allows only querying against indexes (this is usually done by no-sql dbs which have flexibility to deny bad queries).
IIRC Thomas Goyard hit 41kts on the foil, but may not be "official".

The speed canals where they hit really high speeds on fins are in special areas that most people will never be able to experience that have no wind disruptions and are very shallow canals to keep the chop down like in Luderitz, it isn't an open water speed: https://www.youtube.com/watch?v=jt3DQNUJXkc

The races, which have fin and foil against each other, have been in open water state (more real world for 99% of windsurfers), and in those conditions fin vs. foil are very competitive, with foils pulling ahead in the turns due to a lot less resistance and better ability to get back upwind compared to a fin. There's been a lot of debate on even allowing them to compete in the same races as they currently are allowed. They can both do 30ish knots in the same conditions, with the foilers getting away with smaller sails.
https://www.youtube.com/watch?v=jsUDkg2d5tE
If the ACM, instead of founding the Turing award, had attempted to pay to get a Nobel memorial prize in Computer Science, we would have easily recognized it for what it was - a pathetic play for respectability.
I'm a beginner, and I set up my system with Home Manager and on MacOS Nix Darwin. It works extremely well, and both Home Manager & Nix Darwin are quite well-documented. The hardest part was figuring out the different arguments to various Nix functions (sometimes I wished Nix had types).
Would be kind of interesting to see a line of dots below each dot representing as many finishers in that race (assuming any) that fit on the chart
> During the twentieth century, women’s education levels continuously increased, and in most high-income countries they are now substantially higher than for men.

> However, Goldin has shown that the bulk of this earnings difference is now between [sic] and women in the same occupation, and that it largely arises with the birth of the first child.

Interesting situation developing if the main effort is in educating women who then leave the workforce. I assume one of these is going to have to give - presumably who takes primary caregiver responsbilities.
I kind of want to say "y-yeah" regarding Prisma, because all this information (especially the fact that it creates a transaction every time and downloads those engines) is either available in the documentation or visible upon install/build - you can actually make it point to specific executables instead of downloading each time using environment variables but again - it's in the docs.

I picked Prisma because I'm not actually a backend developer and the tradeoffs were okay for my use case.

I wish performance was better, but a few indexes here and there went a long way.

The only surprising bit for me was peak memory usage - it comes in bursts and can get to hundreds of MB when doing even a simple query.

The queries themselves are also kind of out there in terms of complexity but so far I haven't found a reason to rewrite them in raw SQL, since that isn't where our performance bottlenecks are at the moment.

The lack of rollbacks is one legitimate pain point and I wish they addressed it.
If you're an archivist sort of individual, I imagine this would definitely not be your cup of tea.

For what it's worth though, If you're the poster of the thought, the post along with responses are available to you forever. They just 'die' from the point of view of the collective.

Of course, I understand this doesn't necessarily speak to your specific 'needs' but it is an overlap I kept in because I do resonate with your desired approach.
LMMS is a great little program too but in much the same way that a professional mix table is less 'friendly' than a four track recorder.

Both have their uses. What bugs me about LMMS is that it is hard to use its output in any other way than just to send it to your devices, interop with other software isn't all that good unless it is on the plugin side.

And neither Ardour nor LMMS come close to midieditor for the editing of raw midi files, and that's a shame because midieditor isn't very well supported and a bit fragile (it crashes with alarming regularity).
Towards a world war, to sooth the bad conciousness of the dynamite inventor?
You have nothing to apologize for and you're doing great.

I didn't need a valid email to signup for HN,Reddit or even matrix.org in its infancy. That's where I'm coming from. There are better anti-fraud measures and it should be up to the user if they want a way to reset their account. Ideally, you'll have 2FA and the non-email 2FA recovery will also reset the password (such as one time codes you write down, or prove multiple external identity control such as a phone number and creditcard, or ID photo and phone number).

But as I admitted, I shat on your work because I ran into this pet-peeve. So, it is I who should apologize (and I do apologize).
I like the UI of the website, is it some open source template?
Yeah that's why the uppercase/lowercase hardline is a good one. Even Lisp, where free variable capture is a legitimate design pattern, has troubles with this.
Chief Technology Unicorn just doesn't have the same nice ring to it.

Also there's T shaped skills and there's you with:

_________
/|\
/ | \
/ | \
/ | \

Not trying to be snarky, just trying to point out the rarity of such a skill set imo.
I was curious about the question raised in the article: why the name "barrel" files? Even as a native speaker, the term didn't make sense to me either.

I opened by asking ChatGPT what barrel files actually are both to verify that the term used in the article is correct and to ensure that ChatGPT and I were both properly referring to the same thing.

Having taken the time to learn this, I shared it with the community. Not sure what I did wrong there to be downvoted and accused of being a "karma farming" bot.
I think Django is roughly the same level of complexity, once you’ve learned its syntax of course. Actually, it may be too easy in some regards (thinking specifically of implicit joins), such that unaware devs may not realize that they’re causing performance issues.

In general though, I agree with your premise - I don’t understand why people are so reluctant to learn SQL. It’s not a difficult language. Understanding the quirks of your RDBMS, sure. But the base language? Nah.
Along these lines, what is happening when someone walks into a room and sees a snake, but then does a double take and sees that it is a rope.

It seems humans do have miss-identifying visions. Where they categorize something fast but incorrectly, and then might need 'help/time/shock', to kick start re-categorizing. To re-see it again.

Or Like when seeing something for the very first time and they are 'befuddled', can't grasp it. Maybe like Bayes is having to iterate on it much longer.

I'm curious since I'm not all that familiar with Bayes. Is this what you are talking about with 1 or 0. People do make very rapid judgments, then settle on an a 'view'. Then it can take something to make them re-adjust.
From the article there is no detail of what problem they were solving, just "we used tech stack A, we ran into issues, so we went with tech stack B". So I have no idea whether MongoDB was a good choice to begin with, or not, or whether the problem needed a relational database or not. Or for that matter GraphQL or AWS Lambda.

I do get the feeling they went YOLO and built their solution on an over-engineered approach with a stack they were unfamiliar with, and when they hit problems, they YOLO'd into another solution without properly evaluating why, which feels like a team of junior developers run amok.

They also seemed to not really understand relational databases, and why foreign keys are kind of important when you are choosing a relation database implementation (yes you can do without them, but it's best to understand them first).
Show HN: RSS Feed Ownership and Authentication
Creation of information (text, audio, video) is easier and getting more difficult to gauge for authenticity and we need infrastructure to disseminate information in a digitally identifiable manner.

If you give the ability for an agent (human, LLM, etc.) to publish information in a way that digitally authenticates the publishing source and simultaneously acts as a payment method you unlock autonomy of information creation from digitally verifiable sources.

I've created an early version of such a platform at ownmyrss.com and would love to discuss thoughts, ideas, feedback, and anything else!

https://x.com/eabnelson/status/1710296241869893975?s=20
Hmm yeah that last sentence resonates.
I did a bunch of analysis of UK addresses at a former job. My favourite was the clear inverse correlation between house number and value, with a noticeable dip for number 13s, which from memory were valued around 2.5% lower than where they should have been.
You're right, but I get the feeling being acquired by a megacorporation is the goal for a lot of startups.
The joins should be done inside the DB, not in an external server. Any SQL DB should be able to do that.
In terms of 'onboarding' or 'going-to-market', this approach was something I had considered.
However, the hassle along some of my prior experiences in similar user workflows did deter me from following through.
Do you have any link to read more about it?
in the US, Regulatory-wise, how would a product be viewed that's essentially a raspberry pi in a box? Would it need FCC certification at all?
But also more vendors, market fragmentation, and far less open-source firmware?
It's not like you will be able to upgrade the CPU. Even RAM isn't mentioned.
This is absolutely awful, and anyone who chose it as an ORM either didn’t read the docs, or didn’t understand the implications.

“I’ll just SELECT * from all these tables, and figure out what I want in my app.”
Israel's Failure to Stop Hamas Attack Shows the Danger of Too Much Surveillance
Related thread:

https://news.ycombinator.com/item?id=37679584 ("Observation of the effect of gravity on the motion of antimatter (nature.com)"; 68 comments)
> it's also available as a pre-build product to pay for

Show me where to pay for the pre-built product:

https://community.ardour.org/download?platform=linux&archite...

All I see is a direct download link. If you want to pay that's optional.
Documentation is such a broad area I think it's big enough for everyone to hate something.

There's

- how (implementation, how the system works)

- what (what the system is for, it's purpose

- why (design)

And there's audiences

- developers (using the interfaces)

- architects (designing the interfaces)

- testers (validating the interfaces)

- operators (running the system)

- managers (organizing development efforts)

And at some companies it's 1 person doing all of that. I think once you start to add more people, you start to have debates about documentation. The programmer might have written "clean" code and automated tests which are understandable to other programmers but less useful to project managers and operators.
I see. Thanks for that link!
It's the reason Rust makes us use an exclamation mark with macro calls: beware! magic! here!

I like this as a convention, but not necessarily as a grammar rule. Printing values is common enough that it shouldn't require shouting for constant attention, simple code shouldn't trigger sensory overload.
(Mis)understanding RISC-V ecalls and syscalls
I’m sorry for my lack of clarity. Please keep in mind this is what killed Firefox for me, not the wider audience.
Love the aesthetic and how you've organized things in the UI. I don't freelance, but this seems like a helpful tool, especially the report generation.
One thing that keeps coming up is that SQL equals low productivity. I don't think this is true. I think the culprit is that most developers are using to heavily abstracting SQL using ORMs like Prisma that hides the database and SQL logic.

Since building a SQL generator (https://aihelperbot.com) as a side project, I have become much more proficient in SQL and even though I am also locked into Prisma, I use the `queryRaw` all the time to execute raw SQL queries. You can understand the code without knowing Prisma API. It is more performant. For more complex SQL queries, I use the SQL generator for initial suggestions and adapt if needed.

For the next projects I build I want to use the minimal Postgres client (https://github.com/brianc/node-postgres) combined with a lightweight migration library.
New: All errors in the application have been fixed and a function has been added to complete publication in the absence of Internet for maximum accounts.

Social Poster (SP) is a convenient and powerful application that serves as a versatile planner and autoposting tool, making it a valuable asset for managing your social media presence. With SP, you can easily and quickly publish posts on popular social networks such as VKontakte (VK), Telegram, and Instagram. Whether you're looking to plan and schedule your posts, engage with your audience on social media, or simply share announcements, Social Poster streamlines the process for you.

One of the standout features of this application is its user-friendly interface, designed for both beginners and seasoned social media managers. Even if you are new to SMM promotion, Social Poster's intuitive design ensures you can navigate the app effortlessly. To get started, simply add your social network accounts of choice. Then, seamlessly switch between these accounts as you work within the application.

When crafting a new post, take advantage of the option to attach photos, videos, or other files to enhance your content and captivate your audience. You can easily select the desired social network and the specific post you want to publish. For those managing multiple groups or pages, Social Poster allows you to handpick where your content gets shared.

Furthermore, SP offers the convenience of automatic republishing in case of an interrupted internet connection during the posting process. Additionally, you can set up automated post scheduling, which proves especially useful if you're unable to monitor posts and mailings constantly.

For those seeking enhanced control over their publishing processes and a comprehensive view of statistics, SP provides a detailed publication history. This feature enables you to track when and where each post was made, monitor the number of views, and gauge engagement through likes and comments.

Data and account security are paramount, and Social Poster ensures your peace of mind. Easily authorize the application through your social network accounts, knowing that your data is safeguarded.

It's worth highlighting that our dedicated team of developers continuously strives to improve the application, regularly introducing new functionality and enhancing existing features. We highly value user feedback and remain open to suggestions aimed at elevating the quality of our product.

We are confident that SP will become an indispensable SMM planner, autoposting assistant, and a go-to tool for achieving your social media objectives. Expand your reach, engage your audience, and achieve your desired results with ease and efficiency.

Experience the power of Social Poster - your comprehensive social media planner and publishing solution. Start planning, scheduling, and publishing your posts effortlessly today.
This is probably an elementary question, but are those focal shifts still done manually, with a camera guy turning the ring by hand? Or do they set the two points in advance and hit a button to start a motorized transition?
I'm a bit reverse. Anxiety drives me towards people. Being on top of everything at work, getting into the flow - I too don't want to touch my PC for fun, but I also don't want to talk to people, or do anything that would "flush the cache" or "page to disk" all the work stuff, because I feel that once I break my stride, I won't regain it any time soon.

It's perhaps irrational, but it's something I struggle with - my perfect way of working unfortunately goes against every social expectation, life/work balance stuff, etc.
Cool! For momo.coach, I wanted to have everything I needed in the same app and personally I do not go too fare in time tracking.
One "weird numbering scheme" according to the article is setting house numbers based on distance (in meters) from a predefined "street start" point.

I find this arrangement to be the most convenient one, and I've found it quite often in villages in France.

No need for "bis" or "3a" or "3 ½" house numbers, and a consistent method to obtain the position of a house based on its house number.
> It’s a pathetic marketing scheme by a fake science.

What makes a science "real" and what makes it "fake"?
Another UK Postcode oddity is Gibraltar which has GX111AA as the postcode for the entire country
After a few decades of life, I dare say I am reasonably calibrated.
For creating requests the GUI of postman is way over the top. HTTP is so simple, why not just write that directly in a literate format you can checkin to a repo? For actually running the requests though I agree a gui is nice. I actually use dot-http as an embedded tool in a browser extension. They're still alternatives, just not in the style you're used to.
In its defence, the image says it is for Obsidian, so that is probably its intended use right there, in the screenshots.
Why do people balk at using a Huawei phone but have no problem using Lenovo laptops? Honest question; I've always liked the hardware.
This resonates with me a lot, thank you for sharing it.
I, genuinely, have a USB-C cable which will only charge my phone in one orientation.

That's worse than Type-A, since I can't even look at the end to see which side has the plastic bar, I just have to try it and obviously it fits, but see if it charges. Which means it takes about 94 attempts because I only realise the other end's not plugged in, or it's turned off at the wall, on the 92nd.
> People needing to query huge amounts of data discovering technology that's been developed over the past 45 years for querying huge amounts of data efficiently; news at 11

I think a lot of folks are quick to discount just how scalable a database like Postgres or SQL Server can be (not to mention battle tested). Maybe its because of a lack of DBMS experience as we've move more and more from owning database servers to consuming *-as-a-service. Maybe it's because everyone thinks that they'll have Facebook scale traffic and concerns so they immediately gravitate to technologies designed to solve problems at a different order of magnitude.
As tables scale you may need to partition them. FKs also introduce a performance it on writes and DDL. In some DDL cases a table rewrite may be required, such as if FKs cascade.
Nuclear Test Sites Are Busy
The article is cringe yolo for sure

With that said I was planning to use prisma and went and looked at issues on GitHub. They’re egregious … and I will not be using prisma

The library also looks like it was written in a yolo way as well.

My guess is the graphql background has permanently stunted it, as the project manager keeps wanting examples for performance issues instead of realizing the entire fact joins are missing to begin with is idiotic and absurd.

So my guess is they’re piecemeal fixing one off issues instead of fixing the problem at its root, probably because prisma code is not designed with that in mind from the beginning
And it wasn't the first iPod that ended up killing it. Circa 2004->2006 minidiscs were still super common.
Somebody should superimpose the U-curve with the fertility rate graph. It might be that women employment picked up again when women gave up on having children/families. If you live in a 1st world country and you're too poor to afford to have a family (and by this I mean to be able to raise children with a certain standard of living) you might as well have a career... just to have some semblance of meaning in life.
Great talk, thanks for sharing! I am looking for a way to finance building and maintaining the thing I want to build, and this talk was a nice reminder that donations actually CAN work. Otherwise, VCs are interested in an "Exit" event, but what if you as the founder are not? It doesn't sound like you are interested in exiting zig any time soon, either.