Skip to content

Index

  • 1 min read

Generating fake data using SQL

Link: Generating fake data using SQL: "Fake data are very useful in development environment for testing your application or some query performances for example. In this Blog Post I’ll share how I ..."

Some fancy sql technique to create masses of fake data efficiently. Note: no Ruby or Python involved!

  • 1 min read

5 Practical SQL CTE Examples

Link: 5 Practical SQL CTE Examples: "In this article, we’ll go through several examples to see how SQL CTEs can help you with complex calculations and hierarchical data structures."

Just heard about CTE (Common Table Expressions). They are a feature of SQL. Not sure whether all SQLs or just Postgres. A way to refactor a complicated SQL statement into substagements.

  • 1 min read

How I stopped worrying and loved Makefiles

Link: How I stopped worrying and loved Makefiles: "First contact with make When I was invited for my first job interview in the IT, I’ve been asked such question: How would you typically build a program from sources, what commands will you use? I answered: It’s obvious: ./configure make make install Those times belong to the past now and nowadays not many programmers use GNU Make1. Try asking this question and you will see disgust at best. For many it’s the fist contact with make and often the last one, but not for me 😉"

Great reminders on how and why to use the ancient and ubiquitous “make” tool.