Understanding Isolation levels in SQL Server
A transaction is a group of T-SQL statements performing single or multiple operations on objects as a single unit. If any of the statements in the transaction fails, then the whole operation reverts due to transaction rollback. This assures that thos...
Read: https://mssqlserver.dev/understanding-isolation-levels-in-sql-server
A transaction is a group of T-SQL statements performing single or multiple operations on objects as a single unit. If any of the statements in the transaction fails, then the whole operation reverts due to transaction rollback. This assures that thos...
Read: https://mssqlserver.dev/understanding-isolation-levels-in-sql-server
Aggregation in MongoDB
Hello, devs 👋
In this blog, we will learn the basics of the MongoDB aggregation framework to filter, sort, group, and transform our MongoDB results. MongoDB helps us to do all these operations through aggregation pipelines which are a series of oper...
Read: https://saurabhbomble.hashnode.dev/aggregation-in-mongodb
Hello, devs 👋
In this blog, we will learn the basics of the MongoDB aggregation framework to filter, sort, group, and transform our MongoDB results. MongoDB helps us to do all these operations through aggregation pipelines which are a series of oper...
Read: https://saurabhbomble.hashnode.dev/aggregation-in-mongodb
Как настроить Kerberos аутентификации в Keycloak
Виктор Попов, техлид DevOps-команды в X5 Tech и спикер курса «Безопасность проекта: аутентификация в Keycloak», подготовил туториал. В нём он рассказывает, как настроить Kerberos аутентификации в Keycloak и как подготовить браузеры для работы.
Читать: https://habr.com/ru/post/661209/
Виктор Попов, техлид DevOps-команды в X5 Tech и спикер курса «Безопасность проекта: аутентификация в Keycloak», подготовил туториал. В нём он рассказывает, как настроить Kerberos аутентификации в Keycloak и как подготовить браузеры для работы.
Читать: https://habr.com/ru/post/661209/
Architecture Case Study: Complex Data-Tier Systems within Multi-Tier Web Architecture
Today, we are going to solve a technology company's data-tier multi-tier architecture problems. This company is one of the newest and fastest growing technology companies of the year. It is a USA based company with more than 5,000 employees, among wh...
Read: https://danielbossou.hashnode.dev/architecture-case-study-complex-data-tier-systems-within-multi-tier-web-architecture
Today, we are going to solve a technology company's data-tier multi-tier architecture problems. This company is one of the newest and fastest growing technology companies of the year. It is a USA based company with more than 5,000 employees, among wh...
Read: https://danielbossou.hashnode.dev/architecture-case-study-complex-data-tier-systems-within-multi-tier-web-architecture
Every Day Is Tax Day When Your Data Architecture Is Too Complex
Read: https://www.mongodb.com/blog/post/every-day-tax-day-when-your-data-architecture-too-complex
Read: https://www.mongodb.com/blog/post/every-day-tax-day-when-your-data-architecture-too-complex
Day 26/100
Designing Data-Intensive Applications [Book Highlights]
[Part I : Chapter II] Data Models and Query Languages
The Cypher Query Language
Cypher is a declarative query language for property graphs, created for the Neo4j
graph database
Example 2-4. Cyp...
Read: https://rawdatareaders.hashnode.dev/day-26
Designing Data-Intensive Applications [Book Highlights]
[Part I : Chapter II] Data Models and Query Languages
The Cypher Query Language
Cypher is a declarative query language for property graphs, created for the Neo4j
graph database
Example 2-4. Cyp...
Read: https://rawdatareaders.hashnode.dev/day-26
«Импортозамещаем» анализ планов PostgreSQL
Вчера Hubert 'depesz' Lubaczewski закрыл доступ с российских IP ко всем своим сайтам, включая широко известный визуализатор планов PostgreSQL-запросов explain.depesz.com.
Но это не беда, потому что в компании "Тензор" мы разработали сервис explain.tensor.ru, функционал которого гораздо обширнее, и которым можете воспользоваться и вы.
Читать: https://habr.com/ru/post/660727/
Вчера Hubert 'depesz' Lubaczewski закрыл доступ с российских IP ко всем своим сайтам, включая широко известный визуализатор планов PostgreSQL-запросов explain.depesz.com.
Но это не беда, потому что в компании "Тензор" мы разработали сервис explain.tensor.ru, функционал которого гораздо обширнее, и которым можете воспользоваться и вы.
Читать: https://habr.com/ru/post/660727/
Day 27/100
Designing Data-Intensive Applications [Book Highlights]
[Part I : Chapter III] Storage and Retrieval
fundamentals of a database are two things: it should store the data, it should give it back as well.
Consider the world’s simplest database, imple...
Read: https://rawdatareaders.hashnode.dev/day-27
Designing Data-Intensive Applications [Book Highlights]
[Part I : Chapter III] Storage and Retrieval
fundamentals of a database are two things: it should store the data, it should give it back as well.
Consider the world’s simplest database, imple...
Read: https://rawdatareaders.hashnode.dev/day-27
Set up your application with Heroku's Database
Heroku is a cloud platform as a service (PaaS) supporting several programming languages as well as RDBMS like Postgres
In this blog, you're going to learn "How to set up your application with Heroku's Database"
Prerequisites
Basic JS, Postgres knowl...
Read: https://eklavya.hashnode.dev/set-up-your-application-with-herokus-database
Heroku is a cloud platform as a service (PaaS) supporting several programming languages as well as RDBMS like Postgres
In this blog, you're going to learn "How to set up your application with Heroku's Database"
Prerequisites
Basic JS, Postgres knowl...
Read: https://eklavya.hashnode.dev/set-up-your-application-with-herokus-database
SQL vs NoSQL
Introduction
Database is a component required to persist data. In the world of databases, there are two main types of solutions: SQL(relational) and NoSQL(non-relational) databases.
SQL
SQL stands for structured query language. As the names suggests...
Read: https://codeminion.hashnode.dev/sql-vs-nosql
Introduction
Database is a component required to persist data. In the world of databases, there are two main types of solutions: SQL(relational) and NoSQL(non-relational) databases.
SQL
SQL stands for structured query language. As the names suggests...
Read: https://codeminion.hashnode.dev/sql-vs-nosql
🗃️ How to use Mongoose with Next.js for MongoDB?
Hey all 👋!
Next.js is an amazing full-stack framework and MongoDB is a great NoSQL database. Using them together will make an app super fast and awesome! In this post, we'll go ahead and set up the Mongoose ODM inside our Next.js app to make use of ...
Read: https://blog.usman-s.me/how-to-use-mongoose-with-nextjs-for-mongodb
Hey all 👋!
Next.js is an amazing full-stack framework and MongoDB is a great NoSQL database. Using them together will make an app super fast and awesome! In this post, we'll go ahead and set up the Mongoose ODM inside our Next.js app to make use of ...
Read: https://blog.usman-s.me/how-to-use-mongoose-with-nextjs-for-mongodb
How I extracted 588 Questions from A PDF file with Regex
Introduction
Before I start, I'd like to mention the article is meant to iterate the potentials of regular expression with keen attention on its style and syntax in JavaScript. Please note that the code samples in this article were executed in Node ...
Read: https://opeolluwa.hashnode.dev/how-i-extracted-588-questions-from-a-pdf-file-with-regex
Introduction
Before I start, I'd like to mention the article is meant to iterate the potentials of regular expression with keen attention on its style and syntax in JavaScript. Please note that the code samples in this article were executed in Node ...
Read: https://opeolluwa.hashnode.dev/how-i-extracted-588-questions-from-a-pdf-file-with-regex
SQL Queries For Mere Mortals: Filtering Your Data
Refining What You See Using WHERE
The type of SELECT statement we’ve worked with so far retrieves all the rows from a given table and uses them in the statement’s result set.
This is great if you really do need to see all the information the tabl...
Read: https://samra.hashnode.dev/sql-queries-for-mere-mortals-filtering-your-data
Refining What You See Using WHERE
The type of SELECT statement we’ve worked with so far retrieves all the rows from a given table and uses them in the statement’s result set.
This is great if you really do need to see all the information the tabl...
Read: https://samra.hashnode.dev/sql-queries-for-mere-mortals-filtering-your-data
Adventuring into the Cosmos
Studying for AZ-204: Developing Solutions for Microsoft Azure
I'm scheduled to take the AZ-204 exam in the next couple of weeks so I'm currently playing around with the main resources covered to get some practice in the portal and also writing client...
Read: https://phillipjohnson.co.uk/adventuring-into-the-cosmos
Studying for AZ-204: Developing Solutions for Microsoft Azure
I'm scheduled to take the AZ-204 exam in the next couple of weeks so I'm currently playing around with the main resources covered to get some practice in the portal and also writing client...
Read: https://phillipjohnson.co.uk/adventuring-into-the-cosmos
Connection Pooling in Database
As a developer, you may not have spent a lot of time thinking about database connections. A single database connection is not expensive, but as things scale up, problems can arise. So let’s dive into the world of connection pooling, and take a look a...
Read: https://prodip-7.hashnode.dev/connection-pooling-in-database
As a developer, you may not have spent a lot of time thinking about database connections. A single database connection is not expensive, but as things scale up, problems can arise. So let’s dive into the world of connection pooling, and take a look a...
Read: https://prodip-7.hashnode.dev/connection-pooling-in-database
Commonly used Queries in MongoDB
In this article, we'll look at some of the most commonly used query methods in MongoDB. We'll be using the MongoDB compass and the MongoDB shell to navigate and manipulate a simple database.
Prerequisites
To comprehend this tutorial, it is expected t...
Read: https://davidekete.com/commonly-used-queries-in-mongodb
In this article, we'll look at some of the most commonly used query methods in MongoDB. We'll be using the MongoDB compass and the MongoDB shell to navigate and manipulate a simple database.
Prerequisites
To comprehend this tutorial, it is expected t...
Read: https://davidekete.com/commonly-used-queries-in-mongodb
Binning in MySQL
Binning, and eventually graphing as a histogram, is an effective and useful way to analyze and understand trends in your data. BI tools like Tableau provide easy binning capabilities so you can bin on ranges like month or year. But is there a way wit...
Read: https://nav610.hashnode.dev/binning-in-mysql
Binning, and eventually graphing as a histogram, is an effective and useful way to analyze and understand trends in your data. BI tools like Tableau provide easy binning capabilities so you can bin on ranges like month or year. But is there a way wit...
Read: https://nav610.hashnode.dev/binning-in-mysql
ETL using Python (Petl) in Oracle Database
Hello there, Good day ! 👋
This blog is to show or give you guys an idea of how to do Extraction, Transformation and Load a dataset into an Oracle Database. ETL process can be done by many methods, one of them is by using Python. Here, we will have t...
Read: https://maran.hashnode.dev/etl-using-python
Hello there, Good day ! 👋
This blog is to show or give you guys an idea of how to do Extraction, Transformation and Load a dataset into an Oracle Database. ETL process can be done by many methods, one of them is by using Python. Here, we will have t...
Read: https://maran.hashnode.dev/etl-using-python
Binning in MySQL
Binning, and eventually graphing as a histogram, is an effective and useful way to analyze and understand trends in your data. BI tools like Tableau provide easy binning capabilities so you can bin on ranges like month or year. But is there a way wit...
Read: https://nocd.hashnode.dev/binning-in-mysql
Binning, and eventually graphing as a histogram, is an effective and useful way to analyze and understand trends in your data. BI tools like Tableau provide easy binning capabilities so you can bin on ranges like month or year. But is there a way wit...
Read: https://nocd.hashnode.dev/binning-in-mysql
Masonite Project- One to One Relationship Example
In this tutorial we will explore One to One Relationship in Masonite Project.
One to One model relationship is very simple and basic. We have to make sure that one of the tables has a key that references the id of the other table. We will learn how ...
Read: https://blog.popolo.dev/masonite-project-one-to-one-relationship-example
In this tutorial we will explore One to One Relationship in Masonite Project.
One to One model relationship is very simple and basic. We have to make sure that one of the tables has a key that references the id of the other table. We will learn how ...
Read: https://blog.popolo.dev/masonite-project-one-to-one-relationship-example
3 Minutes for Structure of Database System
If you are here, I am assuming that you have a little bit of knowledge of what is a database and some kinds of stuff and If not then feel free to learn it on my Blog in an Easy way.
Let's Take a Look at the Original Diagram of the Database System.
F...
Read: https://wolfgunner.hashnode.dev/3-minutes-for-structure-of-database-system
If you are here, I am assuming that you have a little bit of knowledge of what is a database and some kinds of stuff and If not then feel free to learn it on my Blog in an Easy way.
Let's Take a Look at the Original Diagram of the Database System.
F...
Read: https://wolfgunner.hashnode.dev/3-minutes-for-structure-of-database-system