Our managed MySQL database currently uses a parameter group with `time_zone = 'US/Pacific'`. British Columbia is moving to permanent Pacific Daylight Time at UTC−07:00, so the current timezone…
I've developed a strong interest in SQL and databases through college and my professional experience. I enjoy writing clean, readable, maintainable queries and have practical experience creating SQL…
I run an uptime monitoring service that checks various protocols every two minutes from multiple regions. Each check creates a row in BigQuery, and I'm starting to worry…
I've been hopping around cloud platforms, starting with Google Cloud, then moving to DigitalOcean (DO) for my projects. I really appreciate how DO's managed databases are located right…
We're transitioning to Kubernetes for our company's software platform and have noticed a lot of advantages, like teams being able to independently develop and deploy services. However, we're…
I'm working in a CI/CD-driven environment using Docker, Kubernetes, and Azure, but I'm finding that database changes are less predictable compared to application deployments. We utilize migrations, yet…
I'm trying to decide if Amazon RDS is worth the added expense compared to running PostgreSQL on EC2. What are the benefits and drawbacks of each option?
I'm having an issue where my local SQL Express database keeps exceeding the 10GB limit. Even though the total objects in my tenant are less than 25% of…
Hey everyone! I'm a software engineering student gearing up for my graduation project, and I've got a vision for a mobile app that would help manage educational facilities,…
Hey everyone! I'm diving into multi-tenant systems and I'm curious about how to handle database creation when a new client signs up. If I want to have one…
I'm transitioning from AWS to an on-premises setup and I'm looking for recommendations on solutions for managing PostgreSQL. I've heard a bit about the Zalando PostgreSQL operator, but…
Hey everyone! I'm diving into Cosmos DB for my multi-tenant SaaS project, and I need some help with partition keys. Currently, I'm using `/instanceId` to keep tenant data…
I'm wondering if it's possible to use the 'begins with' function specifically on a partition key in DynamoDB. Are there any limitations I should be aware of?
Hey everyone! I'm diving into managing my databases with CloudNativePG and need some advice. What CSI driver do you all recommend for it? I've been looking at TopoLVM…
I'm really fascinated by how log analysis websites, particularly Warcraftlogs, manage to scale for such a vast user base. They process log files that can have 10 to…
I'm a beginner programmer looking to create a program that reads a specific value from a game app's memory, then stores that data in a database. Ideally, my…
I recently came across a new feature in PostgreSQL that allows logical replication from a reader or standby instance. I'm really curious to know if this also applies…
Hey folks! I'm eyeing a job that requires experience with several database technologies, including Oracle Database Server, MS SQL Server (specifically Always On Availability Groups), MongoDB, and MySQL.…