Jasmin Fluri
banner
jasminfluri.bsky.social
Jasmin Fluri
@jasminfluri.bsky.social
280 followers 270 following 17 posts
Database DevOps Engineer / Consultant - schaltstelle.ch Oracle ACE - @oracleace.bsky.social Sym42 Member - @sym42.bsky.social Cyclist and Mountaineer 📍🇨🇭
Posts Media Videos Starter Packs
I felt like writing a blog post —a little write-up on why fixing failed #database deployments is challenging.
Spoiler: The part about undo-scripts might feel like a rant, probably because it is. 🙃

medium.com/@jasminfluri...
Database Rollbacks in CI/CD: Strategies and Pitfalls
Database rollbacks would be incredibly valuable and essential if we want quick fixes for failed deployments. But they are rarely feasible.
medium.com
Reposted by Jasmin Fluri
Reposted by Jasmin Fluri
🥹🥹🥹
#POUG2025 is closing down.
Thank you @luizafrompoland.bsky.social , @ora600pl.bsky.social , all the sponsors, speakers, attendees and people in the background.
Hope to see you all at #POUG2026 !
Reposted by Jasmin Fluri
#POUG2025 10 years anniversary 👏🎉🪓🍻
Reposted by Jasmin Fluri
Only at the #POUG2025 - @jloracle.bsky.social LIVE with a full room, obviously.
Reposted by Jasmin Fluri
Different approaches to monitoring, according to @jasminfluri.bsky.social at #POUG2025

(The Poland version is applicable in many countries 😇)
Reposted by Jasmin Fluri
🎉 The 2025/2026 Oracle ACE Program members have just been announced! Join us in celebrating the incredible contributors, experts, and community leaders making a difference in the Oracle world.
Check out the full list and let’s congratulate the new ACEs! 👉 blogs.oracle.com/ace/post/int...

#OracleACE
Reposted by Jasmin Fluri
Reposted by Jasmin Fluri
Oracle Database 23.6 added sessionless transactions

These enable you to:

Start a transaction in session 1
Suspend it
Resume the transaction in session 2
Complete it in session 2

This allows the app to release DB connections while doing other work mid-transaction
Reposted by Jasmin Fluri
Join me next Wednesday (12 Feb) to learn about using PL/SQL to build #database APIs

We'll cover Oracle Database 23ai enhancements to help you do this such as:

Better loops
Extended case expressions
JSON integration
The automatic SQL transpiler

Starts 10am UK time

go.oracle.com/LP=146704?el...
Developer Coaching: Build Database APIs with PL/SQL in Oracle Database 23ai
Oracle Database 23ai continues to enhance PL/SQL with better loops, extended case expressions, and better JSON integration. Join this session to learn what’s new to help you build data-drive apps.
go.oracle.com
Reposted by Jasmin Fluri
Truer words have never been spoken.....
You don't want to miss this one. Submit your session for the #POUG2025 and join us as a Speaker 😎

sessionize.com/poug-2025/
Nothing like doing some yak shaving to start the week... initial goal seems to consist of numerous side quests. Work RPG I guess.
Reposted by Jasmin Fluri
In this session we looked at how to

- Structure database code files in version control
- Use Liquibase in SQcl to automate database releases

Thanks to @jasminfluri.bsky.social for joining me

The recording is now available at

www.youtube.com/watch?v=Zmmy...
If you missed our #AskTomOfficeHours session about #SQL Version Control, you can now rewatch it on Youtube ⬇️

📹
youtu.be/ZmmyquWkhno?...
@oracleace.bsky.social
Reposted by Jasmin Fluri
Join Oracle ACE Pro @jasminfluri.bsky.social and Oracle Developer Advocate @chrisrsaxon.bsky.social for a free session SQL Version Control. ♠️

Register now 👉
asktom.oracle.com/ords/r/tech/...
#OracleACE
Thx @salvis.com and @sartograph.bsky.social for the input - I edited the blog post with a remark to the proxy user setup! 🙏
Reposted by Jasmin Fluri
Discover where you can find the Oracle ACEs presenting in January 2025 in the latest post from the ACEs in Action blog ♠️ 👉
blogs.oracle.com/ace/post/ora...
#OracleACE
@ixchelruiz.bsky.social @jasminfluri.bsky.social @hanno.codes @loiane.bsky.social @rustam.no @handle.invalid
Yes, it's very important that also the credentials of a deployment user aren't known to developers. They should have their own common users (c##) to log onto the database.
I haven't thought about a proxy user. Good idea indeed.
Where I see the main difference is that it's a specific deployment user. From an audit perspective it is way more transparent on what happens on the database - who executes, creates, does what exactly. With a schema user it could still be shared for different purposes.
Correct, the deployment user would also need some create, alter, drop <object> grants. But maybe (depending on the use case) no permissions to modify data?! ... This probably isn't massively different from what a schema user can - permission wise.
After my last blog post, a discussion started about user permissions and CI/CD. So, I wrote a short story about the problem that occurs when using a schema user for application access or in database schema deployments.

@oracleace.bsky.social

medium.com/@jasminfluri...
Permission Concept for Database CI/CD in the Oracle Database
CI/CD changed how we manage and deploy database changes. This article explains how to set up application- and deployment users correctly.
medium.com