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
Why Choose TiDB to Support OSS Insight

Many times we hope that our data access becomes more real-time. It has diffrrent meanings for various industries. For logistics, it means that resource allocation can be carried out with a faster frequency. For e-commerce, it means quicker adjustment...

Read: https://hashnode.com/post/why-choose-tidb-to-support-oss-insight-cl3ctd1ry08fvy3nvbtqb7k8p
Should you use Raw SQL or an ORM?

Interacting with databases is super crucial in becoming a badass developer. Whether you want to be a front-end, back-end or full-stack developer, you would encounter databases because most dynamic applications rely on user data. And you don’t want to...

Read: https://thinkpanda.hashnode.dev/should-you-use-raw-sql-or-an-orm
Collaborative User Story Mapping with Avion and MongoDB

Read: https://www.mongodb.com/blog/post/collaborative-user-story-mapping-avion-mongodb
Deploy a high-performance database for containerized applications: Amazon MemoryDB for Redis with Kubernetes

Read: https://aws.amazon.com/blogs/database/deploy-a-high-performance-database-for-containerized-applications-amazon-memorydb-for-redis-with-kubernetes/
Open Banking: How to Future-Proof Your Banking Strategy

Read: https://www.mongodb.com/blog/post/open-banking-how-future-proof-your-banking-strategy
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