Things to Keep in Mind when working with Data Migration Scripts
Data migration, Data fix is very common in the industry and we do it more often than we like. There can be many reasons which lead to data fix/migration for our system. Most of the time, such changes will be applied to the live database and if we are...
Read: https://setupatani.hashnode.dev/things-to-keep-in-mind-when-working-with-data-migration-noscripts
Data migration, Data fix is very common in the industry and we do it more often than we like. There can be many reasons which lead to data fix/migration for our system. Most of the time, such changes will be applied to the live database and if we are...
Read: https://setupatani.hashnode.dev/things-to-keep-in-mind-when-working-with-data-migration-noscripts
How to update multiple different values at the same time in one query
Context
You want to update the same column for multiple records in one query and set different values for each record.
Example:
class Car < ActiveRecord::Base
# has attributes: id, license_plate
end
Let's say you want to update license plates and yo...
Read: https://allaboutcoding.ghinda.com/how-to-update-multiple-different-values-at-the-same-time-in-one-query
Context
You want to update the same column for multiple records in one query and set different values for each record.
Example:
class Car < ActiveRecord::Base
# has attributes: id, license_plate
end
Let's say you want to update license plates and yo...
Read: https://allaboutcoding.ghinda.com/how-to-update-multiple-different-values-at-the-same-time-in-one-query
USB-накопители информации корпоративного и индустриального класса и их отличия от потребительского сегмента
USB-флеш-накопители – уже привычное для нас устройство переноса и хранения информации. Несмотря на то, что большинство из нас переходит на облачные хранилища, флешек всё равно продаётся и покупается очень много. Они используются в решении бытовых задач, в работе офисов и индустриальной сфере. При этом специфические требования корпоративного и индустриального применения часто игнорируются. Выбор устройств, содержащих важную для пользователей и бизнеса информацию, необходимо осуществлять с полной ответственностью, поэтому в этой статье мы рассмотрим критерии надёжного хранения информации и разберём способы соответствия им.
Читать: https://habr.com/ru/post/658671/
USB-флеш-накопители – уже привычное для нас устройство переноса и хранения информации. Несмотря на то, что большинство из нас переходит на облачные хранилища, флешек всё равно продаётся и покупается очень много. Они используются в решении бытовых задач, в работе офисов и индустриальной сфере. При этом специфические требования корпоративного и индустриального применения часто игнорируются. Выбор устройств, содержащих важную для пользователей и бизнеса информацию, необходимо осуществлять с полной ответственностью, поэтому в этой статье мы рассмотрим критерии надёжного хранения информации и разберём способы соответствия им.
Читать: https://habr.com/ru/post/658671/
Terms you should know in the Database as a back-end Developer.
In the previous blog, I talked about the databases and the file system. If you haven't seen that blog yet then the link is here. Well, Let me repeat what is Database to refresh our memory.
What is Database?
A database is a systemic way of collecting ...
Read: https://wolfgunner.hashnode.dev/terms-you-should-know-in-the-database-as-a-back-end-developer
In the previous blog, I talked about the databases and the file system. If you haven't seen that blog yet then the link is here. Well, Let me repeat what is Database to refresh our memory.
What is Database?
A database is a systemic way of collecting ...
Read: https://wolfgunner.hashnode.dev/terms-you-should-know-in-the-database-as-a-back-end-developer
Improved Experience for Saved Aggregations and Queries in MongoDB Compass
Read: https://www.mongodb.com/blog/post/improved-experience-saved-aggregations-queries-mongodb-compass
Read: https://www.mongodb.com/blog/post/improved-experience-saved-aggregations-queries-mongodb-compass
Azure SQL Database Geo Replication
In today’s article, we will talk about Azure SQL Database Geo Replication. I will be telling you how to replicate a copy of a PaaS SQL database that we positioned on Azure on a different geography. Process steps ; 1) We connect to the Azure Portal 2) Select Geo-Replication in SQL Database. 3) We can …
Read: Azure SQL Database Geo Replication.
In today’s article, we will talk about Azure SQL Database Geo Replication. I will be telling you how to replicate a copy of a PaaS SQL database that we positioned on Azure on a different geography. Process steps ; 1) We connect to the Azure Portal 2) Select Geo-Replication in SQL Database. 3) We can …
Read: Azure SQL Database Geo Replication.
Three ways to import data into Postgres
What is a database without data? Postgres provides multiple options to import data from files. You can use the COPY command, restore from a backup, or load in a CSV with a SQL GUI tool. Which method is fastest and easiest will depend on your setup an...
Read: https://arctype.hashnode.dev/three-ways-to-import-data-into-postgres
What is a database without data? Postgres provides multiple options to import data from files. You can use the COPY command, restore from a backup, or load in a CSV with a SQL GUI tool. Which method is fastest and easiest will depend on your setup an...
Read: https://arctype.hashnode.dev/three-ways-to-import-data-into-postgres
👎1
Day 12/100
Scylla Compaction Fundamentals
Log Structured Writes
Changes to the data are first written to memory and then Flushed into SSTable
Updates accumulate overtime in different sstables,
Having several version of the same cell is called space amplificat...
Read: https://rawdatareaders.hashnode.dev/day-12100
Scylla Compaction Fundamentals
Log Structured Writes
Changes to the data are first written to memory and then Flushed into SSTable
Updates accumulate overtime in different sstables,
Having several version of the same cell is called space amplificat...
Read: https://rawdatareaders.hashnode.dev/day-12100
Ruby Added to MongoDB Export to Language for Compass and VS Code
Read: https://www.mongodb.com/blog/post/ruby-added-mongodb-export-language-compass-vs-code
Read: https://www.mongodb.com/blog/post/ruby-added-mongodb-export-language-compass-vs-code
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
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
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
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.
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
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
Отчёт о пожаре в OVH
Спустя год после разрушительного пожара, уничтожившего дата-центр OVH в Страсбурге, местные пожарные опубликовали отчёт о том, что там произошло и почему это стало возможным. Коротко: в дата-центре SBG2 были деревянные потолки, не было огнетушителя и хоть какого-нибудь общего рубильника для отключения электроэнергии.
Читать: https://habr.com/ru/post/659001/
Спустя год после разрушительного пожара, уничтожившего дата-центр OVH в Страсбурге, местные пожарные опубликовали отчёт о том, что там произошло и почему это стало возможным. Коротко: в дата-центре SBG2 были деревянные потолки, не было огнетушителя и хоть какого-нибудь общего рубильника для отключения электроэнергии.
Читать: https://habr.com/ru/post/659001/
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
Read: https://www.mongodb.com/blog/post/migrating-transactional-data-mongodb-aws-zaloni-arena-data-governance-platform