Result for 48467DA5104FC580D666682401BC4026529A1542

Query result

Key Value
FileSize99448
MD579245B33F5C8CB126A355476DEA284E8
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-148467DA5104FC580D666682401BC4026529A1542
SHA-256092773A2C257E52745ED5C8A1366CFCBA121A131BBDC2C36B68D339CAFF4ED1C
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/ogr_fdw.bc
FileSize65004
MD5584F1C4C2DF8CCDA3D26B3E04ED8309D
SHA-101621A9A94546BE247B2AE412732E4846CC11886
SHA-256AFE1B467FE7123028F5C55B892A67C7A8E9C1B93A6B689EA45BC0166451F2D4B
SSDEEP1536:VTxe5a05zWCq6QuN/Tx/zu1VUULBfijZepcDF8fJy:VTxe5a0lWCqQBVPyBfAef8
TLSHT198537B19B065C6D0D588163E8CBF12DD07A6B504CF09AB537399B72C7D30298FAB267D
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_deparse.bc
FileSize23980
MD5F2DDF1ACB7CA7386E3DB8EBCF9301C37
SHA-10C47B08C8F7FD52A3B4F460D4A0A2AD838033A02
SHA-25611BC1736A6E0F69F5C6F2C64587A252A80C345A9EADA30B348EA549645F79F92
SSDEEP384:kw4tMWHOyOXZw1/fx5KJ0r3UkNzE+WEc6rVe7v3KnsB5Ql:dheOK1RsJGXNljW7vasBGl
TLSHT14AB27C2DF5A54193C888123D4C7F02DB47E7F449EF0492937698672CAEB1384CAB2A7D
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_func.bc
FileSize6020
MD5D2D5F5C4D2AC069FC35DF9ADC2156C4A
SHA-1AFD76F7FF2796E5BFFE9BDE40207728D83B9F57A
SHA-256FC74AED9B9B61AC7CE139249380A5492435FB1764E02DC550CC9DFF4B8B58F27
SSDEEP96:k59cXSFkqeJ7WSYJ7WS89HTn3eIKjr695Q1AKtZDy+uYym1FFastoYqXWQoYmwg4:krcqe7Y78tr3Ij+Y1AKtTUCisEg4
TLSHT1AEC11A6972A81291C259173C9CAD0289273DDD089FD9BB877355763CFFB121EBD00872
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/ogr_fdw.so
FileSize67600
MD56E70DEFDD24473A5F48BE6FA82535E1B
SHA-1A224101AF30204B80F3D2539900CE12FB2BEC7A4
SHA-2562BF6D98F995AAB702E8D3A2337262EA70FC99DB3CAD3A00C1AEBD2B77D4439B1
SSDEEP768:5C8QR/eVLc3GvD3Z8g//iojQCH6OSJ2s53nzMR6ybczMA:5CDR/Qc3GvDprQCmNzO9A
TLSHT15963F992EF001F12D0D68E3584BED171367C6D177640C792DA5C9A99BE2B9CF0AC7A0A
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw.index.bc
FileSize10204
MD530787310AE661E67005259F66046B554
SHA-1C0301BD3C69BE0E8BA6E66E008B2C17A42CA2563
SHA-25678222AAF515CE55007C229C6C662576A8FA3AC45F424C5326160601245BF0E4B
SSDEEP192:DE3BlwKl6JeN3w/BK+8VepeU7vgkoJrmvcnK4Nvgx768wvmFjM/mQ8cob:Dhm6Y9w/I+5peU7P4rm0nRE75NFg/mQy
TLSHT19B227DD6E26980919507F1D2C8AFAEFA52E4105302BA54E3F8C8BF53369376D2ADD530
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/stringbuffer_pg.bc
FileSize10356
MD502C84D9E49909BE00B34B0D2E4A9E0F7
SHA-1596C7798DC0ACCA60CE1D8B9D4C68FEEEA538B43
SHA-25678914279DA1613DA1333276C17054C1761A002EDD6CD5EA99A84BF1DF95D5B44
SSDEEP192:knYoUtr3m1Yb7Qrtr3Nl4nNKtT8aGkihquOwNzxTgOOVuTWNJMLO:knYogr3vQhr3n4kGkFuOwNzxThOkWF
TLSHT12A223D2FF1584B91C18853381CFB028FA7AED844DF64727BE7B69E7CBDA11279460901
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_common.bc
FileSize15320
MD5CAE0A82C2D7CEA544473FE0A6945D69C
SHA-113A9A0CF48215F82B273ECA2F381E8DAF1F1038E
SHA-256D059F4C713B982BD4CCBB4A97B8AE7A7E866F3EB222C4D7F53B7F989F04A304E
SSDEEP192:kEcn3r38YfrvhPnP0CipCOUJKtTFRHCxYhsjDM1V74GSRY/DPxxcYGdicz356yK:kEc3r35FcPlZCxYhiMT4MDUYiiCUd
TLSHT10962F82EB6958BD5C884523E597F02CA83B6F509DF12A3432698773C7D71209E9B293C
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
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
Key Value
FileName./usr/lib/postgresql/13/bin/ogr_fdw_info
FileSize33528
MD50D81B46E5A54DB105392214570A13187
SHA-16B17EB1C2778B1579F467CA1AA44EE22D1311ECD
SHA-25641437DEE2346C8584F05917DE0437B766E747A58DD9FE7C4100A335D6B31F4E2
SSDEEP384:IDIAGWf469+Y8DCUnKmAkiVFm4ODPRQ1tb/q3U5pg:ID1pw69+7DtOkmFmJPRYtbyUP
TLSHT1ECE2C5B7EB042F26DCC6AE35851EA03A167D3C45EB11C353DA48A6F92E366C94ED0C4D