Tag: Database

My relationship with relational databases relates back to the late 90s. It was part of my first steps with computers and programming, became an essential part of my formal education and studies as a software engineer and constantly followed me through my professional career. I almost crawled through...

My relationship with relational databases relates back to the late 90s. It was part of my first steps with computers and programming, became an essential part of my formal education and studies as a software engineer and constantly followed me through my professional career. I almost crawled through...

This is an updated version of the original article. Search is the base of many applications. Once data starts to pile up, users want to be able to find it. It’s the foundation of the internet and an ever-growing challenge that is never solved or done. The field of Natural Language P...

Local data storage is crucial for many Android applications, allowing them to store and retrieve data efficiently. In this guide, we will explore Room, a powerful library that simplifies database management in Android apps. We’ll cover everything from setting up Room to performing database ope...

Search is the base of many applications. Once data starts to pile up, users want to be able to find it. It’s the foundation of the internet and an ever-growing challenge that is never solved or done. The field of Natural Language Processing (NLP) is rapidly evolving with a number of new dev...

While developing a website ,we need to store app data and user information in a safe and secure place and it should be easily accessible by the webapp so that the data can be stored and retrieved at a faster rate and the user can experience a smooth web service.Speaking about the data,wher...

Last time I wrote about Facebook fanout, but got bogged down in trying to figure out what Facebook actually did. A requirement for Facebook is that users can publish posts; another requirement is that users can receive posts (“news”). We can implement this with the push/fanout-on-write a...

My relationship with relational databases relates back to the late 90s. It was part of my first steps with computers and programming, became an essential part of my formal education and studies as a software engineer and constantly followed me through my professional career. I almost crawled through...

I’ve seen this over and over for the last 30 years, people let the database set the ID or Primary Key of a table from the database, at first glance this sounds simple and everyone knows you should let the database do the heavy lifting, with a numeric “Sequence” number you need to l...

Welcome back! In part 2 of “Zero To Million Users”, we’ll dive into the world of databases — the backbone of any successful application. From relational to graph databases, we’ll explore the pros and cons of each and discover when to use what. So fasten your seatbelts, ...

Search is the base of many applications. Once data starts to pile up, users want to be able to find it. It’s the foundation of the internet and an ever-growing challenge that is never solved or done. The field of Natural Language Processing (NLP) is rapidly evolving with a number of new dev...

In my research to understand how a simple SQL query sent from the app end up in the disk I learned that the term page and block is perhaps the most overloaded concepts in software engineering. There is a database page, an operating system virtual memory page, a file system block,...

As a backend developer, efficiency and simplicity are paramount when it comes to managing databases and infrastructure. MongoDB, a NoSQL database known for its flexibility, and Docker, a containerization platform, have become my dynamic duo for database management. In this article, I&rsquo...

√ What exactly is WordPress? WordPress, at its core, is the easiest and most popular way to create your own website or blog. WordPress, in fact, powers more than 1 in 4 websites on the Internet. WordPress is a free and open-source content management system. A content management system (CMS)...

When building a service with microservices, each microservice performs a specific task and can be independently deployed and scaled. This means that a service can be composed of many microservices, each with a short runtime, rather than a monolithic application that performs all tasks in a single pr...

Recently, I started a new job as a mobile developer. My first assignment: write unit tests for an application that leveraged Paging Library. If you’re unfamiliar with this powerful tool, you can delve deeper into its info here: Paging Library Overview. To give you a quick snapshot, the...

In the ever-evolving landscape of technology, staying one step ahead is crucial to ensure your business’s success in the long run. And when it comes to optimizing database performance, being ahead of the game becomes even more important. That’s where Vitess comes into play — a powe...

The MIT-BIH Arrhythmia Database is a set of 30-minute heart rhythm recordings (AKA “electrocardiograms” or “ECGs”) from 47 patients from 1975 to 1979. The data is from a range of healthy to heart-diseased patients and is useful for practicing analyses of t...

As many of you may know, over the past 4 years I have been meticulously building The Sneaker Database. As of March, I decided to sell The Sneaker Database to Arbit. Not to worry. The same great data and insights will still be available just under a new name. While a separate article explaining ...