Understand PostgreSQL Enum type!
In this article, you are going to understand the PostgreSQL enum and try to get the answer below question,
What does an enum?
why use an enum?
How to use an enum?
Introduction:
PostgreSQL supports the boolean type of binary data type, where you can...
Read: https://techwasti.com/understand-postgresql-enum-type
In this article, you are going to understand the PostgreSQL enum and try to get the answer below question,
What does an enum?
why use an enum?
How to use an enum?
Introduction:
PostgreSQL supports the boolean type of binary data type, where you can...
Read: https://techwasti.com/understand-postgresql-enum-type
Почему миграция критически важных бизнес-систем в облако неизбежна
Поскольку глобальные объёмы данных теперь измеряются в зеттабайтах и быстро растут, вопрос о миграции в облако в 2022 году звучит не «зачем?», а «когда и как?», и отказ от переноса критически важных приложений в облако часто уже невозможен. Любой компании, чтобы быть успешной необходимо иметь программы или программное обеспечение, которые работают непрерывно. И если одно из таких критически важных приложений перестанет работать, это может иметь серьёзные негативные последствия для бизнеса. Сбой этих приложений может привести к финансовым потерям, снижению производительности и нанести ущерб репутации компании. Примеры критически важных приложений варьируются от отрасли к отрасли.
Общим для критически важных сервисов является то, что они необходимы для работы и должны быть постоянно подключены. Критически важные системы и приложения переносятся в облако для создания интеллектуальных систем с безопасными данными и обеспечения непрерывной работы. Миграция этих приложений в облако имеет много преимуществ, поскольку обеспечивает высокий уровень масштабируемости и гибкости. Это позволяет компаниям использовать больше ресурсов при меньших затратах.
Читать: https://habr.com/ru/post/666994/
Поскольку глобальные объёмы данных теперь измеряются в зеттабайтах и быстро растут, вопрос о миграции в облако в 2022 году звучит не «зачем?», а «когда и как?», и отказ от переноса критически важных приложений в облако часто уже невозможен. Любой компании, чтобы быть успешной необходимо иметь программы или программное обеспечение, которые работают непрерывно. И если одно из таких критически важных приложений перестанет работать, это может иметь серьёзные негативные последствия для бизнеса. Сбой этих приложений может привести к финансовым потерям, снижению производительности и нанести ущерб репутации компании. Примеры критически важных приложений варьируются от отрасли к отрасли.
Общим для критически важных сервисов является то, что они необходимы для работы и должны быть постоянно подключены. Критически важные системы и приложения переносятся в облако для создания интеллектуальных систем с безопасными данными и обеспечения непрерывной работы. Миграция этих приложений в облако имеет много преимуществ, поскольку обеспечивает высокий уровень масштабируемости и гибкости. Это позволяет компаниям использовать больше ресурсов при меньших затратах.
Читать: https://habr.com/ru/post/666994/
Building a Modern App Stack with Apollo GraphQL and MongoDB Atlas
Read: https://www.mongodb.com/blog/post/building-modern-app-stack-apollo-graph-ql-atlas
Read: https://www.mongodb.com/blog/post/building-modern-app-stack-apollo-graph-ql-atlas
How the N+1 query can burn your database
Overview
Have you ever watched a movie/series or experience your self going to a hotel where they have room service?, let's put that you go to one of these hotels, where the hotel’s restaurant is at the first floor, and you’re hosteling at the 10th f...
Read: https://hernanreyes.dev/how-the-n1-query-can-burn-your-database
Overview
Have you ever watched a movie/series or experience your self going to a hotel where they have room service?, let's put that you go to one of these hotels, where the hotel’s restaurant is at the first floor, and you’re hosteling at the 10th f...
Read: https://hernanreyes.dev/how-the-n1-query-can-burn-your-database
Install HarperDB on Linode
Hi... let's see how to install HarperDB with Docker on a Linux machine running on Linode. HarperDB is a NoSQL DB that also supports SQL style queries. It can be installed in various ways and we shall be installing it the Docker way, in this post.
Ins...
Read: https://networkandcode.hashnode.dev/install-harperdb-on-linode
Hi... let's see how to install HarperDB with Docker on a Linux machine running on Linode. HarperDB is a NoSQL DB that also supports SQL style queries. It can be installed in various ways and we shall be installing it the Docker way, in this post.
Ins...
Read: https://networkandcode.hashnode.dev/install-harperdb-on-linode
Oracle Autonomous Database users can now be authenticated and managed with Azure Active Directory
Many on-premises customers integrate their Oracle Database with Microsoft Active Directory to streamline user management and help reduce risk. As these customers migrate to the cloud, many are looking to centralize identities in their cloud directories while their Oracle Database runs in Oracle Cloud Infrastructure (OCI).
Read: https://blogs.oracle.com/database/post/azure-active-directory-can-authenticate-database-users
Many on-premises customers integrate their Oracle Database with Microsoft Active Directory to streamline user management and help reduce risk. As these customers migrate to the cloud, many are looking to centralize identities in their cloud directories while their Oracle Database runs in Oracle Cloud Infrastructure (OCI).
Read: https://blogs.oracle.com/database/post/azure-active-directory-can-authenticate-database-users
Oracle
Oracle Autonomous Database users can now be authenticated and managed with Azure Active Directory
Many on-premises customers integrate their Oracle Database with Microsoft Active Directory to streamline user management and help reduce risk. As these customers migrate to the cloud, many are looking to centralize identities in their cloud directories while…
InfluxDatabase is up and running with Docker.
InfluxDB is an open-source time-series database for recording metrics, events, and analytics.
InfluxDB is a time-series database built from the ground up to handle high write and query loads. InfluxDB is meant to be used as a backing store for any us...
Read: https://techwasti.com/influxdatabase-is-up-and-running-with-docker
InfluxDB is an open-source time-series database for recording metrics, events, and analytics.
InfluxDB is a time-series database built from the ground up to handle high write and query loads. InfluxDB is meant to be used as a backing store for any us...
Read: https://techwasti.com/influxdatabase-is-up-and-running-with-docker
Introduction to Apache Doris(incubating)
Apache Doris (incubating) is a high-performance, real-time analytical database based on MPP architecture, known for its extreme speed and ease of use. It only requires a sub-second response time to return query results under massive data and can supp...
Read: https://github.com/apache/incubator-doris/introduction-to-apache-dorisincubating
Apache Doris (incubating) is a high-performance, real-time analytical database based on MPP architecture, known for its extreme speed and ease of use. It only requires a sub-second response time to return query results under massive data and can supp...
Read: https://github.com/apache/incubator-doris/introduction-to-apache-dorisincubating
5 полезных запросов для MS SQL
За 2 года работы с MS SQL у меня накопился перечень из 5 запросов: для поиска, отладки, агрегации и обработки множеств и таблиц.
Читать: «5 полезных запросов для MS SQL»
За 2 года работы с MS SQL у меня накопился перечень из 5 запросов: для поиска, отладки, агрегации и обработки множеств и таблиц.
Читать: «5 полезных запросов для MS SQL»
Почему закон о персональных данных глубже, чем кажется
Как должны храниться персональные данные, почему они попадают в сеть, и что с этим делать бизнесу. Как распределяются зоны ответственности и какие федеральные законы регламентируют действия операторов данных.
Читать: https://habr.com/ru/post/671302/
Как должны храниться персональные данные, почему они попадают в сеть, и что с этим делать бизнесу. Как распределяются зоны ответственности и какие федеральные законы регламентируют действия операторов данных.
Читать: https://habr.com/ru/post/671302/
Trino: Scalable, Distributed, and OpenSource SQL Engine!
Trino is a tool designed to query large amounts of data using distributed queries efficiently. If you work with terabytes or petabytes of data, you probably use tools that interact with Hadoop and HDFS. Trino is designed as an alternative to tools th...
Read: https://josueluzardogebrim.hashnode.dev/trino-scalable-distributed-and-opensource-sql-engine
Trino is a tool designed to query large amounts of data using distributed queries efficiently. If you work with terabytes or petabytes of data, you probably use tools that interact with Hadoop and HDFS. Trino is designed as an alternative to tools th...
Read: https://josueluzardogebrim.hashnode.dev/trino-scalable-distributed-and-opensource-sql-engine
Deep Insights into Low-code Development Tools
In this chapter, we will share with you some of the top low-code development tools repos (LCDT repos) on GitHub in 2021 measured by different metrics including the number of stars, PRs, contributors, countries, regions and so on.
Note:
You can move ...
Read: https://hashnode.com/post/deep-insights-into-low-code-development-tools-cl4f500gg03bk0vnv25lz54s1
In this chapter, we will share with you some of the top low-code development tools repos (LCDT repos) on GitHub in 2021 measured by different metrics including the number of stars, PRs, contributors, countries, regions and so on.
Note:
You can move ...
Read: https://hashnode.com/post/deep-insights-into-low-code-development-tools-cl4f500gg03bk0vnv25lz54s1
MongoDB Compatibility With Rocky Linux and AlmaLinux
Read: https://www.mongodb.com/blog/post/mongodb-compatibility-rocky-linux-alma-linux
Read: https://www.mongodb.com/blog/post/mongodb-compatibility-rocky-linux-alma-linux
Migrating Databases from Heroku Postgres to AWS
Many teams host their relational data storage on Heroku. However, over time, a significant number find themselves migrating their Postgres workloads over to AWS. In this article, I'll discuss why many teams are making this jump. I'll also detail the ...
Read: https://blog.tinystacks.com/migrate-heroku-postgres-aws
Many teams host their relational data storage on Heroku. However, over time, a significant number find themselves migrating their Postgres workloads over to AWS. In this article, I'll discuss why many teams are making this jump. I'll also detail the ...
Read: https://blog.tinystacks.com/migrate-heroku-postgres-aws
New MariaDB Enterprise Server Releases with backported Features and Rocky Linux Support now available
Read: https://mariadb.com/?p=31832
Read: https://mariadb.com/?p=31832
Most Significant Data Breaches Of The Twenty-first Century
Multiple databases of stolen records are freely exchanged on Dark Web networks, which is nothing new. Stolen data may be utilised in a variety of attacks, such as spear-phishing, random malspam campaigns, and so on. However, a new, alarming data brea...
Read: https://khansa.hashnode.dev/most-significant-data-breaches-of-the-twenty-first-century
Multiple databases of stolen records are freely exchanged on Dark Web networks, which is nothing new. Stolen data may be utilised in a variety of attacks, such as spear-phishing, random malspam campaigns, and so on. However, a new, alarming data brea...
Read: https://khansa.hashnode.dev/most-significant-data-breaches-of-the-twenty-first-century
Automate AI Model Building in SkySQL: MariaDB & MindsDB Collaboration
Read: https://mariadb.com/?p=31716
Read: https://mariadb.com/?p=31716
How the N+1 query problem can burn your database
Overview
Have you ever watched a movie/series or experience your self going to a hotel where they have room service?, let's put that you go to one of these hotels, where the hotel’s restaurant is at the first floor, and you’re hosteling at the 10th f...
Read: https://hernanreyes.dev/how-the-n1-query-problem-can-burn-your-database
Overview
Have you ever watched a movie/series or experience your self going to a hotel where they have room service?, let's put that you go to one of these hotels, where the hotel’s restaurant is at the first floor, and you’re hosteling at the 10th f...
Read: https://hernanreyes.dev/how-the-n1-query-problem-can-burn-your-database
Amazon Aurora PostgreSQL backups and long-term data retention methods
Read: https://aws.amazon.com/blogs/database/amazon-aurora-postgresql-backups-and-long-term-data-retention-methods/
Read: https://aws.amazon.com/blogs/database/amazon-aurora-postgresql-backups-and-long-term-data-retention-methods/
MySQL Support in Database Tools in OCI
Database Tools in OCI now supports connections to the MySQL Database Service.
Read: https://blogs.oracle.com/database/post/mysql-support-in-database-tools-in-oci
Database Tools in OCI now supports connections to the MySQL Database Service.
Read: https://blogs.oracle.com/database/post/mysql-support-in-database-tools-in-oci
Oracle
MySQL Support in Database Tools in OCI
Database Tools in OCI now supports connections to the MySQL Database Service.
Cloud Database Services for Every Workload
Oracle offers three cloud database service families that are 100% compatible with the industry leading Oracle Database: Oracle Autonomous Database, Oracle Exadata Database Service, and Oracle Base Database Service. These services give you the freedom to choose the best database service to meet your specific needs, whether it’s features, SLAs, or even data residency requirements.
Read: https://blogs.oracle.com/database/post/cloud-database-services-for-every-workload
Oracle offers three cloud database service families that are 100% compatible with the industry leading Oracle Database: Oracle Autonomous Database, Oracle Exadata Database Service, and Oracle Base Database Service. These services give you the freedom to choose the best database service to meet your specific needs, whether it’s features, SLAs, or even data residency requirements.
Read: https://blogs.oracle.com/database/post/cloud-database-services-for-every-workload
Oracle
Cloud Database Services for Every Workload
Oracle offers three cloud database service families that are 100% compatible with the industry leading Oracle Database: Oracle Autonomous Database, Oracle Exadata Database Service, and Oracle Base Database Service. These services give you the freedom to…