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
MySQL SUBSTRING() Function With Examples – Substack Repost

Read: https://joshuaotwell.com/?p=35967
6 reasons why TerminusDB is the right toolkit to build collaborative apps

If you are looking to build collaborative applications where users are a primary source of data and content, then this article explains the TerminusDB and TerminusX features that make them well-suited data management toolkits for building collaborati...

Read: https://hashnode.com/post/6-reasons-why-terminusdb-is-the-right-toolkit-to-build-collaborative-apps-cl1m3u3530eoujvnv2lgh4c2z
Межкластерная репликация Apache Kafka между тремя дата-центрами

Я Роман Ананьев, NoSQL/Kafka-инженер в Авито. В этом материале расскажу, как мы попробовали использовать брокер сообщений Apache Kafka в трёх дата-центрах и что из этого получилось.

Сначала пробегусь по архитектуре Kafka, потому что она играет роль в репликации между кластерами. Затем коснусь самих способов репликации и расскажу о двух инструментах для неё: MirrorMaker и uReplicator. Основная часть статьи — про нашу реализацию Kafka cluster federation и то, как Kafka размазана на несколько дата-центров.


Читать: https://habr.com/ru/post/651503/
Hidden Cost of Foreign Key Constraints in MySQL

Read: https://www.percona.com/blog/?p=80567
Аварийное восстановление и резервное копирование в облаке

Решения Disaster Recovery восстанавливают работоспособность ИТ-инфраструктуры после сбоя или атаки. Объясняем, как использовать вместе с резервным копированием. Материал будет полезен специалистам, которые начинают работу с облаком и только знакомятся с его возможностями.


Читать: https://habr.com/ru/post/659037/
MongoDB ASEAN: How the Corporate Sales Team Is Scaling in One of MongoDB’s Fastest-Growing Regions

Read: https://www.mongodb.com/blog/post/asean-how-corporate-sales-team-scaling-one-mongodbs-fastest-growing-regions
When (and why) not to go serverless

Originally posted at Serverless
There are a lot of people out there championing the serverless movement. Serverless lowers administrative overhead. It takes server maintenance off developers’ plates forever and cuts server costs. The benefits are rea...

Read: https://serverlessinc.hashnode.dev/when-and-why-not-to-go-serverless
Scale applications using multi-Region Amazon EKS and Amazon Aurora Global Database: Part 1

Read: https://aws.amazon.com/blogs/database/part-1-scale-applications-using-multi-region-amazon-eks-and-amazon-aurora-global-database/
Live Migration from Azure Database for MySQL to MySQL Database Service on OCI

Read: https://lefred.be/?p=5395
Day 16/100

Scylla Manager Agent


Reads config from scylla API on start
Listens on Scylla
CPU pinning
Agent conf file etc/scylla-manager-agent/scylla-manager-agent.yaml

Scylla Manager Backup Benefits

Data selection - single table or entire keyspace
deduplica...

Read: https://rawdatareaders.hashnode.dev/day-16100
Run SQL Server on macOS + Docker

Intro
If you haven't seen Microsoft's latest Docs site update, you really should check them out. There is a getting started article regarding SQL Server (2017) Containers on Linux and other OSs including Azure. The SQL Server 2019 version article is ...

Read: https://itsjoshcampos.codes/run-sql-server-on-macos-docker
👎2
Choosing a Database for Serverless Applications

Originally posted at Serverless
When designing and building an application, one of the key considerations is which database to use. A poor decision here can cost you severely, either by requiring costly ongoing maintenance of a database or by forcing...

Read: https://serverlessinc.hashnode.dev/choosing-a-database-for-serverless-applications
How to use MongoDB with Node.js

Introduction
When working with a server, we will always have to save and retrieve data using a database. There are many server-side languages and databases. In this article, we will learn how to use MongoDB with Node.js
MongoDB is a non-relational d...

Read: https://backendbro.hashnode.dev/how-to-use-mongodb-with-nodejs
Import sample database into AWS MySQL using Workbench & Shell

Bytebase open-sourced an Employee sample database for MySQL https://github.com/bytebase/employee-sample-database-mysql with 2 variations: Full dataset (~170 MB) including 300024 employee records and Small dataset (~6 MB) including 10000 employee reco...

Read: https://adelafun.hashnode.dev/import-sample-database-into-aws-mysql-using-workbench-and-shell
Import sample database into AWS MySQL using Workbench & Shell

Bytebase open-sourced an Employee sample database for MySQL https://github.com/bytebase/employee-sample-database-mysql with two variations: A Full dataset (~170 MB) including 300024 employee records and a Small dataset (~6 MB) including 10000 employe...

Read: https://devrel.bytebase.com/import-sample-database-into-aws-mysql-using-workbench-and-shell
Data Insertion and Data Persistence in a Vector Database

Milvus architecture recap

SDK sends data requests to proxy, the portal, via load balancer. Then the proxy interacts with coordinator service to write DDL (data definition language) and DML (data manipulation language) requests into message storage.
...

Read: https://angela.hashnode.dev/data-insertion-and-data-persistence-in-a-vector-database
How to modify a JSON field in SQL ?

Read: https://lefred.be/?p=5434
How to create and test a GitHub Action that generates types from Supabase database

Recently I started a side project Billy, a React Native bill tracker app which uses Supabase for user management & database. Initially, I wasn’t too sure of all the fields that the Bill model should have, so as I developed the project, the data model...

Read: https://blog.esteetey.dev/how-to-create-and-test-a-github-action-that-generates-types-from-supabase-database
Creating A Hot Standby In PostgreSQL

In today’s post, I will show you Creating A Hot Standby In PostgreSQL. PostgreSQL Community 13 Installation: [crayon-624d7770b7251200400556/] To create Stanby, we need two servers with Postgresql Community 13 installed. If you have not installed, you can install from the link above. There are operations that need to be done on both the master and …

Read: Creating A Hot Standby In PostgreSQL.
Securely connect to an Amazon RDS or Amazon EC2 database instance remotely with your preferred GUI

Read: https://aws.amazon.com/blogs/database/securely-connect-to-an-amazon-rds-or-amazon-ec2-database-instance-remotely-with-your-preferred-gui/
QVentures and MongoDB Partner to Support the Next Generation of B2B SaaS Founders

Read: https://www.mongodb.com/blog/post/qventures-mongodb-partner-support-next-generation-b2b-saas-founders