Urgent.News

What's breaking now, across thousands of outlets.

More in Tech

OpenProfile.md 0.2: answer the forty dating-site questions once

Every dating site asks the same forty questions, and every one keeps the answers behind its own login. Your birthday, your height, whether you smoke, whether you want children, who you are looking for…

  • OpenProfile.md collects 40 common dating-site questions
  • Hosted on user's domain, linked across platforms
  • Version 0.2 includes Match section answering all questions

Recursive CTEs: How SQL Secretly Learned to Loop

Ask a SQL query to find "all employees under this manager," and things get ugly fast if you don't know how many levels deep the org chart goes. A regular join handles one level.

  • Recursive CTEs enable looping in SQL without complex joins.
  • They are useful for hierarchical data like org charts or category trees.
  • UNION ALL combines anchor and recursive members, avoiding unnecessary deduplication.

More from Sunday 13 September →