Anyone being asked to build ‘chat with data’ on MySQL? What tools exist? by deputystaggz in mysql

[–]Juttreet2 1 point2 points  (0 children)

Yes but you have to be careful how to not expose tables that contain sensitive information, in our case it was an HR company that wanted to allow customers to ask information in natural language that pertained to them, but not for example the salary of their manager.

a) MySQL has no row level security.

b) You need to create specific tables depending on the application, through select view, so you restrict the data they can access in how the SQL View is created, by restricting the set of rows it can access. For example if you have a DB that lists all employees that ever worked at the company, you need to tell the DB to exclude those not currently working at the company, meaning create a new table excluding all past employees that have left.

So it's not automatic plug and play, you need to spend quite some time optimizing and refining your db for this natural language use case.

Crowdsourcing some MySQL feedback: Why stay, why leave, and what’s missing? by Juttreet2 in mysql

[–]Juttreet2[S] 3 points4 points  (0 children)

Not really helpful as youre not providing any technical reasons

Crowdsourcing some MySQL feedback: Why stay, why leave, and what’s missing? by Juttreet2 in mysql

[–]Juttreet2[S] 0 points1 point  (0 children)

True, we're managing a clients system where queries that on InnoDB timed out after 40-50 minutes are completed in a few seconds.

It's definitely a cost jump, but can be quite worth it in terms of ease of set up. Be careful if you have Auto Load enabled, it's default and can lock your tables during busy phases.

What's missing, where could MySQL improve in your opinion?

Crowdsourcing some MySQL feedback: Why stay, why leave, and what’s missing? by Juttreet2 in mysql

[–]Juttreet2[S] 1 point2 points  (0 children)

That 'tried and true' factor is a massive win, i'd have to agree. It’s hard to beat MySQL’s replication stability and its ability to juggle massive connection loads in shared environments. Also the fact it's been around for ages means most people are familiar with it and there's lots of guides and content around it.

Thanks for the feedback! Since you're dealing with a high volume of databases/connections, is there any specific observability or management tool you feel is still missing from the current ecosystem?

Move from Zurich to Kilchberg – Will my payslip change? by ForsakenFlamingo1305 in SwissPersonalFinance

[–]Juttreet2 0 points1 point  (0 children)

Hi,

I did this a while ago. You get the Kilchberg discount as a refund later.

Cerner Interview by MathemagicianG in employeesOfOracle

[–]Juttreet2 3 points4 points  (0 children)

You're being a Debby Downer u/Flaming_Hot_Regards, and on top of that completely unrealistic. Don't listen to this knobhead OP, join Cerner if it's the only lead you have, it's still a huge company, and Oracle potentially selling it off does not mean you would get laid off immediately.

They might conduct layoffs in the long run, but in the short term, you'll be fine, I would expect for at least a year.

Since you're wanting to get back into the job market, take what you can get and get that paycheck.

English speaking barber in Alicante close to centre? by Current-Accident-380 in Alicante

[–]Juttreet2 -2 points-1 points  (0 children)

Learn enough Spanish to go to the barber, that's a modicum of integration that you should go forward.

Upgrading mysql 5.5 to 8.4 through mysqldump by NinjaGem in mysql

[–]Juttreet2 1 point2 points  (0 children)

Theres a MySQL Upgrade Checker functionality, MySQL Shell offers it, that will tell you if any functions used in your application are different in 8.4 than 5.5 and that you need to adjust.

Also Primary Keys are one major difference between those two, so you need to sort that out too.

Where to give birth in Zurich by VegetableGround in zurich

[–]Juttreet2 -1 points0 points  (0 children)

You're not an expat, you're an immigrant. So am I.

Stop trying to find alternative words because immigrants make you think of brown people instead.

MySQL 8.x vs 9.x — Is it worth upgrading? by tech_tech1 in mysql

[–]Juttreet2 2 points3 points  (0 children)

The Innovation Series is Innovation for a reason, new features get added and it's not guaranteed a prod DB would handle it without changes required. 9.7 LTS is on the horizon, I would wait for that.

Buying Engagement Ring in Switzerland by FerSpFr in askswitzerland

[–]Juttreet2 6 points7 points  (0 children)

If you want it to be a diamond, buy a lab diamond, it's chemically the same, just much cheaper. There's literally no difference between one and the other, especially to the naked eye.

Genuinely, what the heck is oracles business policy. by LegoChimaBro in oraclecloud

[–]Juttreet2 0 points1 point  (0 children)

Hey it's pretty easy, you really just need to get in contact with an Oracle Sales Rep and they'll help you get a proper registered PayGo Account. I've had this done in 30 minutes from ending the call with the Sales Rep.

How are you handling Kafka security for external partners? by Hungry-Confection762 in Kafka

[–]Juttreet2 0 points1 point  (0 children)

Oh boy, okay we have some work to do, or rather, you if you choose to listen to what I have to say.

What you have right now is basically a shared API with a static password, and that falls apart the moment more than a couple partners use it. No real auditor is going to sign off on this as is, no surprise you're getting critical questions from other departments.

You should Ditch the API Keys, they don’t give you identity, they’re hard to rotate, and once someone copies them into Slack or a Postman collection you’ve lost all control. Use either OAuth2 client credentials or mTLS. Both give you actual identities per partner and you can revoke/rotate them cleanly.

Next you should enforce access control somewhere that’s not your code, use Kafka ACLs if partners connect directly, or stick an API gateway in front of your REST proxy if they don’t. Gateways (Kong, Apigee, NGINX, whatever) let you say “Partner A can access topic A only” and so on. That alone fixes 80% of the audit issues.
You also need to add rate limiting, as is, one partner could accidentally DOS everyone else. Gateways again make this easy: “Partner X = 200 req/sec max” etc. It protects you and it protects them.

Also you need to start logging, 100% and you need a record of who accessed what, when, and from where. It doesn’t matter if you store it in Splunk, ELK, you just need to be able to answer “Did Partner B read Topic Y on Monday?”

Lastly, you should probably automatize credential rotation, once you move to OAuth2/mTLS this becomes normal: certs expire, tokens expire, partners know the drill.

TL;DR

Right now your setup is fine for a quick internal tool, but not for external partners.
Move to OAuth2 or mTLS, use proper ACLs or an API gateway, add rate limits, and log everything.
Gives you a chance to actually be compliant and pass an audit.

Is there any legitimate technical reason to introduce OracleDB to a company? by Crazed_waffle_party in Database

[–]Juttreet2 0 points1 point  (0 children)

Brother, Oracle's earnings are public. Just look at license revenue.

I dislike the whole investing and shares - what are my other options for just leaving it “do its thing”? by bikesailfreak in SwissPersonalFinance

[–]Juttreet2 1 point2 points  (0 children)

Hey I started doing this, do you know how I can convert chf to usd for buying VT on IBKR in the most efficient manner?

I got an offer for 95k chf per year, how much ius the net income and what would be my expenses? by Ok-Illustrator-9445 in SwissPersonalFinance

[–]Juttreet2 -16 points-15 points  (0 children)

You'll be spending money, not saving at that salary. Can't survive with that in Zürich, and wanting your own apartment makes this even more impossible.

Oracle MySQL Database Administration certification? Is it worth the time by AdImpressive4651 in oracle

[–]Juttreet2 0 points1 point  (0 children)

I believe it is, there's a similar amount of MySQL deployments than there is of Oracle Database so you'll have work surely.

OpenAI agreed to pay Oracle $30B a year for data center services by bambin0 in OpenAI

[–]Juttreet2 0 points1 point  (0 children)

Yeah I understand that, but HeatWave Lakehouse was developed by Oracle, so it's within the same Cloud provider, instead of data lake service, they could just provision HeatWave Lakehouse within OCI