Мигрируем БД в продакшене без даунтайма

В этой статье мы рассмотрим основные принципы миграции БД без даунтайма и дадим быстрые рецепты для наиболее распространенных случаев.


Читать: https://habr.com/ru/post/664028/

When Disaster Strikes: Production Troubleshooting

Tom Granot and myself have had the privilege of Vlad Mihalcea’s online company for a while now. As a result we decided to do a workshop together talking about a lot of the things we learned in the process. This workshop would be pretty informal ad-ho...

Read: https://talktotheduck.dev/when-disaster-strikes-production-troubleshooting

Semeris Demystifies Legal Documents Using MongoDB

Read: https://www.mongodb.com/blog/post/semeris-demystifies-legal-documents-using-mongodb

OCI Vault Integration with Oracle Database Cloud Service

This blog describes the OCI Vault integration with Oracle Database Cloud Service.

Read: https://blogs.oracle.com/database/post/oci-vault-integration-with-oracle-database-cloud-service

How to use Bytebase to coordinate multi-tenancy database schema change

If you haven't set up Bytebase for your team, please refer to How to start using Bytebase for team database collaboration
We already learn the basic SQL review process in Bytebase in How to use Bytebase to facilitate SQL review process (UI workflow)...

Read: https://devrel.bytebase.com/how-to-use-bytebase-to-coordinate-multi-tenancy-database-schema-change

Кастомизируем дашборды в Grafana для инженеров по холодоснабжению ЦОДа

Система мониторинга инженерной инфраструктуры – это нервная система дата-центра. С ее помощью инженеры вовремя видят неприятные симптомы на графиках и предотвращают проблемы в работе кондиционеров, бесперебойников, сетевых устройств и других элементов инженерных систем.

Наша система мониторинга на базе Nagios развивается вместе с сетью дата-центров, и мы уже много рассказывали о ее работе (например, в этом цикле). Но нет предела совершенству, и чем дальше, тем больше хочется улучшить что-то еще: добавить новый “разрез” анализа, взглянуть на оборудование под другим углом.

В этой статье расскажем, как и для каких задач наши инженеры создают кастомные дашборды с помощью графического плагина FlowCharting для Grafana.


Читать: https://habr.com/ru/post/664460/

Build a solution for data migration between on-premises and Amazon Aurora databases hosted in isolated VPCs using AWS DMS

Read: https://aws.amazon.com/blogs/database/build-a-solution-for-data-migration-between-on-premises-and-amazon-aurora-databases-hosted-in-isolated-vpcs-using-aws-dms/

Deploy Amazon RDS on AWS Outposts with Multi-AZ high availability

Read: https://aws.amazon.com/blogs/database/deploy-amazon-rds-on-aws-outposts-with-multi-az-high-availability/

PostgreSQL Antipatterns: в этом плане кто-то лишний

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


Читать: https://habr.com/ru/post/664466/

Learn with Me: SQL and Relational Databases

What is SQL?
SQL stands for Structured Query Language. SQL is a programming language designed for managing data in a relational database system (We will get to what that means later). SQL is broken down into four sublanguages:

Data Query Language (D...

Read: https://jakeconrad.hashnode.dev/learn-with-me-sql-and-relational-databases

Connecting the AWS RDS Console to your PostgreSQL Engine

A data base is a standardized collection of data, which is stored and access electronically. With the help of database, data management is easy. Small database can be stored on a file storage, while large database are hosted on computer clusters or C...

Read: https://everythingtechbyisdonobi.hashnode.dev/connecting-the-aws-rds-console-to-your-postgresql-engine

Masonite Project - Factory Tinker Example Tutorial

In this series, we will see a Masonite factory tinker example.
As we know testing is very important part of any web development project. Sometime we may require to add hundreds records in our users table. Also think about if we require to check pagi...

Read: https://blog.popolo.dev/masonite-project-factory-tinker-example-tutorial

Convert database schemas and application SQL using the AWS Schema Conversion Tool CLI

Read: https://aws.amazon.com/blogs/database/convert-database-schemas-and-application-sql-using-the-aws-schema-conversion-tool-cli/

02 - Database Design

To staff building the different parts of the application we shall first start working on database design, where all the data is stored related to the application. As mentioned earlier we shall be using PostgreSQL to store our data.Following is the i...

Read: https://srikanthvenkata.hashnode.dev/02-database-design

Apache ShardingSphere & openGauss: Breaking the Distributed Database Performance Record with 10 Million tpmC!

Our open source community has cooperated with Huawei’s openGauss to build a distributed solution with Apache ShardingSphere and openGauss.
We tested performance together with openGauss on 16 servers for more than one hour. The results were great: our...

Read: https://distributeddatabase.hashnode.dev/apache-shardingsphere-and-opengauss-breaking-the-distributed-database-performance-record-with-10-million-tpmc

The Best 10 MySQL GUI Clients for Mac OS X

MySQL is a widely used, open-source relational database management system (RDBMS). It is known for its high performance, flexibility, ease of use, security, and speed. MySQL clients are programs that enable you to communicate your databases and manag...

Read: https://catalins.tech/best-mysql-clients-mac

CRUD functions in supabase 👋

Welcome guys to this 2nd blog for supabase and nextjs integration. In this blog, I will be telling you how to create, read, update, and delete data in a subbase with the help of next js.
🤔 If you don’t know how to set up supabase then you can read t...

Read: https://nextdev1111.hashnode.dev/crud-functions-in-supabase

Which one to choose MongoDB or MySQL??

Hey everyone, nice to meet you again. If you wonder which one is better MongoDB or MySQL database, then you are at right place to know about it. I hope you will enjoy this another journey of learning also, so let's start the journey.

What are SQL ty...

Read: https://anubhavg.hashnode.dev/which-one-to-choose-mongodb-or-mysql

Database

Introdaction of SQL

SQL is a standard query language for storing, manipulating, and retrieving data in a database.

Things that SQL can do
CRUD (Create, Read, Update and Delete)

Create
can create a database
create new tables in a database
insert r...

Read: https://yusrastack.hashnode.dev/database

Are you confused about which database architecture to use between SQL and NoSQL? Here is how Presear Softwares can help you!

When it comes to making decisions regarding the correct database architecture, the process might need prior knowledge of the database architectures.
Though the terms Relational Database Management Systems (RDBMS) and the Structured Query Language (SQ...

Read: https://blogs.presear.com/are-you-confused-about-which-database-architecture-to-use-between-sql-and-nosql-here-is-how-presear-softwares-can-help-you