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

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

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

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

Другие наши проекты: https://tprg.ru/media
Download Telegram
SaaS Insight for Building a Real-time CRM Application

Background
To store large volumes of real-time user data like email and provide insights is not easy. If your application is layered on top of Gmail to automatically extract and organize the useful information buried inside of our inboxes.
It became ...

Read: https://hashnode.com/post/saas-insight-for-building-a-real-time-crm-application-cl3dss9tx00gs07nvegkx8y5a
MariaDB Q2 2022 maintenance releases

Read: https://mariadb.com/?p=31503
Comparing DynamoDB and Fauna for multi-region data stores

One of the critical architectural decisions you must make when designing modern applications is selecting the right data storage technology. Not only can this decision be expensive to change later, but it also deeply affects your application’s availa...

Read: https://fauna.hashnode.dev/comparing-dynamodb-and-fauna-for-multi-region-data-stores-cl3eo4mdq02kur1nvhjzp9568
Migrate your SAP ASE (Sybase ASE) database to Amazon RDS for SQL Server

Read: https://aws.amazon.com/blogs/database/migrate-your-sap-ase-sybase-ase-database-to-amazon-rds-for-sql-server/
Database 04

👋🏾, welcome back.
Definition

This clause is used to combine rows from two or more tables, based on a related column between them.

Different Types of SQL Joins

INNER JOIN: returns records that have matching values in both tables
LEFT(OUTER) JOIN:...

Read: https://yusrastack.hashnode.dev/database-04
Why AWS S3 is the best fit for Data Lake

What is a data lake and why should your organisation consider creating one? A data lake is essentially a technique to monetise and derive economic value from your data.

For example, Fortnite from Epic Games has been a wildly successful game that has...

Read: https://piyushmagarwal.hashnode.dev/data-lake-with-aws-s3-part-1-3-3cf5a093e76
#0003 - Solicitações de Informações a um Banco de Dados.

No post de hoje vamos falar sobre Query. Que resumidamente é uma solicitação de informações a um banco de dados.
Mas o que é Query? Muitas pessoas que começam a estudar programação tem essa dúvida. Basicamente, a palavra em inglês significa consulta,...

Read: https://vagnermaltauro.hashnode.dev/0003-solicitacoes-de-informacoes-a-um-banco-de-dados
1
Shopware creating CLI command to generate demo data on your entity

In this blog post, you will learn how to create a custom command in a Shopware 6 plugin and use it to generate the demo data.
Because Shopware 6 is based on the Symfony framework, it also has its Console available. So you can do most of the stuff you...

Read: https://viennt.me/shopware-creating-cli-command-to-generate-demo-data-on-your-entity
Разметка дисков в стиле 70-х

В наши дни массовые хранилища данных для компьютеров довольно просты. Они либо твердотельные, либо используют вращающийся диск. Есть несколько уникумов, использующих ленту, но по сравнению с тем, сколько их было раньше, лента скорее мертва, чем наоборот. Но еще не так давно число типов запоминающих устройств было огромным. Ленты, диски, барабаны, перфокарты, бумажная лента и еще более странные вещи. Но наверное ни один из них не был настолько странным, как накопитель IBM 2321 Data Cell — то, что внутри IBM называлось MARS.


Читать: https://habr.com/ru/post/667098/
NoSQL Databases

In order to understand NoSQL, it’s necessary to understand SQL. NoSQL Databases refers to a database method that differs entirely from the typical relational database management system(RDBMS). SQL is a query language used by relational databases.

SQ...

Read: https://nidhigupta.hashnode.dev/nosql-databases
Triggers in Supabase for making new rows.

Hi 👋 friends. This blog is made for teaching you how to set up triggers in supabase. You can use triggers for sending notifications or adding more rows to your tables.
🎯Goals
One day, I logged into your site and registered there. Your website allow...

Read: https://nextdev1111.hashnode.dev/triggers-in-supabase-for-making-new-rows
Нетривиальный подход, или Как мы обнаружили баг в отечественной СУБД и успешно его обошли

Три года назад у одного из наших заказчиков — крупнейшего российского банка — появилась задача перенастроить платёжный сервис для ГИС ГМП (штрафы, пошлины и налоги), ГИС ЖКХ, а также запросы начислений (подписки). Выбор решений на рынке был невелик, поскольку нам нужно было подобрать продукт с готовыми комплектами ППО и СУБД, сертифицированный ФСБ России и ФСТЭК России. Перебрав несколько вариантов, мы остановились на комплексном Open Source-решении от российских компаний ID Systems и Red Soft. Плюсом также было использование одним из департаментов банка аналогичного пакета, только с другими адаптерами СМЭВ.


Читать: https://habr.com/ru/post/666512/
Industry role of a data analysts

Data analysts, who are these people anyway? So many young students want to take a role in a developing corporate without having basic details about the fundamentals.
Let's see what you will be doing, In a working environment. Data analysts are the pe...

Read: https://blog.skillsafari.in/industry-role-of-a-data-analysts
Add Database to Application hosted in Amazon Lightsail

Amazon Lightsail offers dedicated Databases. You can make use of it instead of an on-instance database. It's easy, managed, secure, and most importantly it's not tied to the instance. So, your database will be safe even if instance crashes.
In "Deplo...

Read: https://blog.harun.dev/add-database-to-application-hosted-in-amazon-lightsail
What Does the Executive Order on Supply Chain Security Mean for Your Business? Security Experts Weigh In on SBOMs

Read: https://www.mongodb.com/blog/post/what-does-executive-order-supply-chain-security-mean-business-secuirty-experts-weigh-sboms
Dynamically modify AWS DMS endpoints for flexible intermittent data migrations to AWS

Read: https://aws.amazon.com/blogs/database/dynamically-modify-aws-dms-endpoints-for-flexible-intermittent-data-migrations-to-aws/
Configure SQL Server replication between Amazon RDS Custom for SQL Server and Amazon RDS for SQL Server

Read: https://aws.amazon.com/blogs/database/configure-sql-server-replication-between-amazon-rds-custom-for-sql-server-and-amazon-rds-for-sql-server/