Re: [PyGreSQL] [ANNOUNCE] Release of PyGreSQL version 5.2.5

[Glyph]

> On Aug 28, 2023, at 8:09 PM, D'Arcy Cain  wrote:
> 
> On 2023-08-28 11:14, Christoph Zwerschke wrote:
>> Hi all,
>> PyGreSQL 5.2.5 with some bugfixes and support for Python 3.11 and Postgres 
>> 15 version has been released.
>> @D'Arcy: We currently have a problem with www.pygresql.org:
>> - the http link shows an old version
> 
> Sorry about that.  Must have missed the last announcement.  I have published 
> 5.2.5 now.
> 
>> - the https link does not work (wrong domain name in certificate)
> 
> It never did work.  We don't have a security certificate.  Since I am 
> covering the domain cost perhaps a few people can donate towards the 
> certificate.  It isn't all that much and if I get more than I need I will 
> just bank it for future renewals.
> 
> Best way is Paypal to bill...@vybenetworks.com.  Please donate at least a 
> dollar or else PayPal fees could take the whole thing.

Not that I would discourage anyone from contributing to the project to cover 
other costs, but TLS certificates are free, and have been for several years: 
https://letsencrypt.org/

If you can listen on port 80, you can grab a cert as simply as shutting down 
the web server for a minute, `pip install certbot`, then this command:

sudo certbot certonly --standalone --preferred-challenges http -d 
www.pygresql.org -d pygresql.org

That'll spit out a certificate.  Dig it out of the config/live directory (or 
reconfigure your web server to point at the paths there) and you'll be set.

If you can point it at a static directory that corresponds to your 
`.well-known` directory, you can set up a cron job to auto-renew every 80 days 
or so, and you don't need to touch it after that.

If your hosting provider is charging you extra for a cert in 2023, you should 
probably get a different provider :).  Read The Docs can host a 
Sphinx-generated website for free, with a custom domain; just go to 
 and add your domain 
in there.  And they'll take care of the certificate for you too ;).

-g

___
PyGreSQL mailing list
PyGreSQL@Vex.Net
https://mail.vex.net/mailman/listinfo/pygresql

Re: [PyGreSQL] [ANNOUNCE] Release of PyGreSQL version 5.2.5

[D'Arcy Cain]

On 2023-08-28 11:14, Christoph Zwerschke wrote:

Hi all,

PyGreSQL 5.2.5 with some bugfixes and support for Python 3.11 and 
Postgres 15 version has been released.



@D'Arcy: We currently have a problem with www.pygresql.org:
- the http link shows an old version


Sorry about that.  Must have missed the last announcement.  I have 
published 5.2.5 now.



- the https link does not work (wrong domain name in certificate)


It never did work.  We don't have a security certificate.  Since I am 
covering the domain cost perhaps a few people can donate towards the 
certificate.  It isn't all that much and if I get more than I need I 
will just bank it for future renewals.


Best way is Paypal to bill...@vybenetworks.com.  Please donate at least 
a dollar or else PayPal fees could take the whole thing.


--
D'Arcy J.M. Cain  |  Democracy is three wolves
http://www.druid.net/darcy/|  and a sheep voting on
+1 416 788 2246 (DoD#0082)(eNTP)   |  what's for dinner.
IM: da...@vex.net, VoIP: sip:da...@druid.net

___
PyGreSQL mailing list
PyGreSQL@Vex.Net
https://mail.vex.net/mailman/listinfo/pygresql

[PyGreSQL] Roadmap for PyGreSQL

[Christoph Zwerschke]

Hi all,

the lastest release 5.2.5 of PyGreSQL now supports Python from 2.7 to 
3.11 and PostgreSQL from 9.0 to 15.


It has become a burden to test and created builds for this wide range of 
versions, some of which are not officially supported any more. I feel 
the time has come to de-support the older Python and PostgreSQL 
versions, particularly Python 2. This will slim down and simplify the 
code base and allow us to use new features (such as type hints).


My suggestions is to require Python >= 3.6 and PostgreSQL >= 10,
which is still very conservative.

My plan is to implement this in a new release 6.0, without adding any 
new features or breaking changes.


Version 6.1 can then add some of the backward compatible features that 
were originally planned for 5.3, and Version 7.0 will add features and 
make changes which may not be fully backward compatible.


I have already created a branch 5.2.x for bugfix releases, and will work 
on 6.0 in the main branch.


What do you think about this plan?

-- Christoph



___
PyGreSQL mailing list
PyGreSQL@Vex.Net
https://mail.vex.net/mailman/listinfo/pygresql

[PyGreSQL] [ANNOUNCE] Release of PyGreSQL version 5.2.5

[Christoph Zwerschke]

Hi all,

PyGreSQL 5.2.5 with some bugfixes and support for Python 3.11 and 
Postgres 15 version has been released.



@D'Arcy: We currently have a problem with www.pygresql.org:
- the http link shows an old version
- the https link does not work (wrong domain name in certificate)

The best solution would be if both of these URLS simply redirect
to https://pygresql.github.io/PyGreSQL/.

-- Christoph

___
PyGreSQL mailing list
PyGreSQL@Vex.Net
https://mail.vex.net/mailman/listinfo/pygresql