> ## Documentation Index
> Fetch the complete documentation index at: https://developer.upsun.com/llms.txt
> Use this file to discover all available pages before exploring further.

# jrmy-deruss

> Articles written by jrmy-deruss.

<div className="blog-card-grid">
  {/* Auto-generated by blog:generate — DO NOT edit manually */}

  <a href="/posts/how-tos/no-downtime-postgres-updates" className="blog-card group rounded-xl bg-card border-theme card-hover shadow-sm hover:shadow-md transition-all overflow-hidden flex flex-col">
    {`/images/posts/how-tos/no-downtime-postgres-updates/postgresql.webp` !== '' && (
          <div className="blog-card-img-wrap">
            <img src="/images/posts/how-tos/no-downtime-postgres-updates/postgresql.webp" alt="How to update your PostgreSQL database without downtime" className="blog-card-img" />
          </div>
        )}

    <div className="blog-card-body">
      <div className="flex items-center gap-2">
        {`how-tos` !== '' && (
                      <span className="text-xs font-semibold uppercase tracking-wider px-2 py-0.5 rounded-md bg-accent-badge border border-accent-soft text-accent">
                        how-tos
                      </span>
                    )}

        <span className="text-xs text-subtle">Thursday, January 9th 2025</span>
      </div>

      <h3 className="blog-card-title group-hover:text-accent transition-colors">How to update your PostgreSQL database without downtime</h3>
      <p className="blog-card-desc">On paper, releasing a new version of your application that requires upgrading the schema of the database is straightforward. But, changes of code and schema can not be updated in an atomic way, you only need to take care that old code is not performing a query against new schema, and reciprocally.</p>
    </div>
  </a>
</div>
