PostgreSQL

Linux Server
1

データ型としてJSONフォーマットを標準サポートしているため導入

GitHub DockerHub Image

https://hub.docker.com/_/postgres

参考）MariaDBとの相違点

管理アプリ：pgAdmin

#
# Setup the repository
#

# Install the public key for the repository (if not done previously):
$ curl -fsS https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /usr/share/keyrings/packages-pgadmin-org.gpg

# Create the repository configuration file:
$ sudo sh -c 'echo "deb [signed-by=/usr/share/keyrings/packages-pgadmin-org.gpg] https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

#
# Install pgAdmin
#

# Install for both desktop and web modes:
$ sudo apt install pgadmin4

# Install for desktop mode only:
$ sudo apt install pgadmin4-desktop

# Install for web mode only: 
$ sudo apt install pgadmin4-web 

# Configure the webserver, if you installed pgadmin4-web:
$ sudo /usr/pgadmin4/bin/setup-web.sh
2

pgAdmin クエリ実行

テーブルposts.translationsのcontent内のurlを置換え

Screenshot from 2024-03-31 16-30-32
Screenshot from 2024-03-31 16-30-321295×836 95.7 KB

UPDATE public.posts_translations
SET content = REPLACE(content, 'http://localhost:8055', 'https://api.ficusonline.com')
WHERE content LIKE '%http://localhost:8055%';