skysight-inc/HackerNews huggingface dataset:
SQL cannot be "fixed". It's too broken, too ubiquitous, too customized, too optimized. Will these functors integrate with the thousands of optimizations modern database systems rely on?

This post has the format: "SQL is extremely terribly awful at writing business logic. But if people implemented this one half-baked, unrealistic idea, then it would suck a little bit less!" The first part is spot-on: SQL is a horrible language for writing business logic. So: stop. Stop doing that.

Stop writing business logic in SQL!

Imagine you joined a new team, and they said: our program uses a bunch of XML files as its data format, and that's why most of our business logic is implemented in XPath. Just sit there and ponder that situation for a little bit. This is what you all sound like to me. Stop it!

> Testing the simplest query requires building up a massive object graph, just to test an infinitesimal slice of it.

Yes, correct, because SQL is awful at representing business logic, and foreign key constraints are business logic! The fact that an employee has one supervisor who is also an employee (FK Employee.SupervisorID -> Employee.ID) is a business constraint. (And one that can easily change, by the way.) All these database engineers who can't pull themselves away from their stored procedures will argue with me to their graves about foreign key constraints, but they're generally terrible. They're a business constraint that just happens to be supported by the database engine, but they're still a business constraint. Stop putting your business logic in your persistence layer.

We've been getting better at building programming languages that actually support software engineering every year. Use one of those. SQL is an output of one of your program layers. Just like XPath would be an output of your program. Compose SQL in an actual real programming language that isn't horrible instead of doing any of this.
Didn't that drive the 1950 & 1960s in the USA? Taxing the rich and giving to the working class to build bridges, schools, GI homes, ... Isn't that classified as the most stable economy in their history? The only decades where the stock market was stable?

How do you know your taxes are not going where they should? Do you wish for them not to be used to help the sick, the poor, and the vulnerable?

Was DARPA's tax payer investment in ARPNET worth it or DOD with GPS?

I'm not saying there is abuse in the system, any should be found and dealt with. Nor saying spending should stays the same, money needs to move improve the health, well-being and wealth of non-rich.
Beets (for library management) + Navidrome (for serving) is a great combo if you want to go self-hosted.

Options for acquiring media:

- Buy vinyl/CDs

- Ripping from streaming services (Deezer was well-known for that a few years ago)

- yt-dlp for niche picks you can’t find in better quality elsewhere

- Rip CDs from local library

- Bandcamp, Soundcloud

- Various what.cd successors, if that’s your thing
Same

I just wrote about my experience here on a project
https://fzakaria.com/2025/01/28/bazel-build-event-protocol-v...
Based on the edit:

What are you offering to pay your “technical cofounder”? I bet it’s peanuts and “equity”. If that’s the case, do you not see that you are part of the same toxic culture that defines many startups hiring process.
It doesn't matter whether you use AI or not, what matters is whether your articles are relevant and useful or not
I'd say with very few features I miss from Spotify, that yt music is simply a better platform (even more so with owning yt premium)
California farming is a major resource for US food and should be protected as a national security issue. Why haven't previous administrations implemented this apparently simple fix?
I'm also planning to leave. It's offensive that they decided to do podcasts and audiobooks and not allow you to turn that off in the UI. I want an app to listen to music! But someone there apparently thinks they can engage me more if they throw in a bunch of other irrelevant functionality. Ugh.
> no thanks, Podcasts are terrible. If I wanted to hear idiots laughing at each other I'd listen to the Radio DJs

When you inject personal opinions like this which are obviously at odds with millions of other people, it's difficult to take the rest of the comment seriously.
Yes it's called private services. For instance there are no public roads for miles where I live, so I rented backhoe and made them. There is no police, so I learned how to defend myself. There is no water, so we drilled a well. The whole of public services can be privatized into line items.
(1) If you run the model on your server there is no problem

(2) They have a privacy policy, so it boils down to (a) do you like it? and (b) do you trust them to follow it?
Public Service Announcement: there’s a healthy marketplace of refurbished and upgraded iPods from the 2004 era on eBay, the Classic 5.5 comes highly recommended with solid DAC from the factory but iPods mini with upgraded DAC, fresh battery, and large flash memory swaps for the old spinning disks are readily available.

I subscribe to Qobuz and buy a lot of lossless DRM free music and can recommend them as well, tho there was recently a big swath of the available music dropped due to licensing issues (hence the utility of downloading DRM free music). I also price shop against the digital albums and often a CD on eBay will be cheaper, I don’t mind missing out on the “24bit 192khz hifi” to save a few bucks.
Thanks! Yes, will push it as template to our repo (https://github.com/PySpur-Dev/pyspur) soon! We used o1 and claude3.5
And then your manager is wondering if you're a software engineer why you can't debug it
No discovery of new music?
We need to think about where we want the knowledge and what knows it. We could use humanoid AIs. We could hatch humans "just in time". Run them in a sim to 18 then release them on their mission. Ethics would need to accept this. Maybe we would be happy slowly expanding across the universe and an decendant talking to 'the aliens'.

I am not totally serious. But you wanna meet aliens? Gotta do something a bit radical.
Changing production code on the fly? So testing/qa is done on production? Uh, no thank you.
To extend your Lego metaphor to the question of “is a lot of this irrelevant?“ Does your Lego model of a city need to have interior floors, furniture, and fixtures in order to satisfy your requirements? Perhaps in some cases, but not in most.
Sort of. There's a class of startups that's not meant to be profitable, except maybe by happy accident. Many (most?) tech startups are like that now. After all, the investors don't care about creating profitable companies - they just want to make money, which they're positioned to do in many ways. One of them is to help create profitable companies. Another is to help grow companies to be sold to other companies and/or to the public for maximum value, giving the investors back a large multiple of initial investments, after which... they don't care anymore.

It's like with modern husbandry: you can make money selling milk, eggs and meat by sustainably raising animals living comfortable lives, but you can make more money by sticking them in cages, pumping them up with antibiotics and optimized fodder, to maximize production rates and minimize costs. The two approaches are inherently incompatible with each other. And I dare to say, modern startup ecosystem kind of entered the era of "factory farming" some time ago now.
Hangout.fm has no AI slop, all human
Hit Me! Kick Me! Make me feel cheap!

Have your S bot call my M bot...

People really think ChatGPT gets "mad"? This is just a joke right?

Or, more internet brain damage...
Those were needed because buying politicians and public favor was hard.

Now you just buy media.
I’ve been strongly considering refurbing the 6th gen iPod Classic I have in the garage. The disk died years ago, and I imagine it would need a battery by now.

Now I’m wondering if anybody sells a USB-C adapter to iPod dock connector.

One of these days the parts are going to end up at my doorstep. Boredom and a couple of beers away.
All what? Tell me what "people" don't want and I will tell you why people don't know what the heck they are talking about. This site is focused on expertise. Would you want "people" to tell you why you need that helper class? Stuff. Is. Complicated.
I still don't see this being something large airlines would be overly interested in, but I wonder if there's a private market. If you're Taylor Swift maybe being able to fly from NYC to LA in half the time is well worth it.
Pretty much - either they pay gig musicians an hourly wage to record "human" slop that spotify has the rights to and can stream effectively for free, or just out right ai generated slop

https://harpers.org/archive/2025/01/the-ghosts-in-the-machin...

https://www.fastcompany.com/91170296/spotify-ai-music
This is what AGI probably would be. It could help you, or it could be as arbitrary and capricious as a teenager. It could lie to you, or tell you to go fly a kite. Companies don’t really want true AGI, they want a docile corporate drone that works 24/7.
European airfares from the US can be really funky. I'm doing a trip in a couple months with a roundtrip for Heathrow and I'm actually taking the Eurostar back to London because returning directly from Paris was going to be so expensive. Open jaws in particular can be fairly OK or can be really expensive (as in my case).
Something that is named intelligent, does not get "tricked", or need to be defended, or qualified, or defined, aaaand can take a trillion dollar market colapse in stride, pull up its big artificial undies all by itself,right!
Way ,way to late for some kind of academic splaining things away.
People bet a lot lot more than the meer trillion dollars.Primary national stratigic objectives have been put into play, on the promise of hardware and AI based dominence, and ZAM, just like that, North Korea etall, are jammin that artificial jive.
So all of the main hypsters, are going to be promoted to somewhere, quiet and dry.
It is realy troubleing that last week, ai tarpits
were amusing, inconsequential, pranks, and now its
"AI haters".The author of the ai tarpit was self depreciating, and recognised that there actions were symbolic at best.
MS-SQL would seem to already support everything you’ve suggested.
That's over 8,000 miles. An aircraft with that kind of unrefueuled range could go pretty much anywhere from New York, except Australia, SE Asia, or the tips of Africa and India.
Who would have guessed just a few years ago that the final programming language would be English.
> They also deprecated their library (libspotify) which had previously been used to build alternative third-party clients and playback-capable integrations for paying Spotify users. They promised a replacement, but that never happened…

It exists... but only for employees: https://xcancel.com/rogueops/status/1656349863968112680
> When we do our job, we very rarely interact directly with the "mission".

And this is the problem, if I am hiring for a startup or in my case green field initiatives, I don’t need just “coders”. I need people who understand the business and can give prescriptive insights and deal with the ambiguity that comes with any green field initiative. If you are just a coder, how do you plan to stand out from the literally 1000s of applications that every company gets?
Self replicating automata as described by Von Neumann able to repair and duplicate themselves, and other things like electronic components. ICs keep getting faster (so far) but use smaller and smaller features of silicon and could wear out from metal migration and all components will be under much more cosmic radiation than on earth. This makes a large shield of heavy material on front of vehicle to minimize this effect but that increases the energy/fuel needed. The space shuttle only took maybe week long trips but it had four computers for flight control , three extra in case of failure in different parts of the shuttle along with IIRC a separate backup backup computer in for use as last resort.
When does this actually happen? I can imagine it on their background music playlists (and wouldn’t really mind it) but I’ve never encountered it on any playlist at least as far as I’m aware. Is it only electronic music or will they AI you an entire 5 piece rock band?
The problem is when the censorship is not known in advance. How would you know the answer you got wasn't censored?

Or are you going to make a verification prompt every time, phrased as a coding question, to check if the previous answer differed in ways that would imply censorship?
I was more stating the perception that compute is cheap than the fact that compute is cheap - often enough it isn't! But carelessness about performance happens, well, by default really.
My criteria are:

- 500GB+

- Ability to sort by the albumartist tag (listen to heaps of compilations)

- Ability to export play log

- Functions like any other external storage device for transfer purposes

Anything out there? Last I checked (10 years ago) there was nothing that hit all these marks. I had a Sansa Clip with Rockbox and just dealt with the low storage capacity.
Operating Systems: Three Easy Pieces – Free Book
I've only ever felt that on reddit. It's a schadenfreude paradise. Next to that it's LinkedIn. HN is the last true sane social media for me where people seem normal (albeit _highly_ analytical, almost to a fault at times)
KnowBe4 is awesome. It trains everyone to be on the lookout. The penalty for barely screwing up is another boring training session that no one has time for. Very painful. Pain is a great teacher.
Solargraph is like 8+ years old too.

This person clearly has no actual rails experience. Every deal breaker he lists has a well established solution in rails.
Of all the problems that I have with Spotify - its frequently changing selection of music, its hostility to power users, its shuffle algorithm, its artist hostile rates, its frequently changing-for-the-worse interface - I can't really say that AI music is one of them. If I come across some and enjoy it, great! I'm not going to let that impact my enjoyment of music as a whole.
Do you have more details?

How long did it take you?

What's the square footage and number of bedrooms / bathrooms?

Did anyone help you?

Did you include buying / renting tools in that amount?

Already own the land?

Interior / exterior finish levels? e.g. is it a cabin?
Where and how do you disable these mitigations?
No people want the amount of money that the market will give them. If you can’t afford the inputs that are required for your business, that’s a you problem. Come back when you have enough funding to pique my interest with cash comp - not worthless “equity”
If you haven't, you should read Accelerando, it's a collection of short stories IIRC that were put into a novel by the author. I didn't want to start with that, but that is in there. :)
My personal favourite is PostHog, which sounds like something one might say on Grindr.
Currently use AutoIT and InnoSetup for installation wrappers those that don't have installers with silent support or have the ability to automate the settings. This is where BSD and Linux shine compared to Windows! Scripting and automation is built-in with the ladders and greatly lacking in the former.
2021 was such a bizarre year in so many ways. It feels like a post COVID fever dream in retrospect, and seeing that massive jump in job listings that year is a reminder of how weird it was.
> Plan for 10,000 years out, not tomorrow.

I'm happy to. But then, like most people, I'm impatient, so I'll draw a second plan that ensures I get to see at least some of the cool stuff before I die, and then I'll get annoyed when this plan isn't followed.

Galactic timescales are large. Human lifespans are tiny.
This isn't just limited to safari. I wonder if this apple fix this more thoroughly than spectre and meltdown.
> I found it way too messy and complicated, and our codebase was awful.

Are you saying that’s because RoR was used? Doesn’t seem plausible. Messy bad code is the fault of the programmer, not the language/framework
I have put on "I Glued My Balls To My Butthole Again" on YouTube Music, unironically, several times. I don't actually hate AI music.
I still haven’t found anything that matches the power, functionality, and flexibility of VMS batch queues.
That didn't take too long.

Expect the current administration to spend more time in court than any other.

Of course, this won't be anything new for Donald...
Sycophancy is not the natural state of pre-trained LLMs. If you played around with the OG GPT-3 in 2020 or early [0] Bing/Co-pilot, it's easy to see. The latter quite frequently got upset and refused to entertain further conversation.

The sycophancy is a deliberate product of post-training.

[0]
https://www.reddit.com/r/ChatGPT/comments/111cl0l/bing_ai_ch...

https://www.reddit.com/r/ChatGPT/comments/10xmif4/i_made_bin...

https://www.reddit.com/r/ChatGPT/comments/12g0ksj/bing_can_b...

https://www.reddit.com/r/ChatGPT/comments/1566bi9/bing_chatg...
But an iPod from the 2004 era is both hard to use and very heavy. You can get a tiny flash-based modern mp3 player for $30-$40, which is below the apparent price of a 2004 iPod on eBay.
Yes and no. A lot depends on who the architect is.
- top text entry field could also be selected by default upon load: ready for typing entry
Very good presentation but I do miss any mention of the audience claim. This claim is underrated in my opinion at least. It allows the token to climb access to an api or server or whatever that can be used by gateways to do a high level authorization. Then the scopes can be used at the resource server to govern lower level authorization.
Company Name Generator
Your brand deserves a name that turns heads, sparks curiosity, and demands attention.

Whether you're launching a startup, rebranding your business, or brainstorming your next big idea, this AI-powered Company Name Generator delivers unforgettable names that stick!
I’ll do you one better, how about swapping the port on the iPod to USB-C ?

https://moonlit.market/

Have you got the old iTunes installed? I was pleasantly surprised Apple still offers the old binaries for download

https://support.apple.com/en-us/docs/software
It worked for thefacebook.com.
Maybe the fact that it can't but we still shove it everywhere is scarier.
I wouldn't recommend it if anything were to go wrong. It's a quick way to end up in bankruptcy if anyone gets hurt, or if your neighbors property gets damaged
You can use exportify to get playlists and likes off of there. After that maybe make a script to search for entries on whatever service you're using.
iPod video 5th gen w/ Rockbox custom firmware. Then do the bluetooth mod and you're in music heaven. Probably fairly easy to write a plugin for the functionality you mentioned.
The biggest boom and gains in the US arguably happened after the Civil War and before WW1, during which federal tax burden was something like 2% and there was no income tax.
This is like cancelling the fire department and then wondering why the city burned down. Daft and clueless. But par for the course from the party that brought you the Iraq war, the 2009 financial crisis, the pandemic. They are like a cancer on all decent Americans.
Thats the point.

EVERYTHING is upturned. "All other things solved" includes robotics. It's a 10x everywhere.
That is quite a significant fire. A rather successful evacuation to only have 3 injuries. I read from an eyewitness that there was a crackle from a luggage rack which can potentially suggest a battery fire from a personal electronic device.
Sure, why not. Krugman could be lying about the reason for his departure. In fact, maybe he left to avoid embarrassment from the public revelation of his illicit economist-on-editor sex affair.

However, that's what might be politely called "unsupported speculation" aka "just making things up." Without evidence to the contrary, I see no reason not to take Krugman at his word.
Mmm agree to disagree, iPod classic is not a heavyweight device and the UX is what we had when I was a kid so easy AND nostalgic, but agreed the little sandisk clips solve the problem just as well.

Edit: I can't imagine swapping HDD for flash saves more than a few grams, can it?
It'll be interesting to see if the court has the authority to make this ruling.

I assume the administration will push this to the Supremes.

A pause is not a stop.

What people are worried about is that their program is going to be cut after the review. It's better to stop the review now before it starts by making a whole bunch of "the sky is falling" claims. The sky might be falling, but it doesn't hurt to panic.

If you look at the spreadsheet (which is hard, because it's a PDF), you'll see that each agency needs to list the political overseer so the administration can, if they want, find out how to kill it. As far as I know there's never been a list like this, ever. I wish it was a real spreadsheet because the objective text is clipped.

https://www.heinrich.senate.gov/imo/media/doc/instructions_f...
So, uh. I wonder if any of the vendors are going to see any of their pending payments, or if they're just up shit creek.

(For that matter: how many vendors will end up insolvent as a result of this?)
Are there any good AI-generated songs out there that are actually good to the point that you'd add it to one of your playlists?
Its operation at each scale would be very different, and it's not obvious how many different layers we'd need before we'd be at the smallest possible, but maybe.
Erode institutions to erode public trust in institutions. You then a) free up budget to spend on your buddies and b) derisk regulation and/or public criticism from these institutions
What's most offensive is having to pay for audiobooks on top a monthly subscription
i thought it was plainly obvious it was Santa testing new sleighs and all the sheep keep denying it.
Neither of those planes made more money than they cost.

The Tu-144 was famously not reasonable at all.
I wonder if space exploration will turn out to be no different than mountain climbing. There's nothing useful on the mountain, we can't live there, it's purely exploration, sport, and a feeling of achievement.
I loved bullet points before AI was a thing. Now I'm accused of being AI.
Reasoning:

.com is the best TLD by a long shot but it's really saturated, so as a startup you have no chance.

As you say, the hope is to make it and be able to buy the X in getX.com where hopefully you've checked that X belongs to a squatter and not an existing company (they're both bad the latter is worse).
It's mostly about domain names, real words are all gone long ago so people self-funding the early days chose the real words with modifiers.
What is business logic? What specifically is SQL bad at?

I’m not sold by your foreign key example. Constraints are great. I guess you can do that in python? Good like getting ACID right

As soon as your data stops resembling a tree and starts looking like a graph than all your “business logic” looks a lot like operations on relations and you are back to where you started.
I’m the CTO at OpsLevel, where we’ve been running a Rails monolith for ~6 years. We started on Rails 5, upgraded to 7, and are currently moving to 8. Before this, I worked on Rails at PagerDuty (including splitting a monolith into microservices) and on Shopify’s “majestic” monolith.

The best thing about Rails is its strong, opinionated defaults for building web applications. It handles HTTP request routing, data marshalling, SQL interactions, authentication/authorization, database migrations, job processing, and more. That means you can focus on business logic instead of wiring up the basics.

Rails isn’t as fast or lightweight as Go, but they solve different problems. For most web apps, the bottleneck is I/O, not CPU. Rails optimizes for developer productivity, not raw performance, and that tradeoff is often worth it, especially when speed of iteration matters more than squeezing out every last cycle.
Jailbreak not required. I use TrollStore/TrollDecrypt but I'm sure there are other methods.