Spyke

Replies

Comment on

Lemmy World outages

Im a data engineer with 20+ years of experience in sql and various databases, I do performance tuning on daily basis. How can I help? Please message me if you think you can use me. Id be very happy to help where I can!

Comment on

What's a company secret you can share now that you no longer work there?

I worked for an online payment company you all know. Many eployees have access to the main DB which holds all transactions and names and everything in clear text. You could basically find out all PII (personal identification information) of any celebrity you wanted given they had anaccount. Address, phone number, credit card and all. If you knew a bit of SQL you could basically find whoever person you wanted and get purchase history and all.

Cant say I didnt use this to find stuff about my exes or various celebrities.

Comment on

So how long until the Fediverse is monetized?

Wikipedia is probably the most important thing on the internet fight now. It also needs some amount of servers, many crawlers scan it daily, I assume its a shitton of users and logins and API hits and what not. And still it survives on donations alone.

Eventually lemmy is not a streaming services with videos and and a lot of bandwidth. Its just text and people connecting. So I assume you dont need massive servers and shit.

Comment on

How does this pic show that Elon Musk doesnt know SQL?

As a data engineer for the past 20+ years: There is absolutely no fucking way that the us gov doesnt use sql. This is what shows that he’s stupid not only in sql but in data science in general.

Regarding duplications: its more nuanced than those statements each side put. There can be duplications in certain situations. In some situations there shouldnt be. And I dont really see how duplications in a db is open to fraud.

Comment on

Elon Musk gives X employees one year to replace your bank - ‘You won’t need a bank account... it would blow my mind if we don’t have that rolled out by the end of next year.’

As someone who worked for a tech banking company many years, you are too stupid to do it.

This shit is complicated as fuck.

Oh and all the tech in the world or capital you could build is worthless unless you have that sweet banking / credit license in US. And lets just say its really really hard to cone by nowadays.

Comment on

Just had someone say they are going to have a Fatwa put on me . What the hell does that mean? Do I need to report it or something?

Colloquially it means “your blood is free” to other people. It gives islamic religious lunatics a reason to kill you. If you are somewhat of a known person you should be worried. In a regular legal system (as in not in an islamic sharia law place) this can pass as a threat and legal action should be taken against the one who said it to you.

What im saying is the popular street meaning of this and thus it shouldn't be taken lightly. Its a threat. Period full stop.

Theologically it just means some religious legal entity ruled against you in your absence.

Comment on

Lemmy World outages

Reply in thread

Id rather someone just point me to the problematic query obviously. Would be much easier and better use of my time than to run my own instance and fake data into tables to see where the bottle neck is …

Comment on

My parents paid for my vacation aboard a cruise ship, and I hate it.

But hey, at least you tried. You said it was 4 days. At least it wasnt one of those 2 weeks cruises.

You gave it a genuine try and genuinely didnt like it. Tag it as another experience in life you learn from. And thats about it. Next time they invite you just say you tried and you prefer doing something else.

You can also try to invite them for some activity you like for the next vacation.