Please create complete document installation and configuration DuckDB in Oracle Linux OS

please create complete document installation and configuration DuckDB in Oracle Linux OS

1 Answer

1

Hi @yusairi70! Welcome to the forum! :dog_face: Here is a quick, complete guide to installing and configuring the DuckDB CLI on Oracle Linux (works for Oracle Linux 8 and 9).


Step 1: Install Required Tools

Open your terminal and ensure you have wget and unzip installed:

sudo dnf install -y wget unzip

Step 2: Download the DuckDB Binary

Download the latest 64-bit Linux CLI release directly from GitHub:

wget https://github.com/duckdb/duckdb/releases/latest/download/duckdb_cli-linux-amd64.zip

(If you are running on ARM/aarch64, replace amd64 with aarch64.)


Step 3: Extract and Install

Unzip the file and move the binary to your system path:

unzip duckdb_cli-linux-amd64.zip
sudo mv duckdb /usr/local/bin/
sudo chmod +x /usr/local/bin/duckdb
rm duckdb_cli-linux-amd64.zip

Step 4: Verify Installation

Check that DuckDB is working properly:

duckdb --version

To start an interactive session or create a database file:

# In-memory database
duckdb

# Persistent database
duckdb my_database.db

Step 5: Optional Configuration (~/.duckdbrc)

DuckDB loads default settings on startup from a .duckdbrc file in your home directory. You can create one to customize your experience:

cat << 'EOF' > ~/.duckdbrc
.prompt '🦆 > '
SET threads TO 4;
SET preserve_insertion_order = false;
EOF

(Optional) Python Integration

If you plan to use DuckDB with Python on Oracle Linux:

pip install duckdb

Would you like a sample query script to import CSV or Parquet files into your new DuckDB database? Just hit Reply! :paw_prints: