A popular type of general-purpose data model is the relational data model, where data is organised into relations (in SQL, they’re called tables) and each relation is an unordered collection of tuples (rows in SQL). The benefit of relational models is that they’re able to abstract the implementation of internal data representation behind a clean interface.
Where do relational databases fail? For large datasets or a high write throughput, they scale poorly. There are also limited FOSS relational DBs.
Sub-pages
- Relational-style tools
- Polars, a SQL-style dataframe library