article thumbnail

Designing WhatsApp

High Scalability

Design an instant messenger platform such as WhatsApp or Signal which users can utilize tosend messages to each other. However, instant messengers such as WhatsApp don’t save the messages permanently on their server. Problem Statement. Gathering Requirements.

Design 344
article thumbnail

Designing Instagram

High Scalability

Design a photo-sharing platform similar to Instagram where users can upload their photos and share it with their followers. High Level Design. When the server receives a request for an action (post, like etc.) Component Design. API Design. We have provided the API design of posting an image on Instagram below.

Design 334
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

SQL Server Clustered Indexes internals with examples

SQL Shack

In this article, we will learn the SQL Server clustered index concept and some internal details. Indexes are the database objects that accelerate the performance of data accessing when are designed properly.

Servers 86
article thumbnail

OKRs Examples for Software Companies

Tasktop

OKRs should be designed so that every team’s activities can be traced up to the company’s vision. This is easier said than done, so we’ve designed three sets of OKRs examples for software companies to show how it’s possible. Get the ebook on designing flow-based OKRs. This is your Objective.

article thumbnail

PostgreSQL Database Security: External Server-Based Authentication

Percona

PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server. The pg_hba.conf file is used to configure the authentication methods the PostgreSQL server uses and can specify different methods for different types of connections.

Database 124
article thumbnail

Additional T-SQL Improvements in SQL Server 2022

SQL Performance

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. I’ll be using the sample database TSQLV6 in the examples in this article. Those improvements were introduced in CTP 2.0.

Servers 142
article thumbnail

New Bit Manipulation Functions in SQL Server 2022

SQL Performance

One example is using a bitwise representation of a set of user/role permissions. Another example is using a bitwise representation of a set of settings turned on or off in a given environment. Even SQL Server stores some flag-based data using bitwise representation. The returned value is of the BIT type.

Servers 122