# DuckDB

## DuckDB

DuckDB is an in-process SQL OLAP database management system.

As an in-process database, DuckDB is easy to configure: specify the path to your DuckDB filename as the database name, e.g. `<PATH_TO_YOUR_DUCKDB_FILE>/duckdb`.

One thing to remember is about how DuckDB manages concurrency. The things to remember are summarized below:

* Only one process at a time can both read and write to the database.
* Multiple processes can read from the database, but no processes can write. To set this behavior, remember to specify in the connection’s options the property duckdb.read\_only = true

For details, please refer to [DuckDB Java API documentation](https://duckdb.org/docs/api/java).

| Option           | Info                                                                                |
| ---------------- | ----------------------------------------------------------------------------------- |
| Type             | Relational                                                                          |
| Driver           | [Driver Link](https://search.maven.org/artifact/org.duckdb/duckdb_jdbc/1.3.0.0/jar) |
| Version Included | 1.3.0.0                                                                             |
| Hop Dependencies | None                                                                                |
| Documentation    | <https://duckdb.org/docs/api/java.html>                                             |
| JDBC Url         | jdbc:duckdb: (in memory) or jdbc:duckdb:\<FILE\_PATH>                               |
| Driver folder    | \<Hop Installation>/lib/jdbc                                                        |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.primeur.com/data-shaper-1.21/knowing-the-data-shaper-designer/relational-database-connections/duckdb.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.