SQLite fdw 2.1.1 released - Mailing list pgsql-announce

From Toshiba via PostgreSQL Announce
Subject SQLite fdw 2.1.1 released
Date
Msg-id 164063171946.21667.14451382483900048675@wrigleys.postgresql.org
Whole thread Raw
List pgsql-announce
 

SQLite fdw 2.1.1 released

We have just released version 2.1.1 of the Foreign Data Wrapper for SQLite.
This release can work with PostgreSQL 10, 11, 12, 13 and 14.
This release improves following items :

  • Support Insert/Update with generated column
  • Support check invalid options
  • Bug fixings:
    • Fix issue of accessing fts table on SQLite
    • Fix memory leak

The FDW supports following key features :

  • SELECT, INSERT, UPDATE and DELETE of foreign tables
  • WHERE clauses is push-downed
  • Aggregate is push-downed
  • ORDER BY is push-downed
  • JOIN is push-downed (LEFT,RIGHT,INNER)
  • LIMIT and OFFSET are push-downed (*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

 

pgsql-announce by date:

Previous
From: Toshiba via PostgreSQL Announce
Date:
Subject: GridDB FDW 2.1.1 released
Next
From: Toshiba via PostgreSQL Announce
Date:
Subject: JDBC FDW 0.1.0 release