2349 views • Database Engineering
Traditional databases like MySQL, Postgres, MongoDB run on their server on a specific port. Anyone who wants to talk to the database can directly connect and talk.
Embedded Databases are different from these traditional databases, and they operate in their own confined space within a process. There is no separate process for the database.
No one can directly connect to this database, unlike how we do it with MySQL and other databases. The role and the use of the embedded database are limited to the process it is confined to.
An embedded database is always designed to solve one niche really well.
Every modern browser uses an embedded database called IndexedDB to store browsing history and other configuration settings locally. The browser is confined to a machine, and the IndexedDB is contained in the browser; there is no separate process to connect to.
Every Android phone has support for SQLite database that we can use to store any information like game scores, stats, and information locally on the phone.
The core idea: When we need to store and query data that could be confined within a space and does not need to be centralized, we choose to use an Embedded Database.
If you like what you read subscribe you can always subscribe to my newsletter and get the post delivered straight to your inbox. I write essays on various engineering topics and share it through my weekly newsletter.
2461 views • 135 likes • 2022-03-21
Any persistent database needs to guarantee reliability. No matter how big or small the changes are, they should survive ...
4312 views • 303 likes • 2022-03-16
In this video, we discuss how indexes make a database operate faster. While discussing that, we dive deep into how the d...
A set of courses designed to make you a better engineer and excel at your career; no-fluff, pure engineering.
Being a passionate engineer, I love to talk about a wide range of topics, but these are my personal favourites.
Arpit's Newsletter read by 17000+ engineers
🔥 Thrice a week, in your inbox, an essay about system design, distributed systems, microservices, programming languages internals, or a deep dive on some super-clever algorithm, or just a few tips on building highly scalable distributed systems.
Powered by this tech stack.