WHAT IS DATABASE TRANSACTION ISOLATION?
⠀
💡 Transaction isolation levels specify the amount of data that is visible to a transaction, specifically when the same data is accessed by multiple transactions simultaneously. The SQL standard defines four transaction isolation levels, from weak to strong:
⠀
❶ Read Uncommitted: a transaction is allowed to read data from a row that has been modified by another running transaction and not yet committed. This phenomenon is also known as “dirty reads”.
⠀
❷ Read Committed: guarantees that any data read by a transaction is committed at the moment it is read, hence preventing “dirty reads”. But it makes no promise if the transaction re-reads the data, it will find the same data; data is free to change after it is read.
⠀
❸ Repeatable Read: similar to Read Committed, but guarantees that if the transaction re-reads the data, it will find always the same data. Basically, it keeps the read lock until the transaction commits. Even though this isolation is pretty strict, phantom reads anomaly is still possible (out of this post's scope).
⠀
❹ Serializable: The strictest isolation level, that prevents most anomalies. Comes with a big performance cost.
⠀
For advanced readers: it’s fascinating that MySQL, Postgres, Oracle DB, and MS SQL Server understand and implement the aforementioned isolation levels differently. For example, Oracle doesn’t support Serializable level. Check out this repository for more information:
⠀
> https://github.com/ept/hermitage

Source: Coding Unicorn
https://www.instagram.com/p/CHvLtR7APf5/?utm_source=ig_web_copy_link

The S.O.L.I.D Principles in Pictures 🤖

There are so many great articles online about SOLID but I rarely see any examples with pictures. This makes it a bit difficult for visual learners like me to learn while staying engaged.

So the main aim of this article is to get a better understanding of these principles using illustrations and emphasizing the goal for each principle. 🌈

Source: kutt.it/solid

#SOLID

Let’s Encrypt is a Certificate Authority (CA) that provides an easy way to obtain and install free TLS/SSL certificates, thereby enabling encrypted HTTPS on web servers. It simplifies the process by providing a software client, Certbot, that attempts to automate most (if not all) of the required steps.

https://www.digitalocean.com/community/tutorials/how-to-secure-nginx-with-let-s-encrypt-on-ubuntu-16-04

ROBUST WEB SCRAPING OR WEB API BASED DATA COLLECTION

https://datascience.blog.wzb.eu/2020/12/04/robust-data-collection-via-web-scraping-and-web-apis/

A Switch story

What is a switch?
The switch is a statement that evaluates the accuracy or similarity of the value of a certain input. But isn’t that the same thing that the if statement does?

https://matteoguadrini.github.io/posts/a-switch-story/

ASP.NET Core Developer Roadmap in 2021 🚀

Github Repository:
https://github.com/MoienTajik/AspNetCore-Developer-Roadmap

Singletons: Instantiate objects only once

Let's explore how Python deals with objects such as True, False, None, and why we use the syntax is True instead of == True in our code

https://pythonforthelab.com/blog/singletons-instantiate-objects-only-once/

Help out your favorite open source projects and become a better developer while doing it.

1) https://up-for-grabs.net/#/
2) https://www.codetriage.com/

The Magic of Python Context Managers

Resource management is one of those things you need to do in any programming language. Whether you are dealing with locks, files, sessions or database connections - you always have to make sure you close and free up these resources for them operate correctly. Usually, one would do that using try/finally - using the resource in try block and disposing of it in finally block. In Python however, there is a better way - the context management protocol implemented using with statement.

So, in this article we will explore what it is, how it works and most importantly where you can find and how you can implement your own awesome context managers!

https://martinheinz.dev/blog/34