bacon_pdp
@bacon_pdp@lemmy.world
- Comment on Well, shit. 1 day ago:
The key part is while the query is active.
Also you are not doing hard deletes on the main table but only on the _A table. As you can always retrieve the main table values from the _A table (which only deletes records based on audit_date when they have aged out) and that is not something that the user or even any of the service accounts will have access to do. (Only a specialized clean up job on a restricted account would have delete permissions on the _A tables and access to nothing else)
- Comment on Selfhosting Sunday - slrpnk edition 1 day ago:
It is actually a dozen different communities that I know of.
Local drug dealers, the local police department, local firefighters, End of the World preppers, black panthers, some old school ham radio operators, socialist rifle association and a bunch more (and honestly since anyone can join, there is definitely more than that)
- Comment on Selfhosting Sunday - slrpnk edition 1 day ago:
The pool is a set of micro-atx servers each with about 100TB of storage that provide core services.
The mesh network is approximately 400+ routing nodes capable of providing access to 100k people in the event of emergency (other people are able to add their own nodes into the mesh network, so the details change daily); the standard has 96 hours of battery life and enough solar panels to provide 24 hours worth of power in 2-4 hours of sunlight.
- Comment on Selfhosting Sunday - slrpnk edition 1 day ago:
We are installing new solar panels so that the “pool” will be off grid 24/7 and thus the local mesh network will have access to a world of educational materials and entertainment regardless of weather and the ISP situation.
- Comment on Well, shit. 2 days ago:
If you need to speed up your deletes, might I suggest not storing data that you don’t need. It is much faster, cheaper and better protects user privacy.
Modern SQL engines can parallelize the loop and the code is about enabling humans to be able to reason about what exactly is being done and to know that it is being done correctly.
- Comment on Well, shit. 2 days ago:
Another company that never had a real DBA tell them about _A tables.
This stuff is literally in the first Database class in any real college.
This is trivial, before any update or delete you put the main table (let us use table foo with a couple columns (row_id,a, b, create_date,create_user_id, update_date and update_user_id) in this example)
For vc in (select * from foo where a=3) Loop Insert into foo_A (row_id,a,b, create_date,create_user_id, update_date, update_user_id, audit_date,audit_user_id) values(vc.row_id,vc.a,vc.b, vc.create_date,vc.create_user_id, vc.update_date, vc.update_user_id, ln_sysdate,ln_audit_user_id); Delete from foo where row_id =vc.row_id; End loop
Now you have a driver that you can examine exactly the records you are going to update, along with ensuring that you will be able to get the old values back, who updated/deleted the values and an audit log for all changes (as you only give accounts insert access to the _A tables and only access to the main tables through stored procedures)
- Comment on How long do we have before PCs get locked bootloaders and corporations ban installation of "non-approved" software? (for context: Google is restricting sideloading worldwide on Android ETA 2027) 1 week ago:
That is already a thing in ARM laptops
- Comment on That's an impressive drop. Any ideas why? 1 week ago:
Notice it goes down over periods of time for which the political party in power is against women having bodily autonomy or rights?
And goes up when leftist policies such as expanding access to healthcare are introduced.
- Comment on Another win for the blind 1 week ago:
What is in the image?
OCR is not showing any thing
- Comment on Friday Merch Roundup — Star Trek: Resurgence Comes to Switch, EXO-6's Next Gen Captain Chair, and More Raktajino Mugs 1 week ago:
The 1/6 size is the only thing that makes me sad. I wish I could find a place that sells a full sized version of this chair.
- Comment on Who is the enemy? 1 week ago:
Wow, I always thought every bad grade meant that I needed to get my child more help studying the material that they performed badly on. (Even bad teachers with fair tests can give one a chance to figure out what they are bad at teaching and get my child the help on those subjects outside of their class).
The only type of teacher that I ever had a problem with was one who was not fair in their tests. (Like seriously, it is a math test and their answer is correct but you marked it wrong because they used a different method than the one you taught in class???)
- Comment on Who is the enemy? 1 week ago:
God, wtf.
We always went out of our way to help the teachers whenever possible. We donated any and all supplies that they asked for and gave them gift cards for Christmas. We supported them actively when they protested for better wages and other benefits.
What sort of monster would hate the very people who you trust with their own children?
- Comment on what are the grievances with the "male loneliness epidemic"? 2 weeks ago:
Well as I am trying to work as a matchmaker, that is the sort of people who are willing to pay me to find them a partner who is compatible.
- Comment on what are the grievances with the "male loneliness epidemic"? 2 weeks ago:
I can’t speak to men’s systemic issues as I am not a man.
But if you pay a matchmaker to find a woman who is compatible with you and your desires; realize that me telling you these things are deal breakers for the type of women that you want and you need to either address them or expand your definition of what you will accept because here are women different than what you expressed desire for who might not have an issue with the previously mentioned deal breakers.
For the guys who know that and stop demanding the 18 year old super model with the porn star sex drive, an intact hymen and a desire to have kids; they can find someone who is compatible.
(Not that there isn’t a subset of women with a very similar problem themselves)
- Comment on what are the grievances with the "male loneliness epidemic"? 2 weeks ago:
I would more empathy for lonely men if every one of them that I met didn’t have massive red flags in their attitude and/or behavior towards women.
Like seriously, a 57 year old man wants a woman to have kids with but thinks a 52 year old woman who wants kids wouldn’t have any by then…
- Comment on [deleted] 2 weeks ago:
Why wouldn’t they work together and then he would have to do all the cleaning/washing/household routines
- Comment on [deleted] 2 weeks ago:
The key is to first get the body you want and then maintain it while you get the mind to match.
Mindless diet and exercise; certainly allow plenty of time for audiobooks and other educational content.
- Comment on [deleted] 2 weeks ago:
Mathematically speaking humans are donuts.
- Comment on [deleted] 3 weeks ago:
I would more want context. As I know that I am not a charming woman (I believe the phrase was a hellfire demon on wheels) but even my husband (who has a 176 IQ) considers me clever.
Also I realize that we are all dumb about many subjects that are not our interests. And what people find charming can vary greatly.
- Comment on If your happiness is derived from your enjoyment of a false (i.e. fictional) stories, is that truely happiness, or is that technically a delusion? 3 weeks ago:
If you dig too deep into reality, you will discover that effectively 100% of the population is delusional on no less than 2000 subjects. They just have yet to be bitten on the ass for it.
And people take it very poorly when you start pointing it out; just like you and I will when someone else shows up to do the same thing to us. Historically speaking we lock people up for shouting things that have not yet been accepted by enough people. Like the earth is going to be eaten by the sun (true in a few billion years) or the sky is falling (it is more acceptable when you call it rain).
- Comment on [deleted] 3 weeks ago:
It hinges on if the vampire is allowed to be invited in by anyone (like the black plague was) or only by the owner of the house.
- Comment on What are some good "frugal" movie viewing setups? (Recommendations) 3 weeks ago:
You can get a quality 1080p projector for about $120 (or spend more to get a 4K)
A proper speaker setup for $211 (this bit can go up to crazy prices if you go overboard)
An Intel NUC for $150
And a white sheet for $10 (get the highest thread count you can find)
You can get them at your local retailers pretty easily.
- Comment on Is there a place online where I can apply for a bunch of free books? I was thinking of creating a library in my local county jail to help educate and pass the time in a healthy way? 3 weeks ago:
Reach out to local libraries, they might even setup interlibrary loans to give you access to even more.
- Comment on Is there a place online where I can apply for a bunch of free books? I was thinking of creating a library in my local county jail to help educate and pass the time in a healthy way? 3 weeks ago:
Physical or ebooks?
- Comment on The New Yorker Asks: Is the A.I. Boom Turning Into an A.I. Bubble? 3 weeks ago:
25 years ago an 8P server had only 8 cores (even if you bought Alpha 21364s) And states needed whole buildings to host their servers. Scaling that down to a single rack is the progress that occurred.
- Comment on The New Yorker Asks: Is the A.I. Boom Turning Into an A.I. Bubble? 3 weeks ago:
Constraint solvers for things such as Medicaid eligibility; OCR tagging for scanned documents; Anti-AI detection for uploaded images; but yes most state services are data entry and batch processing with web front ends.
Also the number of supported users does not scale linearly with the number of CPU cores as Amdahl’s law showed back in 1967.
- Comment on Could I just create my own drive format? 3 weeks ago:
Creating a drive format is the easy part; getting it generally supported is the hardest part.
- Comment on The New Yorker Asks: Is the A.I. Boom Turning Into an A.I. Bubble? 3 weeks ago:
No. A state government needs to support 1/10th of its population actively using its services. Say that state has 10M people; you will want 10k cores for all state services. an 8P server has about 1536 cores and you will need about 7 of them. So it still takes a whole rack even with the COBOL programs and applications written in C and Assembly.
- Comment on The New Yorker Asks: Is the A.I. Boom Turning Into an A.I. Bubble? 3 weeks ago:
Ok; what application (which benefits society) requires data center level compute beyond physics simulations (which are better suited for quantum computers).
- Comment on The New Yorker Asks: Is the A.I. Boom Turning Into an A.I. Bubble? 3 weeks ago:
When entire state governments can fit in a single Rack, why bother?