Hacker News new | ask | show | jobs
by atonse 1887 days ago
Whoa I love this idea. I usually refer to it as "transactional" (always growing, represents the daily activity, read and write heavy) vs "lookup" data (almost exclusively read, not changed often). But still store them in the same database.

What ends up happening is we end up separating the two more with "cache this one, not that one" rather than two different databases.

I will explore this idea on my next greenfield project, whenever that happens.