public inbox for [email protected]
help / color / mirror / Atom feedInclude h3-pg extension
9+ messages / 3 participants
[nested] [flat]
* Include h3-pg extension
@ 2023-11-04 02:44 Regina Obe <[email protected]>
2023-11-04 09:50 ` Re: Include h3-pg extension Christoph Berg <[email protected]>
0 siblings, 1 reply; 9+ messages in thread
From: Regina Obe @ 2023-11-04 02:44 UTC (permalink / raw)
To: [email protected]
I couldn't find this when searching, so assume it's not available yet on
apt.postgresql.org.
H3-pg is an Uber Hexagon Extension commonly used with PostGIS and is growing
in popularity.
It relies on postgis and postgis_raster extensions.
https://github.com/zachasme/h3-pg
Would you consider carrying it?
Thanks,
Regina
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Include h3-pg extension
2023-11-04 02:44 Include h3-pg extension Regina Obe <[email protected]>
@ 2023-11-04 09:50 ` Christoph Berg <[email protected]>
2023-11-05 00:37 ` Re: Include h3-pg extension Devrim Gündüz <[email protected]>
0 siblings, 1 reply; 9+ messages in thread
From: Christoph Berg @ 2023-11-04 09:50 UTC (permalink / raw)
To: Regina Obe <[email protected]>; +Cc: [email protected]
Re: Regina Obe
> I couldn't find this when searching, so assume it's not available yet on
> apt.postgresql.org.
>
> H3-pg is an Uber Hexagon Extension commonly used with PostGIS and is growing
> in popularity.
>
> It relies on postgis and postgis_raster extensions.
>
> https://github.com/zachasme/h3-pg
>
> Would you consider carrying it?
Hi Regina,
it looks like https://github.com/uber/h3 hasn't been packaged yet,
which makes this a bit more complicated.
I'll see if I can find the time to package both.
Christoph
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Include h3-pg extension
2023-11-04 02:44 Include h3-pg extension Regina Obe <[email protected]>
2023-11-04 09:50 ` Re: Include h3-pg extension Christoph Berg <[email protected]>
@ 2023-11-05 00:37 ` Devrim Gündüz <[email protected]>
2023-11-05 11:02 ` Re: Include h3-pg extension Christoph Berg <[email protected]>
0 siblings, 1 reply; 9+ messages in thread
From: Devrim Gündüz @ 2023-11-05 00:37 UTC (permalink / raw)
To: Christoph Berg <[email protected]>; Regina Obe <[email protected]>; +Cc: [email protected]
Hi Christoph,
On Sat, 2023-11-04 at 10:50 +0100, Christoph Berg wrote:
> it looks like https://github.com/uber/h3 hasn't been packaged yet,
> which makes this a bit more complicated.
>
> I'll see if I can find the time to package both
There are some overlapping files between h3 and h3-pg. I did not check
closely, but you may not have to package h3. Just a FYI.
Cheers,
--
Devrim Gündüz
Open Source Solution Architect, PostgreSQL Major Contributor
Twitter: @DevrimGunduz , @DevrimGunduzTR
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Include h3-pg extension
2023-11-04 02:44 Include h3-pg extension Regina Obe <[email protected]>
2023-11-04 09:50 ` Re: Include h3-pg extension Christoph Berg <[email protected]>
2023-11-05 00:37 ` Re: Include h3-pg extension Devrim Gündüz <[email protected]>
@ 2023-11-05 11:02 ` Christoph Berg <[email protected]>
2023-11-05 21:55 ` RE: Include h3-pg extension Regina Obe <[email protected]>
0 siblings, 1 reply; 9+ messages in thread
From: Christoph Berg @ 2023-11-05 11:02 UTC (permalink / raw)
To: Devrim Gündüz <[email protected]>; +Cc: Regina Obe <[email protected]>; [email protected]
Re: Devrim Gündüz
> There are some overlapping files between h3 and h3-pg. I did not check
> closely, but you may not have to package h3. Just a FYI.
It took me a while to figure out because it was hidden in an
unexpected location, but the reason h3-pg can be compiled without h3
is that it downloads it at build time:
CMakeLists.txt:
# Include core library
add_subdirectory(cmake/h3)
cmake/h3/CMakeLists.txt:
FetchContent_Declare(
h3
URL https://github.com/uber/h3/archive/refs/tags/v${H3_CORE_VERSION}.tar.gz
URL_HASH SHA256=${H3_CORE_SHA256}
)
FetchContent_MakeAvailable(h3)
Deleting the line from CMakeLists.txt made it properly use the
system-installed libh3.
Regina: postgresql-NN-h3 packages are in the repository.
Christoph
^ permalink raw reply [nested|flat] 9+ messages in thread
* RE: Include h3-pg extension
2023-11-04 02:44 Include h3-pg extension Regina Obe <[email protected]>
2023-11-04 09:50 ` Re: Include h3-pg extension Christoph Berg <[email protected]>
2023-11-05 00:37 ` Re: Include h3-pg extension Devrim Gündüz <[email protected]>
2023-11-05 11:02 ` Re: Include h3-pg extension Christoph Berg <[email protected]>
@ 2023-11-05 21:55 ` Regina Obe <[email protected]>
2023-11-05 21:56 ` Re: Include h3-pg extension Devrim Gündüz <[email protected]>
0 siblings, 1 reply; 9+ messages in thread
From: Regina Obe @ 2023-11-05 21:55 UTC (permalink / raw)
To: 'Christoph Berg' <[email protected]>; 'Devrim Gündüz' <[email protected]>; +Cc: [email protected]
> Deleting the line from CMakeLists.txt made it properly use the
system-installed
> libh3.
>
> Regina: postgresql-NN-h3 packages are in the repository.
>
> Christoph
Great thanks very much. I just tried and works great so far.
apt update
apt postgresql-16-h3
and was able to install with
CREATE EXTENSION h3_postgis CASCADE;
Devrim,
While I have you. I didn't check if yum.postgresql.org is carrying it.
Would be great if it did too.
Thanks,
Regina
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Include h3-pg extension
2023-11-04 02:44 Include h3-pg extension Regina Obe <[email protected]>
2023-11-04 09:50 ` Re: Include h3-pg extension Christoph Berg <[email protected]>
2023-11-05 00:37 ` Re: Include h3-pg extension Devrim Gündüz <[email protected]>
2023-11-05 11:02 ` Re: Include h3-pg extension Christoph Berg <[email protected]>
2023-11-05 21:55 ` RE: Include h3-pg extension Regina Obe <[email protected]>
@ 2023-11-05 21:56 ` Devrim Gündüz <[email protected]>
2023-11-05 22:00 ` Re: Include h3-pg extension Christoph Berg <[email protected]>
0 siblings, 1 reply; 9+ messages in thread
From: Devrim Gündüz @ 2023-11-05 21:56 UTC (permalink / raw)
To: Regina Obe <[email protected]>; 'Christoph Berg' <[email protected]>; +Cc: [email protected]
Hi,
On Sun, 2023-11-05 at 16:55 -0500, Regina Obe wrote:
> While I have you. I didn't check if yum.postgresql.org is carrying
> it. Would be great if it did too.
Pushed the packages a few mins ago:
h3, and h3-devel: h3 RPMs
pg-h3_XY : Extension RPMS
Regards,
--
Devrim Gündüz
Open Source Solution Architect, PostgreSQL Major Contributor
Twitter: @DevrimGunduz , @DevrimGunduzTR
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Include h3-pg extension
2023-11-04 02:44 Include h3-pg extension Regina Obe <[email protected]>
2023-11-04 09:50 ` Re: Include h3-pg extension Christoph Berg <[email protected]>
2023-11-05 00:37 ` Re: Include h3-pg extension Devrim Gündüz <[email protected]>
2023-11-05 11:02 ` Re: Include h3-pg extension Christoph Berg <[email protected]>
2023-11-05 21:55 ` RE: Include h3-pg extension Regina Obe <[email protected]>
2023-11-05 21:56 ` Re: Include h3-pg extension Devrim Gündüz <[email protected]>
@ 2023-11-05 22:00 ` Christoph Berg <[email protected]>
2023-11-05 22:30 ` RE: Include h3-pg extension Regina Obe <[email protected]>
0 siblings, 1 reply; 9+ messages in thread
From: Christoph Berg @ 2023-11-05 22:00 UTC (permalink / raw)
To: Devrim Gündüz <[email protected]>; +Cc: Regina Obe <[email protected]>; [email protected]
Re: Devrim Gündüz
> > While I have you. I didn't check if yum.postgresql.org is carrying
> > it. Would be great if it did too.
>
> h3, and h3-devel: h3 RPMs
> pg-h3_XY : Extension RPMS
5.11.23 22:55 Regina Obe pgsql-pkg- RE: Include h3-pg extension
5.11.23 22:56 Devrim Gündüz └─>
That must be a new record :D
Christoph
^ permalink raw reply [nested|flat] 9+ messages in thread
* RE: Include h3-pg extension
2023-11-04 02:44 Include h3-pg extension Regina Obe <[email protected]>
2023-11-04 09:50 ` Re: Include h3-pg extension Christoph Berg <[email protected]>
2023-11-05 00:37 ` Re: Include h3-pg extension Devrim Gündüz <[email protected]>
2023-11-05 11:02 ` Re: Include h3-pg extension Christoph Berg <[email protected]>
2023-11-05 21:55 ` RE: Include h3-pg extension Regina Obe <[email protected]>
2023-11-05 21:56 ` Re: Include h3-pg extension Devrim Gündüz <[email protected]>
2023-11-05 22:00 ` Re: Include h3-pg extension Christoph Berg <[email protected]>
@ 2023-11-05 22:30 ` Regina Obe <[email protected]>
2023-11-05 22:42 ` Re: Include h3-pg extension Devrim Gündüz <[email protected]>
0 siblings, 1 reply; 9+ messages in thread
From: Regina Obe @ 2023-11-05 22:30 UTC (permalink / raw)
To: 'Christoph Berg' <[email protected]>; 'Devrim Gündüz' <[email protected]>; +Cc: [email protected]
> Re: Devrim Gündüz
> > > While I have you. I didn't check if yum.postgresql.org is carrying
> > > it. Would be great if it did too.
> >
> > h3, and h3-devel: h3 RPMs
> > pg-h3_XY : Extension RPMS
>
> 5.11.23 22:55 Regina Obe pgsql-pkg- RE: Include h3-pg extension
> 5.11.23 22:56 Devrim Gündüz └─>
>
> That must be a new record :D
>
> Christoph
Yes that was quick. Thanks to both of you.
Devrim, just confirming you have it only for Rocky / Redhat/ CentOS 8 or above right.
Not seeing it for the 7 series. Which is fine, just confirming.
Thanks,
Regina
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Include h3-pg extension
2023-11-04 02:44 Include h3-pg extension Regina Obe <[email protected]>
2023-11-04 09:50 ` Re: Include h3-pg extension Christoph Berg <[email protected]>
2023-11-05 00:37 ` Re: Include h3-pg extension Devrim Gündüz <[email protected]>
2023-11-05 11:02 ` Re: Include h3-pg extension Christoph Berg <[email protected]>
2023-11-05 21:55 ` RE: Include h3-pg extension Regina Obe <[email protected]>
2023-11-05 21:56 ` Re: Include h3-pg extension Devrim Gündüz <[email protected]>
2023-11-05 22:00 ` Re: Include h3-pg extension Christoph Berg <[email protected]>
2023-11-05 22:30 ` RE: Include h3-pg extension Regina Obe <[email protected]>
@ 2023-11-05 22:42 ` Devrim Gündüz <[email protected]>
0 siblings, 0 replies; 9+ messages in thread
From: Devrim Gündüz @ 2023-11-05 22:42 UTC (permalink / raw)
To: Regina Obe <[email protected]>; 'Christoph Berg' <[email protected]>; +Cc: [email protected]
Hi Regina,
On Sun, 2023-11-05 at 17:30 -0500, Regina Obe wrote:
> Yes that was quick. Thanks to both of you.
I actually started working on them yesterday :-)
>
> Devrim, just confirming you have it only for Rocky / Redhat/ CentOS 8
> or above right. Not seeing it for the 7 series. Which is fine, just
> confirming.
Already stopped adding new packages to RHEL 7:
https://yum.postgresql.org/news/rhel7-postgresql-rpms-end-of-life/
Cheers,
--
Devrim Gündüz
Open Source Solution Architect, PostgreSQL Major Contributor
Twitter: @DevrimGunduz , @DevrimGunduzTR
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2023-11-05 22:42 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-11-04 02:44 Include h3-pg extension Regina Obe <[email protected]>
2023-11-04 09:50 ` Christoph Berg <[email protected]>
2023-11-05 00:37 ` Devrim Gündüz <[email protected]>
2023-11-05 11:02 ` Christoph Berg <[email protected]>
2023-11-05 21:55 ` Regina Obe <[email protected]>
2023-11-05 21:56 ` Devrim Gündüz <[email protected]>
2023-11-05 22:00 ` Christoph Berg <[email protected]>
2023-11-05 22:30 ` Regina Obe <[email protected]>
2023-11-05 22:42 ` Devrim Gündüz <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox