_    ____  _____  __   _____  _   _                  
                    / \  |  _ \| ____| \ \ / / _ \| | | |                 
                   / _ \ | |_) |  _|    \ 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