Sign Up
Welcome home! Here at WTMX you can make new friends and meet people with the same interests as you. All free and ad-free.
Databases and Data
Internet & Technology
Databases and Data shared a link
Handling slowly changing dimensions in an Activity Schema
The simplicity of modeling slowly changing dimensions in an Activity Schema vs a Star Schema
Destiny Blue likes this.
Databases and Data shared a link
How and why the Relational Model works for databases
This is a note on, the Turing Award laureate, Ted Codd’s revolutionary paper — A Relational Model of Data for Large Shared Data Banks. In this post, I will review the paper and add my comments with a ...
Databases and Data shared a link
Building a recommendation engine inside Postgres with Python and Pandas
Learn how you can leverage Python and Pandas from directly inside PostgreSQL to build your own recommendation engine.
Databases and Data shared a link
Postgres’s pg_trgm provides ways to query and search text for specific strings of characters (as opposed to FTS which is more word oriented). Stephen demonstrates some of the performance concerns when... View More
Postgres text search: balancing query time and relevancy
How do you balance query time and relevance with Postgres text search? Stephen Gutekanst, an engineer working on Sourcegraph’s API docs feature, shares tips for stirring code analysis with search inde...
Databases and Data shared a link
Why Observability Requires a Distributed Column Store - Honeycomb
Alex explains distributed column stores, how they work, why they’re so fast, and why that’s a fundamental requirement for observability.
Databases and Data shared a link
TiloDB - credit bureau case study
TiloDB was developed to help a credit bureau assemble entities for tens of millions of identities.
Databases and Data shared a link
What time-weighted averages are and why you should care
Learn how time-weighted averages are calculated, why they’re so powerful for data analysis, and how to use TimescaleDB hyperfunctions to calculate them faster – all using SQL.
Databases and Data shared a link
Migrating Facebook to MySQL 8.0
We are sharing how we tackled the migration to MySQL 8.0 — and some of the surprises we had in the process.
Databases and Data shared a link
Write a time-series database engine from scratch
It covers how to make a time-series database engine from scratch
Coz likes this.
Databases and Data shared a link
Links to 1211 (and Counting) Interesting Datasets — A wide variety of delights from datasets of every death in Tarantino’s movies and cruise ship inspections to the coins in 22,500 French wallets.
Data Is Plural — Structured Archive
Items edition,position,headline,text,links,hattips
2015.10.21,1,Every place name in the United States.,Sometimes, bureaucracy creates poetry. Since 1890, the U.S. Board on Geographic Names has been cat...
2015.10.21,1,Every place name in the United States.,Sometimes, bureaucracy creates poetry. Since 1890, the U.S. Board on Geographic Names has been cat...
