skysight-inc/HackerNews huggingface dataset:
Disagree on the point and reasoning about the single database.

Sounds like they experienced badly managed and badly constrained database. The described fks and relations: that's what the key constraints and other guard rails and cascades are for - so that you are able to manage a schema. That's exactly how you do it: add in new tables that reference old data.

I think the regret is actually not managing the database, and not so much about having a single database.

"database is used by everyone, it becomes cared for by no one". How about "database is used by everyone, it becomes cared for by everyone".
Show HN: [x theme] oh-my-zsh alternative that supports ash/dash/bash/zsh (demo)
Implemented using posix shell and awk. Lightweight and fast. 20 themes x at least 6 scheme for each theme.
I spent 5 years of high school writing in a fountain pen as a leftie. For me, with good ink and good paper, it smudges LESS than a ballpen: the ballpen ink is thicker and takes a while to dry, so it doesn't quite smudge, but still leaves a slow-forming ink stain on the side of your hand. Fountain pen ink dries quickly and does not. However, different lefties write in different ways: I write from the bottom-ish.
They finished killing Cortana some time before starting from scratch with Copilot
I am good at databases (have been a DBA in the past), and 100% agree with this. RDS is easy to standup and get all the things you mentioned, and not have to think about again. If we grow to the point where the overhead is more than a FT DBA, awesome. It means we are successful, and are fortunate to have options.
This comment needs to be higher up.
> Startups don’t have the luxury of a DBA …

I understand, but I think they don’t have the luxury of not having a DBA. Data is important; it’s arguably more important than code. Someone needs to own thinking about data, whether it is stored in a hierarchical, navigation-based database such as a filesystem, a key-value stored like S3 (which, sure, can emulate a filesystem), or in a relational database. Or, for that matter, in vendor systems such as Google Workspace email accounts or Office365 OneDrive.
At 40 outside we're going beyond uncomfortable towards health threatening.
And tangential:

Nushell (300-400 comments),

- https://news.ycombinator.com/item?id=20783006

- https://news.ycombinator.com/item?id=27525031

- https://news.ycombinator.com/item?id=33419944

Ask HN: Are alternative (oil, nu, etc.) shells usable as daily drivers? (141 comment)

- https://news.ycombinator.com/item?id=34722208
Only people on the latest version get the latest Safari, that's the relevant number.

And I already addressed older versions. They get updates but only for vulnerabilities that Apple "is aware" are being exploited in the wild, not all vulnerabilities Apple has fixed in the newest version (yet Apple isn't omniscient about what gets used in the wild). And no updates for rendering bugs, as far as I'm aware.
It's not the little guy with his plastic straw that's the problem when the greater majority of waste is coming from the big corporations and dirty nations.

Then to top it off you have billionaires like Taylor Swift who uses their private jets to fly a 15 minute trip instead of taking a 25 minute car ride.

Give it another 50 years and the little guy will need to be eating bugs to be environmentally conscious while the people on top still do exactly what they did before.
> I think the account manager’s job at AWS or any cloud or SAAS is to create a reality distortion field and distract you from how much they are charging you.

How do they do this jedi mind trick?
It sounds to me like the jury felt that the harm was to third parties. Which isn't actually what the law says - the harm is supposed to be to the one defamed.

This is a problem because on the one hand, the jury should not have based its award on harm to third parties, because that would not have properly been argued before it. But it also means that defamation is not adequate to defend science, where most of the harm of attacking science is towards third parties.

I'd quite like to see lying in public life punished more harshly, because it is in fact corrosive to both public and private life. But it's going to be hard to frame 'harm to third parties' well, since it potentially covers a lot of political speech.
I’m still miffed that Dropbox killed Mailbox.

I’m a big fan of Notion but these hires/acquu-hires are a deathknell indicator. It means they’ve hit that point where the ideas have stopped flowing but the money hasn’t, so they start using the money instead of their own creative juices. It’s a shame because there’s still so many places Notion could improve.
So... passwords?

Your passwords will rely on:

* The cloud,

or

* Some specific computer

They can be guessed, leaked, or stolen
Awesome work! Can you share the titles of some of your favorite books or courses in controls and RL (for controls) that helped you in doing this project?
I see this argument a lot. Then most startups use that time to create rushed half-assed features instead of spending a week on their db that'll end up saving hundreds of thousands of dollars. Forever.

For me that's short-sighted.
> NOTE: Jan 2024: We have been slammed with thousands of requests (20 times the usual amount) so please be patient in the time it will take to receive your starter.
Good point. And, since you brought up financials, you also see this when people use a majority of their savings to lump sum pay off a mortgage. They take an overweighted view of saving on interest and, IMO, underweight the flexibility of liquidity.
> such a law obviously does not prevent people from using or learning their ethnic language

It is only one measure of many that is driving the rapid decline of indigenous peoples in Russia. Russia has a long history of methodical persecution of indigenous peoples with a wide arsenal that spans from closure of schools and suppression of media to made up charges about "extremism" and being a "foreign agent" to punitive psychiatry in the best Soviet traditions. Many languages and cultures have already become extinct like Native American tribes that were forced into conditions that caused a permanent loss of language, culture and identity. With official departure from the European Convention on Human Rights, the Framework Convention for the Protection of National Minorities, and other international treaties, Russia doesn't even bother to act like they care about human rights. The council that monitored how signatories enforced the framework convention used the same word in their reports about the situation of minorities as you did: marginalization, increasingly so.

And it's gotten much worse since Putin decided to invade Ukraine in 2022. Russia is now decimating indigenous populations by disproportionally conscripting them to die in Ukraine. Buryats and Nenets are overrepresented by a factor of 50 in casualties compared to ethnic Russians from Moscow. Two genocides for the price of one - trying to overwhelm Ukrainian defenders by throwing indigenous peoples from Russia at them.
Based in the USA office. They laid everyone off except for a handful of people last year. For the USA employees, the compensation is competitive with Tier 2 big tech depending on when you joined.
What on earth is a standby charge on gas?
Microsoft is there because Open-AI needs cheap infrastructure.

I bet that they can have the same deal with Amazon, Google, Oracle...
The referenced previous study (2023) was extensively discussed: https://news.ycombinator.com/item?id=36864319
But then you're addressing a different point to the one I made!

I don't disagree with what you're saying inherently. But the "sidestepping legal process" is crucial to why this is so problematic.
Some contrast to this comment: this is steamVR data which is not only specific to steam (which as pointed out in the article, is not representative of the entire market) but also mostly biased towards gaming.
Now I will concede that VR has mostly been “successful” with that demographic (gaming), in fact, oculus (now quest) is mostly making money solely on that sort of content… some people at Meta while I was there would even argue that this product should limit its ambition to be the “Nintendo switch of VR”.
Apple on the contrary has been setting expectations much more clearly that gaming is not in the forefront (but not excluded).
Whether it will be successful is another story, but we should still welcome new challengers in an industry / product category.
What happened to the excitement in tech everyone :-)
Can you recommend some resources to learn how to do the above? I would like to beef up my spreadsheet skills.
F-Droid 1.19.0 brings automatic background updates and a new workflow for repos
If your car key can be copied using a simple replay attack, it is not a key.
I'm sorry but "I don't see it" is not a good argument in security. Hailing a technology as "exploit proof" should be considered a non-starter.

Any security evaluation should be about thread models, attack surfaces, mitigation and trade-offs. Never "trust us".

Not knowing how a technology could be exploited is not a feature, is a liability.
> However, there is more liability on the PG&E for failure to adequately mitigate risk, and failure to asses and frontload charges for probable payment.

Mitigating the risk is pointless. Wildfires are a natural occurrence in California. The ignition source is irrelevant. The fire is happening, you can't stop it.

> I fully support them doing whatever makes them happy, as long as they don't expect me to pay for it

But that's exactly what they expect you to do. Their houses are in a tinder box. There is some absurdly high probability that they'll burn. And then they're going to want to play the sympathetic victim who has just lost everything in a fire and go to the government and try to get someone else (i.e. you, via PG&E) to pay for the consequences of their choices.

The traditional way of doing this is to make the insurance pay, but they didn't have insurance because the high risk was known in advance which made the insurance unaffordable. When that's not available, the lawyers have to find someone else to sue, and in this case it's the power company.
No, Jira loading is relatively OK and on par with other SPAs. It's got a CTRL+SHIFT+P style actions menu for tickets which helps cut down on point and click pain (especially for linking issues etc). Setting up statues and workflows and how they map to a board is relatively straightforward.

There are lots of things where Jira falls short, but the pain points on an under-resourced self hosted instance of ten years ago are nothing like the ones you'll find on Jira cloud today.
Agree. "What if you're wildly successful and get huge?" Awesome, we'll solve the problem then. The other part is what if AWS was a part of becoming successful? IE, it freed my small team from having to worry all that much about a database and instead focused on features.
I’ve implemented such a process for companies multiple times, bro. I know what I’m talking about.
> Multi-selectivities are good, but IIRC they can't be specified across tables and thus across joins, right?

Yeah, no extended statistics for join quals yet.

> how do you reconcile multiple selectivities?

Looking at https://doxygen.postgresql.org/extended__stats_8c.html#a3f10... it seems the aim is to find the stats that cover the largest number of clauses tiebreaking on the statistics with the least number of keys. For your example both of those are the same, so it seems that which stats are applied is down to the order the stats appear in the stats list. That list is ordered by OID, which does not seem ideal as a dump and restore could result in the stats getting a different OID. Seems sorting that list by statistics name might be better. That's what we do for triggers, which seems like a good idea as it gives the user some ability to control the trigger fire order.
There's a weird thing in online discourse, especially Twitter, where creepy, gross and disgusting stand in for moral judgements and enforcement of social norms. Maybe it's just a current style, or maybe people choose it because it's hard to argue against a feeling the way you argue against a judgement.

I feel, though, that it's infantilizing the discussion. We are not going to find common ground if, for example, one person thinks it's gross that people aren't masking up anymore, while another is creeped out by mask wearers. But these statements of feeling seem to tickle the algorithm better than statements of fact and discussions of public safety.
> * use LISTEN to be notified of rows that have changed that the backend needs to take action on (so you're not actively polling for new work)

> * use NOTIFY from a trigger so all you need to do is INSERT/UPDATE a table to send an event to listeners

Could you explain how that is better than just setting up Event Notifications inside a trigger in SQL Server? Or for that matter just using the Event Notifications system as a queue.

https://learn.microsoft.com/en-us/sql/relational-databases/s...

> * you can select using SKIP LOCKED (as the article points out)

SQL Server can do that as well, using the READPAST table hint.

https://learn.microsoft.com/en-us/sql/t-sql/queries/hints-tr...

> * you can use partial indexes to efficiently select rows in a particular state

SQL Server has filtered indexes, are those not the same?

https://learn.microsoft.com/en-us/sql/relational-databases/i...
Yes! So excited for this!
maybe due to https://www.theverge.com/2022/6/7/23159049/microsoft-hololen...
>making a single RDBMS server in a container

On what disk is the actual data written? How do you do backups, if you do?
No, but again, that sounds like a lot of complexity your average startup does not need. Multi-az? Why?
It does for a billion+ people who cannot afford aircon and use ceiling fans.
It's ok to make short sighted investment decisions based on current market position, especially when one of your biggest bets from the last decade is striking gold in a big way, and you need all hands on deck to reap maximum strategic value during the temporary opportunity window.

In that phase, it makes absolute sense to reduce or cut anything that is not CURRENTLY performing well, in favor of the area that is taking off and needs all the push you can give it. When the gen AI market stabilizes, ideally with Microsoft in a dominant position, it will again be appropriate to diversify bets. That includes pushes for markets where MS can grab 2nd or even 3rd place.
Having led a successful Bazel migration, I'd still recommend many projects to stick to the native or standard supported toolchain until there's a good reason to migrate to a build system (And I don't consider GitHub actions to be a build system).
I made sth similar to monitor my github followers list. it's a simple script to use github api to get followers list & diff each day.

https://github.com/tuananh/github-followers-watch/
Go 1.22 yielding a 18% regression in single-threading performance: Golang
Yes. I want to take part.
>>> to claim your free premium plan: Reply to this post expressing your interest
"make an http request" as in fetch() would be OK, but doing "classic" XHR in an interview? Hell no, I've got better things to do.
Opening with Firefox gives a full TOC: https://imgur.com/a/cgdy0nY
This kind of thing is why we stopped using the gold standard.

On the other hand, BTC prices changes are so wild that it makes gold seem like a constant-value asset.
That "no" is not so unequivocal. TOTPs have two use cases... 1) to prevent replay attacks, 2) as a second factor. While passkeys do the same as TOTPs for #1, they don't by themselves address #2. You may still want to use a TOTP that's generated by a separate device (physically different from your primary device) for #2. Of course if you're using the same password manager to handle both passkeys and generate TOTPs and have that on all your devices then your TOTP wouldn't be a real second factor. Ideally here you'd use one of those TOTP-only devices such as those old RSA "credit cards".
Reading further

> Endorse-ish: Schema migration by Diff

Well that explains it... What a terrible approach to migrations for data integrity.
100% agree. People still think that maintaining infrastructure is very hard and requires lot of people. What they disregard is that using cloud infrastructure also requires people.
I feel like Arc is just exposing a problem users have felt for a long time, but has been ignored: most of the web is now spam.

Ads everywhere, deceptive and janky cookie pop ups, low quality click bait journalism lacking substance (ie using hundreds of words to say very little) and publishing platforms charging for that garbage, sites that steal/scrape content and rank higher because of black hat SEO, people inflating content (like recipes, but that's always been a meme I suppose) so there's more breakpoints where ads can be injected, now there's also AI generated posts/articles (don't mean Arc using them to distil content)

The web has become toxic, and Arc just feels like a gas mask.

I use Arc for a few months now, and using this feature recently has been a breath of fresh (or filtered) air. On the other hand I also don't know how I feel about it in the long run. Some of the points in the article make sense, but also how long before Arc gets poisoned itself (which seems inevitable in tech)
Nice article. As someone who's also gotten into robotics from the software side, I'd also suggest learning a bit about the hardware side. If you're doing anything with custom boards and board bring-up, you'll need to be able to read a schematic and data sheet at a basic level. Being able to use an oscilloscope and logic analyzer is also _very_ useful. None of this stuff is terribly hard, but it's nice to know what to expect.
That's whataboutism. I'm not claiming my methods are unassailable. I'm disputing the notion that anyone can claim that about their methods.

The key difference is, I know the weaknesses on my approach and I mitigate for them. I'm not reaching for whishful thinking.

Anyone claiming security by "I don't see an attack vector" should be doubted.
Me too, some text, links, but no actual code or link to download.
That's for slower projects.

You know the old adage "fast, cheap, good: pick two"? With startups, you're forced to pick fast. You're still probably not gonna make it, but if you don't build fast, you definitely won't.
Confusing name considering Microsoft's DAX scripting language for PowerBI.

https://learn.microsoft.com/en-us/dax/dax-overview
It's rambling as you don't agree and are stuck in "bitcoin bad boo". Learn some things about life, buy some bitcoin and don't repeat stupid talking points formulated by others ...
I think no one talked about having physical server on their own premises but colocating servers in a data center or renting servers in a data center.
One other appealing alternative for smaller startups is to run Docker on one burstable vm. This is a simple setup and allows you to go beyond the cpu limits and also scale up the vm.

Might be other alternatives than using Docker so if anyone has tips for something simpler or easier to maintain, appreciate a comment.
This is also related to Godot
"The reason to make it optional is that Direct3D 12 support currently relies on the proprietary dxil.dll library from the DirectX Shader Compiler being shipped together with Godot, and shipping proprietary software goes against the mission of the Godot project."
https://godotengine.org/article/dev-snapshot-godot-4-3-dev-3...
The thing about zero day exploits is, no one saw them coming.

The whole notion of "this is perfectly secure trust us" should immediately raise warning flags.
Ruby on the Apple II (2019) [video]
Came here to say this as well. Using it in a side project and it works well.
Chose windmill because it allows me to upgrade to other backends when necessary.
A great overview of the terrible mess that underlies cross-3D-API shader compilation (and even though it focuses on D3D and Microsoft, it's not much better on other 3D APIs - for instance you simply can't cross-compile Metal shaders from a Linux host - only from macOS and - somewhat recently - Windows).

If the Mach team can pull off this whole "Zig as a cross-3D-API shader compiler" and make it work as smoothly as "Zig as a cross-compilation toolchain", then this would be pretty much the biggest thing in computer graphics since 1995 or so :)
Early on, depending on what you're building, you don't need a fully fleshed DBA and can get away with at least one person that knows DB fundamentals.

But if you only want to hire React developers (or swap for the framework of the week) then you'll likely end up with zero understanding of the DB. Down the line you have a mess with inconsistent or corrupted data that'll come back with a vengeance.

It's short-sighted for serious endeavors.
Where "local environment" is extraordinarily influenced by the flour you feed your starter with.

Which itself is influenced by growing location and conditions, storage, transport, and distribution, etc.

I'd be interested in seeing specific research on how much "wild yeast" and lactobacilli outside of the feeder flour actually influences starter. My strong suspicion is that this is somewhat less than is often considered, if only because of the difficulty of starting one's own sourdough from sterilised flour (bleached), which is to say, being highly dependent on wild yeast.

The other factor I suspect is the evolution of one's own starter culture based on conditions (feed frequency, temperature, flour, storage conditions, light/darkness, etc.) in which it exists.
With a bit more digging, but very similar https://nee.lv/2021/02/28/How-I-cut-GTA-Online-loading-times...
I am having trouble replying to this thread and the one 3 hrs later. This looks great. So it will give me info on my site visitors?
rental period is a month
you can also use hetzner cloud, which is still roughly 10x less expensive then aws and that does not take into account the vastly cheaper traffic
Django SQLite Benchmark
Sorry for the newb question, I have a custom domain and have set up MX records, etc., to point to skiff.

Does anyone know how to switch these out to point to another provider, e.g., purelymail/fastmail/proton, without downtime? I mean I would not like to miss emails during the transfer. Is that even possible?
But who is going to buy expensive credits that actually do something instead of cheap credits that don't? At that point you're just making a donation and the concept of "credits" no longer has any relation to what is happening.
Building for DOS, OS/2, and DOS on a MacBook Apple Silicon
They developed MSFS 2020, which is the killer app for VR headsets, and announced a successor already. At least there seems to be some strategic misalignment.
Yeah that. They enter every single market, deliver a half-assed broken product with dubious gains and expect to pick up business and when it doesn't they shelve it, even if the market is heading in that direction. At the same time they compromise their core business with the fads they pick up because attention is diverted. Can you imagine what it's going to be like getting all the unused AI crap out of windows and office when the inevitable incoming AI winter hits.

Dear MS, can you please just concentrate on your core business. We know it's dreary but we just want Windows, Office and AD that doesn't suck balls.
Germany's days as an industrial superpower are coming to an end
Well you shouldn't have sold as that bolsters my argument. Also, "you're jealous" fits perfectly here by your own admission.

1 more, just to seal this, nothing has changed for bitcoin 10 years vs now. It's you who changed, but I'm guessing, wishes you hadn't.
From the linked post:

"This deprecation does not impact HoloLens."