CODEWITHSUNDEEP
sqlpostgresqlnosqlredis
seanbrant
seanbrant

Reputation: 1417

relating data stored in NoSQL DB to data stored in SQL DB

Whats the best way to use a SQL DB along side a NoSQL DB? I want to keep my users and other data in postgres but have some data that would be better suited for a NoSQL DB like redis.

I see a lot of talk about switching to NoSQL but little talk on integrating it with existing systems. I think it would be foolish to throw the baby out with the bath water and ditch SQL all together, unless it makes things easier to maintain and develop.

I'm wondering what the best approach is for relating data stored in SQL to my data in redis. I was thinking of something along the line of this.

Anyone have experience, tips, better ways?

Upvotes: 1

Views: 657

Answers (2)

pcent
pcent

Reputation: 2039

An article about it: http://www.pythian.com/news/9387/liveblogging-at-confoo-blending-nosql-and-sql/

Upvotes: 1

Aiden Bell
Aiden Bell

Reputation: 28386

You can relate things however you want. A popular approach is using non-sequential UUID values as identifiers so that you can query discrete data sources for related data.

The problem is integrity ... without relational constraints, things can get messy. A well coded application can deal with this however.

I would also ensure you use caching wherever popular to avoid the overhead of many datasources.

Upvotes: 0

Related Questions