How to Use SQL to Analyze And Visualize Data?
The goal of every business is to perform efficiently, maximize profit and make strategically-guided decisions. In the current business world, the competition is high and every business needs every edge and advantage they can get to improve their odds...
Read: https://arctype.hashnode.dev/how-to-use-sql-to-analyze-and-visualize-data
The goal of every business is to perform efficiently, maximize profit and make strategically-guided decisions. In the current business world, the competition is high and every business needs every edge and advantage they can get to improve their odds...
Read: https://arctype.hashnode.dev/how-to-use-sql-to-analyze-and-visualize-data
👍1
Understand deadlock by gap locking in InnoDB
When we develop a web application, sometimes we want to implement a DB-related logic like SELECT and INSERT if the row is not found. However, this may cause deadlock in InnoDB under a specific condition.
This article explains what is a Gap lock, and ...
Read: https://tanishiking.hashnode.dev/avoid-deadlock-caused-by-a-conflict-of-transactions-that-accidentally-acquire-gap-lock-in-innodb-a114e975fd72
When we develop a web application, sometimes we want to implement a DB-related logic like SELECT and INSERT if the row is not found. However, this may cause deadlock in InnoDB under a specific condition.
This article explains what is a Gap lock, and ...
Read: https://tanishiking.hashnode.dev/avoid-deadlock-caused-by-a-conflict-of-transactions-that-accidentally-acquire-gap-lock-in-innodb-a114e975fd72
Getting Started with MongoDB
MongoDb is a No SQL Database, this means that we do not use SQL commands to interact with it. Unlike SQL databases that are made of Columns with Rows and on each Table consist rows that stores data types and each of the column is a property on the Ta...
Read: https://rukayat-balogun.hashnode.dev/getting-started-with-mongodb
MongoDb is a No SQL Database, this means that we do not use SQL commands to interact with it. Unlike SQL databases that are made of Columns with Rows and on each Table consist rows that stores data types and each of the column is a property on the Ta...
Read: https://rukayat-balogun.hashnode.dev/getting-started-with-mongodb
Access Amazon MemoryDB for Redis from AWS Lambda
Read: https://aws.amazon.com/blogs/database/access-amazon-memorydb-for-redis-from-aws-lambda/
Read: https://aws.amazon.com/blogs/database/access-amazon-memorydb-for-redis-from-aws-lambda/
Writing your first MongoDB Document
Open your terminal and type mongosh
At this point, you should have mongoDB compass installed on your system. Open this software,
Click on connect
If for any reason you do not have the mongosh instance running, type Services in the search bar
Scrol...
Read: https://rukayat-balogun.hashnode.dev/writing-your-first-mongodb-document
Open your terminal and type mongosh
At this point, you should have mongoDB compass installed on your system. Open this software,
Click on connect
If for any reason you do not have the mongosh instance running, type Services in the search bar
Scrol...
Read: https://rukayat-balogun.hashnode.dev/writing-your-first-mongodb-document
What's the difference between a column oriented database and a column-family store?
Hello everyone. Today I'm going to briefly explain the difference between column oriented databases (e.g Vertica, MonetDB, Clickhouse) and column-family stores (e.g Cassandra) because throughout many system design courses I've seen and also throughou...
Read: https://hewi.hashnode.dev/whats-the-difference-between-a-column-oriented-database-and-a-column-family-store
Hello everyone. Today I'm going to briefly explain the difference between column oriented databases (e.g Vertica, MonetDB, Clickhouse) and column-family stores (e.g Cassandra) because throughout many system design courses I've seen and also throughou...
Read: https://hewi.hashnode.dev/whats-the-difference-between-a-column-oriented-database-and-a-column-family-store
Pattern Matching In Sql
Hello there. We all have faced situations where we remembered a part of the word or line but not entirely. This happens with analysts all the time and hence SQL has the perfect solution to this called Pattern Matching and today we are going to dive t...
Read: https://sourajitad.hashnode.dev/pattern-matching-in-sql
Hello there. We all have faced situations where we remembered a part of the word or line but not entirely. This happens with analysts all the time and hence SQL has the perfect solution to this called Pattern Matching and today we are going to dive t...
Read: https://sourajitad.hashnode.dev/pattern-matching-in-sql
How to Create a Linux MariaBD Galera Cluster 2022
Install CentOs
Firstly we will use three machine instances with CentOs 7 operative system installed, in my case i used this image [CentOS-7-x86_64-DVD-2009].
Internet Config
nano /etc/sysconfig/network-noscripts/ifcfg-enp0s3
Ctrl+O + enter + Ctrl+X
yu...
Read: https://juliang.hashnode.dev/how-to-create-a-linux-mariabd-galera-cluster-2022
Install CentOs
Firstly we will use three machine instances with CentOs 7 operative system installed, in my case i used this image [CentOS-7-x86_64-DVD-2009].
Internet Config
nano /etc/sysconfig/network-noscripts/ifcfg-enp0s3
Ctrl+O + enter + Ctrl+X
yu...
Read: https://juliang.hashnode.dev/how-to-create-a-linux-mariabd-galera-cluster-2022
The Great Mind-Shift: Why I Decided To Be A Data Analyst.
Dear Reader,
This journey you are about to engage in is that of self-discovery. A story of a girl who was once lost, now found. We all have a story. Something that shapes us, a desire that makes us want to take the world by surprise. A dream to liv...
Read: https://chisom111.hashnode.dev/the-great-mind-shift-why-i-decided-to-be-a-data-analyst
Dear Reader,
This journey you are about to engage in is that of self-discovery. A story of a girl who was once lost, now found. We all have a story. Something that shapes us, a desire that makes us want to take the world by surprise. A dream to liv...
Read: https://chisom111.hashnode.dev/the-great-mind-shift-why-i-decided-to-be-a-data-analyst
How to create a test database with Laravel Sail
Introduction
I have worked on projects that required the production and testing database to be the same.
This could be because some features work in MariaDB, but not in SQLite. Or some bugs appear in MySQL, but not in PostgreSQL.
When you're working ...
Read: https://blog.akbal.dev/how-to-create-a-test-database-with-laravel-sail
Introduction
I have worked on projects that required the production and testing database to be the same.
This could be because some features work in MariaDB, but not in SQLite. Or some bugs appear in MySQL, but not in PostgreSQL.
When you're working ...
Read: https://blog.akbal.dev/how-to-create-a-test-database-with-laravel-sail
Session Storage and Local Storage APIs
Hi , Zenkin's here .
Usually for a growing application you'd need data , and thus must be stored somewhere . Now , you'd likely never want to set up a database if your data is really miniscule and small . Therefore in the newer web browsers , the We...
Read: https://zenkin.hashnode.dev/session-storage-and-local-storage-apis
Hi , Zenkin's here .
Usually for a growing application you'd need data , and thus must be stored somewhere . Now , you'd likely never want to set up a database if your data is really miniscule and small . Therefore in the newer web browsers , the We...
Read: https://zenkin.hashnode.dev/session-storage-and-local-storage-apis
Structured Query Language (SQL)
Use of minimal columns in table creation. (max 100 columns).
Avoid use of distinct; use ‘group by’ instead.
Use of LIMIT when fetching records.
Avoid use of * in the select statement. Define columns instead.
Indexing tables. Try using composite index...
Read: https://bikash8848.hashnode.dev/structured-query-language-sql
Use of minimal columns in table creation. (max 100 columns).
Avoid use of distinct; use ‘group by’ instead.
Use of LIMIT when fetching records.
Avoid use of * in the select statement. Define columns instead.
Indexing tables. Try using composite index...
Read: https://bikash8848.hashnode.dev/structured-query-language-sql
MongoDB: Capped Collections & Time-To-Live Index
When you use MongoDB in a production environment, you may eventually need to lower the amount of memory your database needs or increase how much it can read and write. The good news is that MongoDB has several ways to deal with these problems. One of...
Read: https://blog.sofwancoder.com/mongodb-capped-collections-and-time-to-live-index
When you use MongoDB in a production environment, you may eventually need to lower the amount of memory your database needs or increase how much it can read and write. The good news is that MongoDB has several ways to deal with these problems. One of...
Read: https://blog.sofwancoder.com/mongodb-capped-collections-and-time-to-live-index
Почему децентрализованный хостинг не работает
(cc) Пирамиды Гизы за окном пиццерии
Минуло 13 лет с появления биткоина, который породил сотни платформ со своими блокчейнами, протоколами и смарт-контрактами. И некоторые умные люди жалуются, что за прошедшее время мы так не нашли новых полезныхприменений для всего этого хозяйства. Кроме хранения и передачи ценности, разумеется. Максималисты могут сказать, что этого и так более чем достаточно. С другой стороны, а где полезные варианты использования для остальных 4000+ токенов, которые сейчас в обращении. Ведь они же создавались с какой-то хорошей целью, кроме строительства пирамид за фасадом легального бизнеса, верно ведь?
Например, одним из утилитарных применений считается децентрализованный P2P-хостинг типа Filecoin (за 0,0017% от стоимости Amazon S3) и StorJ. Они обещали кардинально изменить рынок хранения данных. Что же на самом деле? На самом деле всё не очень хорошо…
Читать: https://habr.com/ru/post/682540/
(cc) Пирамиды Гизы за окном пиццерии
Минуло 13 лет с появления биткоина, который породил сотни платформ со своими блокчейнами, протоколами и смарт-контрактами. И некоторые умные люди жалуются, что за прошедшее время мы так не нашли новых полезныхприменений для всего этого хозяйства. Кроме хранения и передачи ценности, разумеется. Максималисты могут сказать, что этого и так более чем достаточно. С другой стороны, а где полезные варианты использования для остальных 4000+ токенов, которые сейчас в обращении. Ведь они же создавались с какой-то хорошей целью, кроме строительства пирамид за фасадом легального бизнеса, верно ведь?
Например, одним из утилитарных применений считается децентрализованный P2P-хостинг типа Filecoin (за 0,0017% от стоимости Amazon S3) и StorJ. Они обещали кардинально изменить рынок хранения данных. Что же на самом деле? На самом деле всё не очень хорошо…
Читать: https://habr.com/ru/post/682540/
👍1
The Great Mind-Shift: Why I Decided To Learn Data Analysis.
Dear Reader,
This journey you are about to engage in is that of self-discovery. A story of a girl who was once lost, now found. We all have a story. Something that shapes us, a desire that makes us want to take the world by surprise. A dream to liv...
Read: https://chisom111.hashnode.dev/the-great-mind-shift-why-i-decided-to-learn-data-analysis
Dear Reader,
This journey you are about to engage in is that of self-discovery. A story of a girl who was once lost, now found. We all have a story. Something that shapes us, a desire that makes us want to take the world by surprise. A dream to liv...
Read: https://chisom111.hashnode.dev/the-great-mind-shift-why-i-decided-to-learn-data-analysis
Fact and Dimension In Data Warehouse
Fact and Dimension are building blocks of Data Warehouse. Understanding these terminologies is important so that we can model the warehouse correctly. Fact and Dimension work together to give each other real meaning.
Fact
Fact are generally measureme...
Read: https://rochakdh.hashnode.dev/fact-and-dimension-in-data-warehouse
Fact and Dimension are building blocks of Data Warehouse. Understanding these terminologies is important so that we can model the warehouse correctly. Fact and Dimension work together to give each other real meaning.
Fact
Fact are generally measureme...
Read: https://rochakdh.hashnode.dev/fact-and-dimension-in-data-warehouse
Migrating to the Cloud Isn't As Easy As Most People Think: A Conversation With Mark Porter and Accenture’s Michael Ljung
Read: https://www.mongodb.com/blog/post/migrating-to-cloud-not-easy-most-people-think-conversation-accenture
Read: https://www.mongodb.com/blog/post/migrating-to-cloud-not-easy-most-people-think-conversation-accenture
Make configuration changes to an Amazon RDS Custom for Oracle instance: Part 1
Read: https://aws.amazon.com/blogs/database/part-1-make-configuration-changes-to-an-amazon-rds-custom-for-oracle-instance/
Read: https://aws.amazon.com/blogs/database/part-1-make-configuration-changes-to-an-amazon-rds-custom-for-oracle-instance/
Recreate an Amazon RDS Custom for Oracle database: Part 2
Read: https://aws.amazon.com/blogs/database/part-2-recreate-an-amazon-rds-custom-for-oracle-database/
Read: https://aws.amazon.com/blogs/database/part-2-recreate-an-amazon-rds-custom-for-oracle-database/