Ndifreke Ekott

Thoughts, stories, ideas and programming

18 Mar 2025

Enforcing JSON Schema in Django JSONField

Learn how the introduction of JSON datatypes in relational databases has revolutionized data storage by enabling document-structured data handling without relying on NoSQL solutions like MongoDB. Discover the benefits of JSON columns in reducing complex table joins, optimizing queries in ORM-based applications, and simplifying the development of REST APIs with JSON-compatible databases. Explore the challenges, such as schema enforcement, and how they can be addressed effectively in Django using JSONField and custom schema validation, with an example showcasing real-world solutions. Perfect for developers looking to integrate flexibility and performance in their database design!

17 Feb 2025

Whatever Your Hands Finds to Do ...

In the rapidly evolving field of software engineering, it’s easy to get caught up in the latest trends and lose sight of the value in our current skills. This post reflects on the importance of embracing and excelling in whatever task or opportunity we find ourselves in, no matter how small it may seem. Drawing from personal experiences and biblical wisdom, I emphasize the need to adapt to new technologies while appreciating our present abilities.

05 Feb 2025
29 Jan 2025

How to de-couple your business logic by writing a simple EventBus module

One of the exciting moments in the life of a software application is evolution, the moment you have to add yet another feature. Adding a new business capability is a sign of more usage being expected from running software. However, depending on how long the software has been running, adding new capabilities can be challenging. In a code base that isn’t well thought out, the result is a lot of procedural calls or couple if then else statements.

22 Aug 2024

Understanding and Working With Sql/Json Language With Postgresql

I must say, I have enjoyed my journey of understanding PostgreSQL offerings for JSON data type. I am also realising how much ORMs do for you; there can be pros to using one and cons simultaneously depending on your personality. There is however a sense of satisfaction in understanding how the database we depend on for business works.