{"repo":"Mause/duckdb_engine","free":true,"listed":false,"github":"https://github.com/Mause/duckdb_engine","clone":"git clone https://github.com/Mause/duckdb_engine.git","description":"SQLAlchemy driver for DuckDB","language":"Python","stars":495,"topics":["duckdb","python","sql","sqlalchemy","duckdb-engine"],"license":"MIT","category":"databases-storage","readme_excerpt":"duckdb engine Basic SQLAlchemy driver for DuckDB - duckdb\\ engine - Installation - Usage - Usage in IPython/Jupyter - Configuration - How to register a pandas DataFrame - Things to keep in mind - Auto-incrementing ID columns - Pandas read sql() chunksize - Unsigned integer support - Alembic Integration - Preloading extensions (experimental) - Registering Filesystems - The name Installation DuckDB Engine also has a conda feedstock available, the instructions for the use of which are available in it's repository. Usage Once you've installed this package, you should be able to just use it, as SQLAlchemy does a python path search Usage in IPython/Jupyter With IPython-SQL and DuckDB-Engine you can query DuckDB natively in your notebook! Check out DuckDB's documentation or Alex Monahan's great demo of this on his blog. Configuration You can configure DuckDB by passing connect args to the create engine function The supported configuration parameters are listed in the DuckDB docs How to register a pandas DataFrame Things to keep in mind Duckdb's SQL parser is based on the PostgreSQL parser, but not all features in PostgreSQL are supported in duckdb. Because the duckdb engine dialect is derived from the postgresql dialect, SQLAlchemy may try to use PostgreSQL-only features. Below are some caveats to look out for. Auto-incrementing ID columns When defining an Integer column as a primary key, SQLAlchemy uses the SERIAL datatype for PostgreSQL. Duckdb does not yet support this datatype b","default_branch":null,"files":null,"tree":[],"storefront":"/r/Mause","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Mause/duckdb_engine/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."}