Pythonium

Python, What else ?

The Pythonium Blog

Welcome to my "new" blog! I plan to publish articles related to Python, as you’ve probably guessed 🙂 I will cover topics like data science, programming, data, and other things (perhaps a bit less related to Python, but still within the Tech realm).
My posting schedule may be a bit slow, but please be patient!

JSONL explained: what it is and when to use it

There's no need to introduce JSON (JavaScript Object Notation) anymore. It has become the de facto standard for exchanging structured data between applications. However, when working with large datase...

VPN: Do you really need one to protect yourself?

Whenever we browse the Internet, we expose our personal data to certain risks. A VPN (Virtual Private Network) is supposed to act as a "digital" shield by hiding our IP address and securing our connec...

Managing technical debt

Technical debt is probably one of developers' biggest concerns (it's my personal pet peeve). It creeps in over time throughout a project: a shortcut taken to meet a deadline, tests postponed until lat...

Common SQL database mistakes

SQL databases are predominant in professional applications, even though NoSQL databases have gained popularity in recent years for some specific use cases. They allow data to be stored, organized, and...

Why do developers spend so much time debugging?

Debugging is part of our everyday life as developers. Even when a project is well designed, tested, and documented, there always comes a time when something does not work as expected. Sometimes, a bug...

Bugs related to race conditions

Race conditions are among the most frustrating bugs to fix for a developer. The problem is simple to understand: several operations can execute in parallel or be interleaved, and the result depends on...

What makes an API pleasant for developers to use?

An API can be technically correct while still being frustrating to use. Two APIs can offer almost exactly the same features, but we generally prefer the one that is easier to understand, test, integra...

What developers need from cloud ecosystems

Developers are increasingly relying on cloud ecosystems instead of traditional infrastructure. Applications must support users across multiple environments, integrate with a wide range of services, an...

Common REST API mistakes

REST APIs are now used in the majority of web applications. They allow different services to communicate easily using the HTTP protocol. However, designing a good REST API is not always easy, and some...

Why CSV is more complicated than it seems

The CSV (Comma-Separated Values) format is not exactly new. It is one of the most widely used data formats. You can find it everywhere: database exports, Excel files, ERP, CRM, BI tools, APIs... At fi...

Floating-point number pitfalls in programming

Floating-point numbers are one of the concepts that every developer encounters early on. They allow decimal numbers to be represented in almost every programming language. However, their behavior can ...