Result for 71200EB3CDC5889CE90362C65825C806805DE349

Query result

Key Value
FileSize95808
MD519FFC554231A076300B0030AB11879AA
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-171200EB3CDC5889CE90362C65825C806805DE349
SHA-25657DFAD4844F3584CDC0F210DC0AAD0A18FE83C5BF0E355A47646481428D34CC8
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_deparse.bc
FileSize24064
MD545F0EE2F833C4C8B7233F728D07BA0AE
SHA-1FCCFE14AF2D252A937580B49602B92B8C28C3621
SHA-256C1AD8618ACD3781FD767E681D4726C0DBF8C10A9EDB761E7EC195AFE94D5B941
SSDEEP384:kWO7qsQFgoUD307WuwQor3hUWTEsBWWNJVcGwaqhLYCRRB5QE:Hq5tDk7jwbKYfIWN0jhLYwRBGE
TLSHT105B27B2EF5A18252C848073D5DBF01971BE6B588EF10938BA64E773C7DB22849B32675
Key Value
FileName./usr/lib/postgresql/13/lib/ogr_fdw.so
FileSize42460
MD541E89E42CBBA9E768A400FBAA5EE1696
SHA-1E99F5FBD860E5EC42EA8E9880BB0E81EC3D4330C
SHA-256DB60373B577C38DF1B0D7129F838A65DA6DF092C4BAB232B56040828A29CC3BD
SSDEEP768:tuIDU8VDSuhosqerRlOlNo85z8YvaYeKiTc/FQ89o2fEjaluaY/KmxuzTR6YIobK:Q18Dr4sRwlNoA8YvaYNiTKQ8mBaE/Kkj
TLSHT1301329EBF10B1533C88A13720BE34C021A11559AD6953FD27158F97B4F6E618ECAAF74
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
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/stringbuffer_pg.bc
FileSize10616
MD5E49B809339D77539FCDDAD74BE3391E2
SHA-1006532093F8466F911810B0DA420F39DF1E714EB
SHA-256BC32F1354DC2419AAA1694E34EDA1238700ADA7507268A31F402EF66A0266C28
SSDEEP192:kmOvh7yKcWYb7rTRv+KtTvuCnyzxUkkKNjDQTWPJML:kmeU3XrTRvjnkYKNvsW
TLSHT144223A1FB3AC9A51D1491F3C8CE7419DC2AAB4848F20E7A777A61B3CAEF103E58D1156
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.index.bc
FileSize10252
MD54A0EAB52351DE5C7B739E3EB192B33B7
SHA-19009136C62067501FA674F799383619415D40A4C
SHA-256B3D15A3910FB0B4F0CE46971B776D696F1B89DED9FD104D83403805152CC2EF6
SSDEEP192:jIqNZ5N6lyZhc+K46grps/+uzrOevhlrpEJK1cgal9ik+gPiIjEJVAindP/05Vl+:96AhF6gts1lv3rWtik+gPiIuVAAdwI
TLSHT16D228CD2F3CD8526D84BD2C485DF4CFCA8E4702B4365819780AEBD473A5232C84AE63D
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/ogr_fdw_func.bc
FileSize6140
MD5CCDDABD0BA5E07EB17681937E6CE8E69
SHA-1557D1BE7E763999097D79C1D83D2962121CDF351
SHA-2566D696282F0B09DC35E6C9367696B09D08DE3B5D3C8EA094AC8003CF3B82AB3FC
SSDEEP96:kn9XJxc21QJ7WEN/+/Eh7yV9HTn3ZHPrnw5KtZDy+uMgJP7toYqXWri5oYmwgb1h:k9+/V5h7yVtr3Zw5KtTfYP74tgT
TLSHT12AC1191B73A405D2C69E073A9CAE81CE2736F3088F56A75776557A2CFEB031EA4005B7
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/13/lib/bitcode/ogr_fdw/ogr_fdw.bc
FileSize64524
MD59E4F476E66F3051BEDFD09F00002EBD0
SHA-110463E08C90524EBA85F81059D7AFDEF0A96EEF1
SHA-2561239C9488A1DE6E1F33FAF9224B3FB3354402268FF3759BFF9D87FBDFF03106D
SSDEEP768:KPVYKARTHSAIyWy7eo4IfV9HSz/l/uSCPGmHUeKuJIQch9oynZt5o5e68okeJ2:NtT71H4unGKUqxc4ynZt5o5F8AJ2
TLSHT1AD536C2E75108681E84C273E5CBF1ACE07F6A644CF069657779A976C3C31344EA72ABC
Key Value
FileName./usr/lib/postgresql/13/bin/ogr_fdw_info
FileSize18228
MD52C0E24EE7239031E85DBD73E78046CA2
SHA-1A2E04708376009245072BB9D221083B98BA545A4
SHA-2566AE40E90DD93698E01316D0BB4769B32F35D423D039BF0834BAFDE9DC41887AF
SSDEEP384:AK9caXmrmylekHo6/A+Oa7uOnN5MXGlKa4+MSQWEqIOwtNDVbPCm+8:AIv2rmyleUtAON5MXG0a4+MSQWEqIOww
TLSHT15482F887A242C873DDC5BA7A74A749024329D39ECDA74FD3640836640F8EB1BEDE5B50
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_common.bc
FileSize16120
MD52BAB8347421582304507E887FA1771C8
SHA-1D8F3FACC80A23232EADB84834622B6B47E33EF0F
SHA-256BCCDF508350D89F77FC1EEDC6C76D6D4123F1DDE57624B0219D7378DFBA3297A
SSDEEP384:k1ZUYr315Hx1L/+26QbXA3ZbkkyUyMfWYii/QdW:AyC15RF+2pTA3nWRi/QdW
TLSHT13F72F72BBA918791D694523E187F018F97B9F508CF1B92933B9C773C6970144EAB087A
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/copyright
FileSize1620
MD5499B3FB5D2AAB1E6C06D1CCFBC800180
SHA-17F3316DC5C6DD7A5E955520CA0887D2C6ACC47C2
SHA-256A44FF01B48025CB7EB1CA15965214E09653E902221EE69DF88BD5380112C5D1E
SSDEEP24:gttzRRSoRhmKWgKrKUxrwNJHZH0yf3gtk1Hc1hMK9QH0sUv4kOk4/+/U3oq4sFig:s3qfxyJxl/El5QH0s5ANU3oWFig
TLSHT1B631C84FF64403632DE233E29854B8E9A7337489B0AB16C5F44EE2047B2A0ADC1FA464