{"repo":"duckdb/duckdb-sqlite","free":true,"listed":false,"github":"https://github.com/duckdb/duckdb-sqlite","clone":"git clone https://github.com/duckdb/duckdb-sqlite.git","description":"DuckDB extension to read and write to SQLite databases","language":"C","stars":289,"topics":["sql","sqlite","duckdb"],"license":"MIT","category":"databases-storage","readme_excerpt":"DuckDB SQLite extension The SQLite extension allows DuckDB to directly read and write data from a SQLite database file. The data can be queried directly from the underlying SQLite tables. Data can be loaded from SQLite tables into DuckDB tables, or vice versa. Reading Data from SQLite To make a SQLite file accessible to DuckDB, use the ATTACH command, for example with the bundled sakila.db file: The tables in the file can be read as if they were normal DuckDB tables, but the underlying data is read directly from the SQLite tables in the file at query time. You can query the tables using SQL, e.g. using the example queries from sakila-examples.sql Opening SQLite Databases Directly SQLite databases can also be opened directly and can be used transparently instead of a DuckDB database file. In any client, when connecting, a path to a SQLite database file can be provided and the SQLite database will be opened instead. For example, with the shell: Writing Data to SQLite In addition to reading data from SQLite, the extension also allows you to create new SQLite database files, create tables, ingest data into SQLite and make other modifications to SQLite database files using standard SQL queries. This allows you to use DuckDB to, for example, export data that is stored in a SQLite database to Parquet, or read data from a Parquet file into SQLite. Below is a brief example of how to create a new SQLite database and load data into it. The resulting SQLite database can then be read into","default_branch":null,"files":null,"tree":[],"storefront":"/r/duckdb","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/duckdb/duckdb-sqlite/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}