PostgreSQL_Backup and Restore database

🎯 Target: create plain dump of PostgreSQL Database and move it to another server
🛠️ Tools and prerequisites: PostgreSQL DB and pgAdmin 4
Step 1 - Create DB backup

In pgAdmin 4 LMB click on the needed DB name and choose Backup...


2.Choose path an...

Read: https://dataviz.hashnode.dev/postgresqlbackup-and-restore-database

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 15 – Add support for security invoker views.

Read: https://postgr.es/p/5hU

PostgreSQL_Drop Mainantanance DB

🎯 Target: drop mainantanance database
🛠️ Tools and prerequisites: Mainantanance DB and another DB and pgAdmin 4
Step 1 - Disconnect Server and Change Mainantanance DB
1.In pgAdmin 4 LMB click on the PostgreSQL 14 name, choose Disconnect Server and ...

Read: https://dataviz.hashnode.dev/postgresqldrop-mainantanance-db

Introducing Hyperledger Fabric 2.2 LTS Support on Amazon Managed Blockchain

Read: https://aws.amazon.com/blogs/database/introducing-hyperledger-fabric-2-2-lts-support-on-amazon-managed-blockchain/

Deploy Amazon RDS databases for applications in Kubernetes

Read: https://aws.amazon.com/blogs/database/deploy-amazon-rds-databases-for-applications-in-kubernetes/

MySQL 8: Password Verification Policy

Read: https://www.percona.com/blog/?p=79319

Authentication Plugin ‘***’ Cannot Be Loaded: How MySQL Searches Client-Side Plugins

Read: https://www.percona.com/blog/?p=80411

Day 2/100

HDFS [Hadoop Distributed File System] - Part 2
Snapshots

Snapshots lets you save the current state of filesystem, so that rollbacks while upgrade are possible.
Only one snapshot can exists, basically it reads existing and creates new checkpoint with...

Read: https://rawdatareaders.hashnode.dev/day-2-of-100

Okta Digital Breach Investigation

Read: https://www.mongodb.com/blog/post/okta-digital-breach-investigation

Сохранение данных для ESP32/Arduino в удаленной базе MySQL и не только

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



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

Limit Rows with the WHERE clause – MySQL Beginner Series

Read: https://joshuaotwell.com/?p=35625

Getting Started With Non-relational Databases Using Mongodb

What is a relational database?
If you’ve worked with databases for a while, chances are, you started your career using a relational database. Examples of a relational database are Microsoft Access, MySql, Oracle, etc.
A relational database is the con...

Read: https://nelzluv.hashnode.dev/getting-started-with-non-relational-databases-using-mongodb

MySQL 8: Multi-Factor Authentication Overview

Read: https://www.percona.com/blog/?p=79314

Schema and code validator for Oracle to Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL migration

Read: https://aws.amazon.com/blogs/database/schema-and-code-validator-for-oracle-to-amazon-rds-for-postgresql-or-amazon-aurora-postgresql-migration/

Import and export CloudFormation templates and CSV sample data with NoSQL Workbench for Amazon DynamoDB

Read: https://aws.amazon.com/blogs/database/import-and-export-cloudformation-templates-and-csv-sample-data-with-nosql-workbench-for-amazon-dynamodb/

Какие флеш-карты быстрее и дешевле? Замеры скорости бюджетных microSD в одноплатниках

Карты microSD удобно использовать для расширения памяти и хранения файлов на смартфонах и в разных гаджетах, а в Raspberry Pi и других одноплатниках (SBC) у них ещё более ответственная задача: это системный носитель, с которого загружается ОС и рабочие инструменты. Здесь особенно важна производительность.

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


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

Ultrahuman and MongoDB Partner to Raise Fitness Awareness

Read: https://www.mongodb.com/blog/post/ultrahuman-mongodb-partner-raise-fitness-awareness

Models Part 2 (Django models relationship)

Table relationships in Relational Database design
1. One to One relationship (1-1)

A relation is said to be 1-1 if a row in Table A can have only one matching row in Table B
Let's take an example of simple 1-1 relationship between user and user_det...

Read: https://djangotherightway.com/django-models-relationship

Setting SQL_MODE

Read: http://blog.mclaughlinsoftware.com/?p=12990

Calendar In Linux

In today’s article I will talk about Calendar In Linux. You are running a Linux operating system and if you want to query the operating system whether the time is correct, a few commands will help you. You can see the month, year, day, hour, minute and second information with the date command.   If …

Read: Calendar In Linux.

Day 3/100

Deltalake - [ Intro and Quick Start ]
key features -

ACID transactions
schema enforcement on writes
Unification of batch and streaming - A table in Delta Lake is a batch table as well as a streaming source and sink.
Time travel
Supports merge, upd...

Read: https://rawdatareaders.hashnode.dev/day-3100