May 9th 2024: PostgreSQL 16.3, 15.7, 14.12, 13.15, and 12.19 Released!

SQLite FDW 2.3.0 released

Posted on 2023-01-20 by Toshiba
Related Open Source

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

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

  • Support PosgreSQL 15.0
  • Support push down CASE expressions

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 Software Engineering & Technology Center.
Please see the repository for details.

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

Best Regards,
TAIGA Katayama