DEV Community: a gorde

Build Your Own Cloud Database in Minutes

a gorde — Tue, 24 Mar 2026 18:38:06 +0000

This is a step-by-step guide for making a private cloud database for your projects for start you just need a cloud server

usecase:

perfect for personal project, centralized database
full control

A. Install PostgreSQL on VM

Im using OVH Cloud as a VM with ubuntu.

# Update the package list to get info on the newest versions of packages
$ sudo apt update

# Install PostgreSQL database server and additional utilities/extensions
$ sudo apt install -y postgresql postgresql-contrib

# Start the PostgreSQL service immediately
$ sudo systemctl start postgresql

# Enable PostgreSQL to start automatically on every system boot
$ sudo systemctl enable postgresql

B. Create a database and user

1- Start PostgreSQL 17

# Start the PostgreSQL cluster (version 17, cluster name "main")
$ sudo pg_ctlcluster 17 main start

# List all PostgreSQL clusters with their version, name, port, status, and data directory
$ sudo pg_lsclusters

Ref Screenshot

2- Create DB and user

# Creating database and setting user
$ sudo -u postgres psql
CREATE DATABASE twohype;
CREATE USER twohype_user WITH PASSWORD 'yourpassword';
GRANT ALL PRIVILEGES ON DATABASE twohype TO twohype_user;
\q

3.1- Allow remote connections

# Open the main PostgreSQL 17 configuration file in the nano text editor
# Find and enable; listen_addresses = '*'

$ sudo nano /etc/postgresql/17/main/postgresql.conf

3.2- Allow remote connections

# Open the host-based configuration file
$ sudo nano /etc/postgresql/17/main/pg_hba.conf

# Add at the bottom:
host    all             all             0.0.0.0/0               md5

Ref Screenshot

4- Restart and open firewall

# Restart the PostgreSQL service
$ sudo systemctl restart postgresql@17-main

# Allow incoming TCP traffic on port 5432
$ sudo ufw allow 5432/tcp

Note: if your not with root user you might have to enable rule from your VM console

Voilà! You've just got your personal cloud-based database, which you can use anywhere with
DATABASE_URL="postgresql://twohype_user:yourpassword@YOUR_VM_IP:5432/twohype"

oops

a gorde — Tue, 17 Feb 2026 14:37:05 +0000

No this is OOPS concepts;

1) Abstraction
abstraction hiding implementations details and only showing functionality.

interface one{
     void start();
     // Focus on “what” not “how”
}

2) Encapsulation
a wrapper which creates the object of the class with private variables but public getters/setters.

class Student {
    private int age;

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }
}

3) Polymorphism
Two Types

1 compile time (it overloads the methods)

int add(int a, int b)
double add(double a, double b)

2 runtime (it overriders the method)

class Animal {
    void sound() {
        System.out.println("Barking")}
}

class Dog extends Animal {
    void sound() {
        System.out.println("Bark");
    }
}

4) Inheritance
easy its just in the word it inherit...Hierarchy

class Animal {
    void eat() {}
}

class Dog extends Animal {
    void bark() {}
}

Java Concepts #1 (Java8, Mircro-services, String)

a gorde — Mon, 16 Feb 2026 12:47:05 +0000

About me

In my previous company, I worked on multiple phases of product lifecycle. I worked on database migration from DB2 to Oracle for a banking client, then contributed to building a microservices-based service manager integrated with RabbitMQ, and also handled maintenance and bug fixes for legacy JSP applications.

Java 8

It felt like a big leap forward. Java 1.8 was stacked and released for improved code readability, reduced boilerplate, and enhanced performance.

some of the features was

Streams API a game changer for clean, realizable code and whole boilerplate reduction.
Lambda expression are basically short, inline way of writing functions.
Default and Static Methods in Interfaces aka Functional Interfaces to support Lambda expression.

Where I've used it? I've benefited from lambdas when working with collection like filtering a list of transactions in one line instead of writing loops.

and yes some additional changes were;

New Date and Time API
Method References
Optional Class

Microservice architecture

micro - small & service - logic
consider small logics are together combining to make one application. Suppose this as building a factory where every function working separately and support each others work inside, for example packing department as one microservice and Quality Control department as a another together they are can we called as factory or an application.

how do you handle inter-service communication ?

classic question but you need to understand what does it takes, Inter-service comms can be handled in two main ways; Asynchronous and Synchronous

Strings

Remember as immutable: String is immutable, means onces an object is created, its value cannot be changed. Any modification creates a new object in memory.

String str = "Hello readers";
String str1 = "Hello readers";
String str2 = new String("Hello readers"); // creates new object

sout(str == Str1) // true
sout(str == strs2) // false

Before Java 7 String was stored in the PermGen space.
PermGen (Permanent Generation) is a special heap space separated from the main heap memory.

Reasons being:

PermGen had a fixed size
Poor tuning and management
Not Designed for GC's
Memory fragmentation

While the entire PermGen was removed completely in java 8 and replaced with MetaSpace for better scalability, performance, and easier management.

While String begin immutable,
StringBuilder and StringBuffer are mutable, means their content can be modified without creating a new object.