Overview
QuestDB web Console query
The QuestDB web Console, served on port 80 through an authenticating nginx proxy, running a SQL query against the time series database.
QuestDB web Console query
QuestDB Console chart
QuestDB Console tables
This is a repackaged open source software product wherein additional charges apply for cloudimg support services.
Overview QuestDB is a fast, open source, columnar time series database built for high throughput ingestion and low latency SQL analytics. It speaks SQL with time series extensions, ingests data over the InfluxDB line protocol and the PostgreSQL wire protocol, and answers queries through a REST API and an interactive web Console. This image delivers the QuestDB open source core fully installed and configured as a system service, so a production grade time series database is running within minutes of launch.
Application Stack The QuestDB open source core installed under /opt/questdb with its bundled Java runtime and run by a dedicated unprivileged service account. The database root stored on a dedicated data disk so the time series store is independently resizable. A systemd service that starts the database in the foreground on boot and restarts it on failure. An nginx reverse proxy that publishes the web Console and the REST API on port 80 behind HTTP Basic authentication.
Time Series Database Ingest data at high throughput over the InfluxDB line protocol or the PostgreSQL wire protocol, then query it with SQL through the built in web Console, the REST API or any PostgreSQL client. QuestDB uses a columnar storage engine partitioned by time with SQL extensions for downsampling, interpolation and as of joins, so large datasets stay fast on modest hardware.
Secure First Boot On the first boot of your instance a one shot service generates a fresh admin password, unique to that instance, writes it into the nginx credentials file and writes the password to a root only file. The database itself binds to loopback only and is never exposed without authentication. No shared or default credentials ship in the image.
Ready To Use The web Console is served on port 80 through nginx. Sign in with the generated administrator credentials to run SQL queries, import data, build charts and inspect tables. Point your InfluxDB line protocol writers, PostgreSQL clients or REST API integrations at the instance using the same credentials.
cloudimg Support 24/7 technical support by email and chat. Help with deployment, ingestion protocol configuration, schema and partitioning design, SQL queries, PostgreSQL and InfluxDB integration, TLS and storage tuning.
Use Cases Application and infrastructure metrics. Financial market and tick data. IoT and sensor telemetry. Real time analytics dashboards. A fast SQL backend for time series workloads and a cost effective alternative to hosted time series services.
All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.
Highlights
- QuestDB open source time series database preinstalled as a systemd service with the web Console and SQL REST API published on port 80 behind an authenticating nginx proxy, no manual setup required
- Ingests the InfluxDB line protocol and the PostgreSQL wire protocol and answers SQL queries with time series extensions, with the database root on a dedicated independently resizable data disk
- Hardened first boot generates a fresh admin password for every instance and stores it in a file only the root user can read, with 24/7 technical support from cloudimg
Details
Introducing multi-product solutions
You can now purchase comprehensive solutions tailored to use cases and industries.
Features and programs
Financing for AWS Marketplace purchases
Pricing
Free trial
- ...
Dimension | Description | Cost/hour |
|---|---|---|
m6i.large Recommended | m6i.large | $0.08 |
t2.micro | t2.micro instance type | $0.04 |
t3.micro | t3.micro instance type | $0.04 |
r6idn.xlarge | r6idn.xlarge instance type | $0.12 |
c6id.32xlarge | c6id.32xlarge instance type | $0.24 |
c5a.xlarge | c5a.xlarge instance type | $0.12 |
m5a.4xlarge | m5a.4xlarge instance type | $0.24 |
c8i.16xlarge | c8i.16xlarge instance type | $0.24 |
c5ad.8xlarge | c5ad.8xlarge instance type | $0.24 |
c7i.large | c7i.large instance type | $0.08 |
Vendor refund policy
Refunds available on request.
How can we make this page better?
Legal
Vendor terms and conditions
Content disclaimer
Delivery details
64-bit (x86) Amazon Machine Image (AMI)
Amazon Machine Image (AMI)
An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.
Version release notes
Initial release of QuestDB 9.4.3 open source time series database.
Additional details
Usage instructions
Connect via SSH on port 22 as the default login user for your operating system variant (the user guide lists it per variant). The web Console is served on port 80: browse to http://<instance-public-ip>/ and sign in with user admin and the generated password. Retrieve the credentials with: sudo cat /root/questdb-credentials.txt. The SQL REST API (/exec, /imp, /exp) is served on the same port 80 behind the same HTTP Basic credentials. The PostgreSQL wire protocol (port 8812) and the InfluxDB line protocol (port 9009) bind to loopback only by default; the user guide shows how to expose them when required. The QuestDB database root lives on a dedicated data disk mounted at /var/lib/questdb.
Resources
Vendor resources
Support
Vendor support
cloudimg provides 24/7 technical support for this product by email and live chat. Our engineers help with deployment, configuration, updates, performance tuning and troubleshooting; critical issues receive a one hour average response. Contact support@cloudimg.co.uk .
AWS infrastructure support
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.
Similar products

