skysight-inc/HackerNews huggingface dataset:
This.

I've heard countless times that Postgres is better and I've watched talks where they show how loosey-goosey MySQL is with some things but I know how to backup, restore, tune, secure and replicate MySQL. I grok it's permissions in depth more than I ever have with Postgres and I've even written a mysql plugin in C so I have that in my toolbox if I need it. So I'd by default, usually go with MySQL (or in some cases SQLite.) but if I didn't have to administer or maintain it, and someone else was handling that I think I'd be fine with Postgres too.
I've been using MariaDB (MySQL) as a hobbyist for years. I just set up a couple myqsql servers with phpmyadmin on Raspberry PIs and use them for local development. Basic crud apps, etc.

I've always assumed that PostgreSQL is a step up, but never really bothered to look into what I get for the effort. Do I really get anything if I'm not trying to make apps at scale?
Friends dont let friends use #Horracle software.

That includes VirtualBox, MySQL, Horracle Cloud. Just step back. Walk away. Do not pass go, do not collect $20000 lawyers fees for unintended actions.
Good to know! I’m starting a project that will use location, and I chose Postgres, I’m happy to hear this :-)
Its simple AF - I just always pick the well proven PostgreSQL database.

... if that is too big I use SQLite.
They are only equivalent to a very limited goto, not the unlimited sort that Dijkstra's letter was primarily about.

A continue or break can be replaced with this:

while (some_cond) {
if (whatever) continue;
if (whocares) break;
}
=>
while (some_cond) {
next:
if (whatever) goto next;
if (whocares) goto after;
}
after: ...

EDIT: added break into the above, forgot to earlier

Note that it stays within the same scope or, in the case of a break, would just escape that scope. The sort of goto Dijsktra wrote about would let you do things like this:

void foo() {
while(some_cond) {
next: // how did we get here again?
...
}
}
void bar() {
goto next;
}
I think only rich people say the poor need financial intelligence and then they make things like Robinhood so the poor can feel like they have financial intelligence while losing money and the rich get richer.
I don't personally understand why you would use their hardware for anything considering each of their devices have industry leading competitors that people like more.

I think you have to just want to buy their hardware. They're lifestyle devices.
The wonderful part of this is that you get the choice.

Choose where you live, who you have for healthcare, who you use for childcare/schooling.

We have the opportunity to make that choice instead of having a bureaucracy making those choices for us.
> Will IRS refund said workers the payroll taxes workers paid as part of their Schedule-C?

If my understanding is correct, merely the fact the IRS has officially made this classification entitles those workers to a refund, even if the IRS never manages to collect the money from FTX.

A nice big fat bonus paycheck for the workers there!
Dijkstra wrote what he wrote and chose the words he did because he was Dutch.

To some extent Anglos will never understand.
"Code smell" is especially ambiguous and annoying.
It doesn’t seem ridiculous if you’re a professional whose life revolves around voice recording. Seems like prosumer quality pricing.
wow, I guess mass shootings are no problem at all and when they happen we should be like, "so what? 3000 people died of cancer today, who cares if some kids got their faces blown to pieces". thanks for clearing that up! problem solved
Ah yes, the just world fallacy of layoffs makes its unsurprising appearance.
I think it's important to remember that Dijkstra was a bit of a troll. Well actually, not just a bit. Like, really, really a troll.
We should probably do "Falsehoods Programmers Believe ..." one, called "Falsehoods People Believe About Falsehoods Programmers Believe."

Ted in Marketing insists on a last name. That field is how the cold callers sort.

Your boss' boss made promises, there's no time to cover all of these edge cases you keep talking about.

Shipping says we don't serve India, anyway, so why are you making us go through this?
> They would certainly have done the same to us

And it would later be justified as it being necessary for the US to surrender, and maybe now we would be discussing in Japanese how a couple of US cities are much nicer some 70 years after being nuked.

Either way, this is already far beyond the point of the thread.
Sorry, but var is absolutely still a thing. It has plenty of valid use cases and sometimes using let just needlessly complicates the code.
Or they'll just keep building solar, wind and power cables to keep up with the increased demand from this transition.

This would be a good thing.
> No classes in JS was much better than with.

I think you experienced a different JS than I did. JS has always had classes, they were just "harder" to build/use and every "Framework" had a different mixed bag of "utilities" and patterns to work with it and they weren't always compatible. (Mixing jQuery style classes and Dojo style classes was "fun", for two random examples. I could go on all day about the long tail from MOO Tools to YUI to Backbone to…) ES2015 class syntax just standardized already common patterns and increased interoperability and cleaned up a lot of footguns regarding Prototype-style inheritance along a "garden path".

The class syntax garden path is much nicer than the weed-filled hedge maze it mostly replaced.
In which case Apple could notice that 600 tags from the same guy tend to float around you...
Don't even need manic episodes to understand this (and if you went through one I'm terribly sorry, they can be such cruel events people disregard), music is a good example. You can be so profoundly moved by a song in an entirely different language you don't understand not because of writing, but because of what the person conveys through sound. Instruments as another example of this.

What our thoughts are made up of visuals (shapes, lights), feelings, and sounds. Not words, however words are convenient shortcuts to communication so we use them a lot. This is part of why we continue trying to understand animals. It's also why multilingual people will have these jarring stops in speaking/writing, and struggle to connect those visuals/feelings/sounds in their mind to the expression (speaking/writing).

It's literally the reason that "love" is so elusive to us. Despite numerous people trying their best over centuries to express it in writing, music, art, etc. it's still this profound feeling we feel has endless potential. We know it's just brain signals, and yet it continues to be deeply embedded in our thoughts.
Unfortunate that the repo name and header text of the README both misspell “programming”
You don’t have to like your opponent’s strategy, but you also don’t get to decide whether or not they use it.

The goal is to cancel BS “inflation reduction act” spending that was approved prior to the House having a Replublican majority. This is their chance to do this.

And considering the threat “dumb” is naive. There are just as many scorched earth conservatives as liberals.
When I hear animation I think of 3D character rigging in a 3D engine with animations. This seems to be text-to-video?
Because a big aspect of intelligence is compression and decompression. As people age they have more context already available so there is more to draw on (automatically) when solving problems or learning. So less distance to get there.
Musicians Are Already Using AI More Often Than We Think
Fast fashion but slow progress at loss-making Asos
My civility seems to be struggling today, thanks for pointing this out!
One big factor that keep us on MySQL is the MyRocks engine. We have huge databases with billions of rows. The MyRocks enable the use of it with heavy compression, that PostgreSQL can´t handle it, as it is much slower and uses 30x more disk usage, even with heavy TOAST tuning and/or ZFS compression.
yeah to me a field-recorder with transcription is aimed at least somewhat towards journalists who can't even come close to affording this
I got to fiddle around with one. I have probably average sized male fingers, and it really wasn't a problem at all. Tbh if there's one thing you can pretty reliably count on TE for it's spectacular minimalist design, but if there's a _second_ thing it's thoughtful ergonomics.
You only see the curves go upward. But if you look very detailed, you see that a plateau is coming. A downward trend will follow.

When the going gets tough...

About the inequality : it is really bad, but hundreds years ago, the poor were starving because of lack of food, in stark contrast with landlords and knights and kings.

Today an equal amount of or more, people die from too much food than of too little.

My point is, you need to take a step back and look from a bit more distance to see the real trend. Things are bad now, because we are at a maximum.
A better analogy is my wife took out a mortgage in my name and I’m refusing to pay it.
What keyboard do tou use for text input?
That may need a million tokens just for one book, though!
Starship isn't the ticket to colonizing Mars despite the hype. They're just not big enough to bring the people and the goods they would need to even tenuously subsist for a few months at least not the 100 per ship Musk claims would be possible.
Not an expert on fusion reactors so possible that might not happen this near in the future. Possibly who knows? There might be a possible alternative by the time then. Right now there's only 1 design that has a positive gain. There might come more.

reference: https://en.wikipedia.org/wiki/Fusion_power#:~:text=Research%....
when any regex interpretation doesn't work like bbedit regex, i still feel like it's broken
Being a true passive investor is much harder than most people think. We are flooded with stories of "amazing opportunities" and "systemic risks".
https://en.m.wikipedia.org/wiki/Solar_water_heating
In FTX’s case it’s impossible to hold your keys, right. The condition to get interest payments is to allow them to manage your funds and invest/loan/etc.

Is there any crypto “bank” that promises to pay interest while you hold your own keys?
I enjoy coding… there’s feeling of personal power that coding gives you, and I like problem solving. I’ve been working on 2 saas oriented projects, one focused on real estate industry, and the other on support for entrepreneurs or would-be entrepreneurs.
Ask HN: How are LLMs improving or worsening your life?
The only real problem with Javascript is people's lack of understanding of it - and it's not even that difficult.
“Palm 2 Full Breakdown” by AI Explained
"Four main takeaways: 1. PaLM 2 is competitive with GPT-4. 2. Google is not saying much about parameters or compute, but smaller than GPT-4. 3. Gemini is already in training and intended to rival GPT-5 while arriving much sooner. 4. Google talks a lot about safety in specific contexts, but not about AI safety more broadly."
You could seek permission from users to let you use their data to build a model to provide guidance.
> I’m really amazed you thought that 7% yield from savings at a time of 0% interest rates was anything other than a fabrication

Necessarily risky. Not necessarily fabrication. Between those two there is room for both productive gains and delusional optimism.
Pricing is the same as the base model.
Lol what? FTX stole everyone's money, the IRS is just collecting what is owed...
I can't think of any store that caters to this specific type of thing. And now that you mention it, it's a real shame. Neiman Marcus and Nordstrom sell a lot of Veblen goods, not necessarily actual high-end anything.

Costco sells actual high-end products, but they're very limited in their selection. For various products, people in the know don't use them. However, for example, flashlights they sell from Duracell are stronger than anything you can pickup from Home Depot, curiously.
This company is the best kind of self-indulgent. The product looks incredible and probably will be a joy to use. It's neat to see hardware that's not commoditized.
>> I’m sorry for your loss but I’m really amazed you thought that 7% yield from savings at a time of 0% interest rates was anything other than a fabrication.

The guy (SBF) was hanging out with and appeared to be anointed by Gensler and crew https://www.sec.gov/about/commissioners/gary-gensler. How much due diligence does one expect common citizens to perform?
> but major version upgrades are much much more of a pain on Postgres than on almost any other system I have ever used.

This is a thread comparing MySQL and Postgres and your claim is that postgres is harder to do major version upgrades than anything you have used??

Context is important here, have you honestly actually upgraded a MySQL node? It’s a lesson in pain and “major” version changes happen on minor versions, like the entire query planner completely trashing performance in 5.6->5.7

Postgres has two forms of updates:

1) in place binary upgrade.

Fast, clean, simple, requires that you have the binaries for the old and the new database.

2) dump/restore.

Serialise the database into text files, load a new database and deserialise those files into it.

Slow, but works flawlessly & consistently with relatively low danger.

MySQL can only do option 2.

You can sort of fake an “update” by abusing the fact that MYSQLs replication offers no guarantees, so you can make a new server a replica; then roll over. But it is impossible to know what data was lost in that transition and MySQL will happily continue without ever telling you.

I have experienced this behaviour in large e-commerce retailers. MySQL was very popular for a very long time and I am intimately aware of operational best practices and how they are merely patching over an insane system.
Also I agree with the quote. But I also believe what we predict/expect never happens. So in some ways we can never run out of the possibilities of future however much we predict
I think it's reasonable to believe in efficient markets, but also understand that pricing in markets is a) made up of imperfect information, and b) subject to outside influences like emotion, propaganda, etc.
Gee, I wonder why the SEC isn't happy about exchanges selling unregistered securities to retail investors. They should absolutely have cracked down on it way earlier, but unfortunately regulatory agencies work rather slow.

You threw your money in the local wishing well and are now upset that it got confiscated with your money inside it for unpaid taxes.
Dear Chat GPT. Happy Thursday. How can I use you to make a software platform worth millions of dollars. Thanks, zerbin.
Ironically Abel himself died at age 26. Even Amy Winehouse lived longer.
These devices are ostensibly toys for rich people, but really more like advertisements for their product design services. You're supposed to see the TP-7 as a CEO of a hardware startup and want to hire Teenage Engineering to design the shell to go around your prototype.
There is ZERO 'incompetence' --> it is skilled fraud. Madov level.... this guy needs to not kill himself with a sheet in prison.

This is a guy who is an utter piece of shit, and his FN STANFORD parents were certainly in on it and they need to go down as well, but they are a smoke screen.
Never is a long time. QUIC isn't great for this, because while it has IP address flexibility, it's not designed to have multiple paths simultaneously active.

If you design for this use case, you can make it work today; especially since the user is on a video call and only asking for the audio to be glitchless. Sending audio over both wifi and cell is possible and simple and would solve audio at the expense of double the audio bandwidth. More bandwidth efficient methods are left to the reader.
I suspect they mean "dry" as in "not damp from washing" not "dry" as in "dehydrated". Lots of people wash their mushrooms, which can lead to them cooking down soggy.
10 seconds? Slight exaggeration, surely.
If you are using .NET then Postgres might be better choice. (much better support for drivers and default ORM).

If you need replication go with MySQL.
“Designed for humans”
Because threatening a law enforcement officer is actually illegal. and your scare quotes don't make it less of a crime.
I was in the middle of writing a reply to the comment you replied to, when i had to stop because my app was crashing in staging, because i had written a unit test for integration code.
I, uh... what? This doesn't track. At all.
Pretending that all those people have had equal success, or that poorer parents don't have a significantly worse time of it than more affluent groups is not helpful.

There is A LOT of child neglect here in the states, and plenty of children literally do not make it out alive.
In an ideal world we’d have a network of trusted people that feed trusted event highlights and leave it to ai to fill in the gaps or detect bias. At the moment news is just a collection of episodes and arcs aimed at maintaining a constant state of fear and anger - emotions familiar to all of us. We are designed to pay attention to danger and the media knows this. We should detoxify it. It’s done enough harm.

Edit: after reading some of the content i really like it!
For some people, the concept of just existing without experiencing something grand or new, is a waste of life. Imagine, doing the same thing every day until you die. For some people it is peaceful and wonderful. The joy of existing. For others it is a horror. Stagnation and rot.

I used to be the former, with a great fear of missing out on all life has to offer. Lately though I'm the latter, realizing the immense joy in existing.
Yep, same here. I never read things with these sorts of titles.
The North American development pattern is unsustainable. It costs more money than to maintain than could possibly be paid for by property taxes. It's wildly inefficient in basically every way.

We've been okay for a while since we use the influx of cash from new developments to support our existing maintenance obligations, but that adds new maintenance in the future.

It's functionally a Ponzi scheme, and now it's starting to unravel. It'll happen in the U.S. too, just slower since the U.S. is bigger.
I'd be likely to use this in my daily workflow if it was a chrome extension that could simply modify headlines and article text.
The only way to pay down the debt is massive tax increases on the wealthy. The same way we did it in from 46' to 80'

https://www.longtermtrends.net/us-debt-to-gdp/
It's weird that red teams for war are experts in war. But red teams for AI are humanities departments, who dont understand humans or AI. It's such a boring reaction to LLMs and pretends that LLM ~= AI.
Show HN: Track and bill users' AI token usage through an API
Nowadays, everyone's building an AI app, but they're not pricing their apps fairly. Each user should be billed separately based on their GPT token usage, and many developers aren't tracking tokens. Instead, they just give a fixed price for their users, which isn't equitable. This is what I built Tiktokenizer to solve, it allows you to use OpenAI's GPT models and track each user's token usage through a single REST API. You could then use this API to get every user's token usage and bill them accordingly.
Assuming their employer sent 1099s to the IRS like they are supposed to, it's unlikely that any significant portion of them ended up dodging their tax burden.
So what is motivating to you in your career?
That assumes that the speed of light is an insurmountable speed limit. We can't be 100% sure of that.

But even if it is, TCP can be used with any latency if you configure the timeouts accordingly and maintain a large enough send buffer to allow retransmissions.
Well, there was some hand-waviness claiming that GUSD was FDIC insured [1], and they kept comparing it to bank accounts. I will admit that I should have done more research before putting it in, but I just assumed that since Gemini was ostensibly working with regulators and they were plastering the safety of GUSD everywhere, I guess I just didn't do my due diligence. I'll accept my share of the blame.

[1] https://www.gemini.com/dollar It still mentioned "FDIC" stuff in small print, but it was much more prominent in earlier stuff.
I feel like I'm the only person who isn't a fan of Teenage Engineering's design. It's all a bit too uncanny valley for me.
The prospect that this type of tech could proliferate is politicians' and political media's worst nightmare lol. Imagine everyone putting a boring filter on CNN, Fox News, and political Twitter. Politicians would have to run on policy platforms again, which has become almost unthinkable.
Node.js has been on par with Java for many years now due to the Jit and tons of money google has pumped into that ecosystem: https://benchmarksgame-team.pages.debian.net/benchmarksgame/...
But then it’s nasty blackout. Somebody still needs to design electricity grid for one of these very rare events.
Ferdium: All your services in one place built by the community
Oh, so the fruit is just being used as an electrolyte, not as actual energy storage?
In the old days, I am told, BBC newsreaders read the news, and on days when not enough had happened, proceeded to play music for the remainder of their timeslot.
Really makes me wonder what the European tech scene is like. I might be living in my North American tech bubble but I rarely hear about large tech conglomerates coming out of the EU nor any "revolutionary" products.

Is there just no investment? What is the US doing that Europe isn't?
Isn't this what SkyMall used to be?
If there was ever a product page that needed a video...

Spinny jog wheel thingy is lovely. And apparently it moves while you're recording? If you put your thumb on it to slow it down does it pitch the audio up on playback?

It's not how I'd spent $1,500 but I'm glad it exists. Irritates the same itch that makes me want to buy an old Nagra SN. (Which is also not how I'm gonna spend multiple thousands either, but I get it.)
There are already a lot of products that are constrained in various ways from moving across state lines. Alcohol is the poster child, but it's a long list chock full of mundane items. For example, you can't ship a shower head to California unless it has a 1.8GPM flow restrictor on it.
Here's a good place to start:

https://www.sqlite.org/whentouse.html

https://www.sqlite.org/quirks.html

Full-scale RDBMSs, especially Postgres, have lots of goodies that either SQLlite doesn't have (or which it does have, but which aren't so richly featured). Once you've gotten hooked on a few of these, the distinction will feel a lot more clear.

Meanwhile the tipping points in favor of SQLite seem to be embedded systems, and its whole "service-less" architecture and plain ease of use. Which is why it still gets lots of love, for those contexts.
Agree that the new USB-C soldering pencils are sufficient, after using my Mini TS80P for a bit I sold my old station and never looked back.
This is fantastic advice. Another way to think of it: "The days are long but the decades are short"
When I did my own withholding, I had to withhold Medicare and social security taxes on my employees behalf and deposit it quarterly. These are certainly taxes and there is withholding for the employer portion as well as for the employee portion withheld on their behalf along with income and any other applicable taxes.

Here’s a quote from the IRS [0]:
“ An employer generally must withhold social security and Medicare taxes from employees' wages and pay the employer share of these taxes.”

[0] https://www.irs.gov/businesses/small-businesses-self-employe...