Adding a virtual unique key constraint in MySQL
with support of soft deletions
D
Software Engineer at BMW, Oracle Certified Professional Java SE 11 Developer
Command Palette
Search for a command to run...
Comments
Join the discussionNo comments yet. Be the first to comment.
More from this blog
Keycloak: Failed to verify identity token: Invalid token issuer
Two whole days of my life, down the drain! Thankfully, it was just my pet project, but I ended up sacrificing an entire weekend wrestling with this enigma. So, I'm writing this blog post to save you from the same fate. Problem: I am using Quarkus and...
Oct 30, 20235 min read
My Bash Scripting Cheat Sheet
Shebang Shebang is a combination of bash # and bang ! followed the the bash shell path. Shebang is simply an absolute path to the bash interpreter. #! /bin/bash Make a file executable To make a .sh file executable only for your user, use: chmod u+x...
Oct 25, 20231 min read
My PostgreSQL Cheat Sheet
1. Show tables The command \dt stands for describe tables and shows all tables in the database, equivalent to show tables in MySQL. \dt 2. Create user Run the following SQL command to create a user. Replace and 'password' with the desired username a...
Oct 20, 20231 min read
My macOS Cheat Sheet
How to set JAVA_HOME on macOS Monterey? First check which shell you are using (either bash or zsh). For zsh shell, we can put the environment variables at ~/.zshenv or ~/.zshrc.echo $SHELL /bin/zsh On Mac OS X 10.5 or later, we can use /usr/libexe...
Oct 19, 20231 min read
My Open Source Cheat Sheet
Fork your open source project you want to contribute into your GitHub and clone your fork. git clone git@github.com:dcnis/mockito.git Show current configured remote repositories. The origin repo points to your fork on GitHub. git remote -v > origin ...
Aug 29, 20231 min read
