Skip to content

Pigsty Blog Articles

  • Switzerland Mandates Open-Source for Government Software

    In Database

    Open Source

    Featured Image for Switzerland Mandates Open-Source for Government Software

    Switzerland's government leads the way with open source legislation, showing IT developing countries how to ensure software sovereignty and control. True autonomy and control stem from "open source communities," not some "nationalist" style "domestic software."

    Switzerland's government leads the way with open source legislation, showing IT developing countries how to ensure software sovereignty and control. True autonomy and control stem from "open source communities," not some "nationalist" style "domestic software."

  • Blue Screen Friday: Amateur Hour on Both Sides

    In Cloud

    Cloud-ExitCloudflare

    Featured Image for Blue Screen Friday: Amateur Hour on Both Sides

    Both client and vendor failed to control blast radius, leading to this epic global security incident that will greatly benefit local-first software philosophy.

    Both client and vendor failed to control blast radius, leading to this epic global security incident that will greatly benefit local-first software philosophy.

  • Pigsty v2.7: The Extension Superpack

    In Pigsty

    Pigsty

    Featured Image for Pigsty v2.7: The Extension Superpack

    Pigsty v2.7 bundles 255 PostgreSQL extensions, plus Docker templates for Odoo, Supabase, PolarDB, and Jupyter, with new PITR dashboards.

    Pigsty v2.7 bundles 255 PostgreSQL extensions, plus Docker templates for Odoo, Supabase, PolarDB, and Jupyter, with new PITR dashboards.

  • MySQL is dead, Long live PostgreSQL!

    In Database

    DatabaseMySQLPostgreSQL

    Featured Image for MySQL is dead, Long live PostgreSQL!

    This July, MySQL 9.0 was finally released—a full eight years after its last major version, 8.0 (@2016-09).

    This July, MySQL 9.0 was finally released—a full eight years after its last major version, 8.0 (@2016-09).

  • CVE-2024-6387 SSH Vulnerability Fix

    In Database

    Vulnerability

    Featured Image for CVE-2024-6387 SSH Vulnerability Fix

    This vulnerability affects EL9, Ubuntu 22.04, Debian 12. Users should promptly update OpenSSH to fix this vulnerability.

    This vulnerability affects EL9, Ubuntu 22.04, Debian 12. Users should promptly update OpenSSH to fix this vulnerability.

  • Self-Hosting Dify with PG, PGVector, and Pigsty

    In PostgreSQL

    PostgreSQLDockerPigstyApp

    Featured Image for Self-Hosting Dify with PG, PGVector, and Pigsty

    Dify is an open-source LLM app development platform. This article explains how to self-host Dify using Pigsty.

    Dify is an open-source LLM app development platform. This article explains how to self-host Dify using Pigsty.

  • Can Oracle Still Save MySQL?

    In Database

    DatabaseMySQLOracle

    Featured Image for Can Oracle Still Save MySQL?

    Percona founder Peter Zaitsev publicly expressed disappointment with MySQL and Oracle, criticizing the declining performance with newer versions.

    Percona founder Peter Zaitsev publicly expressed disappointment with MySQL and Oracle, criticizing the declining performance with newer versions.

  • Oracle Finally Killed MySQL

    In Database

    DatabaseMySQLOracle

    Featured Image for Oracle Finally Killed MySQL

    Peter Zaitsev, founder of Percona, criticizes how Oracles actions and inactions have killed MySQL. About 15 years after acquiring Sun and MySQL.

    Peter Zaitsev, founder of Percona, criticizes how Oracles actions and inactions have killed MySQL. About 15 years after acquiring Sun and MySQL.

  • MySQL Performance Declining: Where is Sakila Going?

    In Database

    DatabaseMySQLPerformance

    Featured Image for MySQL Performance Declining: Where is Sakila Going?

    Higher MySQL versions mean worse performance? Percona monitoring shows slow migration from 5.7 to 8.x. PostgreSQL is pulling ahead.

    Higher MySQL versions mean worse performance? Percona monitoring shows slow migration from 5.7 to 8.x. PostgreSQL is pulling ahead.

  • PGCon.Dev 2024, The conf that shutdown PG for a week

    In PostgreSQL

    PostgreSQLPG-Ecosystem

    Featured Image for PGCon.Dev 2024, The conf that shutdown PG for a week

    Experience & Feeling on the PGCon.Dev 2024

    Experience & Feeling on the PGCon.Dev 2024

Was this page helpful?