GooseDB

A feature-extended fork of DuckDB™ with server/client,
multi-session, and concurrent-write support using the PostgreSQL wire protocol
(DuckDB is a trademark of DuckDB Foundation)

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

Coming Soon
πŸͺΏ🔍⚡πŸ“Š

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.)

Coming Soon