#100CodeExamples
#100CodeExamples – PL/SQL BOOLEAN to INT
#100CodeExamples – PL/SQL BOOLEAN to INT
For Oracle doesn’t know a BOOLEAN SQL-Type, we must find a smooth way to convert PL/SQL-BOOLEAN to INT
#100CodeExamples
#100CodeExamples – SYSDATE vs. CURRENT_DATE
#100CodeExamples – SYSDATE vs. CURRENT_DATE
I had a very strange problem yesterday where #utPLSQL cli showed different test outcomes than running the tests from my IDE. Here’s the reason.
#100CodeExamples
#100CodeExamples – A challenge to learn and teach: Primary/Secondary Lookup
#100CodeExamples – A challenge to learn and teach.
My first example today: How to do a Primary/Replica lookup (in SQL) which I can query with the ID of any entry.
BeckDesignRules
BeckDesignRules for Database Developers: Reveals intention – Naming
My second article on Kent Becks rules for simple software design dives right into the 2nd rule (“Reveals intention”) and one of the hardest aspects of software development: Naming.
Uncategorized
BeckDesignRules for Database Developers Part 1: Passes the tests
Knowledge about SW Design is beneficial for every task related to software development and affects developers of any skill and experience level.
I try to deep-dive into @KentBeck ‘s rules for simple design and how they can be applied to DB development
Uncategorized
Strongholds of confidence: self-testing your database
No software is perfect and we should create meaningful, automated self-tests to give us the confidence in continuously changing and improving our software.
Tooling
There is no clean (database) development without Version Control
Version Control has been around for over 40 years, but still it’s not used in many database projects. This article is a plea and guide to use Version Control in database projects.
Uncategorized
DRY SQL – Writing simple, maintainable queries
We database people are very strict about redundant data in our database design – why aren’t we as strict about the code we write?