_ ____ _____ __ _____ _ _
/ \ | _ \| ____| \ \ / / _ \| | | |
/ _ \ | |_) | _| \ V / | | | | | |
/ ___ \| _ <| |___ | || |_| | |_| |
/_/ \_\_| \_\_____| |_| \___/ \___/
____ _ ____ _____ ____ ___
| __ ) / \ / ___|| ____| _ \__ \
| _ \ / _ \ \___ \| _| | | | |/ /
| |_) / ___ \ ___) | |___| |_| |_|
|____/_/ \_\____/|_____|____/(_)
1 / 12 echo $(whoami) • Principle Software Here is me with me cat,
Engineer Fritzy =3
• Co-founder and Chief Terminal Nerd @ PHL Code![]()
Club 2 / 12 Setting Expectations What this is: • An overview of various database paradigms and their uses • A look at some production headaches you might have with your database • Some time for me to yap about technology :D What this isn't: • An exhastive list of databases • A full deep dive into database architectures and subsystems (But I'm happy to come back and talk about that!) 3 / 12 Overview Topics we will cover: • What is a database? • Some key database paradigms, with strengths and weaknesses ◦ Key-Value ◦ Relational ◦ Document ◦ Fulltext Search • Exploring some databases inside Docker 4 / 12 What Is a Database? Who can tell me what a database is? What are the used for? It's an organized set of data usually stored on disk. This data is often managed by a Database Management System or DBMS.
Generally speaking the data is stored in a manner that makes retrieval and manipulation as efficient as possible. 5 / 12 Database Paradigms What do I mean when I say a "Database Paradigm"?
Data can take many shapes. It might be a social network, a blog, or telemetry data. We want to store and query our data in a way that matches the shape of the data. 6 / 12 Key-Value Stores Can anyone give me an example of a Key-Value Store?
At their core, Key-Value Stores are no different than HashMaps
or Dictionaries. They map a key to a value, and nothing more. This makes lookups super fast, but the lookup constraint isn't
useful on complex data. You generally see these used as in memory application caches, such as Redis or Memcached. However, they can also be used for
very performant simple sorage such as etcd which powers
Kubernetes. 7 / 12 Relational Databases Can anyone give me an example of a Relational Database?
Relational Databases are defined by structured sets of rows
and columns called tables. These tables have strict data schemas that tell you what data types they can hold. They also allow for creating relationships between columns of data which allow you to join tables together efficiently.
Common Relational Databases are PostgreSQL, MySQL, and SQLite.
You may also come across "Enterprise" databases such as OracleDB and Microsoft SQL Server.
8 / 12 Document Databases Can anyone give me an example of a Document Database?
Document Databases are heirarchical sets of key-value pairs,
similar to a key-value store, but they allow for nesting documents and support more complex datatypes. One big feature of most Document Databases is that they
schemaless, meaning the data can be any shape when you store
it. Examples of Document Databases include MongoDB and CouchDB.
9 / 12 Full Text Search Engines Can anyone give me an example of a Full Text Search Engine?
Fulltext Search Engines ingest data from other sources and
index it in such a way that makes searching text (hence the name) and ranking results fast and efficient. These are often secondary to a primary database, such as a
Relational or Document DB. Some examples of Fulltext Search Engines are ElasticSearch,
OpenSearch, and Typesense.
10 / 12 Let's Dig In You can find a git repo with a small docker compose setup to play with here: repo (https://github.com/gv14982/launchpad-db)
11 / 12 echo $(which gvasquez) My website! ( PHL Code Club (
https://gvasquez.dev/) https://phlcode.club/)
12 / 12