https://google.github.io/pytype/
https://github.com/facebook/pyre-check/
https://github.com/google/importlab

python static analysis code, especially type checking , and modules dependencies on each other

Do not forget these two rules:

Everything in software architecture is a trade off,
and always why is more important than how.

Anderson's law:
I have yet to see any problem, however complicated, which, when you looked at it in the right way, did not become still more complicated.

so when initially examining a problem, it's common to find that it becomes more complex as you go deeper into it. This complexity often requires a deeper level of investigation to determine the best solution.

#architecture

human interaction could be a bottleneck in most software projects, and should be managed very carefully.
there is a law around it that says "Adding manpower to a late software project makes it later."
it called Brooks's law

#architecture

Whenever you find yourself implementing distributed transactions within a system, keep the meaning of saga word in your mind.

a long story of heroic achievement;
a story of quasi-legendary events; colloquially, a long tale.
- Oxford English Dictionary

https://huly.io/

#slack #notion #jira #aletrnative

Using Postgres WAL trade-offs, rules you should know before making any decision in this area.

https://www.enterprisedb.com/blog/postgresql-wal-write-ahead-logging-management-strategy-tradeoffs

Laws of UX that worth to read for everyone

https://lawsofux.com/

The Unanimous 2PC (U2PC) protocol introduced in this paper is a fault-tolerant variant of the traditional Two-Phase Commit (2PC) designed to combine efficiency, simplicity, and fault tolerance in distributed transactional systems.

https://dl.acm.org/doi/pdf/10.1145/3642976.3653035

The practice makes permenant, but why?
https://www.sec-ed.co.uk/content/best-practice/developing-skills-the-magic-of-myelin/

When it comes to protecting against credentials theft on Windows, enabling LSA Protection (a.k.a. RunAsPPL) on LSASS may be considered as the very first recommendation to implement. But do you really know what a PPL is? https://itm4n.github.io/lsass-runasp
anonymous poll

No, it's the first time I've ever heard about that. – 3
👍👍👍👍👍👍👍 100%

Yes, I was familiar with that.
▫️ 0%

👥 3 people voted so far.

Introduction to RunAsPPL or LSA protection
https://itm4n.github.io/lsass-runasppl/

What will happen in real world if you don't enable that?
"LSASS has the ability to execute arbitrary kernel-mode addresses? I wrote a small proof of concept that allows administrators to execute unsigned code in the kernel if LSA Protection is disabled."
https://tierzerosecurity.co.nz/2024/04/29/kexecdd.html

Common DB schema change mistakes

https://postgres.ai/blog/20220525-common-db-schema-change-mistakes

Lesser (un)known postgresql features

https://hakibenita.com/postgresql-unknown-features

Constraints and Deferrable in SQL

https://begriffs.com/posts/2017-08-27-deferrable-sql-constraints.html

Atomic DDL is not transactional DDL

"Atomic DDL is not transactional DDL. DDL statements, atomic or otherwise, implicitly end any transaction that is active in the current session, as if you had done a COMMIT before executing the statement. This means that DDL statements cannot be performed within another transaction, within transaction control statements such as START TRANSACTION ... COMMIT, or combined with other statements within the same transaction."

https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html

What is Implicit Commit in MySQL?
The implicit commit occurs within a session.
So for instance you start a transaction, do some updates and then forget to close the transaction and start a new one. Then the first transaction will implicitely committed.

https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html

Spring Boot's application events

https://medium.com/@truongbui95/spring-boots-application-events-36ebe09e9313