Docker based: Cloud Beaver CE (Community Edition) for Managing Databases

CloudBeaver is an open-source, web-based version of DBeaver, a popular database management tool. CloudBeaver allows you to manage databases directly through your web browser, without needing to install a desktop application. It is essentially a cloud version of DBeaver that provides many of the same features but is designed for easy access and use in a cloud environment or over the web.

Key Features of CloudBeaver:

1. Web-based Interface: Unlike DBeaver, which is a desktop application, CloudBeaver is accessed via a web browser. This makes it ideal for managing databases remotely or in a cloud-based infrastructure.
2. Cross-Platform Support: Since CloudBeaver runs in a browser, it works on any platform that supports modern web browsers (Linux, macOS, Windows, etc.) without the need to install specific software.
3. Database Management: Like DBeaver, CloudBeaver supports a wide variety of databases, including:

• MySQL
• PostgreSQL
• MariaDB
• Oracle
• SQL Server
• SQLite
• MongoDB
• and many others.

1. SQL Editor: CloudBeaver includes a SQL editor with features like syntax highlighting, auto-completion, and query execution, making it easier to interact with databases.
2. Database Browsing: It allows you to browse database schemas, tables, views, and even run SQL queries or scripts directly from the web interface.
3. User Management: CloudBeaver supports multi-user access, allowing you to define roles and manage access to databases and features. This is especially useful in collaborative and team environments.
4. Docker and Kubernetes Integration: CloudBeaver can be deployed using Docker and Kubernetes, which is great for scaling and running in cloud environments.
5. Extensibility: CloudBeaver is modular and can be extended with plugins. This allows you to add additional features as needed.
6. Secure Access: CloudBeaver supports user authentication mechanisms, including OAuth2, making it secure for accessing databases over the web.

Use Cases:

• Remote Database Administration: CloudBeaver is ideal for database administrators and developers who need to manage databases remotely without installing desktop applications.
• Team Collaboration: It can be used by teams to collaborate on database queries, management, and data analysis.
• Cloud Environments: It is particularly useful in cloud environments where databases are hosted in the cloud and can be accessed via a web browser.

How to Use CloudBeaver:

• Self-hosting: You can deploy CloudBeaver on your own server using Docker or Kubernetes.
• Cloud Hosting: CloudBeaver can be hosted on cloud platforms like AWS, Google Cloud, or any provider that supports Docker-based containers.
• CloudBeaver Online: There are instances of CloudBeaver provided by the developers or third parties that you can access directly from the web without having to install anything.

Must Have:

• docker: https://blog.aplikasi-pintar.id/installing-docker-on-ubuntu-machine/
• docker-compose: https://blog.aplikasi-pintar.id/installing-docker-compose/

create .env

APP_NAME=cloudbeaver
APP_VERSION=latest
APP_HTTP_PORT=9090
APP_NETWORK=websoft9

create docker-compose.yaml

# image: https://hub.docker.com/r/dbeaver/cloudbeaver
# config docs: https://github.com/dbeaver/cloudbeaver/wiki/Server-configuration#automatic-server-configuration

services:
  cloudbeaver:
      image: dbeaver/cloudbeaver:${APP_VERSION}
      container_name: "${APP_NAME}"
      restart: always
      ports:
       - '$APP_HTTP_PORT:8978'
      volumes: 
       - cloudbeaver:/opt/cloudbeaver/workspace            

networks:
  default:
    name: ${APP_NETWORK}
    external: true

volumes:
  cloudbeaver:

Create network

docker network create websoft9

Build Container

docker-compose up -d --build

Setup Password

• access localhost:9090
• setup your password: anythingEls#!

After that, login and add new connection

Create New Connection:

Reference to this post: https://github.com/dbeaver/cloudbeaver/wiki/Run-Docker-Container