sqlite_fdw
sqlite_fdw copied to clipboard
pgspider
SQLite Foreign Data Wrapper for PostgreSQL
In sqlite we had real data type, and store "-nan(ind)" values, I believe that it is a NaN values. But it gets converted to 0 on postgres. I believe it...
In this PR: - Deparsing of PostgreSQL ∞ special numeric values as `9e999` for SQLite - Add mixed affinity data normalization function for SQLite for reading case insensitive signed or...
Create `rpm.spec`. In continue of https://github.com/pgspider/sqlite_fdw/pull/39 Based on * https://rpm-software-management.github.io/rpm/manual/spec.html * https://github.com/scj643/sqlite_fdw/tree/master * `rpm.spec` from https://rhel.pkgs.org/9/postgresql-14-x86_64/sqlite_fdw_14-2.3.0-1.rhel9.x86_64.rpm.html Thanks to @scj643 and @devrimgunduz
+ - [PostGIS](https://www.postgis.net/) is the most popular PostgreSQL extension. PostGIS provides many spatial functions and fully compatible with [GEOS](https://libgeos.org) `bytea` data formats. - [SpatiaLite](https://www.gaia-gis.it/fossil/libspatialite/index) is SQLite extension with spatial functions...
Only non - `STRICT` tables in legacy SQLite databases is affected. 1. There is foreign table with `bytea` column. In SQLite values usually belongs to [blob](https://www.sqlite.org/datatype3.html#affinity_name_examples) affinity. In SQLite `BLOB`...
## Problem Is it possible to support sqlite plugins (.so/.dll)? ## Context I wanted use FTS5 from sqlite to replace postgresql's built-in FTS, which does not have BM25 ranking support....
[feature request] SQL `RETURNING` have been [introduced in SQLite 3.35.0](https://www.sqlite.org/lang_returning.html). > SQLite's syntax for RETURNING is modelled after [PostgreSQL](https://www.postgresql.org/). Hence look like there is no special behaviour for `RETURNING` in...
I cannot build the compoent for PG16r1. Are you planning to update the extension any time soon?
Hi. I might be pushing the boundaries a little bit - I've got interesting use case, which I might be able to solve with a little bit more functionality from...
