Skip to content

Index

Privacy-friendly Website Analytics | GDPR-compliant, Real-time, Google Analytics alternative | Clicky

Very nice. and cheap alternative to google analytics. I mean, not exactly an alternative. I don't know all the features that GA has. But this tool is really lightweight, nice to look at, and it does a lot for free

The ‘Titan’ Submersible Disaster Was Years in the Making, New Details Reveal | Vanity Fair

Do you remember this story. Here's a really interesting article about what might have happened.

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