# Write a table into SQLite and DuckDB in efficient manner

**URL:** <https://discourse.julialang.org/t/write-a-table-into-sqlite-and-duckdb-in-efficient-manner/93417>\
**Category:** Performance\
**Tags:** help-database, sqlite, sql, database, duckdb\
**Created:** [January 23, 2023, 5:58pm UTC](https://discourse.julialang.org/t/write-a-table-into-sqlite-and-duckdb-in-efficient-manner/93417 "2023-01-23T17:58:45Z")\
**Posts on this page:** 1\
**Showing post:** 22

<div class="post-metadata">

**Author:** ![aplavin](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/aplavin/32/222056_2.png) [@aplavin](https://discourse.julialang.org/u/aplavin)\
**Post date:** [January 27, 2023, 12:34am UTC](https://discourse.julialang.org/t/write-a-table-into-sqlite-and-duckdb-in-efficient-manner/93417/22 "2023-01-27T00:34:25Z")

</div>

A cursory look suggests converting that file from dataframes to arbitrary tables (through `columntable`) is pretty easy. However, I cannot simply run `DuckDB.jl` tests successfully, all of these fail for me:

- `]dev DuckDB` + `]test DuckDB`
- clone duckdb, go to `juliapkg` dir, do `]test`
- clone duckdb, go to `juliapkg` dir, do `./test.sh`

Also, their contribution rules aren’t clear: do you know if they even accept outside PRs?

---

_[View the full topic](https://discourse.julialang.org/t/write-a-table-into-sqlite-and-duckdb-in-efficient-manner/93417)._