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

زیبخِی اِلَهیم ووآخ نیش بِقا

https://biblehub.com/text/psalms/51-17.htm

https://github.com/tarantool/tarantool

Tarantool is an in-memory computing platform consisting of a database and an application server.

most engineers will work on badly designed systems because most systems turn into badly designed systems over time.