search

pgspider / sqlite_fdw

SQLite Foreign Data Wrapper for PostgreSQL
Other
219 stars 37 forks source link

Added Limit/Sort pushdown for SQLite and conversion from SQLite numerical value to PostgreSQL TimeStamp #24

Closed pruiz closed 4 years ago

pruiz commented 4 years ago

Added functionality to allow pushdown for Limit (Limit/Offset) and Order By.

NULLS FIRST/LAST also allowed (pushdown) if SQLite version has functionality implemented (>3.30).

Also, added conversion when adding foreign SQLite table that has numerical values to PostgreSQL timestamp, so now we can store TimeStamp in SQLite as TEXT or NUMERICAL and both will be working as expected with PostgreSQL.

PS: Tests Working with PostgreSQL 12 and SQLite 3.30

hrkuma commented 4 years ago

Thank you for implementing and sharing such good features! We'd like to review and want to apply. However it may take some time, please be patient.

pruiz commented 4 years ago

Thank you for implementing and sharing such good features! We'd like to review and want to apply. However it may take some time, please be patient.

Sure, np :)

hrkuma commented 4 years ago

Thank you for fixing.

Could you add the description about the column_type in README.md ?