dr_analog
top 1% of underdog fetishists
No bio...
User ID: 583
Why not set up a machine instance in one of the VPCs, ssh into it, run mysqldump against the source DB and pipe it to mysql connecting to the destination DB? The piping avoids storing it on a disk/bucket.
Why would the security team kill you for connecting to public IPs? Just make sure TLS is enabled and you're good to go. Also if both VPCs are in the same AZ/DC you're likely not going to go over the internet. You might not even go over the Internet between Google Cloud DCs.
Might need to ask an LLM for the right set of options to disable buffering and select the databases you want to clone.
dr_analog
top 1% of underdog fetishists
13d ago
I originally got into computer programming as a teenager because I wanted to make video games, but I found windows insufferable and got distracted by Linux and a career in SRE.
I've since decided to try to go back to my roots, so to speak. This would all be a lot easier if I just used UE5, but what's the fun in that?
Doesn't seem like the best idea if you have declining fertility because you can't even get your own domestic original stock bloods to reproduce.
You eventually have to make up the deficit with foreigners and it's better to have foreigners with domestic great grandparents than no relation at all.
dr_analog
top 1% of underdog fetishists
14d ago
Too many undesirables from Brazil using it to resettle, apparently.
So! There's a tiny chance I'll be booted out of the US because 5 decades ago my parents were illegal immigrants and the SCOTUS might agree they were foreign invaders, thereby yanking my birthright citizenship.
Meanwhile, right-wing nativist Chuds in my parents' country have decided they think bloodline-based citizenship is the actual menace and are taking steps towards ending it.
I don't really want to live in the old country, but to add insult to injury it's narrowly possible I'll lose residency in the US while my kids become ineligible for residence in the old country and navigating that sounds really unpleasant.
This is really speculative of course. But for peace of mind, are there any decent countries that I can buy a citizenship in? Either cash money or via "investment"? The obvious contenders like Cyprus and Portugal seem to have scaled back the enticements recently.
dr_analog
top 1% of underdog fetishists
16d ago
I'm not sure what you're responding to exactly. Are you saying this seems inane and that school shouldn't focus on this, or that this doesn't seem like a hard academic competition to win. Is this even an academic competition?
IMO it sounds like you only like law when it supports your POV.
EDIT: I also find the nExT admiNiStrAtIoN / white genocide argument a bit funny because it was Reagan that granted my extended family amnesty and they're all white and hardcore Trump voters.
dr_analog
top 1% of underdog fetishists
17d ago
Congress and the President are as "we" as it gets when it comes to law. Unless you want to bring guns into a discussion about SCOTUS rulings.
dr_analog
top 1% of underdog fetishists
22d ago
You know. The deep state. Them. The powers that be.
More seriously, if Trump convenes the extremely serious military people and they present him a limited menu of military actions he can do that is basically the same set of plans they've had for 20 years, that's the MIC at work. The names and faces can change but the dusty binder from the drawer stays the same.
dr_analog
top 1% of underdog fetishists
22d ago
My problem with Iran is that I do not have a good model of just how nutty they are, really. I would model their close ally Hamas as being willing to sacrifice every soul in Gaza to kill a few 10k or 100k Jews. Presumably they are less crazy than that.
What do you think of the use of child soldiers and also child martyrs?
dr_analog
top 1% of underdog fetishists
23d ago
Except "winning" the war with Iran in this case means simply preventing them from projecting force into the rest of the Middle East. If Iran can't stop Israel from blowing up their military assets or nuclear developments or their leaders they aren't much of a threat anymore.
Update.
Separately I noticed there's a problem with how the wheels spin and play with the ambient sunlight. The light appears to get painted onto one section of the wheel and it spins around the wheel with it, which is obviously wrong. I spent a few days on this and haven't made much progress. I'm kind of pulling my hair out.
I finally decided to look at the "normal map" for the wheel and notice it's ... painted on looking? The top right of the circle is dark and the bottom left is shiny which is the behavior I'm running into. As the wheel spins the shine "follows" it towards the ground and then up the back until it loops around again.
/facepalm
Looks like the person who made this model didn't ever expect the wheels to actually turn, which you know, fair. Surprised they did this because the rest of the car relies on reflecting the ambient lighting instead of painted on lighting.
I'm embarrassed it took me this long to decide to check the data.
EDIT: fuck, that's not actually the problem. the normals map is not a shade map. it makes sense that the "color" at one end of a circle is different from the other end
dr_analog
top 1% of underdog fetishists
1mo ago
don't they limit model choice
I'm not really sure anymore. I think they were at first but this led to people trying the free version, seeing how crappy it was, and deciding AI was a fad.
dr_analog
top 1% of underdog fetishists
1mo ago
I've been using Ubuntu for O(decades) now and don't think I've ever used snap.
I only ever install stuff from the CLI using apt. Anything GUI or snap related I usually X out of.
Oh. There is a pop-up periodically that offers to update packages that I click okay on. I do notice it runs apt so I consider that fine.
Maybe I'll be rudely disappointed soon enough.
Oh. There's some. Telemetry for a Linux distro will be pretty weaksauce compared to the rest of the world because of how fickle Linux users are.
But yeah no harm in Mint if you want the full anti-corpo experience.
dr_analog
top 1% of underdog fetishists
1mo ago
I am unlikely to. But, why would Glenn Greenwald being into pervy stuff matter if I was?
Is the implication that if I tried to do anything about Epstein, powers that be would hack my pervy stuff and leak it too?
dr_analog
top 1% of underdog fetishists
1mo ago
Thank you for the clarifications (and outright corrections!). I suppose the awkward fitting is to avoid stepping on the President's toes wrt his authority to declare an emergency, which seems to be widely upheld?
dr_analog
top 1% of underdog fetishists
1mo ago
in paragraph 3 I acknowledge/agree this won't work in online dating
Hey thanks for the wealth of excellent info, as usual!
On the power side, I'd at least consider 3S LiPo battery pack, running the LEDs from that voltage, and just using one buck converter for ESP32 (which can be a tiny 5 watt one). That's only a nominal "12v", and really a 10ish-12.6 range, so you'll want to double-check the datasheet for your specific LEDs, but it's well within spec for the WS2815s.
Why consider? I was a bit freaked out by LiPo watching videos of them burst into flames if they get ruptured. Maybe not something I want to attach to my helmet. But perhaps the issue is just as prevalent with 18650s?
You can get 3S 18650 chargers cheap (eg here, not endorsed), though premade packs are so widely available (and tend to have much better low-current protection) that it's hard to justify building your own packs unless you need 5+ amp.
A friend has been going crazy trying to find a charger that takes USB-C and can charge 2S safely. Some reviews on that link say it doesn't do proper balance charging :/
And even once you have your 'jellybean' parts together, you'll always need something specific to a given project, or find that your old parts aren't available anymore, yada yada. Breaking projects into modules can help, but then you're juggling them, too.
It's really something else. A box of parts will arrive and then I'll make a bit of progress but realize I need, e.g. clear heat shrink tubing to make this thing happen the way I want and then it's another 2 days if I pay way too much on Amazon for it or 11 days to get it from Aliexpress. There's just no powering through some online tutorials and banging this stuff out in a weekend if you're coming from it so cold.
If you're only needing a handful and had little or no interest in 3d printing, seriously consider various fabrication services, or local marker spaces (or some libraries), rather than buying a full 3d printer.
The irony is my local library and (non-profit, communist) maker space all have 3d printers (multiple, even), but they're always broken. But maybe hiring people is not a bad move.
For flexible, light-weight, shaped transparent pieces with little 3d complexity, my go-to has been vacuum-forming. Big ones get surprisingly complicated fast, but for anything under a couple feet square you can get away with stuff you probably have in your house, and the big trouble becomes sourcing the right types of plastic.
TIL!
I'd also recommend considering Traditional Manufacturing -- just as there's a lot of people 3d printing what could be made with a handsaw in ten seconds, you may well be engineering something that could be sewn together in a good half-hour. If you want something flexible and comfortable for long-term wear, sewing is kinda the way to go. You'll still want some boxes for the batteries and protoboards to provide impact resistance, but it'll give a lot more space to consider multiple small project boxes or such, and those are a lot easier to source.
This opened my eyes a bit. As such I'm now currently trying to get pieces of acrylic, cutting them to size and seeing how sandwiching the ESP32 etc and wrapping the whole thing in a rubber gasket for light waterproofing works out. This has the bonus of looking really cool since the internal LEDs and circuitry are visible, if it works.
Though for prototyping I might just wrap it all in an ESD packet and tape it to my helmet, like some kind of silicon organ pouch.
Oh, yeah. Seems like people want small low-power computers to drive widgets rather than make an IBM PC from 1986 on a cocktail napkin.
Ideally all of this should could be end-to-end done with CAD software, or by writing out a .spec file and uploading it to a magic box or web site and then a microwave dings and it's ready. Or it arrives in the mail. Maybe one day...
Maybe it's possible to 3d print ghetto PCBs and also 3d print conductive filament and snap it into place?
dr_analog
top 1% of underdog fetishists
2mo ago
It's really the most hellish part. I'm trying to just take it easy and not worry about how soon I get this done to avoid stressing.
Starter kits help a bit, but they're only like $10 whereas I want something like $100-200 that contains the top 1000 things people use for, e.g. Arduino or LEDs.
I fantasize about taking a two week vacation to Shenzhen and hiring some Chinese EEs that speak English to show me around and going home with a suitcase full of stuff I bought off the street.
dr_analog
top 1% of underdog fetishists
2mo ago
pic attached in last message wasn't showing up. lets try this one.
ha I'm more the opposite. The shell script is legible and easier to reason about. Using some GCP widget is going to not work for some mysterious reason and getting help is impossible if the docs don't cover your use case.
More options
Context Copy link