DuckDB Powered by GlobalSolutions

DuckDB is a relational (table-oriented) DBMS that supports the Structured Query Language (SQL). It runs on a columnar-vectorized query engine, which makes efficient use of the CPU cache and speeds up response times for analytical query workloads. DuckDB fills the need for an embedded database solution for analytical processing and enables users to run complex SQL queries with APIs available for Java, C, C++, and more.

DuckDB has no external dependencies, neither for compilation nor at runtime. It offers a flexible extension mechanism that allows defining new data types, functions, file formats, and SQL syntax. DuckDB can easily pull in files from blob storage, S3, and Azure Blob Storage with minimal configuration.

DBeaver is a powerful and popular desktop SQL editor and integrated development environment (IDE). It is useful for visually inspecting the available tables in DuckDB and for quickly building complex queries.

We have ensured the image is hardened to be secured from all existing vulnerabilities.

Why Subscribe to Our Offering in AWS Marketplace

We update the software constantly to the latest version to address security issues.
Customers can kick-start their core work right away with our pre-packaged AMIs.
Production-ready application stacks.

Accessing Your AMI from AWS Marketplace

To get started with your DuckDB stack:

Subscribe: Purchase the DuckDB AMI from the AWS Marketplace.
Connect via SSH:
- SSH into the instance using the following command:
```
ssh -i yourpemfile.pem ubuntu@<public-ip-of-your-server>
```
- Once logged in you will land in the home directory.
- From here you can run the duckdb command to create a database or process data entirely in memory.

For more information, refer to the AWS Instance Connection Guide.

Installation Paths and Versions

DuckDB is installed in the following location for easy access:

Category	Packages	Version	Location
DuckDB	DuckDB	1.4.4	`/home/ubuntu/.duckdb/cli/1.4.4`

Getting Started with DuckDB

The DuckDB offering from GlobalSolutions comes pre-packaged with all dependent components. All you have to do is subscribe to our AMI — as soon as you SSH into the server everything will be ready to use.

Running DuckDB from the Command Line

Follow these steps to start working with DuckDB:

Once you SSH in, you will be in the home directory.
Navigate to the DuckDB installation directory:
```
cd /home/ubuntu/.duckdb/cli/1.4.4/
```
Run the following command to create a database (replace your-database-name with your preferred name):
```
./duckdb your-database-name.db
```
This will create a database and you can start creating tables and ingesting data for fast querying and analytics.
If you do not provide a database name, all content will be processed in memory.

Accessing DuckDB via DBeaver

Launch DBeaver on your desktop to visually inspect tables and build complex queries against your DuckDB databases.
Connect DBeaver to your .db file by selecting DuckDB as the database type and pointing it to your database file path.

Tip: Use DBeaver as a desktop SQL editor to visually inspect tables and build complex queries against your DuckDB databases with ease.

AWS Cost Optimizer — CloudInsider

Our other popular offering is the AWS Cost Optimizer aka CloudInsider, available in AWS Marketplace. This service has helped our customers save significantly on AWS and other cloud spending. It is easy to subscribe and you can see the savings in minutes.

▶ Watch Demo Video Subscribe on AWS Marketplace

Support

For any questions or assistance with our AWS Marketplace offering, reach out to us at support@theglobalsolutions.net.