destan / multi-language-column

a sample repository for how to deal with multi language columns on Spring Boot with Postgres DB blog post

Multi Language Input Texts with Spring Boot and PostgreSQL

Table of Contents

• Getting Started
  • Setup a database

Implementing dynamic i18n support for user generated content.

Getting Started

Source code link is in the footer.

Setup a database

Tested with following database version on Ubuntu Ubuntu 18.04.2 LTS.

$ psql -V
psql (PostgreSQL) 10.7 (Ubuntu 10.7-0ubuntu0.18.04.1)

Creating a test database

$ sudo -u postgres createuser --interactive --pwprompt demouser
could not change directory to "/your/current/dir": Permission denied
Enter password for new role:
Enter it again:
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) n
Shall the new role be allowed to create more new roles? (y/n) n

$ sudo -u postgres createdb -O demouser demodb
could not change directory to "/your/current/dir": Permission denied

Note	You can safely ignore could not change directory to …​ messages. You can find the reason for it here.