Result for 71B670CB6F1A817256EAA4A2DF05081AC7F59D89

Query result

Key Value
FileSize103548
MD518064C70A966E737C444FA486DC6DBD3
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-171B670CB6F1A817256EAA4A2DF05081AC7F59D89
SHA-256682C788B6D2DD4C03E5095964B90D28178EA526EFBC205D5D04C9DDD3C8726A4
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/share/doc/postgresql-14-ogr-fdw/changelog.Debian.gz
FileSize1631
MD520B13F809F60AC775A9B1E0A7318F312
SHA-1637298717C2311BABE75C971487902FFCAC419CB
SHA-256E8AADA811337EA2082B94BC74A0FAF87D54EFF11345E9C7A802EE6A72307FEB1
SSDEEP48:XkNTxssNxJ209jzGkJ70uFGIzJRByL7IKi07RvJ2wy:25N7n5J70ozJRB6Xp7y
TLSHT14131EAA6D717D0D3B960E70621DEEE7F153ADD99B15B8C033088B7A014221A0A24915D
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/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/14/lib/bitcode/ogr_fdw/ogr_fdw_common.bc
FileSize15560
MD533B3129D0EDB0F4309C64C953235082B
SHA-1906DDE95BFA576F442F8154C4F662003EFA85700
SHA-2562F17EFE0076DA72E40E6E661F5EA57A990FD82D12FC692E5F6FDA277269A9C19
SSDEEP384:kf6r3Orxx1zxvd8SoDkkyUyMD0+oYii/wdW:+EA9xvd8SOloRi/wdW
TLSHT18162D71AB6D486D2D296473D183F019B93BAF508DF1693933B8C333CADB1244E9B057A
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/ogr_fdw_func.bc
FileSize5888
MD503CCEC2E1AB034E6ED27B97967D23FD7
SHA-1F9307608031121EC1ACF98E587A44F7A49F64CBD
SHA-25676CD8E5448F4C92314AD67B2565488248BDCFCEBD354417A19FC604228618303
SSDEEP96:kS9XJxy8jtWHUlJ7W/mGJ7W/mr/9HTn3mexkrnwUdKtZDy+YsEg417NoYqXW1oYi:k2BlW/Wa/tr38w6KtTFEJ17Lg4M
TLSHT1ACC12B1A739815A3C15A0B3D9C6E43C92725F5089F56EB5376597A2CFEB135FF4000A3
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/ogr_fdw_deparse.bc
FileSize24520
MD599543B3175EF86777495631CCA47E786
SHA-11906A190D56D1DD9EC9309DE4A2EF79FBC166968
SHA-2562396FF9418FFCC9D552A20C4A0EB4635B311E036ECBBEA81EA910B9208F23D04
SSDEEP384:kU2rFoRpoXrNXk5LqFFBAcxr3//Ffr+BK2EQFG8Wccf52lHClrKKQnTbIdyLyUKi:J4Fc6rNC8FBn11qBZpWXfEdClrKKQnTZ
TLSHT124B28E1AF2B94692C954163C8CBF02C993D6A60DEF048347359A573C3E727489FB15BE
Key Value
FileName./usr/lib/postgresql/14/lib/ogr_fdw.so
FileSize71300
MD5C57CBE41D00CCAF9FC8102DA7C395C1C
SHA-106A9ECAA3124BD5EE15DF633B53F103610CE8D95
SHA-25685DA39E98CFA00A04500147803035FCDC60BFDDAFE4254D7B96F2BB8ED2C03F9
SSDEEP1536:lH00PTQPtXWpSvqTu4VnZkHnOIMaDHzJKPKYNgh:d00PTw1W8STu4VZHCB
TLSHT11563085FF746D4B1F29350F805CB56326E60068A9073F3E1FA893749B8623D5ED2A272
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/ogr_fdw.bc
FileSize64664
MD52D71E1B478483E91A19CD8FBFC620649
SHA-1E8C7C278E476EC471EA6FE089E2363799A46AD4F
SHA-256A244621200E6F1F750471235BE78E6D8BB5B1323654DFF352AA4D54CAC0E9B9A
SSDEEP768:UYSjVmwsDMnZ5ZTXye6mAX+0PFl7XD6dDsC0pAhC5JcFiie68CgeJy:mLVn9Tys0PXDEDsCcFCiiF8GJy
TLSHT187537E2E7660C391D409233E9CBE168E57F9624C9F0596973799A31C3C7124CFA72ABC
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/stringbuffer_pg.bc
FileSize9980
MD5DC510AED2FF1A1D66FDB6A4F112CF950
SHA-1B95F469F219153CCE4CE301ED62B04FC7F2A8CE9
SHA-256FA93A16FE5C66F339EF7AF29C0ED9A9D50F0DD7069F762561B86C1BDAA2D0EA1
SSDEEP192:ktb0cp+Ptr3inKtTFUDGyXjbFihQ0TWuCJMLh:ktx01r3iXqUBih3W
TLSHT10A222A2FB3DD4B90E5480B3D4CEB425DA36AF445CF159BA7BB92792CBDB013A94E0121
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/bin/ogr_fdw_info
FileSize30620
MD5E09D4E25470A5EAE81B9197B5A418622
SHA-191E84BC93CFCBF3EF58B8DA1B1EEC25C1A6BA63D
SHA-2560D67727E76AA2E28DEB72EAD52C972FCFCE3DA2B3B356D68968F385E3F49D6C0
SSDEEP768:MtuWmX8sROafTRlHCvdpXibsbLiqHWOZ71i1/z:fsotynbLi0W0
TLSHT1FBD2E85EF746C871E0B284FA84A72BB461706C49D137F6E3FA0D33581DB13D9E9152A8
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw.index.bc
FileSize10244
MD52DDAA493BEC1694CFEED2261A28E08E8
SHA-168625182B5B997176008A63E98FEF4125E3B6991
SHA-2561D8A877F3D6FDFF7FECB81FF5D14A45F2DF79C619334AC3710C1C0600F9611E8
SSDEEP192:7QeZmeXbfXUAB1R0A7XZYH9efTIb6Kn5Ujhht60RPFittoVY9Nb4/9Jztt5f:MQ/bX/E0fTQDw6QNnP3ztP
TLSHT156227ECAE3C98184E96B967250DF2EFC42D0411785BF44E34E197CA67E0932E119E5BD
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/copyright
FileSize1620
MD5499B3FB5D2AAB1E6C06D1CCFBC800180
SHA-17F3316DC5C6DD7A5E955520CA0887D2C6ACC47C2
SHA-256A44FF01B48025CB7EB1CA15965214E09653E902221EE69DF88BD5380112C5D1E
SSDEEP24:gttzRRSoRhmKWgKrKUxrwNJHZH0yf3gtk1Hc1hMK9QH0sUv4kOk4/+/U3oq4sFig:s3qfxyJxl/El5QH0s5ANU3oWFig
TLSHT1B631C84FF64403632DE233E29854B8E9A7337489B0AB16C5F44EE2047B2A0ADC1FA464