docker-postgres-upgrade
Serendipity
| docker-postgres-upgrade | Serendipity | |
|---|---|---|
| 4 | 3 | |
| 993 | 198 | |
| - | 1.5% | |
| 6.5 | 8.4 | |
| 3 months ago | 5 days ago | |
| Shell | PHP | |
| MIT License | BSD 3-clause "New" or "Revised" License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
docker-postgres-upgrade
-
When Did Postgres Become Cool?
Ah, looks like psql seems to have switched to actually using minor and major versions properly during the last two years - I remember the dance from the 9.x versions and postgres-upgrade [1].
In any case it's way more straightforward with mysql.
[1] https://hub.docker.com/r/tianon/postgres-upgrade
-
A PostgreSQL Docker container that automatically upgrades PostgreSQL
Related: https://github.com/tianon/docker-postgres-upgrade
-
I upgraded from Debian Bullseye to Bookworm, and it went very well
Also don't forget to pg_dump before the upgrade, as the binaries for previous Postgres version might not exist anymore after the upgrade... Otherwise, https://hub.docker.com/r/tianon/postgres-upgrade/ might be helpful (haven't used it though).
-
In MySQL, never use “utf8”. Use “utf8mb4”
> When you say "complex ride" what does that mean?
On managed postgresql services like RDS it's easy, yes, because Amazon does all of the nasty work for you and has already seen all the kinks you may run into.
If you are on your own and using Docker, you essentially need a third-party image that has the old and new binaries (https://github.com/tianon/docker-postgres-upgrade).
If you are on your own and are using distribution packages, it's more complicated (https://blog.samuel.domains/blog/tutorials/from-stretch-to-b...).
If you are on your own and use postgres from source, well... have fun, there's a reason why I prefer using distribution-maintained packages when possible.
Serendipity
-
Is it possible to create an RSS feed from a github page?
For a public repo the URL for the (Atom, not RSS) commit feed is org/repo/commits/master.atom, for example https://github.com/s9y/Serendipity/commits/master.atom for https://github.com/s9y/Serendipity. See https://github.community/t/rss-feeds-for-github-projects/292.
-
In MySQL, never use “utf8”. Use “utf8mb4”
https://github.com/s9y/Serendipity/blob/05f58f90d743fe9ade24... is just the detection function I wrote for a PHP blog engine to detect whether it would even be possible to use utf8mb4 on the system. We completely ran into this issue and didn't know how to handle it for literally years. Lots of blogs to migrate, and who knows whether it worked for all of them...
-
Chrome testing RSS-powered ‘Follow’ button
In addition to the answers you got refuting load as a problem: "Last updated since" headers are indeed a thing. Look for example at how RSS gets cached in wordpress [0] or the classical blog engine serendipity [1]. Also, push instead of pull is also common. Made popular for feeds by pubsubhubbub, since enterprise-ready renamed to WebSub [2]. Readers like bazqux do support that.
[0]: https://github.com/WordPress/WordPress/blob/270f2011f8ec7265...
[1]: https://github.com/s9y/Serendipity/blob/e2044472c202a8368774...
[2]: https://en.wikipedia.org/wiki/WebSub
What are some alternatives?
pgloader - Migrate to PostgreSQL in a single command!
laravel-commonmark-blog - A simple filesystem-based, SEO-optimized blog for Laravel using CommonMark.
MySQLTuner-perl - MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.
Luminosity - Luminosity – a modern style blogging platform
docker-pgautoupgrade - A PostgreSQL Docker container that automatically upgrades your database
TravianZ - Travian T3.6 Clone in PHP
postgresqltuner - Simple script to analyse your PostgreSQL database configuration, and give tuning advice
WordPress - WordPress, Git-ified. This repository is just a mirror of the WordPress subversion repository. Please do not send pull requests. Submit pull requests to https://github.com/WordPress/wordpress-develop and patches to https://core.trac.wordpress.org/ instead.
pgkit - Pgkit - Backup, PITR and recovery management made easy
RSS-Bridge - The RSS feed for websites missing it
PostgreSQL-Disaster-Recove
Adminer - Database management in a single PHP file