Remove Database Remove Design Remove Servers Remove Software Engineering
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.) We will use a graph database such as Neo4j to store the information. Component Design. API Design.

Design 334
article thumbnail

How It Works: SQL Server Lock Partitioning

SQL Server According to Bob

The lock manager (LockMgr) is designed to track partitioned and non-partitioned locks. A handful of lock types (Database, Metadata, LOGIN_STATS, …) are eligible for lock partitioning. For example: When ‘use database’ takes place the session acquires a shared lock on database.

Servers 103
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

Sponsored Post: G-Core Labs, Close, Wynter, Pinecone, Kinsta, Bridgecrew, IP2Location, StackHawk, InterviewCamp.io, Educative, Stream, Fauna, Triplebyte

High Scalability

Close is building the sales communication platform of the future and we're looking for a Site Reliability Engineer to help us accomplish that goal. has hours of system design content. They also do live system design discussions every week. The geolocation database or API detects location, proxy and other >20 parameters.

Education 100
article thumbnail

Sponsored Post: Close, Wynter, Pinecone, Kinsta, Bridgecrew, IP2Location, StackHawk, InterviewCamp.io, Educative, Stream, Fauna, Triplebyte

High Scalability

Close is building the sales communication platform of the future and we're looking for a Site Reliability Engineer to help us accomplish that goal. has hours of system design content. They also do live system design discussions every week. The geolocation database or API detects location, proxy and other >20 parameters.

Education 100
article thumbnail

Sponsored Post: G-Core Labs, Close, Wynter, Pinecone, Kinsta, Bridgecrew, IP2Location, StackHawk, InterviewCamp.io, Educative, Stream, Fauna, Triplebyte

High Scalability

Close is building the sales communication platform of the future and we're looking for a Site Reliability Engineer to help us accomplish that goal. has hours of system design content. They also do live system design discussions every week. The geolocation database or API detects location, proxy and other >20 parameters.

Education 100
article thumbnail

New Metadata-Only Column Changes in SQL Server 2016

SQL Performance

When we ask SQL Server to change some aspect of a column's definition, it needs to check that the existing data is compatible with the new definition. Depending on the type of change and the configuration of the database, an ALTER COLUMN command will need to perform one of the following actions: Change metadata in system tables only.

Servers 63
article thumbnail

Sponsored Post: Wynter, Pinecone, Kinsta, Bridgecrew, IP2Location, StackHawk, InterviewCamp.io, Educative, Stream, Fauna, Triplebyte

High Scalability

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. has hours of system design content. They also do live system design discussions every week. Apply here.

Education 100