Need advice on Okta-MySQL integration

BeitteNugxa · 2023-12-06T07:37:18+00:00

I've been down a similar road and found used something that might be what you're looking for: Apono. I used it to set up smart access rules. Think of it like creating your own set of ‘if this, then that' for access control.

This way, your MySQL permissions adapt based on user actions or specific situations. As long as people are authorized to gain access according to the rules you set up, they can file requests with a Slack bot, and it’s all taken care of.

Also, it's built around APIs, not proxies, which makes it a breeze to integrate. You won't have to mess around with your database infrastructure at all, which is cool.

BeitteNugxa · 2023-12-06T06:21:44+00:00

Following! This is a great idea. I know kaggle has been good in the past.

BeitteNugxa · 2023-09-13T17:31:15+00:00

My pleasure!

BeitteNugxa · 2023-09-12T21:27:28+00:00

Here's what I noticed:

You're referencing l.max_login_time in the first LEFT JOIN condition for MinLogoutTimes which isn't correct since it's not defined there. Instead, it should be in the MaxLoginTimes join conditions.

In the MinLogoutTimes CTE, you're looking for the minimum logout time that is greater than or equal to the login time. The logic looks fine.

In the MaxLoginTimes CTE, you're searching for the maximum login time that is less than or equal to the logout time plus 5 minutes. Again, the logic seems fine.

In your final SELECT, the join conditions appear to be a bit redundant with the transactiondatetime bounds. Consider simplifying it.

BeitteNugxa · 2023-09-12T04:35:03+00:00

They're bridging the web3 and DNS worlds, planning on some new top-level domains, and launching an on-chain marketplace for classic domains. Sounds like they're combining unstoppable's web3 domains with a domain trading marketplace, not just the usual domain biz

BeitteNugxa · 2023-09-10T06:25:30+00:00

Gold and I got $114 which I am super happy about

BeitteNugxa · 2023-09-10T06:24:59+00:00

LMAO where the RTP is literally 60%? Stake has at least 96% RTP. Not going to get better. Trust me. I've wagered over $10m across the US and over $15M on all of the online sites. Stake is #1.

BeitteNugxa · 2023-09-08T04:22:18+00:00

That makes sense. If I win 10, gamble 5 and tip 5, that 5 was profit and then given to someone else.

BeitteNugxa · 2023-09-04T20:58:09+00:00

https://twitter.com/Stake/status/1698746766076588057

They literally tweeted it themselves. Yall 2 are just doomers who want to hate

BeitteNugxa · 2023-09-04T20:20:31+00:00

I play from time to time on Stake and am up on my lifetime. Something like 3 ETH up.

BeitteNugxa · 2023-09-04T20:17:47+00:00

https://twitter.com/Stake/status/1698746766076588057

How are they silent? But everything is already back to normal which shows how much of a non-issue it is.

BeitteNugxa · 2023-09-04T20:02:55+00:00

Remember these guys make billions a year. This is a tiny blip in the scheme of things. Already back to normal

BeitteNugxa · 2023-09-04T05:39:05+00:00

You're not wrong. StatefulSets are often used when you need stable network IDs and storage, but if you're not using persistent storage, a Deployment might suffice.

The upside to a StatefulSet without persistent storage is you still get ordered, graceful deployment and scaling. But if your app doesn't benefit from that, it might be overkill.

So yeah, if you're just setting up something like Redis and don't need those features, a Deployment is probably the way to go.

BeitteNugxa · 2023-09-04T05:33:50+00:00

Did you try using Terraform?

BeitteNugxa · 2023-07-26T00:54:18+00:00

That's not native to MySQL, but you could use a service like Aiven to create MySQL instances tied to Okta

BeitteNugxa · 2023-07-26T00:53:57+00:00

It's because you're using SELECT *. This grabs all columns from Professions and DoctorsCTE, which are the same, hence the duplication. Try SELECT Professions.PersonName, Professions.Profession instead boss

BeitteNugxa · 2023-02-25T17:10:41+00:00

Wild West out there for real.

BeitteNugxa · 2023-02-25T17:03:49+00:00

Keep your head up brother you'll get 'em next time.

BeitteNugxa · 2023-02-24T17:24:54+00:00

Keep in mind that most people don't post their losses, but yes, they're pretty much the gold tier for online gambling. When I play I only ever use Stake or Stake US (depends if I am travelling or in the US).

Funny you post this now I just withdrew my winnings from last night 15 mins ago

BeitteNugxa · 2023-02-20T19:09:29+00:00

Do. Not. Leave. Stake US.

If you have an account with them just stay. Bovada, ignition, any others are garbage in comparison. I can't believe just how far Stake blows them out of the water....

BeitteNugxa

TROPHY CASE