DATABASE DESIGN – Telegram
DATABASE DESIGN
1.41K subscribers
2.09K photos
3 videos
5.35K links
Лучшие материалы по работе с хранилищами данных на русском и английском языке

Разместить рекламу: @tproger_sales_bot

Правила общения: https://tprg.ru/rules

Другие каналы: @tproger_channels

Другие наши проекты: https://tprg.ru/media
Download Telegram
Где и как хранит данные западный бизнес?

Мы решили поделиться результатами опроса, проведенного агентством S&P Global в начале 2022 года. Они позволяют узнать, какие поставщики систем хранения данных и какие технологии лидируют в 2022-м, кто готов сменить свою СХД и почему.
Взглянуть на рейтинги и цифры

Читать: https://habr.com/ru/post/660841/
What is a Bloom Filter 🤔

Suppose you are creating an account on Twitch or any other website, you will immediately think of a cool username like noobmaster69🙃 and when you submit the form you immediately get "User Name Already Taken"😡 you will try out other cool names or ev...

Read: https://hashnode.com/post/what-is-a-bloom-filter-cl1yv82eg00i3y6nv5hvpfvjq
Find the best Biotechnology Email List | Biotechnology Mailing list in US

Are you seeking reliable data on the biotech sector? AverickMedia's Biotechnology Email List can put you in touch with researchers, life sciences professionals, and biotechnologists from all around the world. Our proper data analysis allows us to pro...

Read: https://hashnode.com/post/find-the-best-biotechnology-email-list-or-biotechnology-mailing-list-in-us-cl1yzx17m0121y6nv28016h1n
Save costs by automating the start and stop of Amazon RDS instances with AWS Lambda and Amazon EventBridge

Read: https://aws.amazon.com/blogs/database/save-costs-by-automating-the-start-and-stop-of-amazon-rds-instances-with-aws-lambda-and-amazon-eventbridge/
Database Locking

Introduction
When many people attempt to modify data in a database at the same time, a system of controls must be implemented so that modifications made by one person do not adversely affect those of another person. This is called concurrency control...

Read: https://codeminion.hashnode.dev/database-locking
Oracle 21c Persistent Memory Database – Eliminate Latency with Directly Mapped Buffer Cache

Persistent Memory Database using Directly Mapped Buffer Cache feature in Oracle 21c and beyond.

Read: https://blogs.oracle.com/database/post/oracle-21c-persistent-memory-database-direct-mapped-buffer-cache
How to Avoid Cartesian Explosion while using EF Core

Cartesian Product
Cartesian product is a mathematical denoscription of a multiplication of two sets. When the first set consists of two elements and the second one consists of three elements, the cartesian product result set consists of 6 elements. Eac...

Read: https://trycatchblog.tech/how-to-avoid-cartesian-explosion-while-using-ef-core
Understanding Isolation levels in SQL Server

A transaction is a group of T-SQL statements performing single or multiple operations on objects as a single unit. If any of the statements in the transaction fails, then the whole operation reverts due to transaction rollback. This assures that thos...

Read: https://mssqlserver.dev/understanding-isolation-levels-in-sql-server
Aggregation in MongoDB

Hello, devs 👋
In this blog, we will learn the basics of the MongoDB aggregation framework to filter, sort, group, and transform our MongoDB results. MongoDB helps us to do all these operations through aggregation pipelines which are a series of oper...

Read: https://saurabhbomble.hashnode.dev/aggregation-in-mongodb
Как настроить Kerberos аутентификации в Keycloak

Виктор Попов, техлид DevOps-команды в X5 Tech и спикер курса «Безопасность проекта: аутентификация в Keycloak», подготовил туториал. В нём он рассказывает, как настроить Kerberos аутентификации в Keycloak и как подготовить браузеры для работы.


Читать: https://habr.com/ru/post/661209/
Architecture Case Study: Complex Data-Tier Systems within Multi-Tier Web Architecture

Today, we are going to solve a technology company's data-tier multi-tier architecture problems. This company is one of the newest and fastest growing technology companies of the year. It is a USA based company with more than 5,000 employees, among wh...

Read: https://danielbossou.hashnode.dev/architecture-case-study-complex-data-tier-systems-within-multi-tier-web-architecture
Every Day Is Tax Day When Your Data Architecture Is Too Complex

Read: https://www.mongodb.com/blog/post/every-day-tax-day-when-your-data-architecture-too-complex
Day 26/100

Designing Data-Intensive Applications [Book Highlights]
[Part I : Chapter II] Data Models and Query Languages
The Cypher Query Language

Cypher is a declarative query language for property graphs, created for the Neo4j
graph database
Example 2-4. Cyp...

Read: https://rawdatareaders.hashnode.dev/day-26
«Импортозамещаем» анализ планов PostgreSQL

Вчера Hubert 'depesz' Lubaczewski закрыл доступ с российских IP ко всем своим сайтам, включая широко известный визуализатор планов PostgreSQL-запросов explain.depesz.com.

Но это не беда, потому что в компании "Тензор" мы разработали сервис explain.tensor.ru, функционал которого гораздо обширнее, и которым можете воспользоваться и вы.


Читать: https://habr.com/ru/post/660727/
Day 27/100

Designing Data-Intensive Applications [Book Highlights]
[Part I : Chapter III] Storage and Retrieval

fundamentals of a database are two things: it should store the data, it should give it back as well.

Consider the world’s simplest database, imple...

Read: https://rawdatareaders.hashnode.dev/day-27
Set up your application with Heroku's Database

Heroku is a cloud platform as a service (PaaS) supporting several programming languages as well as RDBMS like Postgres
In this blog, you're going to learn "How to set up your application with Heroku's Database"
Prerequisites

Basic JS, Postgres knowl...

Read: https://eklavya.hashnode.dev/set-up-your-application-with-herokus-database
SQL vs NoSQL

Introduction
Database is a component required to persist data. In the world of databases, there are two main types of solutions: SQL(relational) and NoSQL(non-relational) databases.
SQL
SQL stands for structured query language. As the names suggests...

Read: https://codeminion.hashnode.dev/sql-vs-nosql
🗃️ How to use Mongoose with Next.js for MongoDB?

Hey all 👋!
Next.js is an amazing full-stack framework and MongoDB is a great NoSQL database. Using them together will make an app super fast and awesome! In this post, we'll go ahead and set up the Mongoose ODM inside our Next.js app to make use of ...

Read: https://blog.usman-s.me/how-to-use-mongoose-with-nextjs-for-mongodb
How I extracted 588 Questions from A PDF file with Regex

Introduction
Before I start, I'd like to mention the article is meant to iterate the potentials of regular expression with keen attention on its style and syntax in JavaScript. Please note that the code samples in this article were executed in Node ...

Read: https://opeolluwa.hashnode.dev/how-i-extracted-588-questions-from-a-pdf-file-with-regex
SQL Queries For Mere Mortals: Filtering Your Data

Refining What You See Using WHERE

The type of SELECT statement we’ve worked with so far retrieves all the rows from a given table and uses them in the statement’s result set.
This is great if you really do need to see all the information the tabl...

Read: https://samra.hashnode.dev/sql-queries-for-mere-mortals-filtering-your-data