index.html

---
layout: default
title: An in-process SQL OLAP database management system
subtitle: An In-Process Analytical Database
description: DuckDB is an in-process SQL OLAP database management system. Simple, feature-rich, fast & open source.
body_class: landing nowrap
---

<section class="welcome">
	<div class="flexwrap wrap">
		<div class="duckdb">
			<h1>DuckDB is a fast <br/><div class="type" data-strings="in-process|analytical|open-source|portable">|</div> <br/>database system</h1>
			<p>DuckDB supports a feature-rich SQL dialect complemented with deep integrations into client APIs.</p>
			<a class="button transparent arrow-down dark" href="#quickinstall">Installation</a>
			<a class="button yellow" href="/docs/">Documentation</a>
		</div>
		<div class="demo window">
			<div>
				<div class="topbar">
					<ul class="lang">
						<li data-language="sql" class="active">SQL</li>
						<li data-language="python">Python</li>
						<li data-language="r">R</li>
						<li data-language="java">Java</li>
						<li data-language="nodejs">Node.js</li>
					</ul>
				</div>
				<div class="content haslines">
					<div class="lines"></div>
						<div class="code dark">
{% highlight sql %}
{% include landing-page/sql/aggregation.sql %}
{% endhighlight -%}
						</div>
				</div>
				<div class="bottombar flexwrap">
					<div class="select">
						<select id="example-select">
							<option value="sql-aggregation-query">Aggregation query</option>
							<option value="sql-join-query">Join query</option>
							<option value="sql-csv-reader">Read remote CSV files</option>
							<option value="sql-parquet-reading-s3">Read remote Parquet files</option>
							<option value="sql-spatial-extension">Spatial extension</option>
						</select>
					</div>
					<a class="button arrow-right livedemo" href="https://shell.duckdb.org/#queries=v0,%20%20-Create-table-from-Parquet-file%0ACREATE-TABLE-train_services-AS%0A----FROM-'s3%3A%2F%2Fduckdb%20blobs%2Ftrain_services.parquet'~,%20%20-Get-the-top%203-busiest-train-stations%0ASELECT-station_name%2C-count(*)-AS-num_services%0AFROM-train_services%0AGROUP-BY-ALL%0AORDER-BY-num_services-DESC%0ALIMIT-3~">Live demo</a>
				</div>
			</div>
		</div>
	</div>
</section>


<section class="whyduckdb">
	<div class="wrap">
		<h1>DuckDB at a glance</h1>
		<div class="flexwrap">
			<div class="featurebox">
				<div class="icon simple"></div>
				<h3>Simple</h3>
				<p>DuckDB is easy to install and deploy. It has zero external dependencies and runs <nobr>in-process</nobr> in its host application or as a single binary.</p>
				<a href="why_duckdb#simple" class="textbutton arrow-right">Read more</a>
			</div>
			<div class="featurebox">
				<div class="icon portable"></div>
				<h3>Portable</h3>
				<p>DuckDB runs on Linux, macOS, Windows, and all popular hardware architectures. It has idiomatic client APIs for major programming languages.</p>
				<a href="why_duckdb#portable" class="textbutton arrow-right">Read more</a>
			</div>
			<div class="featurebox">
				<div class="icon featurerich"></div>
				<h3>Feature-rich</h3>
				<p>DuckDB offers a rich SQL dialect. It can read and write file formats such as CSV, Parquet, and JSON, to and from the local file system and remote endpoints such as S3 buckets.</p>
				<a href="why_duckdb#feature-rich" class="textbutton arrow-right">Read more</a>
			</div>
			<div class="featurebox">
				<div class="icon speed"></div>
				<h3>Fast</h3>
				<p>DuckDB runs analytical queries at blazing speed thanks to its columnar engine, which supports parallel execution and can process larger-than-memory workloads.</p>
				<a href="why_duckdb#fast" class="textbutton arrow-right">Read more</a>
			</div>
			<div class="featurebox">
				<div class="icon extensible"></div>
				<h3>Extensible</h3>
				<p>DuckDB is extensible by third-party features such as new data types, functions, file formats and new SQL syntax.</p>
				<a href="why_duckdb#extensible" class="textbutton arrow-right">Read more</a>
			</div>
			<div class="featurebox">
				<div class="icon free"></div>
				<h3>Free</h3>
				<p>DuckDB and its core extensions are <nobr>open-source</nobr> under the permissive MIT License.</p>
				<a href="why_duckdb#free" class="textbutton arrow-right">Read more</a>
			</div>
		</div>
	</div>
</section>

{% include quick_installation.html %}

<section class="blog">
	<div class="wrap">
		<h1>Blog</h1>
		<div class="newstileswrap">
			{% for post in site.posts limit:2 %}
				{% assign random_number = forloop.index | modulo: 3 | plus: 1 %}
				{% assign tag_classes = post.tags | join: ' ' | downcase | slugify %}
				<div class="postpreview {{ tag_classes }}" data-title="{{ post.title | escape }}">
					<div class="postimg custom">
						{% if post.thumb %}
							<img src="{{ post.thumb }}" alt="{{ post.title }}" class="zoom-image"/>
						{% else %}
							<img src="/images/blog/thumbs/placeholder-{{ random_number }}.svg" alt="Placeholder" class="zoom-image"/>
						{% endif %}
						<a href="{{ post.url }}" class="blocklink"></a>
					</div>
					<div class="postdetails">
						{% if post.tags %}
						<div class="tags">
							{% for tag in post.tags %}
								<span class="tag">{{ tag }}</span>
							{% endfor %}
						</div>
						{% endif %}
						<h3><a href="{{ post.url }}">{{ post.title }}</a></h3>
						<div class="meta">
							<div class="date">{{ post.date | date: "%Y-%m-%d" }}</div>
							<div class="author">{{ post.author | default: "Unknown Author" }}</div>
						</div>
					</div>
				</div>
			{% endfor %}
		</div>
		<a href="{{ site.url }}{{ site.baseurl }}/news" class="button transparent arrow-right">
			News Archive <span></span>
		</a>
	</div>
</section>

{% assign future_events = site.events | where_exp: "event", "event.date >= site.time" | sort: 'date' %}
{% if future_events.size > 0 %}
<section class="upcoming-events">
	<div class="wrap">
		<h1>Upcoming Events</h1>
		<div class="newstileswrap">
			{% for event in future_events limit:2 %}
				{% assign random_number = forloop.index | modulo: 3 | plus: 1 %} <!-- Generiert Werte von 1 bis 3 -->
				{% assign tag_classes = event.tags | join: ' ' %}
				<div class="eventpreview postpreview {{ tag_classes | downcase | slugify }}" data-title="{{ event.title | escape }}">
					<div class="postimg custom">
						{% if event.thumb %}
							<img src="{{ event.thumb }}" alt="{{ event.title }}" class="zoom-image">
						{% else %}
							<img src="/images/blog/thumbs/placeholder-{{ random_number }}.svg" alt="Placeholder" class="zoom-image">
						{% endif %}
						<a href="{{ event.url }}" class="blocklink"></a>
					</div>
					<div class="postdetails">
						{% if event.tags %}
						<div class="tags">
							<span class="eventdate">{{ event.date | date: "%Y-%m-%d" }}</span>
							{% for tag in event.tags %}
								<span class="tag">{{ tag }}</span>
							{% endfor %}
						</div>
						{% endif %}
						<h3><a href="{{ event.url }}">{{ event.title }}</a></h3>
						<div class="meta">
							<div class="venue">{{ event.venue | default: "Venue not specified" }}</div>
							<div class="author">{{ event.author | default: "DuckDB" }}</div>
						</div>
					</div>
				</div>
			{% endfor %}
		</div>
		<a href="/events" class="button transparent arrow-right">
			Events Archive <span></span>
		</a>
</section>
{% endif %}




<section class="hidden">
	
	
<div class="dropdown hero-demo">
	
<!-- example list for SQL -->	
<div data-language="sql">
	<option value="sql-aggregation-query">Aggregation query</option>
	<option value="sql-join-query">Join query</option>
	<option value="sql-csv-reader">Read CSV files</option>
	<option value="sql-parquet-reading-s3">Read Parquet files from S3</option>
	<option value="sql-spatial-extension">Spatial extension</option>
</div>

<!-- example list for Python -->	
<div data-language="python">
	<option value="python-sql-query">SQL query</option>
	<option value="python-pandas-integration">Pandas integration</option>
	<option value="python-udf">Custom UDFs</option>
</div>

<!-- specific example list for R -->	
<div data-language="r">
	<option value="r-sql-query">SQL query</option>
	<option value="r-dplyr-integration">dplyr integration</option>
</div>

<!-- specific example list for Java -->	
<div data-language="java">
	<option value="java-sql-query">SQL query</option>
	<option value="java-appender">Appender</option>
</div>

<!-- specific example list for Node.js -->	
<div data-language="nodejs">
	<option value="nodejs-sql-query">SQL query</option>
	<option value="nodejs-web-service-integration">Web service integration</option>
</div>

</div>
	
<div class="examples hero-demo">
	
<!-- ------------------- SQL ------------------- -->

<div data-language="sql" data-example="sql-aggregation-query" data-buttontxt="Live demo" data-buttonurl="https://shell.duckdb.org/#queries=v0,%20%20-Create-table-from-Parquet-file%0ACREATE-TABLE-train_services-AS%0A----FROM-'s3%3A%2F%2Fduckdb%20blobs%2Ftrain_services.parquet'~,%20%20-Get-the-top%203-busiest-train-stations%0ASELECT-station_name%2C-count(*)-AS-num_services%0AFROM-train_services%0AGROUP-BY-ALL%0AORDER-BY-num_services-DESC%0ALIMIT-3~">
{% highlight sql %}
{% include landing-page/sql/aggregation.sql %}
{% endhighlight %}
</div>

<div data-language="sql" data-example="sql-csv-reader" data-buttontxt="Live demo" data-buttonurl="https://shell.duckdb.org/#queries=v0,%20%20-Load-CSV-file%2C-auto%20detecting-column-name-and-types%0ACREATE-TABLE-stations-AS%0A----FROM-'s3%3A%2F%2Fduckdb%20blobs%2Fstations.csv'~,%20%20-Sample-10-stations-using-replacement-sample%0AFROM-stations-USING-SAMPLE-10~,%20%20-Compute-some-property-on-the-stations-table%0ASUMMARIZE-stations~">
{% highlight sql %}
{% include landing-page/sql/csv-loader.sql %}
{% endhighlight %}
</div>

<div data-language="sql" data-example="sql-parquet-reading-s3" data-buttontxt="Live demo" data-buttonurl="https://shell.duckdb.org/#queries=v0,%20%20-Directly-query-Parquet-file-in-S3%0ASELECT-station_name%2C-count(*)-AS-num_services%0AFROM-'s3%3A%2F%2Fduckdb%20blobs%2Ftrain_services.parquet'%0AGROUP-BY-ALL%0AORDER-BY-num_services-DESC%0ALIMIT-10~">
{% highlight sql %}
{% include landing-page/sql/s3-parquet.sql %}
{% endhighlight %}
</div>

<div data-language="sql" data-example="sql-join-query" data-buttontxt="Live demo" data-buttonurl="https://shell.duckdb.org/#queries=v0,CREATE-TABLE-stations-AS%0A----FROM-'s3%3A%2F%2Fduckdb%20blobs%2Fstations.parquet'~%0ACREATE-TABLE-distances-AS%0A----FROM-'s3%3A%2F%2Fduckdb%20blobs%2Fdistances.parquet'~%0A%0A%20%20-Find-the-top%203-longest-domestic-train-routes%0ASELECT-s1.name_short%2C-s2.name_short%2C-distances.distance%0AFROM-distances%0AJOIN-stations-s1-ON-distances.station1-%3D-s1.code%0AJOIN-stations-s2-ON-distances.station2-%3D-s2.code%0AWHERE-s1.country-%3D-s2.country%0A--AND-s1.code-%3C-s2.code%0AORDER-BY-distance-DESC%0ALIMIT-3~%0A">
{% highlight sql %}
{% include landing-page/sql/join.sql %}
{% endhighlight %}
</div>

<div data-language="sql" data-example="sql-spatial-extension" data-buttontxt="Live demo" data-buttonurl="https://shell.duckdb.org/#queries=v0,%20%20-Spatial-extension-for-geospatial-support%0AINSTALL-spatial~%0ALOAD-spatial~,CREATE-TABLE-stations-AS%0A----FROM-'s3%3A%2F%2Fduckdb%20blobs%2Fstations.parquet'~,%20%20-What-are-the-top%203-closest-Intercity-stations%0A%20%20-using-aerial-distance%3F%0ASELECT%0A----s1.name_long-AS-station1%2C%0A----s2.name_long-AS-station2%2C%0A----ST_Distance(%0A--------ST_Point(s1.geo_lng%2C-s1.geo_lat)%2C%0A--------ST_Point(s2.geo_lng%2C-s2.geo_lat)%0A----)-*-111139-AS-distance%0AFROM-stations-s1%2C-stations-s2%0AWHERE-s1.type-LIKE-'%25Intercity%25'%0A--AND-s2.type-LIKE-'%25Intercity%25'%0A--AND-s1.id-%3C-s2.id%0AORDER-BY-distance-ASC%0ALIMIT-3~">
{% highlight sql %}
{% include landing-page/sql/spatial-extension.sql %}
{% endhighlight %}
</div>

<!-- ------------------- Python -------------------- -->

<div data-language="python" data-example="python-sql-query" data-buttontxt="Python documentation" data-buttonurl="/docs/api/python/overview">
{% highlight python %}
{% include landing-page/python/sql-query.py %}
{% endhighlight %}
</div>

<div data-language="python" data-example="python-pandas-integration" data-buttontxt="Blog post" data-buttonurl="/2021/05/14/sql-on-pandas">
{% highlight python %}
{% include landing-page/python/pandas-integration.py %}
{% endhighlight %}
</div>

<div data-language="python" data-example="python-udf" data-buttontxt="Blog post" data-buttonurl="/2023/07/07/python-udf">
{% highlight python %}
{% include landing-page/python/udf.py %}
{% endhighlight %}
</div>

<!-- ------------------- R -------------------- -->

<div data-language="r" data-example="r-sql-query" data-buttontxt="R documentation" data-buttonurl="/docs/api/r">
{% highlight r %}
{% include landing-page/r/sql-query.r %}
{% endhighlight %}
</div>

<div data-language="r" data-example="r-dplyr-integration" data-buttontxt="R documentation" data-buttonurl="/docs/api/r">
{% highlight r %}
{% include landing-page/r/dplyr-integration.r %}
{% endhighlight %}
</div>

<!-- ------------------- Java -------------------- -->

<div data-language="java" data-example="java-sql-query" data-buttontxt="Java (JDBC) documentation" data-buttonurl="/docs/api/java">
{% highlight java %}
{% include landing-page/java/sql-query.java %}
{% endhighlight %}
</div>


<div data-language="java" data-example="java-appender" data-buttontxt="Java (JDBC) documentation" data-buttonurl="/docs/api/java">
{% highlight java %}
{% include landing-page/java/appender.java %}
{% endhighlight %}
</div>

<!-- ------------------- Node.js -------------------- -->

<div data-language="nodejs" data-example="nodejs-sql-query" data-buttontxt="Node.js documentation" data-buttonurl="/docs/api/nodejs/overview">
{% highlight javascript %}
{% include landing-page/nodejs/sql-query.js %}
{% endhighlight %}
</div>

<div data-language="nodejs" data-example="nodejs-web-service-integration" data-buttontxt="Node.js documentation" data-buttonurl="/docs/api/nodejs/overview">
{% highlight javascript %}
{% include landing-page/nodejs/web-service-integration.js %}
{% endhighlight %}
</div>

</div>
	
</section>