Înapoi la articole →

Cel mai recent articol

Ultima verificare

Urmăritori 0 urmăritori
Articole: 45
  1. Why care about programming languages

    In the age of AI-assisted coding, it’s easy to feel that deep knowledge of programming languages has become obsolete.

  2. On keys, essences and performance

    A recent exchange on linkedin about what data is and how to store it prompted me to write this small piece, since I consider the issue at hand quite fundamental to developing systems that reflect reality and therefore help people.

  3. All you need is PostgreSQL

    Introduction The setup Laying the foundation The foundation: schemas and user roles for modularity Domains Accounts, managed and external Transfers, constrained by a state machine and temporal periods Transfer state history Account auditing Transactions,…

  4. [BROKEN LINK: blog/google-cloud-s-outage-should-not-have-happened-and-they-seem-to-be-missing-the-point-on-how-to-avoid-it-in-the-future.pre-processed.org], another global IT outage happened (dèjá vu strikes again in our industry).

  5. Hallucinations in GPTs can lead to the dissemination of false information, creating harmful outcomes in applications of critical decision making or leading to mistrust in AI.

  6. What is mathematics? A classification based on universals

    I find that it is hard for me to motivate myself to learn a subject that one cannot define.

  7. [BROKEN LINK: blog/analyzing-crowdstrike-s-root-cause-analysis-or-on-missing-the-point-about-quality.pre-processed.org], this time at Google Cloud Platform (team 2025), taking down with it large swaths of the internet (Zeff 2025).

  8. The principles of database design, or, the Truth is out there

    Every software project needs to represent the reality of the business he is embedded in.

  9. Theory in practice: Why Treating Metadata as Relations Pays Off

    Underpinning relational databases you find a very powerful principle: all your information should be represented as attributes drawn from domains in relations(Pascal 2020).

  10. How to Replace LeetCode with Something That Actually Works

    Recently there has been an interest in cheating(?)

  11. Queries when you have a postgresql based system

    Are you managing/developing a PostgreSQL based application?

  12. Have you heard that having decoupled systems is paramount to dealing with complexity at the heart of software?

  13. How to unlock motivation for high performance in your team

    As an engineering manager(EM), one of your core tasks is to build and maintain a team of high performance.

  14. A simple way to deal with the principal threat to scalability

    If you have a distributed system one of the main worries you probably have is scalability.

  15. Debunking Event Sourcing

    Are you looking into event sourcing?

  16. Are you considering Event Sourcing? Think again.

    Are you considering doing event sourcing?

  17. A global IT outage occurred on [2024-07-18 Thu], with several industries having significant economic problems (see Appendix 1: The impact for some quotes on what happened).

  18. How to avoid frustration with software architecture

    It is becoming more common for companies to come out with stories on the downsides of distributed microservice architectures1(Kolny 2023; Ghemawat et al. 2023).

  19. How to avoid a common career pitfall

    If the way you think others see you is in stark contrast to how others actually see you, you are in danger of derailing in your career.

  20. Integrity Constraints and business value

    Again with this database business?

  21. Substantial and accidental forms of a SQL expression

    Multiplicity of parts, variety, and unity of plan which combines the parts into a coherent whole, – such are the elements of order found in all beauty.

  22. Why updateable views, or, Why modules matter?

    Continuing a rich conversation that sparked [BROKEN LINK: blog/a-real-life-example-of-database-design.pre-processed.org] [BROKEN LINK: blog/how-to-use-the-relational-model-to-do-database-design.pre-processed.org], I was asked to justify updateable views w…

  23. A real life example of database design

    In a followup to [BROKEN LINK: blog/how-to-use-the-relational-model-to-do-database-design.pre-processed.org], I was asked to provide an example to illustrate the point: Can you walk through a real life example of modelling, let’s say, a car (it’s always a…

  24. How to use the relational model to do database design?

    On a recent exchange I was asked the following: … what you mean that you use the relation model to design?

  25. Reification: the treatment of something abstract as a material or concrete thing, as in the following lines from Matthew Arnold’s poem “Dover Beach”: (Britannica 2018) The Sea of Faith Was once, too, at the full, and round earth’s shore Lay like the folds…

  26. A practical principle on politics (office or otherwise)

    If you are involved in politics, as a voter or just as an office worker in an unfortunate situation, you would do well to remember this dictum: When a public figure tells you something that you want to hear, question his sincerity.

  27. A point about FAANG points

    As a technologist I often hear variations of the following phrase in my industry: Do it because some FAANG(Fernando 2023) company did it.

  28. What is really the matter with the 'database'?

    How can we talk straight about a concept when the term that should signify it is equivocated all the time?

  29. The three traditional laws of being

    The law of identity ‘Whatever is, is.’

  30. Who should rule

    If you want to become a (better) leader, you should master the four essential characteristics for leaders: integrity, judgment, competence, and vision(Hogan and Kaiser 2005): Integrity.

  31. Principles of reliable applications

    The following are adapted from(Perry 2020), using a more database centric approach: Principle Implementation Idempotence Client side ids; Session ids Immutability Insert only DBMSes (system time in SQL 2016) Location independence Natural keys Versioning A…

  32. Pots, kettles and databases

    Sometimes you stumble upon small insights that illuminate a good chunk of things.

  33. What is database normalization and why should you do it?

    A fully normalized database means one thing, and only one thing: your relations corresponds only one predicate under a given interpretation (i.e. your business rules).

  34. How I do development on PostgreSQL over Emacs

    These days I’m doing quite a lot of work in PostgreSql.

  35. Performance and safety

    The human mind is limited in its capacity to understand complexity.

  36. Renaming, not abstraction, is the problem of our industry

    abstraction (n.)

  37. A dangerous book

    I recently commented on how the book (Kleppmann 2017) is a dangerous book, due to a subtle error on how it defines data models.

  38. Measure, don't guess.

    … when you trade safety for performance, you may get neither.

  39. Themes of the Elite Private School Curriculum

    I think its fair to say that one can significantly improve one’s chances of being materially successful in life by learning John Taylor Gatto’s 14 Themes of the Elite Private School Curriculum1: A theory of human nature (as embodied in history, philosophy,

  40. CQRS as nominalism

    A theme that I think is important to understand a lot of modernity and the IT sector in particular, is nominalism.1 So, what is Nominalism, and why does it matter?

  41. How to stand out in your career, the shortest version I know

    Someone asked me about this, so I feel it might help people out there.

  42. Recruitment and Selection of high performing programmers

    What could be more important for a technology company than great software?

  43. What is a good manager?

    It is hard to do science without proper definitions.

  44. I have come across people claiming to fear being replaced by bots, specially chatGPT and other large language models (LLM).

  45. An illustrated way to enable openVPN on Qubes OS 4.1.2

    In my view, Qubes OS lives up to its motto: A reasonably secure operating system.