noxer

I have 8+ million rows added daily to a 100+GB DB. There is a limit somewhere but I haven't found it yet.

I have a 100GB SQLite DB in use that gets 8+ million rows added dally. It's on an off-the-shelf nvme SSD in a "server" that I build from 5+ year old parts.

Those are writes not hits so not directly comparable.

As for the DELETE issue the easy solutions are:

-Delete it batches

-Delay between batches

-Preload the rowids before deleteing with SELECT (Select does not block)

Additionally if data was added sequentially primary to the same table the data is likely stored this way in the file and deleting it in this or in reversed order can be faster (depends on storage medium and other factors).

No, its 99% binary equal and there are no rounded corners in window 10 anyway.

I know that no one who uses it likes to reinstall it unless absolutely necessary. Its pointless in this case so what's your argument? That people should waste more time becase they already waste time? Genius /s

So you suggest switch over to LTSC for having the exact same OS because it's better? Make it make sense pls. I'm confident became I have tired it all and LTSC has zero benefit and only possible downsides. All the benefits it once had are irrelevant nowadays because windows 10 is EOL and there are no more annoying updates regardless of which version you use.

Try read maybe? There is no benefit to switch to LTSC because normal windows 10 is EOL there are no updates/no features updates and thus all the benefits LTSC HAD are moot. Its a total waste of time to switch to LTSC. A clean switch needs a full reinstallation.

If you would acctually read the comment(s) then you'd understand that SWITCHING has no upside, all your arguments are irrelevant there is no point in wasting time to switch the OS version especially not if you need a full reinstallation. And whether you like it or not there are bad coded software out in the real world that do not work on LTSC they will just error out saying this is not a supported version of windows. To fix this you have to regedit your LTSC installation to pretend to be a normal installation. A hassle no sane person would recommend for absolutely zero benefit.

Some "bad" coded programs have hard-coded version check and check for the OS name instead of build number, if they forgot LTSC (and server and education) the software will refuse to run on these version. Some reg edits can fix this but its a pointless hassle, there is no need to use LTSC today there are no more annoying updates and unwanted features being added. I have a windows 10 pro machine here running since 3 month 24/7.

There are no update, windows 10 is EOL since months and even before that it did not receive any real updates in a long time. The current version is stable and gets only security updates just like LTSC. There is no point to switch, at best its a waste of time and worst you could run into issues with software that expects home/pro and not LTSC.

This is bad advice that is being repeated over and over by the so called tech influencers. You go to an older version that only got security updates so you will lack optimizations and features already in the current stable windows 10. And for the foreseeable future you gain nothing at all. If one day the normal version acctually stops reviving security updates, it almost certainly will be possible to switch the update channel to LTSC and get the LTSC updates that way but for now this is not needed and the switch is unnecessary Also without some trickery, switching to LTSC requires a complete reinstallation, which for most people likely wasting sever hours.

Aside form high powered stuff you can get away with pure lead bullet.

See https://news.ycombinator.com/item?id=47771707 for the rest.

Lead melting is not difficult. The brass case you can just collect used ones. The primer would be harder to make (you can buy them online ofc) but with access to fireworks it is possible with no knowledge of chemistry and no realistic risk of losing body parts.

The guy who killed Shinzo Abe didn't need any of these things and still shot him.

You can make bullets yourself just like you can make the gun. You may remember the assassination of Shinzo Abe.

In the US low powerd black powder is super easy to get you don't even have to take fireworks apart or do home lab chemicals stuff.

Everyone who has money to spend to influencing politics this way. I personally don't think its some kind of shadow cabal. Its many people/groups/organizations with aligned interests doing these things.

Organization isn't the issue that is of course perfectly normal. But stuff like handing out printed signs, protestors posing for photos in a way that makes it look like the crowd is much larger than it actually is. These kind of things aren't necessary if there is a real significant % of people unhappy enough to go protests. There are also faces known that travel from protest to protest. It's of course their right to do so but it seem strange nonetheless. Maybe they are just filthy rich and have no hobbies or maybe they do in fact get paid and are part of an organization that lets them jet around for free to be a protest groupie.

Many things do, mostly people on Twitter seem to get under his skin quite a lot lol.

If the goal was to "trigger" him I don't think the protests succeed in any meaningful way. Innocent Tesla owner where the primary victims followed by share holder, (damaged) property owners and people affected by insurances premiums due to the vandalism.

And then of course there are still a handful of people in jail for crimes committed in relation to the Tesla protest. Arguably not victims but still a negative effects that clear outweigh any perceived positive effect it all had on Musk.

Again another goal post moving and inventing some claim that were not made in this thread.

I never made such statements, I refuted the parent posts statement that the protest against musk "won" that's all I did before the goal post moving replies came talking about DOGE.

Elon Musk's role in DOGE was limited because he was designated as a "special government employee", a federal employment category defined under 18 U.S.C. § 202 that restricts service to no more than 130 days in any 365-day period.

https://www.law.cornell.edu/uscode/text/18/202

This was publicly know back in February. The exact date wasn't know since it was not public when he because such a "special government employee". It turns out they started counting days straight from the inauguration date or rather the Executive Order 14158 (Creation of DOGE) date which was on the same day.

It is totally accurate to say he left as planned and thus also totally accurate to say that one of the statements above claiming the protest "won" by pushing him out of the administration is factually incorrect.

You are moving the goal post. I never said DOGE did achieve anything.

You said the protest lead to him no longer be part of the administration which is factually incorrect. His position was limited from the start and he left as planned.

Bring better numbers that show where the protest "won". I wasn't the one using the stocks as metric for "protest success".

I didn't leave it out, it doesn't matter to my point. I refute the part about "winning" because clearly the protest did nothing to Musk it only had severe negative effects on thousands of other people.

He left his position as planned from the beginning, the protest had zero effect on what he did trough DOGE.

They didn't care about Tesla they wanted to "hurt" Musk Musks net worth is about $270 billion more today compared to when the protests began. Does this look like winning?

They protested un-elected president Musk who will stay in power forever. Then he left his position exactly like communicated from the very start and people now think that they won, even tho they only annoyed tesla dealership employees and tesla owners.

The article seems deliberately misleading for example the "F-5s, which the U.S. Air Force retired out of service in 1990" is of course still in use in the Navy and Marine as well as in China, South Korea, Iran, Brazil and probably other countries.

Also the F-35 is an always was highly controversial in Switzerland from the very first day it was publicly considered that was around 2017. In 2020 the people voted in favor of the F-35 with 50.1% support. So the reality is that any and all reasons to stop or delay the purchase of these jets will be uses by the parties that opposed the purchase, it has little to nothing to do with the so called "trade war".

This assumes that people involuntarily paid for the last 60 years or so but they didn't. USAID was paid for by money printing and more debt making not by taxes. If you want volunteer to chip in they would first need to pay of the debt causes by USAID over the last 60+ years.

Also lets be real here, no one in their right mind would donate to USAID. There are near unlimited way to donate money for good causes and very specific ones, where you can see results. If your goal is to have your money be efficiently used to help people you would never give it to the government. Any other organization that isn't straight up a scam, will be more efficient than the gov.

This is pointless math instead of bad math. 0.1% isn't the issue, the issue is that it isn't actually paid by taxes, it is instead paid by money printing. It's not 0.1% of peoples taxable income going to USAID, it's billions in additional debt that is "funding" USAID.

The actual true cost to the people for the additional debt is hard to measure and likely hits a different generation that the people who created most of USAID. Instead of saying people payed 0.1% to fund USAID you should say they made at least that much additional debt every year. You could not spend 0.1% more than you earn over the course of like 60 years but USAID did that for everyone.

You can get one that's only visible under UV light, but given the topic here it might be relevant to know that these are much harder to remove and also if they age they may become visible under normal light and/or stop fluoresced under UV light.

Normal rust can already do this. For example #[no_panic] attribute is implemented in https://github.com/dtolnay/no-panic crate.

Instead, use a range negation, like [^%] if you know the % character won’t show up. It doesn’t hurt to be a little more explicit.

This is absolutely horrible, pattern are fairly readable if they follow the syntax logic. Matching "everything but that random character that will not appear" is absurd. Also the idea that a . (dot) behaves arbitrary in different languages shows a sever lack up understanding about regex syntax. Ofc you can't write a proper pattern if you don't know which syntax is used. If anything you would force override the behavior of the . (dot) with the appropriate flag to ensure it works the same with different compatible regex engines.

Whether the people are employed by the government directly or a different entity isn't relevant at all, the relevant part is taxes being used for something that has an undefined benefit for the people who are forced to pay for it. (And in case of "no string attacked" even has an undefined goal.)

give Europe as a whole the ability to contribute its vision

Who's vision? The peoples vision? Or the vision of bureaucrats, politicians, lobbyists etc.