Multiple databases

[Roger Dunn]

I'm spinning up a new project and nearly all of the data I need to store can be normalized. Along with this normalized data is one piece that is better suited to a nosql database.

The use case is that the normalized data will be fetched often, is very tabular in nature, and the additional data is more document centric and will be fetch less often, by quite a margin.

I'm thinking of doing a hybrid using the 2 technologies. There will be a 1 for 1 relationship by rows. I know I could do either nosql or mysql, but for the exercise thinking of doing both.

Any examples floating around for this?

[Javier Guerra Giraldez]

On Mon, May 18, 2015 at 7:35 PM, Roger Dunn <tahoe...@gmail.com> wrote:
> The use case is that the normalized data will be fetched often, is very
> tabular in nature, and the additional data is more document centric and will
> be fetch less often, by quite a margin.

have you considered PostgreSql? it does handle json or xml documents
quite well (in fact, arguably better than most "document databases"
out there)

--
Javier

[Galia Ladiray]

It depends what you need,

We use redis for non sql, and postgres for sql,

You can use an id field to have a link between them.

Django 1.8 has a support for postgres specific fields like HStore, maybe this is good enough for you?

Galia