Integration DB is not a good idea for relational DB?

[mikeckennedy]

Integration DB is not a good idea for relational DB?

[joaonc]

Text here:

mongodb-quickstart-course/video_transcripts/3-modeling-documents/3-integration-vs-app-dbs_transcript_final.txt

Lines 29 to 36 in ff89e4f

	00:58 Also in NoSQL databases and document databases,
	01:01 the relationships are enforced in the application,
	01:03 so that means all of these have to agree on
	01:05 what the constraints are, what the relationships are,
	01:08 and that can actually cause data integrity issues.
	01:10 There's a lot of reasons
	01:11 that an integration database isn't a great idea
	01:13 for relational databases.

[mikeckennedy]

Hi @joaonc It does sound like I misspoke. Relational databases with their enforced structure and integrity are better than flexibly NoSQL DBs for integration databases.

[joaonc]

Got it, tx for the clarification.

Suggestion: To fix the video w/o re-creating or editing, add a feature similar to captions where text appears, say, on the top right of the screen. In this case (TR=Top Right):

start_time,duration,position,text
01:13,1,TR,"* document databases"

Thanks again for this course and the podcasts (I follow both your podcasts, but mainly listen to Python Bytes due to time).
This course is allowing me to evaluate using Mongo vs Postgres in a project we're about to start. Now playing around w/ Mongo and finding it super cool.