Category: Software
-
1. The Siren Call of SELECT * Instead of Explicit Columns Problem: SELECT * retrieves every column from a table, even those not needed. This increases network load, slows down queries, and can break applications if the schema changes. Solution: Always specify the exact columns you need: SELECT id, name, created_at FROM users; — Instead…
-
Check out this Pen I made! Source: DEV Community.
-
This post was created for the purposes of entering the GKE Turns 10 Hackathon. For the GKE Turns 10 Hackathon, I decided to extend Bank of Anthos with a retirement planning dashboard. (Bank of Anthos is a sandbox project you can run on GKE.)The idea was to give users a way to check their savings…
-
If you have ever worked with Tauri, you probably already used the tauri::command macro but after a few commands you saw that you needed to write each function manually inside of the invoker, that seemed a bit tedious but acceptable. However the more my project grew personally the harder it became to manage hundreds of…
-
Writing tests early and testing your code helps you catch bugs and ensure your code does what you think it does. MiniScript offers a way to do that. The QA module. In this short blog I want to show you how I use MiniScript’s QA module (https://miniscript.org/wiki/QA) to test my MiniScript projects. I will do…
-
Automating Partition Cleanup in Oracle with PL/SQL and DBMS Scheduler The procedure begins by reading from the configuration table CMN_DROP_PARTITION, which defines which partitioned tables need cleanup, how many partitions should be retained, and which partitions must be excluded. For each active table entry, it retrieves the table owner, table name, and retention count. Next,…
-
As developers, we’re obsessed with building elegant systems. We architect APIs, design databases, and optimize performance. But once we’ve shipped, how do we prove our solution is the right one? How do we convince other savvy engineers to bet on our tech? The answer isn’t just about features or benchmarks. It’s about social proof. And…
-
Good documentation is the backbone of a supported and empowered community. From the moment someone new joins and finds a clear guide to get started, to the experienced member who can quickly find a process, well-organized information saves everyone time and frustration. Most community managers spend hours each week answering the same questions over and…
-
Fedora Linux 43 Beta ships with Gnome 49 and KDE Plasma 6.4 (and other goodies). Sep 19, 2025 Jack Wallen Fedora Linux 43 Beta ships with Gnome 49 and KDE Plasma 6.4 (and other goodies). That’s right, my friends, the beta of the latest iteration of your favorite RPM-based distribution is now available for testing.…
-
When working with Python, you may need to perform a tokenization operation on a given text dataset. Tokenization is the process of breaking down text into smaller pieces, typically words or sentences, which are called tokens. These tokens can then be used for further analysis, such as text classification, sentiment analysis, or natural language processing…