[postgis-users] Relationship between PostGIS, Azure and its various components

[Imre Samu]

>  I would like to see that PostgreSQL/PostGIS can play an important role
on the Azure.

As I see
Microsoft investing a lot of money in the PostgreSQL
- acquired Citus Data  (2019.01)  https://github.com/citusdata
- and supporting three key PostgreSQL committers
https://www.citusdata.com/blog/2020/03/03/azure-and-postgres-committers/

And PostGIS (+postgis_sfcgal;postgis_topology )  on the supported extension
list ..
https://docs.microsoft.com/en-US/azure/postgresql/concepts-hyperscale-extensions

Imre


Shaozhong SHI <shishaozhong at gmail.com> ezt írta (időpont: 2020. szept. 8.,
K, 23:24):

>
>
> On Tue, 8 Sep 2020 at 20:49, Regina Obe <lr at pcorp.us> wrote:
>
>> Shao,
>>
>>
>>
>> Not sure the question you are asking.  Hopefully this helps
>>
>>
>>
>> There are 2 kinds of Azure that PostGIS can exist in
>>
>>
>>
>> Azure Database for PostgreSQL --  PostGIS is an offered extension   --
>> Database as a Service
>>
>> Azure Server – you can spin up a server like Ubuntu on Azure
>> infrastructure and install your  own PostgreSQL and PostGIS.
>>
>>
>>
>>
>>
>> If you go with DbaaS I think it’s much more expensive than just an Azure
>> Server, but you get stuff like simpler scalability and mirroring.  Aside
>> from expense you are stuck with whatever version of PostGIS they give you
>> and have limited extension offerings.
>>
>>
>>
>> Azure Server – cheaper more freedom to install the version of PostgreSQL
>> and PostGIS you want as well as much more freed of installing extensions
>> and accessing the network.
>>
>>
>>
>> --This same statement can be said about Amazon or Google offerings.
>>
>
> Hi, Regina Obe,
>
> Thank you.
>
> Some enterprises/organisations are implementing Azure, and get data at one
> place.
>
> My gut feeling is that a lot of these components on Azure may not be able
> to offer what PostgreSQL/PostGIS can offer.  I am trying to see how best
> PostgreSQL/PostGIS can play an important role on the Azure and interplay
> and interoperate with other components.
>
> Obviously, many organisations have a wide range of types of data.  I would
> like to see that PostgreSQL/PostGIS can play an important role on the Azure.
>
> We must have some strong and factual points in hand to persuade others.
> It is along this line that I am thinking.
>
> Regards,
>
> Shao
>
>
>>
>>
>> *From:* postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] *On
>> Behalf Of *Shaozhong SHI
>> *Sent:* Tuesday, September 8, 2020 1:58 PM
>> *To:* PostGIS Users Discussion <postgis-users at lists.osgeo.org>
>> *Subject:* [postgis-users] Relationship between PostGIS, Azure and its
>> various components
>>
>>
>>
>> Rapid ICT transformation has led to the situation where PostGIS has to
>> exist with Azure and its various components.  A clear understanding of the
>> interplay of PostGIS and Azure and its components is of interest.
>>
>>
>>
>> Anyone has got experience and insight to share?
>>
>>
>>
>> Regards,
>>
>>
>>
>> Shao
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200909/58132609/attachment.html>