{"repo":"pgspider/sqlite_fdw","free":true,"listed":false,"github":"https://github.com/pgspider/sqlite_fdw","clone":"git clone https://github.com/pgspider/sqlite_fdw.git","description":"SQLite Foreign Data Wrapper for PostgreSQL","language":"PLpgSQL","stars":262,"topics":["sqlite","postgres","postgresql","sql","sqlite3","fdw","foreign-data-wrapper","foreign-tables","postgresql-extension","sqlite-fdw"],"license":null,"category":"databases-storage","readme_excerpt":"SQLite Foreign Data Wrapper for PostgreSQL ========================================== This is a foreign data wrapper (FDW) to connect PostgreSQL to SQLite database file. This FDW works with PostgreSQL 13, 14, 15, 16, 17 and confirmed with SQLite 3.49.0. + Also this foreign data wrapper (FDW) can connect PostgreSQL with PostGIS to SpatiaLite SQLite database file. This FDW works with PostGIS 2+ and confirmed with SpatiaLite 5.1. See GIS support description. + Contents -------- 1. Features 2. Supported platforms 3. Installation 4. Usage 5. Functions 6. Identifier case handling 7. Generated columns 8. Character set handling 9. Examples 10. Limitations 11. Tests 12. Contributing 13. Useful links Features -------- Common features - Transactions - Support INSERT / UPDATE / DELETE (both Direct modification and Foreign modification), see access control about conditions of succesfully data modification. - Support TRUNCATE by deparsing into DELETE statement without WHERE clause. - Allow control over whether foreign servers keep connections open after transaction completion. This is controlled by keep connections and defaults to on. - Support list cached connections to foreign servers by using function sqlite fdw get connections() - Support discard cached connections to foreign servers by using function sqlite fdw disconnect() , sqlite fdw disconnect all() . - Support Bulk INSERT by using batch size option - Support INSERT / UPDATE with generated column - Support ON CONFLICT DO NOTHING -","default_branch":null,"files":null,"tree":[],"storefront":"/r/pgspider","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/pgspider/sqlite_fdw/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."}