JMJuan Miguel Nietoinjmnieto.hashnode.dev·Apr 14 · 2 min readHandling Concurrency using EF Core (optimistic approach)Why does EF Core handle concurrency using the optimistic approach? Browsing through the documentation you will see that handling concurrency conflicts on EF Core is handled by implementing optimistic 00
JMJuan Miguel Nietoinjmnieto.hashnode.dev·Apr 12 · 3 min readImplementing searchable encrypted Values using Blind Indexing The Searchability Paradox When we secure sensitive data like emails, social security numbers, or banking details in a database, we usually reach for strong, non-deterministic encryption (like AES-GCM)00
JMJuan Miguel Nietointhe-dev-cureef-core-and-sql.hashnode.dev·Mar 8 · 8 min readMultiversion Concurrency Control Internals on PSQL (PostGre)What happens when multiple users read and write at the same time? Concurrency is one of the hardest problems in relational databases. When many users access the same data simultaneously, the database 00
JMJuan Miguel Nietointhe-dev-curve-meditations.hashnode.dev·Jan 31 · 2 min readBook review of unit testing principles, practices, and patterns by Vladimir KhorikovSetting up your test-suites is one of the hardest challenge a developer will find. Tests are designed to increase confidence in software quality. Yet, they lose their value when developers begin to doubt the reliability of the tests themselves. Tests...00
JMJuan Miguel Nietointhe-dev-cureef-core-and-sql.hashnode.dev·Jan 12 · 2 min readBook Review of Database in Depth by C.J DateThis book is not a book for beginners. A good exposure to different SQL products will help you learn what concepts run on the database products that you use. Although the book doesn’t reference specific products, it focuses on relational model concep...00