New answers tagged database-design
            
                1
            
            vote
        
        
            
        System design for tracking viewed posts and returning unseen posts
                    things get a little tricky with two systems
Indeed.
So stick with the "one system" approach you initially outlined,
where a NOT IN join pushes the problem down to the RDBMS
query planner.
...
                
            
       
        Top 50 recent answers are included
Related Tags
database-design × 1345database × 458
relational-database × 229
design × 140
sql × 132
mysql × 96
architecture × 88
design-patterns × 80
nosql × 65
data-structures × 64
sql-server × 51
postgres × 50
mongodb × 42
c# × 41
database-development × 38
normalization × 36
data-modeling × 34
web-applications × 32
java × 29
schema × 29
php × 25
object-oriented-design × 25
data × 25
object-oriented × 22
api-design × 21
