1{
2 fetchFromGitHub,
3 lib,
4 postgresql,
5 postgresqlBuildExtension,
6 sqlite,
7}:
8
9postgresqlBuildExtension (finalAttrs: {
10 pname = "sqlite_fdw";
11 version = "2.5.0";
12
13 src = fetchFromGitHub {
14 owner = "pgspider";
15 repo = "sqlite_fdw";
16 tag = "v${finalAttrs.version}";
17 hash = "sha256-zPVIFzUv6UFFHq0Zi5MeQOcvgsfZAKGkkNIGxkTJ+oo=";
18 };
19
20 buildInputs = [ sqlite ];
21
22 makeFlags = [ "USE_PGXS=1" ];
23
24 meta = {
25 # PostgreSQL 18 support issue upstream: https://github.com/pgspider/sqlite_fdw/issues/117
26 # Note: already fixed on `master` branch.
27 # Check after next package update.
28 broken = lib.warnIf (
29 finalAttrs.version != "2.5.0"
30 ) "Is postgresql18Packages.sqlite_fdw still broken?" (lib.versionAtLeast postgresql.version "18");
31 description = "SQLite Foreign Data Wrapper for PostgreSQL";
32 homepage = "https://github.com/pgspider/sqlite_fdw";
33 changelog = "https://github.com/pgspider/sqlite_fdw/releases/tag/v${finalAttrs.version}";
34 maintainers = with lib.maintainers; [ apfelkuchen6 ];
35 platforms = lib.platforms.unix;
36 license = lib.licenses.postgresql;
37 };
38})