Databases

Architectural Context

Detailed reference for Databases in the context of Data & Advanced Analytics.

• thenewstack.io: How Database Load Balancing Completes the 3-Tiered Architecture 🌟 [COMMUNITY-TOOL]
• sqlshack.com: SQL Database on Kubernetes: Considerations and Best Practices 🌟 [COMMUNITY-TOOL]
• thenewstack.io: Just How Challenging Is State in Kubernetes? 🌟 [COMMUNITY-TOOL]
• theregister.com: 75% of databases to be cloud-hosted by 2022, says Gartner while dishing on the weak points of each provider [COMMUNITY-TOOL]
• thenewstack.io: What Is Data Management in the Kubernetes Age? [COMMUNITY-TOOL]
• thenewstack.io: A Case for Databases on Kubernetes from a Former Skeptic [COMMUNITY-TOOL]
• hackernoon.com: Database Vs Data Warehouse Vs Data Lake: A Simple Explanation [COMMUNITY-TOOL]
• percona.com: DBaaS on Kubernetes: Under the Hood 🌟 [COMMUNITY-TOOL]
• blog.crunchydata.com: Using Kubernetes? Chances Are You Need a Database 🌟 [COMMUNITY-TOOL]
• thenewstack.io: Databases — Finally — Get Containerized [COMMUNITY-TOOL]
• percona.com: Autoscaling Databases in Kubernetes for MongoDB, MySQL, and PostgreSQL [COMMUNITY-TOOL]
• towardsdatascience.com: SQL vs. NoSQL: How to Select from 12 Database Types 🌟🌟 [COMMUNITY-TOOL]
• andrewlock.net: Running database migrations when deploying to Kubernetes 🌟 [COMMUNITY-TOOL]
• red-gate.com: Designing Highly Scalable Database Architectures [COMMUNITY-TOOL]
• thenewstack.io: Database-as-a-Service: A Key Technology for Agile Growth [COMMUNITY-TOOL]
• cloud.redhat.com: OpenShift Commons Briefing: Database Disaster Recovery Made Easy with Annette Clewett (Red Hat) and Andrew L'Ecuyer (Crunchy Data) [COMMUNITY-TOOL]
• hackernoon.com: Practical Transaction Handling in Microservice Architecture [COMMUNITY-TOOL]
• thenewstack.io: Data on Kubernetes: Operators, Tools Need Standardization [COMMUNITY-TOOL]
• thenewstack.io: Kubernetes Will Revolutionize Enterprise Database Management [COMMUNITY-TOOL]
• cloud.redhat.com: Simplifying Database Cloud Service Access [COMMUNITY-TOOL]
• vladmihalcea.com: Single-Primary Database Replication [COMMUNITY-TOOL]
• treblle.com: How does Treblle scale on AWS without breaking the bank? [COMMUNITY-TOOL]
• intellipaat.com: Difference between DBMS and RDBMS [COMMUNITY-TOOL]
• thenewstack.io: How Kubernetes and Database Operators Drive the Data Revolution [COMMUNITY-TOOL]
• thenewstack.io: How Radical API Design Changed the Way We Access Databases [COMMUNITY-TOOL]
• architecturenotes.co: Things You Should Know About Databases [COMMUNITY-TOOL]
• vladmihalcea.com: A beginner’s guide to database multitenancy [COMMUNITY-TOOL]
• itnext.io: How to Run Databases in Kubernetes [COMMUNITY-TOOL]
• thenewstack.io: More Database, Analytics Workloads Ran on Kubernetes in 2022 [COMMUNITY-TOOL]
• infoq.com: Create Your Distributed Database on Kubernetes with Existing Monolithic Databases [COMMUNITY-TOOL]
• thenewstack.io: Distributed Database Architecture: What Is It? [COMMUNITY-TOOL]
• severalnines.com: How Does a Database Load Balancer Work? [COMMUNITY-TOOL]
• digitalocean.com: How To Use WHERE Clauses in SQL [COMMUNITY-TOOL]
• intellipaat.com: SQL vs MySQL - Key Differences Between SQL and MySQL [COMMUNITY-TOOL]
• vettabase.com: How slow is SELECT * ? [COMMUNITY-TOOL]
• towardsdatascience.com: How to Use SQL Cross Joins [COMMUNITY-TOOL]
• vladmihalcea.com: SQL EXISTS and NOT EXISTS [COMMUNITY-TOOL]
• vladmihalcea.com: Default Database Primary, Foreign, and Unique Key Indexing [COMMUNITY-TOOL]
• blog.jooq.org [COMMUNITY-TOOL]
• vladmihalcea.com: SQL LEFT JOIN – A Beginner’s Guide [COMMUNITY-TOOL]
• vladmihalcea.com: SQL JOIN USING – A Beginner’s Guide [COMMUNITY-TOOL]
• gcreddy.com: SQL Step by Step Videos [COMMUNITY-TOOL]
• freecodecamp.org: SQL Joins Tutorial: Cross Join, Full Outer Join, Inner Join, Left Join, and Right Join [COMMUNITY-TOOL]
• freecodecamp.org: SQL Join Types – Inner Join VS Outer Join Example [COMMUNITY-TOOL]
• freecodecamp.org: The SQL Inner Join Command: Example Syntax [COMMUNITY-TOOL]
• freecodecamp.org: SQL Inner Join – How to Join 3 Tables in SQL and MySQL [COMMUNITY-TOOL]
• geeksforgeeks.org: Best Practices for SQL Query Optimization [COMMUNITY-TOOL]
• towardsdatascience.com: You Should Use This to Visualize SQL Joins Instead of Venn Diagrams [COMMUNITY-TOOL]
• vladmihalcea.com: MySQL JSON_TABLE – Map a JSON object to a relational database table [COMMUNITY-TOOL]
• infoworld.com: Beyond SQL: 8 new languages for data querying [COMMUNITY-TOOL]
• blog.yugabyte.com: Are Stored Procedures and Triggers Anti-Patterns in the Cloud Native World? [COMMUNITY-TOOL]
• xenonstack.com: Stateful and Stateless Applications Best Practices and Advantages [COMMUNITY-TOOL]
• threadreaderapp.com: Kelsey Hightower: "Kubernetes has made huge improvements in the ability to run stateful workloads including databases and message queues, but I still prefer not to run them on Kubernetes" 🌟 [COMMUNITY-TOOL]
• thenewstack.io: Data on Kubernetes: The Next Frontier [COMMUNITY-TOOL]
• openshift.com: OpenShift, Databases and You: When to Put Containerized Database Workloads on OpenShift 🌟 [COMMUNITY-TOOL]
• thenewstack.io: How to Ensure Your Serverless Database Stays Serverless [COMMUNITY-TOOL]
• thenewstack.io: The Benefits and Drawbacks of DataOps in Practice [COMMUNITY-TOOL]
• cloudbees.com: Introductory Handbook for Database Continuous Integration [COMMUNITY-TOOL]
• cloud.google.com: To run or not to run a database on Kubernetes - What to consider [COMMUNITY-TOOL]
• informationweek.com: Can Enterprises Benefit From Adopting Database DevOps? [COMMUNITY-TOOL]
• kubedb.com [COMMUNITY-TOOL]
• Cockroach [COMMUNITY-TOOL]
• cockroachlabs.com: Automated database operations with Terraform [COMMUNITY-TOOL]
• itnext.io: Operator Lifecycle Manager [COMMUNITY-TOOL]
• Spilo: HA PostgreSQL Clusters with Docker [COMMUNITY-TOOL]
• Patroni [COMMUNITY-TOOL]
• How I've Set Up HA PostgreSQL on Kubernetes (powered by Patroni, a template for PostgreSQL HA) [COMMUNITY-TOOL]
• Zalando Postgres Operator [COMMUNITY-TOOL]
• Automate SQL Server Backups with PowerShell [COMMUNITY-TOOL]
• Expanding SQL Server Big Data Clusters capabilities, now on Red Hat OpenShift [COMMUNITY-TOOL]
• devblogs.microsoft.com: DevOps for Azure SQL 🌟 [COMMUNITY-TOOL]
• khalidabuhakmeh.com: Running SQL Server Queries In Docker [COMMUNITY-TOOL]
• blog.eduguru.in: mysql create index on table [COMMUNITY-TOOL]
• percona.com: MySQL 101: Parameters to Tune for MySQL Performance [COMMUNITY-TOOL]
• opensource.com [COMMUNITY-TOOL]
• percona.com: MySQL on Kubernetes with GitOps 🌟 [COMMUNITY-TOOL]
• Moco [COMMUNITY-TOOL]
• tusacentral.com: MySQL on Kubernetes demystified [COMMUNITY-TOOL]
• thenewstack.io: Deploy MySQL and phpMyAdmin with Docker [COMMUNITY-TOOL]
• thenewstack.io: Maria DB Gets Reactive with a Non-Blocking Connector for Java [COMMUNITY-TOOL]
• 9 High-Performance Tips when using PostgreSQL with JPA and Hibernate [COMMUNITY-TOOL]
• migops.com: pgBackRest – The Best Postgres Backup Tool with a very active community [COMMUNITY-TOOL]
• towardsdatascience.com: Practical Introduction to PostgreSQL [COMMUNITY-TOOL]
• percona.com: An Overview of Sharding in PostgreSQL and How it Relates to MongoDB’s [COMMUNITY-TOOL]
• blog.crunchydata.com: How to Setup PostgreSQL Monitoring in Kubernetes [COMMUNITY-TOOL]
• blog.flant.com: Comparing Kubernetes operators for PostgreSQL [COMMUNITY-TOOL]
• blog.crunchydata.com: Cut Out the Middle Tier: Generating JSON Directly from Postgres [COMMUNITY-TOOL]
• percona.com: How to Adjust Linux Out-Of-Memory Killer Settings for PostgreSQL [COMMUNITY-TOOL]
• Postgres.app [COMMUNITY-TOOL]
• devopscube.com: How to Deploy PostgreSQL Statefulset in Kubernetes With High Availability [COMMUNITY-TOOL]
• blog.crunchydata.com: Quickly Document Your Postgres Database Using psql Meta-Commands [COMMUNITY-TOOL]
• blog.crunchydata.com: Devious SQL: Message Queuing Using Native PostgreSQL [COMMUNITY-TOOL]
• percona.com: Should I Create an Index on Foreign Keys in PostgreSQL? [COMMUNITY-TOOL]
• percona.com: PostgreSQL 14 Database Monitoring and Logging Enhancements [COMMUNITY-TOOL]
• theregister.com: MySQL a 'pretty poor database' says departing Oracle engineer [COMMUNITY-TOOL]
• wanago.io: Creating views with PostgreSQL [COMMUNITY-TOOL]
• percona/pg_stat_monitor [COMMUNITY-TOOL]
• blog.crunchydata.com: A Postgres Primer for Oracle DBAs [COMMUNITY-TOOL]
• blog.crunchydata.com: Postgres Indexes for Newbies [COMMUNITY-TOOL]
• dev.to: REST Data Service on YugabyteDB / PostgreSQL [COMMUNITY-TOOL]
• orgrim/pg_back: Simple backup tool for PostgreSQL [COMMUNITY-TOOL]
• sqlrevisited.blogspot.com: MySQL vs PostgreSQL? Pros and Cons [COMMUNITY-TOOL]
• adamtheautomator.com: How to Deploy Postgres to Kubernetes 🌟 [COMMUNITY-TOOL]
• purnapoudel.blogspot.com: How to Configure PostgreSQL with SSL/TLS support on Kubernetes [COMMUNITY-TOOL]
• Percona.com: Percona Kubernetes Operator for Percona XtraDB Cluster [COMMUNITY-TOOL]
• percona.com: MySQL 101: How to Find and Tune a Slow SQL Query [COMMUNITY-TOOL]
• percona.com: Storing Kubernetes Operator for Percona Server for MongoDB Secrets in Github [COMMUNITY-TOOL]
• percona.com: Migration of a MySQL Database to a Kubernetes Cluster Using Asynchronous Replication [COMMUNITY-TOOL]
• percona.com: Migrating PostgreSQL to Kubernetes [COMMUNITY-TOOL]
• RedisLabs/redis-enterprise-k8s-docs: Deploying Redis Enterprise on Kubernetes [COMMUNITY-TOOL]
• freecodecamp.org: How to Get Started with PysonDB [COMMUNITY-TOOL]
• clickhouse.com [COMMUNITY-TOOL]
• Altinity/clickhouse-operator [COMMUNITY-TOOL]
• radondb/radondb-clickhouse-kubernetes [COMMUNITY-TOOL]
• tech.marksblogg.com: Monitor ClickHouse column oriented database with Prometheus & Grafana [COMMUNITY-TOOL]
• Apache Ignite [COMMUNITY-TOOL]
• Apache Druid [COMMUNITY-TOOL]
• dev.to: Apache Druid: overview, running in Kubernetes and monitoring with Prometheus [COMMUNITY-TOOL]
• github.com/dolthub/dolt [COMMUNITY-TOOL]
• victoriametrics.com [COMMUNITY-TOOL]
• victoriametrics.com: Q2 2024 Round Up: VictoriaMetrics & VictoriaLogs Updates [COMMUNITY-TOOL]
• SHMIG [COMMUNITY-TOOL]
• DATA-DOG/go-sqlmock [COMMUNITY-TOOL]
• datafold/data-diff [COMMUNITY-TOOL]
• thenewstack.io: You Don’t Need a Blockchain, You Need a Time-Series Database [COMMUNITY-TOOL]
• opensource.com: Make your data boss-friendly with EDA - Enterprise Data Analytics [COMMUNITY-TOOL]
• thenewstack.io: Kubernetes-Run Analytics at the Edge: Postgres, Kafka, Debezium [COMMUNITY-TOOL]
• unifieddatascience.com: Data lake design patterns on Azure (Microsoft) cloud [COMMUNITY-TOOL]
• unifieddatascience.com: Data lake design patterns on AWS (Amazon) cloud [COMMUNITY-TOOL]
• unifieddatascience.com: Data lake design patterns on google (GCP) cloud [COMMUNITY-TOOL]
• SQErzo: Tiny ORM for Graph databases [COMMUNITY-TOOL]
• towardsdatascience.com: At Its Core: How Is a Graph Database Different from a Relational One? [COMMUNITY-TOOL]
• xataka.com: El Excel se ha usado en la Fórmula 1 hasta que se han dado cuenta que no es la mejor forma de controlar las 20.000 piezas del coche [COMMUNITY-TOOL]

---

💡 Explore Related: Yaml | Message Queue | Newsql