postgresqltuner
Serendipity
Our great sponsors
| postgresqltuner | Serendipity | |
|---|---|---|
| 3 | 3 | |
| 2,551 | 197 | |
| - | 1.5% | |
| 0.0 | 8.4 | |
| 4 months ago | 23 days ago | |
| Perl | PHP | |
| GNU General Public License v3.0 only | 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.
postgresqltuner
- Postgresqltuner: Analyse Your PostgreSQL Database
-
In MySQL, never use “utf8”. Use “utf8mb4”
Are the DBA's on this thread committing code to the MySQL [1] and Postgres [2] tuner scripts that give new DBA's all your learned advise and battle hardening experience? Or at least a repo with the same objectives?
[1] - https://github.com/major/MySQLTuner-perl
[2] - https://github.com/jfcoz/postgresqltuner
- Is there any tool I can use to see what improvements can be made to a db?
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?
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.
laravel-commonmark-blog - A simple filesystem-based, SEO-optimized blog for Laravel using CommonMark.
kanban-board - Single-click full-stack application (Postgres, Spring Boot & Angular) using Docker Compose
Luminosity - Luminosity – a modern style blogging platform
netdisco - A web-based network management tool.
TravianZ - Travian T3.6 Clone in PHP
pgbadger - A fast PostgreSQL Log Analyzer
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.
apache2buddy - apache2buddy
RSS-Bridge - The RSS feed for websites missing it
pgaudit_analyze - PostgreSQL Audit Analyzer
docker-postgres-upgrade - a PoC for using "pg_upgrade" inside Docker -- learn from it, adapt it for your needs; don't expect it to work as-is!