ProgerHub
4.85K subscribers
137 photos
2 videos
64 files
301 links
Ads & contact: @crazydev93

A channel with programming news and tips and tricks, nice for beginners but also for experienced programmers. 💻
Download Telegram
Channel created
Things nobody told me about being a software engineer:

https://anaulin.org/blog/things-nobody-told-me-about-being-a-software-engineer/
How to use multiple programming languages without losing your mind

https://opensource.com/article/18/11/multiple-programming-languages
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
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/