Wiring up a database in the API service
Today I'll talk about how I set up the database for the API server of reread.to. It was a bit of a hassle and there were tons of things I didn't know. However, I think I've figured out the basics now and I'll tell you how I did it. In this article, I...
Read: https://stackdiving.com/wiring-up-a-database-in-the-api-service
Today I'll talk about how I set up the database for the API server of reread.to. It was a bit of a hassle and there were tons of things I didn't know. However, I think I've figured out the basics now and I'll tell you how I did it. In this article, I...
Read: https://stackdiving.com/wiring-up-a-database-in-the-api-service
How to integrate event streaming into your applications
Fauna's event streaming gives applications the ability to access and subscribe to real-time data. In this article, you learn how to integrate event streaming into your application.
We created a sample react app for you to follow along and explore ev...
Read: https://fauna.hashnode.dev/how-to-integrate-event-streaming-into-your-applications-cl0wi5qdq0593j6nvfmpp7row
Fauna's event streaming gives applications the ability to access and subscribe to real-time data. In this article, you learn how to integrate event streaming into your application.
We created a sample react app for you to follow along and explore ev...
Read: https://fauna.hashnode.dev/how-to-integrate-event-streaming-into-your-applications-cl0wi5qdq0593j6nvfmpp7row
How Kubernetes and Database Operators Drive the Data Revolution
Originally published at The New Stack.
These are challenging days for IT. The amount of data our systems need to process grows exponentially. This challenge is further amplified by the growing complexity of data. Information is useless without its co...
Read: https://chedim.com/how-kubernetes-and-database-operators-drive-the-data-revolution
Originally published at The New Stack.
These are challenging days for IT. The amount of data our systems need to process grows exponentially. This challenge is further amplified by the growing complexity of data. Information is useless without its co...
Read: https://chedim.com/how-kubernetes-and-database-operators-drive-the-data-revolution
Understanding SQL Server Common Table Expression - CTE
Common Table Expressions shortly called CTE or WITH clauses are named subqueries returning the data set. With CTE, we can break a long query into smaller parts making it simpler to understand and readable, and also supporting recursive implementation...
Read: https://mssqlserver.dev/understanding-sql-server-common-table-expression-cte
Common Table Expressions shortly called CTE or WITH clauses are named subqueries returning the data set. With CTE, we can break a long query into smaller parts making it simpler to understand and readable, and also supporting recursive implementation...
Read: https://mssqlserver.dev/understanding-sql-server-common-table-expression-cte
SQL Server Nested CTE with examples
After understanding the basics of CTE, multiple CTEs, and explanation in the previous post, in this post we will be exploring Nested CTEs in this post.
AS discussed, we can say that CTE is a named temporary set of rows similar to subqueries. Like sub...
Read: https://mssqlserver.dev/sql-server-nested-cte-with-examples
After understanding the basics of CTE, multiple CTEs, and explanation in the previous post, in this post we will be exploring Nested CTEs in this post.
AS discussed, we can say that CTE is a named temporary set of rows similar to subqueries. Like sub...
Read: https://mssqlserver.dev/sql-server-nested-cte-with-examples
Recursive CTE in SQL Server with examples
After understanding the basics of CTE, Multiple CTEs, and Nested CTEs in the previous post of this CTE series, we will be exploring Recursive CTE in this post.
Recursion takes place when we invoke the block of code inside itself to perform repeated p...
Read: https://mssqlserver.dev/recursive-cte-in-sql-server-with-examples
After understanding the basics of CTE, Multiple CTEs, and Nested CTEs in the previous post of this CTE series, we will be exploring Recursive CTE in this post.
Recursion takes place when we invoke the block of code inside itself to perform repeated p...
Read: https://mssqlserver.dev/recursive-cte-in-sql-server-with-examples
Switchover And Failover
In today’s article we will talk about Switchover And Failover. Databases in Data Guard Environment can be in Primary and Standby (Physical, Logical & Snapshot) roles. With Role Management Services we can dynamically switch between these roles. We can change roles in two ways. One is Switchover and the other is Failover. Switchover 1.There is …
Read: Switchover And Failover.
In today’s article we will talk about Switchover And Failover. Databases in Data Guard Environment can be in Primary and Standby (Physical, Logical & Snapshot) roles. With Role Management Services we can dynamically switch between these roles. We can change roles in two ways. One is Switchover and the other is Failover. Switchover 1.There is …
Read: Switchover And Failover.
REDIS, A cache database
If you are in the tech industry, working as a developer, or learning how to build a full-stack application. You must encounter the term REDIS.
Today, this article is based on the basics of REDIS.
What is REDIS?
Redis [Remote Dictionary Server] is a p...
Read: https://ayushak18.hashnode.dev/redis-a-cache-database
If you are in the tech industry, working as a developer, or learning how to build a full-stack application. You must encounter the term REDIS.
Today, this article is based on the basics of REDIS.
What is REDIS?
Redis [Remote Dictionary Server] is a p...
Read: https://ayushak18.hashnode.dev/redis-a-cache-database
Table background/text color based on value table/database
Just to make it simple!
HTML tables allow you to arrange data into rows and columns. Generally having a HTML table with static data, you always have the possibility to decorate your table using the CSS colors of your choice. This article demonstrates...
Read: https://opere.hashnode.dev/table-backgroundtext-color-based-on-value-tabledatabase
Just to make it simple!
HTML tables allow you to arrange data into rows and columns. Generally having a HTML table with static data, you always have the possibility to decorate your table using the CSS colors of your choice. This article demonstrates...
Read: https://opere.hashnode.dev/table-backgroundtext-color-based-on-value-tabledatabase
SQL Queries For Mere Mortal Chapter 4: Creating a Simple Query
Simple Select Statment:
Don't write SQL Query immediately after reading the problem statement:
Search for nouns in the problem statement as it may be a table name or a column name.
Map the extracted nouns with the suitable table and column names.
...
Read: https://samra.hashnode.dev/sql-queries-for-mere-mortal-chapter-4-creating-a-simple-query
Simple Select Statment:
Don't write SQL Query immediately after reading the problem statement:
Search for nouns in the problem statement as it may be a table name or a column name.
Map the extracted nouns with the suitable table and column names.
...
Read: https://samra.hashnode.dev/sql-queries-for-mere-mortal-chapter-4-creating-a-simple-query
Compare and Find Row changes in SQL Server with CHECKSUM(), BINARY_CHECKSUM(), HASHBYTES()
In this post, we will be looking at how to detect and identify row changes in SQL Server with CHECKSUM(), BINARY_CHECKSUM(), and HASHBYTE() functions. There are use cases where comparing or detecting row changes in the table is necessary like when a ...
Read: https://mssqlserver.dev/compare-and-find-row-changes-in-sql-server-with-checksum-binarychecksum-hashbytes
In this post, we will be looking at how to detect and identify row changes in SQL Server with CHECKSUM(), BINARY_CHECKSUM(), and HASHBYTE() functions. There are use cases where comparing or detecting row changes in the table is necessary like when a ...
Read: https://mssqlserver.dev/compare-and-find-row-changes-in-sql-server-with-checksum-binarychecksum-hashbytes
CFGFWK-60850: Test Failed! Error
The topic of today’s article is CFGFWK-60850: Test Failed! Error. If you get CFGFWK-60850: Test Failed! Error during weblogic domain creation while installing Oracle middleware products, it means that the Wizard cannot communicate with the database. This may come up with messages such as version incompatibility or user name and password error in different ways, …
Read: CFGFWK-60850: Test Failed! Error.
The topic of today’s article is CFGFWK-60850: Test Failed! Error. If you get CFGFWK-60850: Test Failed! Error during weblogic domain creation while installing Oracle middleware products, it means that the Wizard cannot communicate with the database. This may come up with messages such as version incompatibility or user name and password error in different ways, …
Read: CFGFWK-60850: Test Failed! Error.
9. Consistency and Consensus
This chapter is all about building fault tolerant distributed systems. We will look at tow measures for these - Consistency and consensus.
Consensus means all nodes of a distributed system agree on something(leader election, state of data etc.).
Con...
Read: https://rparthas.hashnode.dev/9-consistency-and-consensus-cl0zf26o404gisynv5rvdh8wz
This chapter is all about building fault tolerant distributed systems. We will look at tow measures for these - Consistency and consensus.
Consensus means all nodes of a distributed system agree on something(leader election, state of data etc.).
Con...
Read: https://rparthas.hashnode.dev/9-consistency-and-consensus-cl0zf26o404gisynv5rvdh8wz
SQL Queries For Mere Mortals: Creating a Simple Query
Simple Select Statment:
Don't write SQL Query immediately after reading the problem statement:
Search for nouns in the problem statement as it may be a table name or a column name.
Map the extracted nouns with the suitable table and column names.
...
Read: https://samra.hashnode.dev/sql-queries-for-mere-mortals-creating-a-simple-query
Simple Select Statment:
Don't write SQL Query immediately after reading the problem statement:
Search for nouns in the problem statement as it may be a table name or a column name.
Map the extracted nouns with the suitable table and column names.
...
Read: https://samra.hashnode.dev/sql-queries-for-mere-mortals-creating-a-simple-query
Building a data tech-stack
Data stack
A data stack is a set of tools and technologies built to facilitate the movement, storage and access to data in a business and transforming the data into actionable insights.
Components of data stack
Data source-This is where the data or...
Read: https://dorothycheruiyot.hashnode.dev/building-a-data-tech-stack
Data stack
A data stack is a set of tools and technologies built to facilitate the movement, storage and access to data in a business and transforming the data into actionable insights.
Components of data stack
Data source-This is where the data or...
Read: https://dorothycheruiyot.hashnode.dev/building-a-data-tech-stack
Updates, Order, & the Binlog
Imagine you had two separate databases, a read-write master and a read-only slave, and you wanted to keep a table between them synchronized. Writes would occur on the master table and should eventually appear on the slave table. To synchronize the da...
Read: https://nav610.hashnode.dev/updates-order-and-the-binlog
Imagine you had two separate databases, a read-write master and a read-only slave, and you wanted to keep a table between them synchronized. Writes would occur on the master table and should eventually appear on the slave table. To synchronize the da...
Read: https://nav610.hashnode.dev/updates-order-and-the-binlog
Flutter Hive: Blazing fast Key-Value storage
Intro to Hive
Data persistence is one of the most important aspects of any mobile application. A mobile application always keeps some type of state, such as user information, game scores, the user's current position, and so on.
Data persistence inv...
Read: https://dhruvnakum.xyz/flutter-hive-blazing-fast-key-value-storage
Intro to Hive
Data persistence is one of the most important aspects of any mobile application. A mobile application always keeps some type of state, such as user information, game scores, the user's current position, and so on.
Data persistence inv...
Read: https://dhruvnakum.xyz/flutter-hive-blazing-fast-key-value-storage
Query Editor In Azure Portal
In today’s article, we will talk about Query Editor In Azure Portal. Microsoft Azure added a previewer feature for SQL Databases called Query Editor. This feature is browser-based and is a query editor used on the portal. As seen in the picture below, we can access the required field in the SQL database through the …
Read: Query Editor In Azure Portal.
In today’s article, we will talk about Query Editor In Azure Portal. Microsoft Azure added a previewer feature for SQL Databases called Query Editor. This feature is browser-based and is a query editor used on the portal. As seen in the picture below, we can access the required field in the SQL database through the …
Read: Query Editor In Azure Portal.
Executing Files with .Bin and .Sh Extensions on Linux OS
In this article, we will talk about Executing Files with .Bin and .Sh Extensions on Linux OS. This simple subject is one of the first commands to learn for beginners to the Linux operating system. As usual in Windows operating systems, all .exe , .bat etc. extensions can be run with the ease of double-clicking, …
Read: Executing Files with .Bin and .Sh Extensions on Linux OS.
In this article, we will talk about Executing Files with .Bin and .Sh Extensions on Linux OS. This simple subject is one of the first commands to learn for beginners to the Linux operating system. As usual in Windows operating systems, all .exe , .bat etc. extensions can be run with the ease of double-clicking, …
Read: Executing Files with .Bin and .Sh Extensions on Linux OS.
Standby Max Data Delay
In today’s article, we will talk about Standby Max Data Delay. While some of the reporting users who make inquiries from Active Data Guard expect the retrieved data to be the same as the Production at that moment, others do not care if LAG has been formed for a few seconds. The time until this …
Read: Standby Max Data Delay.
In today’s article, we will talk about Standby Max Data Delay. While some of the reporting users who make inquiries from Active Data Guard expect the retrieved data to be the same as the Production at that moment, others do not care if LAG has been formed for a few seconds. The time until this …
Read: Standby Max Data Delay.