I'm working on my second Craft project ever. (First was an ultra-simple site just to learn the basics.)
With this new project I need to accomplish 2 things...
(1) - Private - Import/aggregate mass data from external sources based on my specific search parameters (think YouTube, CNN, BBC, Instagram, Reddit, Imgur, Pinterest, etc). Then slice, dice, curate, categorize, headline, and editorialize that data to create content-rich, topical feeds.
(2) - Public - Present those content-rich feeds as dense Topical Resources for my website visitors.
Craft is a brilliant solution for building a robust (and lightning fast) Public front end.
But based on how Craft operates underneath the hood... What's the Best Practice for managing the Private raw data behind the scenes?
Is it smarter to have ONE Craft Install with one DB - and separate tables for the imported (but not yet published) data?
Is it wiser to do TWO entirely separate Craft Installs - one for the Private back-end work (importing, compiling, editing, building newly curated feeds) - and another to grab and serve the Public (post-curation) results?