Databases
32 posts
Data Warehouses Are Terrible Application Backends
‘The ever-increasing tide of data has become a paradox of plenty for today’’s developers. According to a report from Seagate, by 2025 worldwide data will grow to a staggering 163 zettabytes, over 10...'
How to Build Applications over Streaming Data the Right Way
In modern data ecosystems, streaming data flows like traffic on a busy highway. Each packet of data has a specific destination,...
The Engineer’s Guide to Enriching Streams and Dimensions
Data - it’s the new oil, the new gold, the new … you get the idea. There’s a whole lot of it, and it’s valuable. But unless you’re into data hoarding, the point isn’t just to collect it; you want …...
Why ClickHouse Should Be Your Next Database
“Today, we’re jumping into databases. Another database to learn? But before you sprint for the hills, allow me to introduce you to ClickHouse.”
A step-by-step guide to build a real-time dashboard
Can you imagine shipping a new user-facing dashboard only to have your users met with a visualization that takes several seconds or even minutes to load? No way, right? Your users would get...
How to build a real-time fraud detection system
Financial fraud is a growing concern in our increasingly digital world. According to a report by PwC, almost half of the surveyed organizations experienced fraud in the past 2 years. For...
Modern data management with real-time Change Data Capture
Data engineers are grappling with surging data volumes while stakeholders increasingly demand real-time decision-making and user-facing features powered by data. This raises a fundamental question:...
Real-time Databases: What developers need to know
Selecting the right application database can be a challenge for developers, especially so when you need a database for building real-time applications. Real-time data has become an essential...
Using Bloom filter indexes for real-time text search in ClickHouse
Efficient text search is one of the hardest problems in data engineering. Text-based data presents a unique set of challenges, especially when you need results in real time...
What it takes to build a real-time recommendation system
Real-time, personalized recommendations have become a foundational part of our online experiences. From streaming services suggesting our next binge-worthy TV series to e-commerce platforms offering...
Event sourcing with Kafka: A practical example
Imagine you’re building banking software, and you’ve been asked to figure out one of the most fundamental tasks in fintech: determining the current balance of every customer in your system....
How to query Google Sheets with SQL in real time
Sick of manually wrestling with Google Sheets like it’s an Excel spreadsheet from 2005? Feel like force-quitting Chrome every time you attempt to sift through just 10,000 rows of data? We’ve all...
Databases and DevOps: How to Use SingleStore With GitHub Actions
Databases are frequently not included when transforming an application and engineering culture toward a DevOps, or continuous deployment engineering organization. And, you could be forgiven for this...
How to Use SingleStore as a Key-Value Store
Key-value stores are perhaps one of the most popular databases on the market today - and with good reason! They are fast, scalable and super easy to use. But did you know you can get all the...
Four Questions You Need To Ask When Choosing a Database
Are you overwhelmed by the sheer amount of databases on the market today, and not sure where to start? Let’s say that you are a Software Developer, and you need to select a database for a brand new...
Database Sharding vs. Partitioning: What’s the Difference?
In this post, I explain the differences between database sharding vs. partitioning and explore when to use each - or even to combine them for data-intensive applications.
How to Add Machine Learning Predictions with SingleStore and MindsDB
Have you ever needed to set a machine learning model on your data before?
How to Get Started with SingleStore
Are you looking for the fastest possible way to get a new SingleStore Cluster up and running while testing out sample datasets to experiment with and use?
How to Use SingleStore and Node.js
Do you need to get a basic SingleStore application setup quickly using Node.js?
How to Manage MongoDB Data at Scale
Let’s face it: Your data can get stale and old quickly. But just because the data isn’t being used as often as it once was doesn’t mean that it’s not still valuable or that it won’t be valuable again...
How to Query from Multiple MongoDB Databases
Have you ever needed to make queries across databases, clusters, data centers, or even mix it with data stored in an AWS S3 blob? You probably haven’t had to do all of these at once, but I’m guessing...
How to Seed a MongoDB Database with Fake Data
Have you ever worked on a MongoDB project and needed to seed your database with fake data in order to provide initial values for lookups, demo purposes, proof of concepts, etc.? I’m biased, but I’ve...
How to Use Custom Archival Rules and Partitioning on MongoDB Atlas Online Archive
Okay, so you’ve set up a simple MongoDB Atlas Online Archive, and now you might be wondering, “What’s next?” In this post, we will cover some more advanced Online Archive use cases, including setting...
How to use MongoDB Client-Side Field Level Encryption (CSFLE) with Node.js
Have you ever had to develop an application that stored sensitive data, like credit card numbers or social security numbers? This is a super common use case for databases, and it can be a pain to...
MongoDB Aggregation Pipeline Queries vs SQL Queries
Let’s be honest: Many devs coming to MongoDB are joining the community with a strong background in SQL. I would personally include myself in this subset of MongoDB devs. I think it’s useful to map...
How To Use The MongoDB Visual Studio Code Plugin
To make developers more productive when working with MongoDB, we built MongoDB for Visual Studio Code, an extension that allows you to quickly connect to MongoDB and MongoDB Atlas and work with your...
Linked Lists and MongoDB: A Gentle Introduction
Are you new to data structures and algorithms? In this post, you will learn about one of the most important data structures in Computer Science, the Linked List, implemented with a MongoDB twist....
Save The World And Money With MongoDB Atlas Data Lake
Thanks for coming to my talk, Save The World And Money With MongoDB Atlas Data Lake. About Data centers are expensive. It turns out that this is not great for the environment. By 2040, storing...
MongoDB Schema Design Best Practices
Thanks for coming to my talk, MongoDB Schema Design Best Practices. Here you will find all the resources discussed during the talk. About Have you ever wondered, “How do I model my schema for my...
From SQL to NoSQL: A Gentle Introduction For Devs
Thanks for coming to my talk, From SQL to NoSQL: A Gentle Introduction For Devs. Here you will find all the resources discussed during the talk. About “I have heard about NoSQL databases, but don’t...
Building Your First GraphQL Client in JS
Thanks for coming to my talk, Building Your First GraphQL Client in JS. Here you will find all the resources discussed during the talk. About RESTful APIs have been around for a while now, but they...
How to Build a React and MongoDB App From Scratch In 10 Minutes
Are you interested in learning how to build a React and MongoDB App? Like many of you, I have been interested in learning more about MongoDB’s cloud offerings and also not spending a dime. This guide...