theglobalsolutions

DuckDB Powered by GlobalSolutions

DuckDB

Powered by GS

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

DuckDB has no external dependencies, neither for compilation nor during run-time.DuckDB offers a flexible extension mechanism that allows defining new data types, functions, file formats and new SQL syntax. DuckDB can easily pull in files from blob storage, S3, and Azure blob storage without much effort.

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 made sure the image is hardened so it 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.

How to Access our AMIs from AWS Marketplace

Subscribe to our AMI from the AWS marketplace.
Login to the server following the below steps,
- ssh to the box using the following command, ssh -i yourpemfile.pem ubuntu@public IP of your server
- Once you are logged in you will land in the home directory
- From here you can run the duckdb command to create a database or do all the compute in the memory

Installation Location

Category	Packages	Version Used	Location
DuckDB	DuckDB	0.10.2	usr/local/bin/

Getting Started -

The DuckDB offering of GlobalSolutions comes prepackaged with all the dependent components for DuckDB. All the user has to do is subscribe to our AMI to start using it.

As soon as you ssh into the server everything will be ready for you. Follow the below steps to start working with DuckDB

Once you ssh you will be in the home directory
Over here type in "sudo duckdb your-database-name.db" (Replace "your-database-name" with your preferred database name)
The above step will create a database and you can start creating tables and ingesting data for fast querying and analytics work.
If you don't provide any database names the content will be processed on the memory.
We have created a Database by the name sample1.db and you can query them when you start the duckdb as a root user (sudo duckdb)

Support

Please contact us at support@theglobalsolutions.net for any questions on this offering in AWS Marketplace.

copyright - © 2016,The Globalsolutions LLC. or its affiliates. All rights reserved.

>