Video coming soon…

🗄️ Setup QuestDB — Time-Series Database with SQL

Deploy QuestDB on Ubuntu with Docker — a fast time-series database you query with plain SQL, exposing a web console on 9008, PostgreSQL wire on 8812, and high-speed ILP ingest on 9011.

⚠️ This script is provided for demo and testing purposes only. Not intended for production use.

📦 Resources & Setup Scripts

Grab the automated bash script from GitHub to follow along with the video.

Automated install script — one command deploys QuestDB with its console, PGWire, and ILP ingest endpoints.
View on GitHub

Quick Install:

wget https://raw.githubusercontent.com/mhmdali94/Docker/main/databases/questdb/questdb-ubuntu.sh
chmod +x questdb-ubuntu.sh
sudo bash questdb-ubuntu.sh

Tutorial Steps

1 Download the Script

wget https://raw.githubusercontent.com/mhmdali94/Docker/main/databases/questdb/questdb-ubuntu.sh

2 Make it Executable

chmod +x questdb-ubuntu.sh

3 Run the Installer

The script installs Docker if needed, starts questdb/questdb:latest with data persisted to ./data:/var/lib/questdb, then polls port 9008 until the console answers.

sudo bash questdb-ubuntu.sh

4 Open the Web Console

Browse to the console and run your first query — no login is required on the console itself:

http://<your-server-ip>:9008

Ports Used

PortPurpose
9008Web console (host → container 9000) — no authentication
8812PostgreSQL wire protocol — default credentials admin/quest
9011InfluxDB Line Protocol ingest (host → container 9009) — unauthenticated

Overview

Why Use It

When You Need It

    Who Should Use It

      Real Use Cases

        Main Features

          How to Use After Installation

            Security Best Practices

              Ports and Firewall Notes

              Backup and Maintenance

                Common Mistakes

                  Troubleshooting

                    Alternatives

                    When Not to Use It

                    PrismaTechWork Professional Help

                      Contact Us

                      Frequently Asked Questions