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
Association Rule With Rapid Miner

Roger is a city manager for a medium-sized, but steadily growing city. The city has limited resources, and like most municipalities, there are more needs than there are resources.
He feels like the citizens in the community are fairly active in vario...

Read: https://designegycreatives.hashnode.dev/association-rule-with-rapid-miner
AND/OR/NOT - How To Get The Rows You Want More Precisely

AND - Ranges
Between Operators


Multiple Conditions


OR - Being Flexible


Brackets

Read: https://designegycreatives.hashnode.dev/andornot-how-to-get-the-rows-you-want-more-precisely
In-Place Upgrade for Database Cloud Service (DBCS) VM DB Systems

In-Place Upgrade for Database Cloud Service (DBCS) VM DB Systems

Read: https://blogs.oracle.com/database/post/in-place-upgrade-for-dbcs-vm-db-systems
What’s the Database Plus concept and what challenges can it solve?

Background
For a long time, unification or fragmentation were the two most popular predictions for the future of databases. With the advance of digitization, a single scenario cannot meet the needs of diversified applications — making database fragme...

Read: https://distributeddatabase.hashnode.dev/whats-the-database-plus-concept-and-what-challenges-can-it-solve
Java and MySQL - A JDBC Introduction

Java DataBase Connectivity (JDBC)
What is JDBC?
Java Database Connectivity is a tool or an application programming interface
(API) that establishes a connection between a standard Database (say MYSQL) and a Java Application that intends
to use that d...

Read: https://rosekamallove.hashnode.dev/java-and-mysql
Integrating GitLab with Bytebase to Version Control Database Schema Similar to Code

We have gone through Bytebase's UI workflow in the previous article:
Using Bytebase to facilitate Database Collaboration Between Developer and DBA
Based on the concept of Database-as-Code, Bytebase provides you with another advanced Version Control ...

Read: https://devrel.bytebase.com/integrating-gitlab-with-bytebase-to-version-control-database-schema-similar-to-code
Integrating GitLab with Bytebase to Version Control Database Schema along with Code

We have gone through Bytebase's UI workflow in the previous article:
Using Bytebase to facilitate Database Collaboration Between Developer and DBA
Based on the concept of Database-as-Code, Bytebase provides you with another advanced Version Control ...

Read: https://devrel.bytebase.com/integrating-gitlab-with-bytebase-to-version-control-database-schema-along-with-code
PostgreSQL Antipatterns: когда мешает внешний ключ

Внешние ключи (foreign keys) - мощный и удобный механизм контроля логической целостности данных в базе. Но он бывает не только лишь полезен, и может неплохо пригрузить вашу БД.

Внимательный взгляд на план запроса поможет избежать многих проблем - как при чтении из базы, так и при вставке в нее.


Читать: https://habr.com/ru/post/665118/
Integrating GitLab with Bytebase for Version Control in Database Schema and Source Code

We have gone through Bytebase's UI workflow in the previous article:
Using Bytebase to facilitate Database Collaboration Between Developer and DBA
Based on the concept of Database-as-Code, Bytebase provides you with another advanced Version Control ...

Read: https://devrel.bytebase.com/integrating-gitlab-with-bytebase-for-version-control-in-database-schema-and-source-code
Integrating GitLab with Bytebase for Version Control in Database Schema similar to Source Code

We have gone through Bytebase's UI workflow in the previous article:
Using Bytebase to facilitate Database Collaboration Between Developer and DBA
Based on the concept of Database-as-Code, Bytebase provides you with another advanced Version Control ...

Read: https://devrel.bytebase.com/integrating-gitlab-with-bytebase-for-version-control-in-database-schema-similar-to-source-code
Integrating GitLab with Bytebase for Version Control in Database Schema as in Source Code

We have gone through Bytebase's UI workflow in the previous article:
Using Bytebase to facilitate Database Collaboration Between Developer and DBA
Based on the concept of Database-as-Code, Bytebase provides you with another advanced Version Control ...

Read: https://devrel.bytebase.com/integrating-gitlab-with-bytebase-for-version-control-in-database-schema-as-in-source-code
Deploy a containerized application with Amazon ECS and connect to Amazon DocumentDB (with MongoDB compatibility) securely

Read: https://aws.amazon.com/blogs/database/deploy-a-containerized-application-with-amazon-ecs-and-connect-to-amazon-documentdb-securely/
Cloud Computing and AWS in Breadth (Part-2)

Describing the predominant half of AWS
As per part 1, we introduced what cloud computing refers to in general terms and also one of the top providers which provide the services for it, namely the AWS.
We will discuss the services mentioned earlier ba...

Read: https://abhiramsatpute.hashnode.dev/cloud-computing-and-aws-in-breadth-part-2
Intro to firestore and how to use it in your web app

This is part one of a three blog series on Firebase basics. In this one, we will read about firestore. I have tried my best to make this beginner-friendly.
What is Firebase?
It is a Backend-as-a-Service (Baas).
It provides various tools and services...

Read: https://slowbro.hashnode.dev/intro-to-firestore-and-how-to-use-it-in-your-web-app
Analyze Blockchain and DeFi data in minutes with SQL and Dune Analytics: A Quickstart Guide

We can't seem to get away from the buzzword "blockchain." It is associated with the decentralized finance industry, NFTs, bitcoin, and cryptocurrencies. And one characteristic that makes blockchain technology appealing is its distributed ledger syste...

Read: https://benny.hashnode.dev/analyze-blockchain-and-defi-data-in-minutes-with-sql-and-dune-analytics-a-quickstart-guide
Две задачи при работе с объектным хранилищем: как правильно создать кастомную ссылку одноразовой загрузки и не ошибиться

Каждый день сотрудники техподдержки Selectel решают задачи клиентов. Что-то не подключается, что-то вдруг удалилось или потерялось. Для ответа на часть тикетов достаточно скинуть инструкцию из базы знаний, но некоторые становятся настоящими техническими квестами.

Сегодня мы решили разобрать несколько из них. В этой подборке все они связаны с работой облачного объектного хранилища. Сейчас в Selectel миграционные каникулы — можно 30 дней не платить за запросы и хранение данных.

Ответы на одну из задач убрали в «спойлеры» — проверьте себя, сможете ли вы сами найти решение на основе «дано». Если вам понравится такой формат текстов, пишите в комментах или голосуйте в опросе, — сделаем еще. А пока — смотрите под кат.


Читать: https://habr.com/ru/post/665372/
Прилег, полежал, встал, побежал

Намедни наш Rutube немного прилег. Не сам, конечно, говорят хакеры помогли, но тем не менее. И со всех сторон зазвучали критические мантры о левых руках, растущих чуть ниже спины у тамошних разрабов и ИБ-шников. Тем интереснее было посмотреть по сторонам. Наверняка же были не менее эпичные фейлы, факапы и прочие отгулы по болезни у популярных сервисов? Go!


Читать: https://habr.com/ru/post/665392/
Take Your Applications Further with An Embedded Database-as-a-Service

Read: https://mariadb.com/?p=31385