Understanding Homomorphic Encryption: A Future for Secure Data
This note covers homomorphic encryption from a lecture, explaining what it is, how it lets us work with encrypted data, its pros and cons, and a demo showing it in action.
Experiment: Finding the Largest SQL Query a Database Can Handle
In this experiment, we test how large an SQL query can get before crashing a PostgreSQL database, using Node.js and Wireshark to monitor the process.
Best Practices for Database Permissions in REST API Development
This lecture explains how to secure databases in REST API apps by using separate users with limited permissions for each route, avoiding risks like SQL injection.
How to Secure Your Postgres Database by Enabling TLS/SSL
This lecture explains how to set up a Postgres database with a secure TLS/SSL connection using Docker, connect to it with PgAdmin, and protect data in transit.
Exploring the Postgres Wire Protocol with Wireshark
This lecture shows how to use Wireshark to analyze the Postgres wire protocol by capturing packets between a Node.js client and a cloud-hosted Postgres database.
Understanding the MongoDB Wire Protocol with Wireshark
A simple guide to how MongoDB talks over the network, using Wireshark to see the details.
Understanding Redis: Why It’s So Popular
This note explains why Redis became a top choice for caching, databases, and messaging, with its key features and a hands-on example using Docker.
Understanding Memcached Architecture
This lecture explores the architecture of Memcached, an in-memory key-value store, covering its memory management, threading model, and distributed nature.
117 post articles, 15 pages.