Relational databases, NoSQL, and downstream usage in AI models

[sgbaird]

Planning to come back to this, but some related discussion at:

Database best practices for SDLs and database types (e.g., document, relational, knowledge graphs)

There are various database frameworks, some popular ones being document-based (e.g., MongoDB), relational (e.g., postgreSQL), and knowledge graph-based (e.g., neo4j). Generally a document-based one is easiest to get started with (especially given the parallels and user familiarity with Python dictionaries), but tends to adapt poorly as needs change and schema are updated. SQL and other relational databases have a long history, and while the entry barrier is generally higher, these seem to do r…