xzcat program about mobilitydb

[estebanzimanyi]

Please see the note I put on the closed issue about zstd which is available on 3.15
https://cmake.org/cmake/help/latest/release/3.15.html?highlight=zstd

[cvvergara]

Can you give me a link to the issue you mention?

[estebanzimanyi]

Last comment in #85

…

On Thu, Jul 29, 2021 at 8:33 PM Vicky Vergara ***@***.***> wrote: Can you give me a link to the issue you mention? — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#109 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AGNHMBU3BDHEMYWI3VN5MMDT2GNGLANCNFSM5BGWYFOQ> .

[cvvergara]

Link to comment:
#85 (comment)

This is what I found about xy files:
https://fileinfo.com/extension/xz
So using something specific that works, say for my computer, it might not work to other systems.
As Regina mentions in this mail:
https://lists.osgeo.org/pipermail/postgis-devel/2021-July/029058.html

I think using sed and awk in a cmake project is a big NO NO.

Its the same thing for xzcat, the no no, is that they do not exist in other systems.

That comment has a link to cmake 3.15, if someone is to package with, say bionic, the cmake that they woul be using is 3.10
https://packages.ubuntu.com/bionic/cmake
So if you wants minimum cmake 3.15 then it wouldn't be packaged for bionic (which hasn't reached its EOL).

This is what currently pgRouting has as minimum in order for it to be packaged to several others systems:
https://github.com/pgRouting/pgrouting/blob/main/CMakeLists.txt#L1

I pumped it up in mobilitydb from 3.1 to 3.2
https://github.com/MobilityDB/MobilityDB/blob/master/CMakeLists.txt#L1
https://github.com/MobilityDB/MobilityDB/blob/develop/CMakeLists.txt#L1

Which cmake to be the minimum one, must not be taken lightly, will affect to which systems you are willing to support.

[estebanzimanyi]

I think we can simply change xzcat by gzcat. We used xz for its reduced size. For example, compressing the file test/general/data with both xz and gzip shows the difference

-rw-r--r-- 1 esteban esteban 2524628 Jul 27 10:46 load.sql.xz
-rw-r--r-- 1 esteban esteban 3947025 Jul 30 10:25 load.sql.gz

Therefore we can simply switch to gzip to enable multiplatform builds. In particular MSYS2 supports gzip but does not have the command gzcat. However, this is not a problem since it is equivalent to gunzip -c.

Just out of curiosity, which feature required to move cmake from 3.1 to 3.2?

[cvvergara]

abd5277

[estebanzimanyi]

Muchas gracias !

[estebanzimanyi]

I found out that MSYS2 comes with xz
https://packages.msys2.org/base/mingw-w64-xz
and MacOS also
https://formulae.brew.sh/formula/xz
So I think we can leave xz for the moment.

[estebanzimanyi]

PR #155