From the course: Data Ingestion with Python

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Types of databases

Types of databases - Python Tutorial

From the course: Data Ingestion with Python

Start my 1-month free trial

Types of databases

“

- [Instructor] A database is where you store your data. Databases are a crucial part of your infrastructure, and you need to know how to work with them effectively. As a rule, prefer all the established databases unless you have a really good reason. This is not the place to play with the shiny new technology. Depending on your data end needs, you might want to look at several kinds of databases. Here are some of the major types. Relational databases store data in tables of rows and columns. They usually support SQL, and a good default choice. Some of the majors ones are PostgreSQL, MySQL, MSSQL, Oracle, and others. Key/value databases are like dicts in Python. They allow fast access by key, and use the log for caching. Redis is probably the most known one these days. Document databases store objects with fields. They allow for rapid development since they are not strict with schema. Notable ones are Elasticsearch, and MongoDB. Graph databases store relationships between objects…

Contents