Postgres Pro
Downloads
Home   >   mailing lists

SQLite FDW 2.4.0 released - Mailing list pgsql-announce

From Toshiba via PostgreSQL Announce
Subject SQLite FDW 2.4.0 released
Date
Msg-id 169593572372.3727338.2454492517131690098@wrigleys.postgresql.org
Whole thread Raw
List pgsql-announce
Tree view
 

SQLite FDW 2.4.0 released

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

This email was sent to you from Toshiba. It was delivered on their behalf by the PostgreSQL project. Any questions about the content of the message should be sent to Toshiba.

You were sent this email as a subscriber of the pgsql-announce mailinglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click the personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 

pgsql-announce by date:

Previous
From: Synthesized via PostgreSQL Announce
Date:
Subject: Synthesized TDK. Populating Test Environments with Production-Like Data
Next
From: Citus Data via PostgreSQL Announce
Date:
Subject: Citus 12.1 Released!