Result for 7EA03B090F2F91F8F1D5CFB581DAA21379CD34F2

Query result

Key Value
FileSize98328
MD5A90CCE833FFCD629416072C3E7595C29
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-13-ogr-fdw
PackageSectiondatabase
PackageVersion1.1.0-1
SHA-17EA03B090F2F91F8F1D5CFB581DAA21379CD34F2
SHA-256BD6D8B21E4B0BB6EE9A58D2750547274BAD23BA75C296018C19AFDDF90CA09B7
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/13/lib/bitcode/ogr_fdw/stringbuffer_pg.bc
FileSize10344
MD5290C2F0562709917E0E35E3C3BE8B1CC
SHA-13AF9994415B1C69CBBFA3638269CC5C60EE28115
SHA-25673D48C45BD355DF08A1F88D16632B2DC1E72DD833DFAD17E5A85DA223A1C279B
SSDEEP192:kQHvrcIDtr32YvFo+7KtTE0Cte1qChTW6JMLm:kQwI5r3PJt+1qCVWI
TLSHT13E222C3FF19C5B50C51D033D4CEB459DF2AD95448F35A76BFBA2AA2C7EA01399890111
Key Value
FileName./usr/lib/postgresql/13/lib/ogr_fdw.so
FileSize62012
MD580EA1DB8285313467B91D3F3F3169FAB
SHA-19A30CC8D474FCBCFC4B2F5067B38B8B3EB0AD5FB
SHA-256FB2F67573E61D01C925434DEADFD1BC0D5EBF4BABF09EF94CD451E6A9FADAF80
SSDEEP1536:RrUnZaEwCxi5wn46cP7TtmFAOLdYCFQSQwC2gK5hRTjVknqSTLxDTiuC7NhTkIrx:RrUnZaEwCk5wn46cjTtmFAwdYCFQSBCx
TLSHT18753D817EF009F62C4C7CC30081EC65296FEAC5F61ACB6A7B82CC9497F52A195CE7598
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/bitcode/ogr_fdw/ogr_fdw_common.bc
FileSize15936
MD5F31E164C3844B949A908B8A944C4C483
SHA-1E747E93A5CC3631531A0D3AEB03031587CAB6CB4
SHA-25613D216AB8E7E095F904C2B0FF983D8C3973C19FF1D7725BD9CD45BF49ECE6270
SSDEEP192:kMEGr3xKhOkfx07SbkGvCbYzKtTjQCQqIFCa6/3lyYATLLFGSRY/VgecYGdici3F:kM9r3M/xyBQzI3i/MWYii/oi
TLSHT1966219397AA48BA1C588023F087F419E5659F908DF37D29376E9733D6D71104EAB0875
Key Value
FileName./usr/lib/postgresql/13/bin/ogr_fdw_info
FileSize23856
MD592E1B337353EEC11A17726936D8ABD64
SHA-14F1373A61834295B6267532564606DA25AF52225
SHA-25646B311521710CB7B6B46D0AF6675603E32B0815B22826AE2E6BC04523A5544E1
SSDEEP384:3ejlro69+BBnqBhwPHyKdv/mB76Mt+/gL5auLqqgqp+614FMecnsujEr5hvz7W9r:3K9o69+nqBhwPHyKdvel6Mt+/gL5au+K
TLSHT145B2931AAF505FD2C4C6CC31496FA34353BFAD9EE0A4A373E45CC9842D42B8A5DE7885
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/share/lintian/overrides/ruby-narray-miss
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/ogr_fdw_func.bc
FileSize6028
MD56F44046CD977B4F119EDC5542D90512A
SHA-17F4FEDA7D48E3F33EFD430A3387A702FECA7193B
SHA-256A5C98085FF35F3F453DB021205D8E85D303CD243DC38237E8BF49D9E94CF1036
SSDEEP96:kQS9XJxc21CRNJ7WmzJ7Wmr9HTn3y3fGL3FTYKtZDy+KUzTcyoYqXWjhoYmwgbK:kQ2gRNvzvrtr3egF0KtTbTHVg
TLSHT12AC1F91672981EA1C25D16398C6D82C96329EB08DF66AB43A2597B2CFEF021EB450173
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_deparse.bc
FileSize23856
MD59984D4A4478DF31F2C0144C8E2A1EBED
SHA-18445BFE2DE1D8BC3B22B614F9CDF14AD03F5DB78
SHA-256F1222DC810F74F6A772C0DCACE54468231B00FC0DB60E9ED3BA36E7302A30224
SSDEEP384:kgO7qsQFgoUD307WuwXshEWEAgVmf9CwAsGdB5Qo1N:tq5tDk7jw8uWEArFAsoBGo1N
TLSHT18FB28D29F6F58652C908163E4D7F41DB185AFE88EF208287A29A373C7D732489F715B1
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw.bc
FileSize64332
MD59570AA32257AB943A5A451501193C2F5
SHA-17BC9F49ACC1F2E9D7C5A977061EBDA884CF30CBA
SHA-25605DEA65C4A4F235A7F5D9A8AD3FE2FCE63D91C8427F286E2D452E64418241581
SSDEEP768:c2YKAR0DGb10sq8lQuyxeXbw2i7KNDKqho5aJevIf3t9EyiZzuLWe68oi1R:Qg+10tjZxzhAhSaJcu3tayiZzaWF8J1R
TLSHT117538D397224D781D89C173F4CBF12CC06A6A604CF2296573796AB2C7D71344EA72AED
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/changelog.Debian.gz
FileSize1531
MD5BB1F73C9C547BA5937B8C85DE0B5261F
SHA-1909565F4A19E1251BBFB8405575B7DF832C3F60A
SHA-256DE88B285B27D97593EAC7EE1204BF1957EB89FE96FCA610778A6E0F7F8C73380
SSDEEP24:XIS1fX06dPb7fZft+H1P3ox8+pafYysZuAqAtS+niZL2P4Ad7Xe3iTkEH6MKbV3X:XIcHRft+HBYxd6Y6d07XeizHs3X
TLSHT14C31B599588D42B179AAA913850F494B6F6A6C43BEC30549E2F8034E90B8B6F4B69021
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw.index.bc
FileSize10252
MD55DC1CC4E6BBDCEF0BE68726D0557E7AB
SHA-19C18AF8BB92651427D2B310BA74DDB75FE7853F1
SHA-2563664BF9ADFD1495688ACC50A3CB0E7D7E81670F5EDC752007F1783B593BF79D3
SSDEEP192:lENPYLjfZNJSIcN2OMR4fQaS5ou1wJCHXi0V6ft4Fa33jh:4PYLjxnc64YaSWMKCHXFRFa3zh
TLSHT189227DCAD28EC1A0F21BA88C189F9EF991CA45139B63D5EFE96C3DA2394531D10CD835
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