Database

Latest Posts in Database

Exponential Smoothing for Time Series Forecasting

Time series anomaly detection is a complicated problem with plenty of practical methods. It’s easy to find yourself getting lost in all of the topics it encompasses. Learning them is…

When to Use explain() in MongoDB

In MongoDB, the command db.collection.explain() is an important operation to help you understand exactly how your queries execute and behave. Once you have a grasp of how MongoDB handles explain(),…

Why WiredTiger Is the Default MongoDB Storage Engine

When we published our blog post about working-sets in MongoDB, one of our colleagues told us he’d been aware that MMAPv1 had previously been MongoDB’s default storage engine, but he…

Understanding Whether Your MongoDB Indexes Are Effective

One of the variables that can have a major impact on your MongoDB performance is the way you implement indexes. While it’s a good idea to use indexes in some…

How to Tell if Your MongoDB Server Is Correctly Sized For Your Working Set

For MongoDB users, knowledge of working sets is critical. Understanding the interactions between your working set and physical memory can make a major difference in how your system performs. To optimize…

Correlated Metrics in Monitoring

If you work with monitoring or monitoring tools much, you’ve probably seen the phrase “correlating” here and there. For example, monitoring vendors often say you can use their product to…

Common Pitfalls When Using database/sql in Go

We’re huge fans of the Go language and its database access library, database/sql. As you’ve probably seen firsthand, the surface area of database/sql is pretty small, but there’s a lot…

Shopify Eliminates High Latency Queries From Redis and MySQL

As intuitive and streamlined as ecommerce technology might seem from the user’s perspective, it involves so much data that engineering ingenuity and smart database management must constantly deliver in order to…

JSON Support in PostgreSQL, MySQL, MongoDB, and SQL Server

If you’ve been watching the evolution of database technologies over the past few years, you’ve seen how quickly JSON has quickly cemented its position in major database servers. Due to its use…

Etsy’s Use of Performance Testing in Development

In a recent case study, we profiled Etsy and learned about how a high-performance data platform helps keep Etsy’s global community engaged. In that study, Etsy’s engineering team provided some key…