Import Dat File Into PostgreSQL
In today’s article we will cover the topic of Import Dat File Into PostgreSQL. Sometimes we need to import/export some tables in PostgreSQL. In this article, we will import the .dat file on PostgreSQL into the table. While doing this, we will do it through pgadmin, which is the simplest and easiest way. First of …
Read: Import Dat File Into PostgreSQL.
In today’s article we will cover the topic of Import Dat File Into PostgreSQL. Sometimes we need to import/export some tables in PostgreSQL. In this article, we will import the .dat file on PostgreSQL into the table. While doing this, we will do it through pgadmin, which is the simplest and easiest way. First of …
Read: Import Dat File Into PostgreSQL.
Remotely Connect PostgreSQL Running on Azure Linux VM
In today’s article, I will explain the topic of Remotely Connect PostgreSQL Running on Azure Linux VM. In order to do this, we need to edit the pg_hba.conf and postgresql.conf files. These files are located in /etc/postgresql/version_info/main. The version information here varies according to the installed PostgreSQL version information. On our server, the access method …
Read: Remotely Connect PostgreSQL Running on Azure Linux VM.
In today’s article, I will explain the topic of Remotely Connect PostgreSQL Running on Azure Linux VM. In order to do this, we need to edit the pg_hba.conf and postgresql.conf files. These files are located in /etc/postgresql/version_info/main. The version information here varies according to the installed PostgreSQL version information. On our server, the access method …
Read: Remotely Connect PostgreSQL Running on Azure Linux VM.
Basic Linux Command
In today’s article I will give information about Basic Linux Command. Cd : You can enter the specified folder with the cd command and you can go to the home directory of the user you are connected to from the directory you are connected to by simply typing cd. After the cd command, you write …
Read: Basic Linux Command.
In today’s article I will give information about Basic Linux Command. Cd : You can enter the specified folder with the cd command and you can go to the home directory of the user you are connected to from the directory you are connected to by simply typing cd. After the cd command, you write …
Read: Basic Linux Command.
Why CockroachDB Serverless is the real deal
After writing my last article about Next Gen databases, I wanted to dig into CockroachDB and all it had to offer. It seemed like such an interesting new technology to me. I had heard of them before but never put aside the time to dive in and see how ...
Read: https://pythondev.hashnode.dev/why-cockroachdb-serverless-is-the-real-deal
After writing my last article about Next Gen databases, I wanted to dig into CockroachDB and all it had to offer. It seemed like such an interesting new technology to me. I had heard of them before but never put aside the time to dive in and see how ...
Read: https://pythondev.hashnode.dev/why-cockroachdb-serverless-is-the-real-deal
Physical migration of Oracle databases to Amazon RDS Custom using Data Guard
Read: https://aws.amazon.com/blogs/database/physical-migration-of-oracle-databases-to-amazon-rds-custom-using-data-guard/
Read: https://aws.amazon.com/blogs/database/physical-migration-of-oracle-databases-to-amazon-rds-custom-using-data-guard/
Day 1/100
HDFS - [Hadoop Distributed File System]
HDFS architecture looks like this -
NameNode holds all the metadata about files and directory structure and then there are
DataNodes which basically hold files in the form of blocks so DataNode holds blocks o...
Read: https://rawdatareaders.hashnode.dev/day-1
HDFS - [Hadoop Distributed File System]
HDFS architecture looks like this -
NameNode holds all the metadata about files and directory structure and then there are
DataNodes which basically hold files in the form of blocks so DataNode holds blocks o...
Read: https://rawdatareaders.hashnode.dev/day-1
Oracle Database 19c Running @Memory Speed
Persistent Memory Database starting Oracle 19.12 using Oracle Memory Speed (OMS).
Read: https://blogs.oracle.com/database/post/oracle-database-19c-running-memory-speed
Persistent Memory Database starting Oracle 19.12 using Oracle Memory Speed (OMS).
Read: https://blogs.oracle.com/database/post/oracle-database-19c-running-memory-speed
Oracle
Oracle Database 19c Running @Memory Speed
Persistent Memory Database starting Oracle 19.12 using Oracle Memory Speed (OMS).
Building a Vector Database for Scalable Similarity Search
According to statistics, about 80%-90% of the world's data is unstructured. Fueled by the rapid growth of the Internet, an explosion of unstructured data is expected in the coming years. Consequently, companies are in urgent need of a powerful databa...
Read: https://angela.hashnode.dev/building-a-vector-database-for-scalable-similarity-search
According to statistics, about 80%-90% of the world's data is unstructured. Fueled by the rapid growth of the Internet, an explosion of unstructured data is expected in the coming years. Consequently, companies are in urgent need of a powerful databa...
Read: https://angela.hashnode.dev/building-a-vector-database-for-scalable-similarity-search
Accelerating Similarity Search on Really Big Data with Vector Indexing (Part II)
From computer vision to new drug discovery, many popular artificial intelligence (AI) applications are powered by vector databases. Indexing, a process of organizing data that drastically accelerates big data search, enables us to efficiently query m...
Read: https://angela.hashnode.dev/accelerating-similarity-search-on-really-big-data-with-vector-indexing-part-ii
From computer vision to new drug discovery, many popular artificial intelligence (AI) applications are powered by vector databases. Indexing, a process of organizing data that drastically accelerates big data search, enables us to efficiently query m...
Read: https://angela.hashnode.dev/accelerating-similarity-search-on-really-big-data-with-vector-indexing-part-ii
How to Install Adminer MySQL Database Management Tool on Alma Linux 8
Read: https://www.howtoforge.com/how-to-install-adminer-on-alma-linux-8/
Read: https://www.howtoforge.com/how-to-install-adminer-on-alma-linux-8/
Отчёт с митапа: PostgreSQL-as-Service — можем, умеем, практикуем
Выкладываем запись с Ozon Tech PostgreSQL Meetup. Ранее я уже описывал нашу инфраструктуру: весь PostgreSQL основан на виртуальных машинах — 2К в тестовой среде и ~8К в проде. Это около 2К кластеров баз данных. Так как у нас микросервисная архитектура, мы придерживаемся принципа 1 сервис = 1 база. Нагрузка на базы может быть приличная: 2-2,5 млн транзакций в секунду, а WAL-трафик порядка 1.5 ГБ/c.
Рассказали, как наша команда управляет всей этой инфраструктурой, как пришли к парадигме выдачи базы по кнопке и как воплотили её в жизнь.
Видео и слайды пол катом
Читать: https://habr.com/ru/post/653521/
Выкладываем запись с Ozon Tech PostgreSQL Meetup. Ранее я уже описывал нашу инфраструктуру: весь PostgreSQL основан на виртуальных машинах — 2К в тестовой среде и ~8К в проде. Это около 2К кластеров баз данных. Так как у нас микросервисная архитектура, мы придерживаемся принципа 1 сервис = 1 база. Нагрузка на базы может быть приличная: 2-2,5 млн транзакций в секунду, а WAL-трафик порядка 1.5 ГБ/c.
Рассказали, как наша команда управляет всей этой инфраструктурой, как пришли к парадигме выдачи базы по кнопке и как воплотили её в жизнь.
Видео и слайды пол катом
Читать: https://habr.com/ru/post/653521/
How to use HarperDB custom functions to build your entire backend
What is HarperDB
When HarperDB first started they were a distributed database platform. Essentially this meant that anyone could spin up a cloud instance for creating a database for storing your data online. These databases supported both SQL and NoS...
Read: https://andrewbaisden.hashnode.dev/how-to-use-harperdb-custom-functions-to-build-your-entire-backend
What is HarperDB
When HarperDB first started they were a distributed database platform. Essentially this meant that anyone could spin up a cloud instance for creating a database for storing your data online. These databases supported both SQL and NoS...
Read: https://andrewbaisden.hashnode.dev/how-to-use-harperdb-custom-functions-to-build-your-entire-backend
EDB Postgres 13 Installation on Oracle Linux 7.8
In today’s article, I will talk about EDB Postgres 13 Installation on Oracle Linux 7.8. First of all, we install the packages that need to be installed before installation. [crayon-6239ae47a6cd4526090328/] We load the repository configuration file. [crayon-6239ae47a6cdd844206122/] After the installation is complete, we enter the edb.repo file with vi and enter the registered edb user …
Read: EDB Postgres 13 Installation on Oracle Linux 7.8.
In today’s article, I will talk about EDB Postgres 13 Installation on Oracle Linux 7.8. First of all, we install the packages that need to be installed before installation. [crayon-6239ae47a6cd4526090328/] We load the repository configuration file. [crayon-6239ae47a6cdd844206122/] After the installation is complete, we enter the edb.repo file with vi and enter the registered edb user …
Read: EDB Postgres 13 Installation on Oracle Linux 7.8.
PostgreSQL_Backup and Restore database
🎯 Target: create plain dump of PostgreSQL Database and move it to another server
🛠️ Tools and prerequisites: PostgreSQL DB and pgAdmin 4
Step 1 - Create DB backup
In pgAdmin 4 LMB click on the needed DB name and choose Backup...
2.Choose path an...
Read: https://dataviz.hashnode.dev/postgresqlbackup-and-restore-database
🎯 Target: create plain dump of PostgreSQL Database and move it to another server
🛠️ Tools and prerequisites: PostgreSQL DB and pgAdmin 4
Step 1 - Create DB backup
In pgAdmin 4 LMB click on the needed DB name and choose Backup...
2.Choose path an...
Read: https://dataviz.hashnode.dev/postgresqlbackup-and-restore-database
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 15 – Add support for security invoker views.
Read: https://postgr.es/p/5hU
Read: https://postgr.es/p/5hU
PostgreSQL_Drop Mainantanance DB
🎯 Target: drop mainantanance database
🛠️ Tools and prerequisites: Mainantanance DB and another DB and pgAdmin 4
Step 1 - Disconnect Server and Change Mainantanance DB
1.In pgAdmin 4 LMB click on the PostgreSQL 14 name, choose Disconnect Server and ...
Read: https://dataviz.hashnode.dev/postgresqldrop-mainantanance-db
🎯 Target: drop mainantanance database
🛠️ Tools and prerequisites: Mainantanance DB and another DB and pgAdmin 4
Step 1 - Disconnect Server and Change Mainantanance DB
1.In pgAdmin 4 LMB click on the PostgreSQL 14 name, choose Disconnect Server and ...
Read: https://dataviz.hashnode.dev/postgresqldrop-mainantanance-db