DuckDB

An analytical in-process SQL database management system.

Start DuckDB

Open an in-memory database:

duckdb

Or open/create a persistent database file:

duckdb my_database.duckdb

Common Commands

Hilfe anzeigen:

duckdb -help

Version überprüfen:

duckdb -version

Example Workflow

# Start DuckDB with a persistent database
duckdb analytics.duckdb

# Inside DuckDB shell
CREATE TABLE users(id INTEGER, name VARCHAR);
INSERT INTO users VALUES (1, 'Alice');

SELECT * FROM users;

Anwendungsdetails