# Supporting appending \`Vector\` in DuckDB

**URL:** <https://discourse.julialang.org/t/supporting-appending-vector-in-duckdb/126511>\
**Category:** Data\
**Tags:** duckdb\
**Created:** [March 3, 2025, 7:51pm UTC](https://discourse.julialang.org/t/supporting-appending-vector-in-duckdb/126511 "2025-03-03T19:51:49Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![slwu89](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/slwu89/32/217323_2.png) [@slwu89](https://discourse.julialang.org/u/slwu89)\
**Post date:** [March 11, 2025, 11:06pm UTC](https://discourse.julialang.org/t/supporting-appending-vector-in-duckdb/126511/3 "2025-03-11T23:06:55Z")

</div>

Just a public service announcement, thanks to @era127’s [[Julia] Add support for appending duckdb List types by era127 · Pull Request #16512 · duckdb/duckdb · GitHub](https://github.com/duckdb/duckdb/pull/16512) which is merged, if you update the `DuckDB` package, the code I originally had trouble with in the previous discourse topic now runs as expected (see below):

```julia
using DuckDB, DataFrames

function load_table!(db::T, df::DataFrame, name) where {T<:DuckDB.DB}
    sch = DataFrame(DBInterface.execute(db, "DESCRIBE $(name);"))
    sch_cols = sch[!, :column_name]
    @assert Set(names(df)) == Set(sch_cols)
    appender = DuckDB.Appender(db, name)
    for i in eachrow(df)
        for j in sch_cols
            # database columns are ordered
            DuckDB.append(appender, i[j])
        end
        DuckDB.end_row(appender)
    end
    DuckDB.flush(appender)
    DuckDB.close(appender)
end

db_mem = DBInterface.connect(DuckDB.DB, ":memory:")
DBInterface.execute(db_mem, "CREATE TABLE tab1 (id INTEGER PRIMARY KEY, vals INTEGER[]);")
tab1_df = DataFrame(id=1:10, vals=fill([1,2,3],10))
load_table!(db_mem, tab1_df, "tab1") # errors
DBInterface.execute(db_mem, "SELECT * FROM tab1;") |> DataFrame

```

---

_[View the full topic](https://discourse.julialang.org/t/supporting-appending-vector-in-duckdb/126511)._