JIYIK CN >

This article will discuss the timestamp types in PostgreSQL and show how they differ. Timestamps in PostgreSQL In PostgreSQL, there are two types of timestamps. Timestamp without time zone Timestamp with time zone The first stores the local...

This article shows how to check the version of Postgres. Checking Postgres Version in Windows C: \ Users \ Admin psql -- version psql ( PostgreSQL ) 14.0 C : \ Users \ Admin postgres -- version postgres ( PostgreSQL ) 14.0 The version shown...

A CSV file is .csv a text file with a .CSV extension and the contents are separated by commas. This file can achieve different goals, such as loading data into database tables and importing data into Google and Excel spreadsheets. When work...

This article discusses how to import SQL files in PostgreSQL. psql Import SQL files in PostgreSQL using command To import the SQL file, run the following command: psql - U dbuser - h localhost databasename filename. sql If the file is locat...

In this article, we will change the user password in Postgres. Changing User Passwords in Postgres Using Windows Open from the menu or search bar SQL Shell (psql) . Connect to the default database using the default port. If you set it up wi...

This article will discuss creating schemas in PostgreSQL using SQL queries or psql. CREATE SCHEMA Use the statement to create a pattern in SQL query To create a new schema, execute the following command. CREATE SCHEMA test_schema To view al...

Today, we will learn how to find a value in a PostgreSQL string and select it if it matches certain conditions. Suppose you have a string carabc and want to see if it contains a value car . Therefore, you will try to use a function that tel...

In this article, we will learn how to query nested objects in MongoDB. Querying nested objects in MongoDB MongoDB provides read operations to retrieve embedded or nested data from a collection or to search for embedded or nested documents....

Unusually slow queries are one of the most common MySQL performance issues. Queries that perform acceptably in development may falter under the pressure of a production workload. Large applications may run hundreds of unique database querie...

By default, MySQL only allows localhost connections from addresses. The configuration file is usually in /etc/mysql/my.cnf We need to bind-address comment out the line so it looks like this: - #bind-address = 127.0.0.1 + bind-address = 127....

Are you using MySQL's utf8 character set in your database ? In this article, I'll explain why you should switch to utf8mb4 , and how to do it. UTF-8 The UTF-8 encoding can represent every symbol in the Unicode character set, ranging from U+...

utf8mb4 Fortunately, MySQL 5.5.3 (released in early 2010) introduced a utf8mb4 new encoding called which maps to proper UTF-8 and thus fully supports Unicode, including astral symbols. Step 1: Create a backup Create a backup of all database...

Oracle's MySQL Operator for Kubernetes is a convenient way to automatically configure a MySQL database within a cluster. One of the key features of the Operator is the integrated automatic backup support for increased resiliency. The backup...

Backing up MySQL isn't hard—you just run mysqldump and output to a file —but it's also not really designed for a production environment. At first, running mysqldump took only a few seconds so everything being locked wasn't a big deal, b...

Kubernetes support for stateful applications has matured considerably over the past few years. It is now possible to co-locate your database within your cluster, allowing it to benefit from the same scalability as your other workloads. MySQ...