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
Data Consistency In The NoSQL World

Introduction
First of all, we have to define what is data consistency, Given that you update a record x with a new value every subsequent read for the same record should display the new value not the old value.
Consistency In SQL
In the SQL world, da...

Read: https://khaled-osama.hashnode.dev/data-consistency-in-the-nosql-world
Day 13/100

Scylla Compaction Strategies
Size tiered compaction strategy [STCS]


STCS organises SSTable into tiers
the tiers are based on the size of SSTable on an exponential scale
When compacting several SSTables, a single SSTable is created.
It may be as la...

Read: https://rawdatareaders.hashnode.dev/day-13100
Document vs Relational : Which database use for your project

Choosing a database for our project is crucial, it determines not only how our data will be stored, but also the technical limitations we will face in the near or distant future.
I don't think there is a universal answer to this question but if you ...

Read: https://crunchstack.hashnode.dev/document-vs-relational-which-database-use-for-your-project
“RCU-6083” And “RCU-6107” Errors While Using Repository Creation Utility

In today’s article, we will cover “RCU-6083” And “RCU-6107” Errors While Using Repository Creation Utility. RCU-6083:Failed – Check prerequisites requirement for selected component:WEBCENTER RCU-6107:DB Init Param Prerequisite failure for: processes I was going to do some tests on WEBCENTER in the past days, when I went to the RCU setup, when I wrote the database …

Read: “RCU-6083” And “RCU-6107” Errors While Using Repository Creation Utility.
Add a Field to a Prisma Model

My Breeze Lakes Point project is in a good working state with my initial User model for logging in and displaying the data from the table. As I was implementing the model, I realized I wanted to capture Middle Name or whether a user didn't have a mid...

Read: https://kristenkinnearohlmann.hashnode.dev/add-a-field-to-a-prisma-model
👍1
OpenLampTech issue #20 – Substack Repost

Read: https://joshuaotwell.com/?p=36009
Отчёт о пожаре в OVH

Спустя год после  разрушительного пожара, уничтожившего дата-центр OVH в Страсбурге, местные пожарные опубликовали отчёт о том, что там произошло и почему это стало возможным. Коротко: в дата-центре SBG2 были деревянные потолки, не было огнетушителя и хоть какого-нибудь общего рубильника для отключения электроэнергии.


Читать: https://habr.com/ru/post/659001/
sysbench 1.1.0 rpm with SSL support

Read: https://lefred.be/?p=5383
Migrating Transactional Data to MongoDB in AWS with the Zaloni Arena Data Governance Platform

Read: https://www.mongodb.com/blog/post/migrating-transactional-data-mongodb-aws-zaloni-arena-data-governance-platform
A Dive Into MySQL Multi-Threaded Replication

Read: https://www.percona.com/blog/?p=80357
Introduction to AWS MySQL Security on RDS : Network

Read: http://mydbops.wordpress.com/?p=11201
Use parallelism to optimize querying large amounts of data in Amazon DynamoDB

Read: https://aws.amazon.com/blogs/database/use-parallelism-to-optimize-querying-large-amounts-of-data-in-amazon-dynamodb/
Content Discovery: How to Win the Battle for Attention

Read: https://www.mongodb.com/blog/post/content-discovery-how-win-battle-attention
👍1
GROUP BY doesn't sum all numeric rows but... I have a workaround.

Why would you want to sum the numbers of the rows that were grouped by?
The problem:
Let's say we have a database that records the transactions of our user row by row. Like this:

But we don't want or need to display transaction by transaction. It wo...

Read: https://lukasalbus.dev/sqlite3-group-by-with-sum
Autonomous Database Newsletter - March 30, 2022

Latest newsletter for Autonomous Database Shared from the ADB product management teams

Read: https://blogs.oracle.com/database/post/autonomous-database-newsletter---march-30-2022-v2
Wetin Be Database?

WETIN BE DATABASE?
Database na group of data wey dey well arranged and stored for inside computer.
This Database, dem dey use am store plenty type of different different data, like users information (anybody wey dey use a website, app or software s...

Read: https://hashnode.com/post/wetin-be-database-cl1lwct2m0dpjjvnv9r5xcfcw
Switchover from Primary Database to Physical Standby Database with SQLPLUS Commands

In today’s article, we will talk about Switchover from Primary Database to Physical Standby Database with SQLPLUS Commands. Before Switchover, there are a series of checks to see if the system is suitable for Switchover. Some of these controls are general and made for our entire Data Guard Environment, while others are specific to Switchover. …

Read: Switchover from Primary Database to Physical Standby Database with SQLPLUS Commands.