# \#duckdb

**URL:** https://discourse.julialang.org/tag/duckdb/1256.md

[Latest](https://discourse.julialang.org/latest.md) · [Categories](https://discourse.julialang.org/categories.md) · [Tags](https://discourse.julialang.org/tags.md)

---

## [Table disappearing from duckdb database?](https://discourse.julialang.org/t/table-disappearing-from-duckdb-database/130172)

<div class="topic-metadata">

**Author:** [@floswald](https://discourse.julialang.org/u/floswald)\
**Replies:** 2\
**Last updated:** [June 25, 2025, 9:31am UTC](https://discourse.julialang.org/t/table-disappearing-from-duckdb-database/130172 "2025-06-25T09:31:11Z")

</div>

I have an esoteric bug. I see this: # persistent database backed by file. function with\_db(f::Function) con = DBInterface.connect(DuckDB.DB, \_DB\_PATH) try return f(con) finally DBInterface.cl…

---

## [Problem loading ducklake extension](https://discourse.julialang.org/t/problem-loading-ducklake-extension/130154)

<div class="topic-metadata">

**Author:** [@kobusherbst](https://discourse.julialang.org/u/kobusherbst)\
**Replies:** 1\
**Last updated:** [June 24, 2025, 5:24am UTC](https://discourse.julialang.org/t/problem-loading-ducklake-extension/130154 "2025-06-24T05:24:28Z")

</div>

When trying to load the ducklake extension in DuckDB v1.3.1 I get the following error: ERROR: Execute of query "LOAD ducklake;" failed: HTTP Error: Failed to download extension "ducklake" at URL "http://extensions.duckd…

---

## [DuckDB, FunSQL.jl, reading data](https://discourse.julialang.org/t/duckdb-funsql-jl-reading-data/127119)

<div class="topic-metadata">

**Author:** [@jerlich](https://discourse.julialang.org/u/jerlich)\
**Replies:** 0\
**Last updated:** [March 18, 2025, 9:20pm UTC](https://discourse.julialang.org/t/duckdb-funsql-jl-reading-data/127119 "2025-03-18T21:20:34Z")

</div>

Expanding Man Wednesday at 2:27 PM using DuckDB to interact with files, granting full query ability for files, really is great. The only thing that sucks about it is having to deal with SQL. I’m increasingly tempted to …

---

## [Supporting appending \`Vector\` in DuckDB](https://discourse.julialang.org/t/supporting-appending-vector-in-duckdb/126511)

<div class="topic-metadata">

**Author:** [@slwu89](https://discourse.julialang.org/u/slwu89)\
**Replies:** 2\
**Last updated:** [March 11, 2025, 11:06pm UTC](https://discourse.julialang.org/t/supporting-appending-vector-in-duckdb/126511 "2025-03-11T23:06:55Z")

</div>

Hi all, following up from How to insert nested/composite types into DuckDB from a DataFrame? - #3 by slwu89 I’m peeking into what it would take to support inserting, say Vector{Int} into a DuckDB database using the appen…

---

## [How to insert nested/composite types into DuckDB from a DataFrame?](https://discourse.julialang.org/t/how-to-insert-nested-composite-types-into-duckdb-from-a-dataframe/126440)

<div class="topic-metadata">

**Author:** [@slwu89](https://discourse.julialang.org/u/slwu89)\
**Replies:** 2\
**Last updated:** [March 3, 2025, 7:01pm UTC](https://discourse.julialang.org/t/how-to-insert-nested-composite-types-into-duckdb-from-a-dataframe/126440 "2025-03-03T19:01:04Z")

</div>

Hi all, it seems DuckDB can support composite types as in Redirecting… I want to know how to insert into columns with one of these types from a DataFrame. I’ve tried the Appender API and directly using prepared statemen…

---

## [How do I properly close a DuckDb database?](https://discourse.julialang.org/t/how-do-i-properly-close-a-duckdb-database/100598)

<div class="topic-metadata">

**Author:** [@kobusherbst](https://discourse.julialang.org/u/kobusherbst)\
**Replies:** 20\
**Last updated:** [February 21, 2025, 1:44am UTC](https://discourse.julialang.org/t/how-do-i-properly-close-a-duckdb-database/100598 "2025-02-21T01:44:28Z")

</div>

I cannot run the following code twice in one julia session: using DuckDB using DBInterface db = DuckDB.DB("C:\\\\Temp\\\\test.duckdb") t = DBInterface.execute(db, "SELECT 1") DuckDB.close\_database(db) On the second run …

---

## [DuckDB load problem](https://discourse.julialang.org/t/duckdb-load-problem/124467)

<div class="topic-metadata">

**Author:** [@kobusherbst](https://discourse.julialang.org/u/kobusherbst)\
**Replies:** 3\
**Last updated:** [January 7, 2025, 11:01am UTC](https://discourse.julialang.org/t/duckdb-load-problem/124467 "2025-01-07T11:01:33Z")

</div>

I created a new project, with just DuckDB and DBInterface packages. When executing the following code: using DuckDB # create a new in-memory database con = DBInterface.connect(DuckDB.DB, ":memory:") fails with the fol…

---

## [Very Slow \`DBInterface.execute\` on large duckdb relative to R](https://discourse.julialang.org/t/very-slow-dbinterface-execute-on-large-duckdb-relative-to-r/121984)

<div class="topic-metadata">

**Author:** [@floswald](https://discourse.julialang.org/u/floswald)\
**Replies:** 4\
**Last updated:** [October 30, 2024, 9:11pm UTC](https://discourse.julialang.org/t/very-slow-dbinterface-execute-on-large-duckdb-relative-to-r/121984 "2024-10-30T21:11:59Z")

</div>

Hi all, I’ve made a clone of @grantmcdermott 's nice workshop on duckdb and polars - adding a chapter on julia and duckdb. He had pointed out some very slow julia timings in his slides, and actually created an issue on …

---

## [Cannot install FTS extension in DuckDB](https://discourse.julialang.org/t/cannot-install-fts-extension-in-duckdb/117996)

<div class="topic-metadata">

**Author:** [@TimG](https://discourse.julialang.org/u/TimG)\
**Replies:** 28\
**Last updated:** [September 8, 2024, 11:25am UTC](https://discourse.julialang.org/t/cannot-install-fts-extension-in-duckdb/117996 "2024-09-08T11:25:06Z")

</div>

I cannot install the fts extension in DuckDB. The docs say it should auto-install, but it reports that it fails. I have also tried to install manually using DBInterface.execute(con, "INSTALL fts FROM 'http://extensi…

---

## [Fts extension in DuckDB doesn't work](https://discourse.julialang.org/t/fts-extension-in-duckdb-doesnt-work/118125)

<div class="topic-metadata">

**Author:** [@TimG](https://discourse.julialang.org/u/TimG)\
**Replies:** 4\
**Last updated:** [August 13, 2024, 11:28am UTC](https://discourse.julialang.org/t/fts-extension-in-duckdb-doesnt-work/118125 "2024-08-13T11:28:40Z")

</div>

The fts extension in DuckDB is finally installed on my windows machine after much appreciated help. The first thing I need to do to use this extension is create an fts index. Following the docs for this extension, I tr…

---

## [Calling database functions when using Octo.jl](https://discourse.julialang.org/t/calling-database-functions-when-using-octo-jl/114044)

<div class="topic-metadata">

**Author:** [@suvayu](https://discourse.julialang.org/u/suvayu)\
**Replies:** 5\
**Last updated:** [June 13, 2024, 7:18pm UTC](https://discourse.julialang.org/t/calling-database-functions-when-using-octo-jl/114044 "2024-06-13T19:18:14Z")

</div>

I’m trying out Octo.jl with DuckDB. I managed to connect to an existing file and query a table there. julia\> import DataFrames as DF; julia\> using Octo.Adapters.DuckDB julia\> con = Repo.connect(adapter=Octo.Adapters.D…

---

## [Why Is There a Significant Slow-down with DuckDB.jl Bridging?](https://discourse.julialang.org/t/why-is-there-a-significant-slow-down-with-duckdb-jl-bridging/109426)

<div class="topic-metadata">

**Author:** [@TheCedarPrince](https://discourse.julialang.org/u/TheCedarPrince)\
**Replies:** 1\
**Last updated:** [January 30, 2024, 11:25pm UTC](https://discourse.julialang.org/t/why-is-there-a-significant-slow-down-with-duckdb-jl-bridging/109426 "2024-01-30T23:25:30Z")

</div>

I did an interesting little exploration with DuckDB.jl + bridging to another local database of a different SQL flavor today (SQLite). Here’s what I did: using BenchmarkTools using DBInterface using DuckDB using HealthSa…

---

## [Allow \`CategoricalArray\` when registering a \`DataFrame\` as \`ENUM\` in DuckDB](https://discourse.julialang.org/t/allow-categoricalarray-when-registering-a-dataframe-as-enum-in-duckdb/107365)

<div class="topic-metadata">

**Author:** [@danielw2904](https://discourse.julialang.org/u/danielw2904)\
**Replies:** 0\
**Last updated:** [December 9, 2023, 5:15pm UTC](https://discourse.julialang.org/t/allow-categoricalarray-when-registering-a-dataframe-as-enum-in-duckdb/107365 "2023-12-09T17:15:40Z")

</div>

Currently CategoricalArrays are not supported in DuckDB but I think it would be a good idea to do so. I have started a discussion on their Github repo. Would it be possible to add this using the new optional dependencies…

---

## [Write a table into SQLite and DuckDB in efficient manner](https://discourse.julialang.org/t/write-a-table-into-sqlite-and-duckdb-in-efficient-manner/93417)

<div class="topic-metadata">

**Author:** [@sairus7](https://discourse.julialang.org/u/sairus7)\
**Replies:** 24\
**Last updated:** [December 8, 2023, 3:25am UTC](https://discourse.julialang.org/t/write-a-table-into-sqlite-and-duckdb-in-efficient-manner/93417 "2023-12-08T03:25:25Z")

</div>

How can I efficiently populate DB table from very long tables (say, millions rows)? I try to compare SQlite vs DuckDB in this scenario, but I think I’m doing this very inefficiently: using SQLite, DuckDB, Tables con\_sq…

---

## [How to share a duckdb database connection to many functions](https://discourse.julialang.org/t/how-to-share-a-duckdb-database-connection-to-many-functions/102921)

<div class="topic-metadata">

**Author:** [@rdavis120](https://discourse.julialang.org/u/rdavis120)\
**Replies:** 1\
**Last updated:** [August 19, 2023, 2:44pm UTC](https://discourse.julialang.org/t/how-to-share-a-duckdb-database-connection-to-many-functions/102921 "2023-08-19T14:44:49Z")

</div>

What is the best practice in Julia to share the a database connection to several functions in a module? Such as a connection from the DBInterface package. Especially, without exporting the connection variable itself, s…