Skip to content

2024

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!

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.