Skip to content

Index

Generating fake data using SQL

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

  • Web site excerpt: 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 ...

  • Link to site: Generating fake data using SQL

5 Practical SQL CTE Examples

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.

  • Web site excerpt: In this article, we’ll go through several examples to see how SQL CTEs can help you with complex calculations and hierarchical data structures.

  • Link to site: 5 Practical SQL CTE Examples