Result for 2F66D1F467870C293D1C19A8B08B8BAC61CB5AB3

Query result

Key Value
FileSize100788
MD530B2703F5A955242F9E81A344A41FD97
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.
PackageMaintainerUbuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com>
PackageNamepostgresql-13-ogr-fdw
PackageSectiondatabase
PackageVersion1.1.0-1
SHA-12F66D1F467870C293D1C19A8B08B8BAC61CB5AB3
SHA-25691711F299BA6D110BA9B00CF1E2750DF771B0CFA427F86934053EA2768ABA3EA
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
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/13/lib/ogr_fdw.so
FileSize67920
MD5F7244750277B17B7A4140BCC3973F78B
SHA-10862913A22D946B31725CD5614FE2AE4562A9009
SHA-256C6D7C6D8E9A4FB958184C55C7B493911D134FF1099BD139088657DE67427B174
SSDEEP1536:+7rYRV/PjW4eLVCprlek4OOXSae5zOjzJMPX:+7rYXhwwhYkPPPX
TLSHT1ED63C60FE150963CC0C4E0718FDF91720720B879B931166F2F85B37F2DA696569BAE26
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
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw.bc
FileSize64624
MD5B219174D984037F499337A49EF0CD390
SHA-1D39324676F2DB084159376FFBAFC40EA682A87D8
SHA-256498458C776AAF329FC34FD54775044B7ADEFE1C6C461000037ED2D269684EBF3
SSDEEP1536:RTxe4c9L7lc8Fd9TkJA7KLy0hZE1YF8QJy:RTxe19L71Fseu7ReQ8
TLSHT1D2537C1EB210C291E548237E4CBF16CE0BB6BA449F05A65373E5771D3C71294EAB1ABC
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/13/lib/bitcode/ogr_fdw/stringbuffer_pg.bc
FileSize10368
MD59BCC5F3DB8727C5193DD93FC1B3FDDA3
SHA-152F1080E8C1FB3EFE205B5E71249BC866A35CE26
SHA-2566B9AAD2C158E2745A4EEB9D40883E7BDA3F2E77FDDE5F09121A5378349D791F0
SSDEEP192:kZRhkoYGr3rxuvhkB0KtTu+AbR4F6mOC7hP6guvEx9TWugJMLn:kZRpr3gbNu6mOC7hiBvmpWC
TLSHT118225B0B77A95A94C1894B3D9CFA838E82BCE080CF64777367956D3C7DE1237A890072
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw.index.bc
FileSize10256
MD5B3C3B5FAC96A4557A12F5408528B124F
SHA-17778E9020CF5B75AC06D3B0CEDA6CBD5F53A8437
SHA-256FCFF81B8995D9FD2E106036FD3226473E415A726E40D1A0642F55483D3DDEE51
SSDEEP192:gsadgDsJHKZuRCRETEqYQEqjFFuF9WhsGN146ShVvxp2NUqPipmMBSaHaYHQQAWi:tanlKZutaQEqji9GsO1yhVa6pnBSWwQY
TLSHT1A6225CCBE6CD42B8D297F1B299CFADF400E0184687C362E7B4967D91355636A82CD236
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/changelog.Debian.gz
FileSize684
MD5F77D347AC7523B82617D28F00AE47C62
SHA-10CB9675C839155F912E074F158A6C6A1A7B1128C
SHA-2565E5D9E1730628A4589FB0AB8B020A3A9F9C82FB842CFF2FCBB836D6597BB5831
SSDEEP12:XejltlLEYJuk0EPFlTO3vXHU1Svvk9QzHSXinmRoW1WWiuQ07IKwtdELG/:XE74YJuk/XOaSnLSqm2WYIemL2
TLSHT1B80194410E6A884AE6990305A4C100089619C6D51E3F8CA1C7DB9B9FC547093483AD4E
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_func.bc
FileSize5996
MD5F23278340FAB952A6DC6D8B8FD9CAE3C
SHA-18BBA7E2FE1F99B6B8B7D9F3DB5C9EBDD0468AE9E
SHA-256AA5B1A54056D5C7B0AC51432352B0100A9A2BBA2C3F52FBE55B27F70073EC47E
SSDEEP96:k69cXSFkqvkHIk/EhkeweaUQBLOKtZDy+KPYXrBD1oHToYqXWdEWoYmwgbZ:k+cqvzhk7epKtTuYHgHg9
TLSHT1EBC14B1E33540A51C185073D9DBF01CAA7BAEA428F52E75726D6B62CBAB032E6C10A71
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_common.bc
FileSize15832
MD58974898CA6878F1A547868A8C6F9D9E7
SHA-1D416302A0B0EF45EB334ABA4CC46B0831994088F
SHA-2567FCB720E5010EE51E505988D9EB939AD0270D93803E58E7BDA24E9A4882C7871
SSDEEP192:knMhkEYkcYYyIvvhkfL1xsvCbYzKtTL4KEJEip6xu54JVUXLMGSRY/oACycYGdiQ:knMIc4YL1OREi64CzBMo7LYiiC/d
TLSHT1FD62E62BF9A14B96D088073E197F02CF93B6F208CF15935326A8772D39B0114E9B093E
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_deparse.bc
FileSize23944
MD5F36C38342F28F182F0F4E959DC8381E4
SHA-1C3FD4E79ABF3A7198E64FEB1F644E52691ED77EA
SHA-256D91998B795D3CEEF3F44CAC632C941E270B4D7E3607BDA41EF6F0CDAC14A1E4B
SSDEEP384:kK4tMWHOyOXZw1/fx5KJK6r3liYNWKWLXFgEuKDqpfrNB5QO:TheOK1RsJ/lDNDWLqEHwRBGO
TLSHT16AB27C2EF5E15542C488463E48BE439B43F7F548EF2482837A99572DBE712809F7163E
Key Value
FileName./usr/lib/postgresql/13/bin/ogr_fdw_info
FileSize35784
MD5F60D6ACF0FA9779B9FE512C919E57AD5
SHA-17659C4AD39C5566353BCB2B05D6155AD8D6D062E
SHA-256A8964F53B7A606BFFB305538230E4A1E64883C753748D6CB4790EA2FE8F31C31
SSDEEP768:ltdpWmM5HV1jbTLD7zrjbTLD7zrjOm+WuGe2Om+WuGe2Om+WuGe2Om+WuGe25Bpr:5V+u7ftL5UCKmTq
TLSHT17AF2F86FB0604F3DCCD59030ADDF50330232A914F532562F1B49B2BB1D9B7B966B99A4
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/share/doc/postgresql-13-ogr-fdw/copyright
FileSize1620
MD5499B3FB5D2AAB1E6C06D1CCFBC800180
SHA-17F3316DC5C6DD7A5E955520CA0887D2C6ACC47C2
SHA-256A44FF01B48025CB7EB1CA15965214E09653E902221EE69DF88BD5380112C5D1E
SSDEEP24:gttzRRSoRhmKWgKrKUxrwNJHZH0yf3gtk1Hc1hMK9QH0sUv4kOk4/+/U3oq4sFig:s3qfxyJxl/El5QH0s5ANU3oWFig
TLSHT1B631C84FF64403632DE233E29854B8E9A7337489B0AB16C5F44EE2047B2A0ADC1FA464