Result for 6C3F5E9D741717D0B1D1BBF2F4C113C82B8ED7F5

Query result

Key Value
FileSize100068
MD5B8646B75927A1AF7EA1DE20A1CC5BCBA
PackageDescriptionPostgreSQL foreign data wrapper for OGR OGR is the vector half of the GDAL spatial data access library. It allows access to a large number of GIS data formats using a simple C API for data reading and writing. Since OGR exposes a simple table structure and PostgreSQL foreign data wrappers allow access to table structures, the fit seems pretty perfect. . This implementation currently has the following limitations: * Only non-spatial query restrictions are pushed down to the OGR driver. PostgreSQL foreign data wrappers support delegating portions of the SQL query to the underlying data source, in this case OGR. This implementation currently pushes down only non-spatial query restrictions, and only for the small subset of comparison operators (>, <, <=, >=, =) supported by OGR. * Spatial restrictions are not pushed down. OGR can handle basic bounding box restrictions and even (for some drivers) more explicit intersection restrictions, but those are not passed to the OGR driver yet. * OGR connections every time Rather than pooling OGR connections, each query makes (and disposes of) two new ones, which seems to be the largest performance drag at the moment for restricted (small) queries. * All columns are retrieved every time. PostgreSQL foreign data wrappers don't require all columns all the time, and some efficiencies can be gained by only requesting the columns needed to fulfill a query. This would be a minimal efficiency improvement, but can be removed given some development time, since the OGR API supports returning a subset of columns.
PackageMaintainerDebian GIS Project <pkg-grass-devel@lists.alioth.debian.org>
PackageNamepostgresql-14-ogr-fdw
PackageSectiondatabase
PackageVersion1.1.1-2
SHA-16C3F5E9D741717D0B1D1BBF2F4C113C82B8ED7F5
SHA-25684DBE1EDC9C74A9B91BD1975D259CDE3B418E69F74C76C82E8E82745BB751631
hashlookup:children-total14
hashlookup:trust50

Network graph view

Children (Total: 14)

The searched file hash includes 14 children files known and seen by metalookup. A sample is included below:

Key Value
FileName./usr/lib/postgresql/14/bin/ogr_fdw_info
FileSize27520
MD5C35A4C3E3BBFB56F545832E1BAAC2E03
SHA-1281C0DBFA7A58EEA4FD448B59969405C9F4332A2
SHA-2563DC7DB222441311BC6CE69547893204D703FC9378A770818419BAED8F27BD7BA
SSDEEP192:8/ANNu1CeCe3htmzydpuU89stsA4dr8l4UUCj6LGFA31+ePXTx72+Xei8ihvltbC:dmrmouJ9ksUlZUCjjBePc+uAJb/FuOz
TLSHT17DC2C66EF958D96BC8CAD2345D9F8372A3236108E327C3F37544065DAE8B7FA4D60990
Key Value
FileName./usr/share/doc/postgresql-14-ogr-fdw/changelog.Debian.gz
FileSize1631
MD520B13F809F60AC775A9B1E0A7318F312
SHA-1637298717C2311BABE75C971487902FFCAC419CB
SHA-256E8AADA811337EA2082B94BC74A0FAF87D54EFF11345E9C7A802EE6A72307FEB1
SSDEEP48:XkNTxssNxJ209jzGkJ70uFGIzJRByL7IKi07RvJ2wy:25N7n5J70ozJRB6Xp7y
TLSHT14131EAA6D717D0D3B960E70621DEEE7F153ADD99B15B8C033088B7A014221A0A24915D
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/stringbuffer_pg.bc
FileSize10484
MD59BCFCD83286527C9905C64DBE0ACD618
SHA-1B411350F998C23C5ABD244B92FC695017A8AA3F5
SHA-256DDAB92CCBFCF8F81AF770B2797F61741D0F427F7C9C80829200462F8275F923C
SSDEEP192:kds23h7EZ5Yl71NVp0r38G4J5KtTUFKfg6DGo++AfIeFPA3guJlHYTMJMLXa:kdJWSnVar3hiFegaG7+Af7FPA3BJ902
TLSHT1C7224A2FF75866D5C08857381CEB42CE92E9A4408FB07677ABB36A3CBEB113758B0550
Key Value
FileNameogr_fdw--1.0--1.1.sql
FileSize299
MD51EF554C616399D0FB6F06EA3F98F8207
RDS:package_id285120
SHA-130C012FEA931EA588C3F6A149ED4824C112DE8AB
SHA-256AA6E1255A8A15EA871B2BA23E9A48A4C44F694AEDC97C360A09146030F14DD93
SSDEEP6:ecUhTaUxCii752Jr6AgFeBzUhTCxCijw52JZzAgFeB5:ecURxZoFFeBzU0/l7zFFeB5
TLSHT12EE0CD0BAD675523D292BF349402C9BF4F13038F446BE95050BB741C8E5380C8B25EEB
insert-timestamp1662198435.8497121
sourcedelta.db
Key Value
FileName./usr/lib/postgresql/14/lib/ogr_fdw.so
FileSize63744
MD5FD7B7A850B7A526D8F01F2E96E972967
SHA-124F92C5F6391A790D261D1BAA767D3CEA3510D36
SHA-25696825A918380D2E07DA758BC501ABE2C3F30B83F8D8935D39BDD4A9D25930026
SSDEEP768:1o5FzsQZnSh6m4ThUkJDI5HoZtSxvU8K9vdM0+Hf6EBFqzMR63bb9TJrn:1unZnlqkJDI90tSdHBB4zPXtV
TLSHT16D534C1FF60DD5E3C746B73449C95721F333101CF1668AF232289B596F8A28EAEB1598
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/ogr_fdw_common.bc
FileSize15532
MD5C8024DE7D7069D0944ACEAA0111B4F37
SHA-1E96165967609B23A3B0167C555C38298FC3ACF95
SHA-256A67F315438ADD804C66CB0883325F83ECE09448F28B616A7EF26274AB5066FC8
SSDEEP192:kgLL3h7Jr3tYwnXKO5fx07HYPsvCbYzKtTOwG7pw7La/5zLoGSRY/FZLLcYGdicA:kg/Hr3wUxDPPGtKLa/qMgYiiCLdW
TLSHT14C62E72ABA944792E188423D197F02CB93BAF10CCF0A9743269C773D6975245E9B1D3E
Key Value
FileNameogr_fdw.control
FileSize152
MD5408F173AC888FA17C052E673078E59A0
RDS:package_id285118
SHA-1ABDA8467690571C922AFF0388ABD42855D6818F7
SHA-256163D3B61CC6DC3415543E755617DDC9579E6E42149687D2AA0A0A0C5A43773A0
SSDEEP3:SJFAYT8XqgSZVQisnqBCv2DB4AGNRKmVVERNwoCEHBYjQCvcTpdFR1n:SJFzT8XqgSZVgD2GNRKm/ErwoXHBYcPv
TLSHT158C08C2113AA84A20814BF28D9000020DEA43AB82212242712C8888C3BA0789B241B09
insert-timestamp1662198435.5457163
sourcedelta.db
Key Value
FileNamesnap-hashlookup-import/usr/share/lintian/overrides/libhdf4-0-alt
FileSize63
MD572EE11F9626FF424B93B5AF1F353BCBA
RDS:package_id293681
SHA-18B1072FD9A6A5C0ACC44BD875330A469DF2C4A09
SHA-256571DA562A54CEA577DAF5A18A413B8A1D02E78769BCB1E7254E9153B260D8C58
SHA-512B914B2C5B4B7400CB7BA0AD16C21E7F68BF2D612FC7E71D07E92D8D03BE24BB17C5F0BD8CBF70377651AF16C5E5BDE3EE10050BC446709E95947716C501BF79F
SSDEEP3:SLfELcAGAI+GAWZGOrtRogPvvn:SALccI+G1Zrnv
TLSHT169A002544D11155A575277107F311705627B617196A442406128154A7406FB422D262E
insert-timestamp1728263316.5318696
mimetypetext/plain
sourcesnap:2ZmiMNpbuanFwhJ4sSt9y1DaYHITLCyb_103
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/ogr_fdw.bc
FileSize64700
MD56479312EBBB5BEC7C495532A9EFBEC71
SHA-1B8A6F0D7BDD5ABA8F14885141AC2941A76AF1C97
SHA-256ED271B67E4B743D0355A87B14D54D3A2E22C231789F36D798FE733766323D155
SSDEEP1536:Zd/q22Di20Vf51WTcgc/9SoKE9ZBgP0F8WJ2:vqNm20VDaGFSfceW0
TLSHT108536B2EB2608391C40C173D88FF16CE47B665419F51966377A8672CBC71258EBB3ABC
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/ogr_fdw_deparse.bc
FileSize24528
MD55BADF79CE70F3E82ECE881D40550AB8C
SHA-145C033A685CCA39D1D071E3EC7250B2D9D8707C3
SHA-2565C6361A187D3995225ACBBF13AC1B7F091EC5A410E2C3A1FB7A7BD157783540B
SSDEEP384:kUd0odI+Lh75Cv2Wtbr/BK22ZMFG8WS4nxBcBmeAyomFA1H7dp5Q:JuyLLh75StvBFpWznIwefoHH7dpG
TLSHT12DB27D1DF2AA0552C588973D8DBB018B43A9E68CDF018347364AB71DBEB1384DFB15B9
Key Value
FileNameogr_fdw--1.1.sql
FileSize767
MD5117BF214A9335C66AB3A7A7CD81D993B
RDS:package_id285120
SHA-13A2503FBEACD0C4038357414816667E81AF7B531
SHA-2567ED528C0611FFD669276F6E38F047C9CFE9E0CDC2E348245C1D49D241A955780
SSDEEP12:UtjGFoUEeBNFY/9UOeSxdcSewsncDS/WuAMVsEURxZoFFeBzU0/l7zFFeB5:qyto7ezSeDGS/WFb9p8eBIyl3eB5
TLSHT14A014C0F596DE1238391BE78A406887FDB12434E4817AAC0909B651C5EC6A094725FFA
insert-timestamp1662198435.6775877
sourcedelta.db
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/ogr_fdw_func.bc
FileSize5864
MD56A2DE305F15517D9C33507952FE30D10
SHA-14465ED23582ED0A286CDAE68B94FCBE76F5D395A
SHA-2562E97E5310E40048EAA7A1637815BC970BFA3BCEFD0E6B5527E3A0A50CADE4290
SSDEEP96:ka9RXS1ePU7JVRWE8SEh7q/mHTn3ZHGmU6xKtZDy+K0cJ1onVMoYqXWf7oYmwgbt:ke9Enmh7q/0r3gAxKtTsOWg2C
TLSHT132C13A2973641A92C18F073AAC6F41CA5339E608DF86B7177646772CB9F021F65004B6
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw.index.bc
FileSize10252
MD51ABB84D2B89DE6CA22969CA9FBD01E5A
SHA-189C6919B2BF9DC44B21384230EA7F72D3F716218
SHA-2560B475098F22A8C5301A5664E3E1A9C80DA80E2F3610BB1DC8C218CC818BDE62E
SSDEEP192:YjVF6WNjfTeQ/hSkSiZ2ExmOIS+7JwYxzv77ooRjds:YhF6m3n/Akd2wmtv7JwsvHokxs
TLSHT1A3229EC7E7C4570C864EE6A6E0CBAFFC4AD0102713E525EB56653C93358271E2ADE439
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/copyright
FileSize1620
MD5499B3FB5D2AAB1E6C06D1CCFBC800180
SHA-17F3316DC5C6DD7A5E955520CA0887D2C6ACC47C2
SHA-256A44FF01B48025CB7EB1CA15965214E09653E902221EE69DF88BD5380112C5D1E
SSDEEP24:gttzRRSoRhmKWgKrKUxrwNJHZH0yf3gtk1Hc1hMK9QH0sUv4kOk4/+/U3oq4sFig:s3qfxyJxl/El5QH0s5ANU3oWFig
TLSHT1B631C84FF64403632DE233E29854B8E9A7337489B0AB16C5F44EE2047B2A0ADC1FA464