GooseDB - An enhanced DuckDB with a server/client architecture

Core Features

🐘

PostgreSQL Protocol Support

Native PostgreSQL wire protocol implementation enables seamless integration with existing PostgreSQL tools and clients.

📡

Client/Server Architecture

True client/server capabilities with network transparency and connection pooling support.

🧑🏻‍🤝‍🧑🏻

Concurrent Operations

Multi-session support with concurrent write operations, maintaining DuckDB's exceptional performance.

PostgreSQL Compatibility

Protocol Features

• Full wire protocol compatibility
• Support for prepared statements
• Extended query protocol
• Built-in connection pooling functionality
• SSL/TLS encryption via Pgbouncer

Program Compatibility List

• CLI & GUI Clients: psql, DBeaver, pgAdmin (partial support)
• Visualization Tools: Grafana, Apache Superset
• Connection Poolers: PgBouncer, PgCat
• Drivers: PostgreSQL JDBC, jackc/pgx (Go), psycopg2 / psycopg3 (Python)

Quick Start

Server Setup

$./goosedb_release start

{"level":"info","msg":"MaxConnections = 10"}
{"level":"info","msg":"DuckDB !!read_write!! Mode)"}
{"level":"info","msg":"GooseDB v1.2.2.2 (DuckDB v1.2.2)"} {"level":"info","msg":"goosedb listening on 0.0.0.0:1234"} ...

Client Connection

$ psql -h localhost -p 1234 -U gooseadmin -d goosedb

goosedb=> show version;
-----------------------------------------------
GooseDB Standalone v1.2.2.2 (DuckDB v1.2.2)
(1 row)

Why GooseDB?

Drop-in Replacement

Use existing PostgreSQL tools and clients without modification. Seamless integration with your current workflow.

DuckDB Performance

Maintains DuckDB's exceptional analytical query performance while adding client/server capabilities.

Modern Architecture

Built for modern data workflows with concurrent write support and multi-session capabilities.

GooseDB Product Family

🪿🆓

GooseDB Freeware

• Non-Commercial Use Only

• Maximum concurrent connections: 10

• Community support

🪿🚀

GooseDB Standalone

• Commercial Version

• Single-node deployment

• Full enterprise features

🪿🔍⚡📊

GooseDB Lakehouse

• Self-hosted alternatives to AWS Athena and Redshift

• Cluster architecture

• Horizontal scaling

• Decoupled compute and storage layers

• Includes GooseDB Standalone version

(AWS™ is a registered trademark of Amazon.com, Inc. or its affiliates.)