SQLite FDW 2.4.0 released

Posted on 2023-09-28 by Toshiba
Related Open Source

We have just released version 2.4.0 of the Foreign Data Wrapper for SQLite.

This release can work with PostgreSQL 12, 13, 14, 15 and 16.
This release improves following items (from 2.3.0):

  • Support PosgreSQL 16.0
  • Add text transformations for pg DB encoding
  • Add updatable option on different levels
  • Improve error messages
  • Refactor README.md

The FDW supports following key features :

  • SELECT, INSERT, UPDATE and DELETE of foreign tables
  • WHERE clauses is pushed down
  • Aggregate is pushed down
  • ORDER BY is pushed down
  • JOIN is pushed down (LEFT,RIGHT,INNER)
  • LIMIT and OFFSET are pushed down (*when all tables queried are fdw)
  • Transactions

This is developed by Toshiba Digital Innovation Technology Center.
Please see the repository for details.

Source repository : https://github.com/pgspider/sqlite_fdw

Best Regards,
TAIGA Katayama