[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-devel
Subject:    Re: [postgis-devel] PSC Vote: Circle CI signup for Free plan
From:       "Regina Obe" <lr () pcorp ! us>
Date:       2023-08-25 22:18:52
Message-ID: 000001d9d7a2$21f13530$65d39f90$ () pcorp ! us
[Download RAW message or body]

This is a multipart message in MIME format.

[Attachment #2 (multipart/alternative)]
This is a multipart message in MIME format.


Imre,

 

Thanks for taking the lead on the docker-postgis work.  It's been great to see it \
flourish under your guidance.

 

Regarding Cirrus – we are already using that for postgis repo for testing MacOSX / \
FreeBSD.

I think we are already overtaxed on that so I'm fine with not using that for the \
docker-postgis repo.

 

I think our still best bet is to use CircleCI and use the work you have already put \
in it already in your tests and I think the

 

"Open source projects can access up to 400,000 credits per month (equivalent to \
80,000 build minutes) to use on Linux, Arm, and Docker."

 

Should be enough for our needs. The credits do seem more generous than Cirrus as I \
recall.



Travis was suggested as an option too by Even, but I think that is a no-go too since \
it would be more work to retool to work with that,

and moving the docker-postgis repo from postgis github org to osgeo github org, I see \
no benefit at this time in doing. 

OSGeo org might make sense though for the geo bundle you were detailing since \
pgrouting, MobilityDB, and PostGIS are all OSGeo projects or community projects.

 

Both pgRouting and MobilityDB are still community projects, but pgrouting I think we \
are close to completing incubation work. 

MobilityDB still has a ways to go, but is still an OSGeo community project.

 

That said, I'll give people one more week to express comments about this topic before \
I move forward with it.

 

Thanks,

Regina

 

From: postgis-devel <postgis-devel-bounces@lists.osgeo.org> On Behalf Of Imre Samu
Sent: Friday, August 25, 2023 2:34 PM
To: PostGIS Development Discussion <postgis-devel@lists.osgeo.org>
Subject: Re: [postgis-devel] PSC Vote: Circle CI signup for Free plan

 

Regina Obe <lr@pcorp.us <mailto:lr@pcorp.us> > ezt írta (időpont: 2023. aug. 22., \
K, 21:04)

The docker-postgis sub-group wants to start shipping ARM docker containers
and the easiest route for that would be to use CircleCI.

 

I'm currently working on expanding the docker-postgis code.

One of the most requested features right now by users is the Arm64/v8 (Aarch64) based \
postgis docker image.

( https://github.com/postgis/docker-postgis/issues/216  )


I've already built a working prototype on CircleCI. 
For further testing, we need to decide if we're going with this or if we need a \
different solution.

Comment: Because we need to give CircleCI access to Docker Hub for this, 

and we want to keep the process secure, it wouldn't be ideal to use our own developer \
accounts to create the images.

 

Some other updates I'm working on:

- Adding 'bookworm' support while maintaining existing 'bullseye' support.  ( \
15-3.4-bookworm , 15-3.4-bullseye )

  Later, we'll also support 2 alpine versions, similar to the upstream docker \
postgres repo we're building on. 


- We'll have expanded docker image tagging. (15-3.4-bookworm, 15-3.4.0-bookworm, \
15-3.4, latest )

- To keep the base postgis/postgis images small, I'm planning simple Debian-based \
(geo)bundle images built on them, 

  with features like pgRouting, MobilityDB, pg_h3, pgsql-gzip, pgsql-http, ogr-fdw, \
pointcloud, TimescaleDB, pgvector, etc. This area is still fluid though.

  ( 15-3.4-bundle-bookworm  )

 

I've got a minimal working prototype:

- docker images: https://hub.docker.com/r/imresamu/postgis

- code: https://github.com/ImreSamu/docker-postgis

 

I'm trying to expand the system so that if there's demand, we can easily create older \
Postgis versions like 3.3, 3.2, 3.1 based on Alpine.

I'm also thinking about a weekly auto-updated "postgis/postgis:*-master" version to \
support testing of other osgeos projects built on postgis.


CircleCI provides about 80,000 build minutes/month for open source. This should \
likely cover the docker-postgis sub-project's needs.

My developer account on CircleCI also received the same amount of open source \
credits/minutes.

 

In the https://circleci.com/pricing/ FAQ:

"""
What if I am building open-source?

CircleCI offers free access to compute time and resources for organizations on our \
Free plan. 

Open source projects can access up to 400,000 credits per month (equivalent to 80,000 \
build minutes) to use on Linux, Arm, and Docker. Open source Windows and macOS builds \
or private repositories can use the 30,000 credits offered in our free plan. If you \
are building a bigger open source project and would like the flexibility of our new \
plans, let us know how we can help you! + https://circleci.com/open-source/ 

"""

 

Another Arm64 Alternative: https://cirrus-ci.org/features/   \
https://cirrus-ci.org/blog/2023/07/17/limiting-free-usage-of-cirrus-ci/

 I haven't tested it, but it seems promising.

 

And there are other CI providers: https://wiki.postgresql.org/wiki/CI_Providers

 

If you have any related questions, I'm here to help.
Regards, 

   Imre 

 


[Attachment #5 (text/html)]

<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type \
content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 \
(filtered medium)"><style><!-- /* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
span.EmailStyle18
	{mso-style-type:personal-reply;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple \
style='word-wrap:break-word'><div class=WordSection1><p \
class=MsoNormal>Imre,<o:p></o:p></p><p class=MsoNormal><o:p>&nbsp;</o:p></p><p \
class=MsoNormal>Thanks for taking the lead on the docker-postgis work.   It's been \
great to see it flourish under your guidance.<o:p></o:p></p><p \
class=MsoNormal><o:p>&nbsp;</o:p></p><p class=MsoNormal>Regarding Cirrus – we are \
already using that for postgis repo for testing MacOSX / FreeBSD.<o:p></o:p></p><p \
class=MsoNormal>I think we are already overtaxed on that so I'm fine with not using \
that for the docker-postgis repo.<o:p></o:p></p><p \
class=MsoNormal><o:p>&nbsp;</o:p></p><p class=MsoNormal>I think our still best bet is \
to use CircleCI and use the work you have already put in it already in your tests and \
I think the<o:p></o:p></p><p class=MsoNormal><o:p>&nbsp;</o:p></p><p \
class=MsoNormal><i>"Open source projects can access up to 400,000 credits per month \
(equivalent to 80,000 build minutes) to use on Linux, Arm, and \
Docker."<o:p></o:p></i></p><p class=MsoNormal><o:p>&nbsp;</o:p></p><p \
class=MsoNormal>Should be enough for our needs. The credits do seem more generous \
than Cirrus as I recall.<i><br><br></i><o:p></o:p></p><p class=MsoNormal>Travis was \
suggested as an option too by Even, but I think that is a no-go too since it would be \
more work to retool to work with that,<o:p></o:p></p><p class=MsoNormal>and moving \
the docker-postgis repo from postgis github org to osgeo github org, I see no benefit \
at this time in doing. <o:p></o:p></p><p class=MsoNormal>OSGeo org might make sense \
though for the geo bundle you were detailing since pgrouting, MobilityDB, and PostGIS \
are all OSGeo projects or community projects.<o:p></o:p></p><p \
class=MsoNormal><o:p>&nbsp;</o:p></p><p class=MsoNormal>Both pgRouting and MobilityDB \
are still community projects, but pgrouting I think we are close to completing \
incubation work. <o:p></o:p></p><p class=MsoNormal>MobilityDB still has a ways to go, \
but is still an OSGeo community project.<o:p></o:p></p><p \
class=MsoNormal><o:p>&nbsp;</o:p></p><p class=MsoNormal>That said, I'll give people \
one more week to express comments about this topic before I move forward with \
it.<o:p></o:p></p><p class=MsoNormal><o:p>&nbsp;</o:p></p><p \
class=MsoNormal>Thanks,<o:p></o:p></p><p class=MsoNormal>Regina<o:p></o:p></p><p \
class=MsoNormal><o:p>&nbsp;</o:p></p><div style='border:none;border-left:solid blue \
1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid \
#E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b>From:</b> \
postgis-devel &lt;postgis-devel-bounces@lists.osgeo.org&gt; <b>On Behalf Of </b>Imre \
Samu<br><b>Sent:</b> Friday, August 25, 2023 2:34 PM<br><b>To:</b> PostGIS \
Development Discussion &lt;postgis-devel@lists.osgeo.org&gt;<br><b>Subject:</b> Re: \
[postgis-devel] PSC Vote: Circle CI signup for Free plan<o:p></o:p></p></div></div><p \
class=MsoNormal><o:p>&nbsp;</o:p></p><div><div><div><p class=MsoNormal>Regina Obe \
&lt;<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>&gt; ezt írta \
(időpont: 2023. aug. 22., K, 21:04)<o:p></o:p></p></div></div><div><blockquote \
style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in \
6.0pt;margin-left:4.8pt;margin-right:0in'><p class=MsoNormal>The docker-postgis \
sub-group wants to start shipping ARM docker containers<br>and the easiest route for \
that would be to use CircleCI.<o:p></o:p></p></blockquote><div><p \
class=MsoNormal><o:p>&nbsp;</o:p></p></div><div><p class=MsoNormal>I'm currently \
working on expanding the docker-postgis code.<o:p></o:p></p></div><div><p \
class=MsoNormal>One of the most requested features right now by users is the Arm64/v8 \
(Aarch64) based postgis docker image.<o:p></o:p></p></div><p class=MsoNormal>( <a \
href="https://github.com/postgis/docker-postgis/issues/216">https://github.com/postgis/docker-postgis/issues/216</a>&nbsp; \
)<o:p></o:p></p></div><div><p class=MsoNormal><br>I've already built a working \
prototype on CircleCI.&nbsp;<br>For further testing, we need to decide if we're going \
with this or if we need a different solution.<br><br>Comment: Because we need to give \
CircleCI access to Docker Hub for this,&nbsp;<o:p></o:p></p></div><div><p \
class=MsoNormal>and we want to keep the process secure, it wouldn't be ideal to use \
our own developer accounts to create the images.<o:p></o:p></p></div><div><p \
class=MsoNormal><o:p>&nbsp;</o:p></p><div><p class=MsoNormal>Some other updates I'm \
working on:<o:p></o:p></p></div><div><p class=MsoNormal>-&nbsp;Adding 'bookworm' \
support while maintaining existing 'bullseye' support.&nbsp; (&nbsp;15-3.4-bookworm \
,&nbsp;15-3.4-bullseye )<o:p></o:p></p></div><div><p class=MsoNormal>&nbsp; Later, \
we'll also support 2 alpine versions, similar to the upstream docker postgres repo \
we're building on.&nbsp;<o:p></o:p></p></div><div><p class=MsoNormal><br>- We'll have \
expanded docker image tagging. (15-3.4-bookworm, 15-3.4.0-bookworm, 15-3.4, latest \
)<br><br>- To keep the base postgis/postgis images small, I'm planning simple \
Debian-based (geo)bundle images built on them,&nbsp;<o:p></o:p></p></div><div><p \
class=MsoNormal>&nbsp; with features like pgRouting, MobilityDB, pg_h3, pgsql-gzip, \
pgsql-http, ogr-fdw, pointcloud, TimescaleDB, pgvector, etc. This area is still fluid \
though.<o:p></o:p></p></div><div><p class=MsoNormal>&nbsp; ( \
15-3.4-bundle-bookworm&nbsp; )<o:p></o:p></p></div><div><p \
class=MsoNormal><o:p>&nbsp;</o:p></p></div><div><p class=MsoNormal>I've got a minimal \
working prototype:<o:p></o:p></p></div><div><p class=MsoNormal>- docker images: <a \
href="https://hub.docker.com/r/imresamu/postgis">https://hub.docker.com/r/imresamu/postgis</a><o:p></o:p></p></div><div><p \
class=MsoNormal>- code: <a \
href="https://github.com/ImreSamu/docker-postgis">https://github.com/ImreSamu/docker-postgis</a><o:p></o:p></p></div><div><p \
class=MsoNormal><o:p>&nbsp;</o:p></p></div><div><p class=MsoNormal>I'm trying to \
expand the system so that if there's demand, we can easily create older Postgis \
versions like 3.3, 3.2, 3.1 based on Alpine.<o:p></o:p></p></div><div><p \
class=MsoNormal>I'm also thinking about a weekly auto-updated \
&quot;postgis/postgis:*-master&quot; version to support testing of other osgeos \
projects built on postgis.<o:p></o:p></p></div><div><p class=MsoNormal><br>CircleCI \
provides about 80,000 build minutes/month for open source. This should likely cover \
the docker-postgis sub-project's needs.<o:p></o:p></p></div><div><p \
class=MsoNormal>My developer account on CircleCI also received the same amount of \
open source credits/minutes.<o:p></o:p></p></div><div><p \
class=MsoNormal><o:p>&nbsp;</o:p></p></div><div><p class=MsoNormal>In the&nbsp;<a \
href="https://circleci.com/pricing/" \
target="_blank">https://circleci.com/pricing/</a>&nbsp;FAQ:<o:p></o:p></p></div><div><div><p \
class=MsoNormal>&quot;&quot;&quot;<br>What if I am building \
open-source?<o:p></o:p></p></div><div><p class=MsoNormal><i>CircleCI offers free \
access to compute time and resources for organizations on our Free \
plan.&nbsp;</i><o:p></o:p></p></div><div><p class=MsoNormal><i>Open source projects \
can access up to 400,000 credits per month (equivalent to 80,000 build minutes) to \
use on Linux, Arm, and Docker.<br>Open source Windows and macOS builds or private \
repositories can use the 30,000 credits offered in our free plan.<br>If you are \
building a bigger open source project and would like the flexibility of our new \
plans, let us know how we can help you!<br></i>+&nbsp;<a \
href="https://circleci.com/open-source/" \
target="_blank">https://circleci.com/open-source/</a>&nbsp;<o:p></o:p></p></div><p \
class=MsoNormal>&quot;&quot;&quot;<o:p></o:p></p></div><div><p \
class=MsoNormal><o:p>&nbsp;</o:p></p></div><div><p class=MsoNormal>Another Arm64 \
Alternative: <a href="https://cirrus-ci.org/features/">https://cirrus-ci.org/features/</a>&nbsp; \
&nbsp;<a href="https://cirrus-ci.org/blog/2023/07/17/limiting-free-usage-of-cirrus-ci/ \
">https://cirrus-ci.org/blog/2023/07/17/limiting-free-usage-of-cirrus-ci/</a><o:p></o:p></p></div><div><p \
class=MsoNormal>&nbsp;I haven't tested it, but it seems \
promising.<o:p></o:p></p></div><div><p \
class=MsoNormal><o:p>&nbsp;</o:p></p></div><div><p class=MsoNormal>And there are \
other CI providers:&nbsp;<a \
href="https://wiki.postgresql.org/wiki/CI_Providers">https://wiki.postgresql.org/wiki/CI_Providers</a><o:p></o:p></p></div><div><p \
class=MsoNormal><o:p>&nbsp;</o:p></p></div><div><p class=MsoNormal>If you have any \
related questions, I'm here to help.<br>Regards,&nbsp;<o:p></o:p></p></div><div><p \
class=MsoNormal>&nbsp; &nbsp;Imre&nbsp;<o:p></o:p></p></div><div><p \
class=MsoNormal>&nbsp;<o:p></o:p></p></div></div></div></div></div></body></html>



_______________________________________________
postgis-devel mailing list
postgis-devel@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-devel


[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic