duckdb/duckdb-sqlite

DuckDB extension to read and write to SQLite databases

Stars: 291
Forks: 45
Open beginner issues: 0
Indexed issues: 29
Avg merge: 10h 13m
Merged PRs (30d): 18

Dominant language: C
License: MIT
Last GitHub push: Sep 13, 2026
Latest indexed: Sep 15, 2026
Contributing guide: No contributing guide
Code of conduct: No code of conduct
Beginner labels: No beginner labels indexed

Open All

29 open issues indexed

Windows build fails if path has whitespace Open

duckdb/duckdb-sqlite#61 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
A question about performance Open

question

duckdb/duckdb-sqlite#74 · 1 comment · 1 reaction · 0 assignees · Indexed Sep 15, 2026
Can't build on an M1/ARM Mac Open

duckdb/duckdb-sqlite#80 · 6 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Getting error "PRAGMA table_info('SpatialIndex'): no such module: VirtualSpatialIndex" on unrelated querry Open

duckdb/duckdb-sqlite#88 · 1 comment · 2 reactions · 0 assignees · Indexed Sep 15, 2026
db Loads in Windows but not Linux Open

duckdb/duckdb-sqlite#100 · 5 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
sqlite: cannot reference table due to type mismatch Open

duckdb/duckdb-sqlite#102 · 0 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
COPY FROM DATABASE SQLite to DuckDB - Catalog Error Open

duckdb/duckdb-sqlite#103 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
How can I load SQLite virtual tables created by a SQLite extension? Open

duckdb/duckdb-sqlite#106 · 0 comments · 2 reactions · 0 assignees · Indexed Sep 15, 2026
GeoPackage geometry type detection Open

duckdb/duckdb-sqlite#113 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
information_schema.table_constraints and key_column_usage always list "memory" for table_catalog on attached databases - CONSTRAINTS are not then well export Open

duckdb/duckdb-sqlite#114 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Getting errors when creating a VIRTUAL table for Full Text Search with SQLite extension Open

duckdb/duckdb-sqlite#128 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Poor performance for simple operation on large-ish database. Open

duckdb/duckdb-sqlite#129 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Create table from another database results in errors and segfault Open

duckdb/duckdb-sqlite#136 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
SQLite `.schema` fails in parsing with table + index Open

reproduced

duckdb/duckdb-sqlite#137 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
open exist sqlite file on Windows 11 arm Open

duckdb/duckdb-sqlite#138 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
After attaching SQLite DB, cannot create a view with a query including `union all` Open

duckdb/duckdb-sqlite#139 · 1 comment · 1 reaction · 0 assignees · Indexed Sep 15, 2026
Impossible to use this sqlite db Open

duckdb/duckdb-sqlite#140 · 3 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
Show statement displays metadata information exception Open

duckdb/duckdb-sqlite#142 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Error parsing Infinity for `REAL` datatype Open

duckdb/duckdb-sqlite#144 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
`ATTACH` fails with `~/some-db.sqlite3` path expansion Open

duckdb/duckdb-sqlite#145 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Feature request: Support globbing to read from multiple similiar sqlite databases Open

duckdb/duckdb-sqlite#150 · 0 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
DuckDB failed with `near "~": syntax error` while creating a view with a string-like operation. Open

duckdb/duckdb-sqlite#155 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
If sqlite's fts use a third-party tokenizer plugin dll, loading will fail Open

duckdb/duckdb-sqlite#158 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
"Scalar Function with name randomblob does not exist!" when inserting from duckdb to sqlite. Open

duckdb/duckdb-sqlite#162 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
CREATE TABLE with DATE column in sqlite saves column as VARCHAR (missing affinity?) Open

reproduced

duckdb/duckdb-sqlite#166 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
COPY from one sqlite db to another does not work Open

duckdb/duckdb-sqlite#167 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Parser errors when running JOINs, subqueries, and aggregations across ATTACHED SQLite databases using DuckDB Node.js (v1.4.3) Open

duckdb/duckdb-sqlite#170 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Transaction starts prematurely during "did you mean" suggestion, causing database open failure Open

duckdb/duckdb-sqlite#183 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Problem with MinGW builds Open

duckdb/duckdb-sqlite#189 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026

A short digest of beginner-friendly GitHub issues.