I want to share my writings to my colleague thorugh my IP before publishing it. So here how I done it:
ipconfig from the terminal.<YOUR_NETWORK_IP> with the IP address.hugo server --bind 0.0.0.0 --baseUrl http://<YOUR_NETWORK_IP>:1313http://<YOUR_NETWORK_IP>:1313.I have came across the following article recently.
Software is a bit like this house plant: its wellbeing depends on the folks who constantly tend it. Without us around, it gradually erodes.
I used Google Orkut in the past and I loved it at that time. It was fun to send messages in the scrapbook, cool usernames, and enjoy all the other social media features that felt cool back then. But after the rise of Facebook and other giants, Google shut down Orkut. They sent us an email with a link to download our data archive and said goodbye. I still have those emails from Orkut, and when I read them recently, they gave me a nostalgic happiness.
What I realize now is that everything eventually comes to an end when the gardeners stop tending their gardens. We cannot take it for granted forever. Today we have access to some of the most amazing things in human history. We need to be grateful and enjoy the beauty of it. So keep on gardening, and cherish your fellow gardeners.
SELECT *
FROM TABLE1
WHERE ID NOT IN (
SELECT ID
FROM TABLE2
)
When I ran the above query I know the condition will give me the results, because the data exists in the TABLE1 which is not in TABLE2. But I didn’t go any results. I got surprised. After I a while I found out the issue.
So the reason is that ID column in the TABLE2 have null values. If any value of ID in the subquery is NULL, then the entire NOT IN clause fails to match anything. This is standard SQL behavior because NULL makes the whole comparison unknown.
Solution:
NOT NULL condition in the sub-query as below:SELECT *
FROM TABLE1
WHERE ID NOT IN (
SELECT ID
FROM TABLE2
WHERE ID IS NOT NULL
)
NOT EXISTS:SELECT *
FROM TABLE1 T1
WHERE NOT EXISTS (
SELECT 1
FROM TABLE2 T2
WHERE T1.ID = T2.ID
)
The NOT EXISTS will automatically handle null values and safer to use.
I often found that Ctrl+Alt+Delete unhangs the Windows PC. I googled why?
The nutshell answer is : Ctrl+Alt+Delete is a secure attention sequence (SAS) triggers a system interrupt, effectively forcing the computer to respond. This is directly handled by the Windows operating system kernel. That means it can bypass most of the stuff that’s currently running (including frozen apps or even some parts of the graphical interface).
Cool to know this.
I just found two tools:
Thunder and Unicorn mixed by Emoji Kitchen
I don’t search for things as much as I used to. These days, I just go straight to ChatGPT. I don’t feel like Googling and clicking through multiple pages to find the best answer. I ask ChatGPT, and most of the time, the results are satisfying.
I’ve heard that traditional Google searches are declining. But now, they’ve introduced AI Overviews at the top of their results. I think it’s a good idea—because we get a quick summary of what we’re looking for, along with links to other websites. Yes, I think it’s a good move.
Install Material Icon Theme
In settings.json:
"material-icon-theme.folders.associations": {
"folder-name": "Home"
}
folder-name is the folder name and Home is the icon.
You can find the files and folders icons in here.
To make a sticky footer in the Bootstrap you can use the below.
<body class="d-flex flex-column min-vh-100">
<main class="flex-fill">
<!-- Your page content here -->
</main>
<footer class="bg-dark text-white text-center py-2">
<!-- Your footer content here -->
</footer>
</body>
d-flex flex-column min-vh-100 on : makes the body fill the viewport and act like a vertical Flexbox container.flex-fill on : makes the content area take up all available vertical space, pushing the footer down.footer: stays at the bottom even with short content.To install or update Hugo extended using HomeBrew, you can use the below,
Install the extended version:
brew install hugo@extended
Or if you already have it and just want to upgrade:
brew upgrade hugo@extended
Check the version to using hugo version.
One of the main topics discussed in the seminar I attended was modernizing legacy applications.
Legacy applications are typically monolithic in nature, making it difficult to scale or integrate new features quickly. The monolithic apps ruled the software industry for a very longer time, but now people are moving (already many moved) to its great alternative, the microservice architecture.
I’ve come across monolithic applications that are tightly coupled with environments like Oracle or .NET, where growth can become a painful process. Over time, these systems tend to become slow, expensive to maintain, and resistant to change.