iiinova — where your digital self keeps evolving

Command Prompt

@cmdpromptinc.bsky.social

30 followers 18 following 252 posts

The oldest Postgres company in North America, offering Postgres and related open source full-stack support, consulting, and development. www.commandprompt.com/contact-us

Posts Replies Media

Command Prompt @cmdpromptinc.bsky.social · 11h

How are you handling security and privacy in PostgreSQL? Our team is joining PostgresWorld's next live Q&A on Security and Privacy Best Practices on October 20th at 1pm ET. postgresconf.org/conferences/...

000

Command Prompt @cmdpromptinc.bsky.social · 06/10/2026

Compiled Cython code degrades to standard Python speeds if the hot path remains tethered to the interpreter. Session 3 shows how the annotation report helps you find it before deciding what to optimize next. youtu.be/CIGB5RQ9CzE

Part 3: Optimizing Cython Code: Benchmarking, Annotations, and Memoryviews

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 06/10/2026

Your data changes, but the score on screen stays the same until the next refresh. Brian Fehrle’s Postgres wishlist starts with real-time materialized views. He explore what makes that difficult, especially with aggregates. Watch the T3D conversation: youtu.be/KEuLpA8meRA

MTAR T3D Sessions: Real-Time Materialized Views in PostgreSQL

YouTube video by Command Prompt, Inc.

Command Prompt @cmdpromptinc.bsky.social · 05/10/2026

Do you ever overlook the things that help the most? Amanda Nystrom and @offgridwithjd.bsky.social wrap up their stress management series by exploring why sleep, movement, boundaries and connection remain some of the most powerful tools we have. Listen to the full conversation: youtu.be/IZJMq2B-NBc

Unlimited with Exceptions presents: Building a Less Stressful Life

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 01/10/2026

Getting a Cython module to compile is only part of the job. Session 2 looks at the build process and why the types inside the code still determine whether you get a real performance gain. youtu.be/t18_P6F-vqU

Part 2: Building and Compiling Cython Modules: From Python to C

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 29/09/2026

How much more information should Postgres logical replication provide? James Nelson, Founder and CTO of @pgcache.bsky.social, wants more visibility into schema changes. He and @offgridwithjd.bsky.social explore the trade-offs in T3D Postgres Wishlist. youtu.be/YC5B1zjFaZ0

MTAR T3D Sessions: Adding Schema Change Events to PostgreSQL Logical Replication

YouTube video by Command Prompt, Inc.

Command Prompt @cmdpromptinc.bsky.social · 28/09/2026

Do you ever feel like you're being measured all the time? Amanda Nystrom and @offgridwithjd.bsky.social explore perfectionism, comparison, burnout, and the growing pressure to always get it right. Listen to the full conversation: youtu.be/QBJ9gHSeecQ

Unlimited with Exceptions presents: Perfection Under Pressure

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 24/09/2026

Working with JSONB in plPHP? The optional jsonb_plphp transform maps function arguments to native PHP values. Each function must declare TRANSFORM FOR TYPE jsonb. Read the docs: github.com/commandpromp... plPH: github.com/commandpromp...

000

Command Prompt @cmdpromptinc.bsky.social · 24/09/2026

AGLedger needed to run without phoning home. Michael Cooper began reviewing the stack, with Drizzle the first component removed. Our new three-part T3D series, "When Postgres Is Enough", starts here. Watch Part 1: youtu.be/uZiE1dD6Ae8 #PostgreSQL

MTAR T3D Sessions | When Postgres Is Enough | From SaaS to Self-Hosted (Part 1)

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 23/09/2026

Can your team merge more pull requests without spending a larger share of its time on new features? The End of the Universe EP06 (with @offgridwithjd.bsky.social, @mayers.io and Justin Reock) examines what AI productivity gains actually deliver. Watch: youtu.be/pfIzr0OvvdA #AI

The End of the Universe 06: Are AI Coding Tools Worth the Cost?

YouTube video by Command Prompt, Inc.

Command Prompt @cmdpromptinc.bsky.social · 23/09/2026

How has AI changed what your team works on? If AI helps your team merge more pull requests in a shorter time frame, what else are they accomplishing? New features? Bug fixes?

000

Command Prompt @cmdpromptinc.bsky.social · 22/09/2026

The algorithm does not always need to change to make a Python loop faster. Session 1 shows what Cython can remove once the types are known at compile time. youtu.be/skHoiIob4qE

Part 1: Cython for Python Performance: How Static Typing Speeds Up Your Code

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 22/09/2026

Write PostgreSQL procedures in your favorite language—even COBOL! plX transpiles your code directly to PL/pgSQL for safe, native, and fast procedures. Read how plX works: github.com/commandpromp...

000

Command Prompt @cmdpromptinc.bsky.social · 17/09/2026

Cloud database costs spike when PostgreSQL settings conflict with kernel caching. Greg Dostatni’s cost-aware tuning model demonstrates how proper memory allocation eliminates cache duplication, reducing disk IOPS up to 6x & lowering metered cloud storage tiers. www.commandprompt.com/blog/postgre...

commandprompt.com

TPC-B vs. Analytics: How Workload Shape Changes the shared_buffers Equation in Large-Memory Systems | Command Prompt

Optimize PostgreSQL for cost, not just speed. Explore how shared_buffers tuning can trade memory, disk I/O, and CPU to reduce infrastructure spend.

000

Command Prompt @cmdpromptinc.bsky.social · 16/09/2026

A Patroni cluster upgrading to PostgreSQL 18 will trigger split-brain states if the Etcd lease TTL isn't adjusted to tolerate longer pg_upgrade disk syncs. Learn more at Group Swim today at 2pm ET. Register: postgresconf.org/conferences/...

000

Command Prompt @cmdpromptinc.bsky.social · 16/09/2026

Some of AI's biggest wins happen before code reaches production. Brian Fehrle shares why AI works best when it helps engineers review, debug, and strengthen their work. youtu.be/srFsNtoCLF4

000

Command Prompt @cmdpromptinc.bsky.social · 15/09/2026

Q: "Why are my log times confusing?" A: log_timezone sets the timezone for server logs (not data storage). Best practice: Use UTC for distributed teams. Use local only for single-location ops. Consistent logs = easier event correlation. #PostgreSQL

000

Command Prompt @cmdpromptinc.bsky.social · 15/09/2026

Which query plans did PostgreSQL consider but reject? Greg Dostatni wants a plan explorer that would show those alternatives and their estimated costs. Hear his case in T3D Sessions' Postgres Wishlist: youtu.be/bNeRc8Vm3NA #PostgreSQL

MTAR T3D Sessions: What's Missing from PostgreSQL Query Planning?

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 15/09/2026

Why is it so easy to overlook everything that went right and focus on the part that didn’t? Amanda Nystrom and @offgridwithjd.bsky.social explore the science behind the pursuit of perfection and how it can shape stress, self-worth, and success. Listen to the full episode: youtu.be/2jF-ah1ZFjw

Unlimited with Exceptions presents: The Science of Perfectionism: How It Drives Stress

YouTube video by Command Prompt, Inc.

Command Prompt @cmdpromptinc.bsky.social · 10/09/2026

Would you accept an AI-generated pull request the contributor hasn't tested? Turso CEO Glauber Costa expects contributors to understand and test their code, even when AI writes it. Hear his conversation with JD on MTAR EP60: youtu.be/WA60GRxVpU4 #OpenSource

MTAR 60: Why AI Is Overwhelming Open Source Maintainers

YouTube video by Command Prompt, Inc.

Command Prompt @cmdpromptinc.bsky.social · 09/09/2026

Your GIN index on JSONB isn't just slow; it bloats WAL files when matching on a non-indexed key. Join PostgresWorld's New Features Group Swim on September 16 at 2pm ET to learn about major features to resolve upgrade pains. Register: postgresconf.org/conferences/...

000

Command Prompt @cmdpromptinc.bsky.social · 09/09/2026

Clinical-trial team goal: every report under 1 min. One QC report took 9+ min. A query rewrite brought it to ~30 sec. For more of the story: www.commandprompt.com/about/case-s...

000

Command Prompt @cmdpromptinc.bsky.social · 08/09/2026

pgcolumnar 1.0-alpha2 offers read-only Iceberg access through foreign tables. Supported filters can skip files before opening them; EXPLAIN (ANALYZE) reports Files Pruned. Read the release notes: www.commandprompt.com/blog/pgcolum...

000

Command Prompt @cmdpromptinc.bsky.social · 08/09/2026

Python loops stall at the CPU level due to dynamic object overhead, slowing down execution as an algorithm scales. Our Mini Cython Series on YouTube shows how compiling and benchmarking bypasses these performance bottlenecks to optimize execution. www.youtube.com/playlist?lis...

Mini Cython Sessions - YouTube

Learn how Cython can speed up Python code without requiring you to rewrite everything in C. In this Mini Cython Series, we start with the fundamentals and bu...

000

Command Prompt @cmdpromptinc.bsky.social · 03/09/2026

Audax Data Manager 1.5 is live. Highlights: Oracle now supported in Schema Editor Spreadsheet-style copy/paste in Data Editor Full keyboard navigation in Database Explorer One tool for many databases. Get: github.com/commandpromp... Info: www.commandprompt.com/products/aud...

Release 1.5 · commandprompt/Audax-Data-Manager

Release Notes New features: implemented support for keyboard navigation in Database Explorer using Page-Up, Page-Down, Home, End and arrow keys #747 implemented support for opening context menu ...

000

Command Prompt @cmdpromptinc.bsky.social · 01/09/2026

PostgreSQL gets a lot right. But what happens when fixing an edge case adds even more complexity? Ildefonso Camargo on LDAP authentication and large objects outside logical replication. youtu.be/YMcW7iWgYQ8

MTAR T3D Sessions: PostgreSQL LDAP Authentication and Large Objects in Logical Replication

YouTube video by Command Prompt, Inc.

Command Prompt @cmdpromptinc.bsky.social · 27/08/2026

AI can make average work easier to produce. That makes your judgment, experience, and perspective more important. Nikki Barua talks about identifying what you uniquely bring to the work, then using AI to build from it. youtu.be/nLdoHk68tjo

MTAR 59: Unlocking Your True Gift

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 25/08/2026

For a regulated employer-benefits TPA client, an urgent issue led to a broader review of auditability, autovacuum, CDC, reporting, monitoring, and DR readiness. Keep your database stable and compliant: www.commandprompt.com/contact-us/

000

Command Prompt @cmdpromptinc.bsky.social · 20/08/2026

Part 2 of Beyond the 25% Rule looks at huge_pages. Greg Dostatni repeated the Part 1 benchmarks with 2 MiB and 1 GiB pages. Throughput changed little, but page-table memory use dropped substantially. www.commandprompt.com/blog/when-to...

commandprompt.com

Part 2: Huge Pages in PostgreSQL: What 128 GB Benchmarks Show | Command Prompt

Benchmarking huge_pages on a 128 GB PostgreSQL 18 system shows throughput gains are modest — but page table overhead at 4KB pages can consume up to 20% of total RAM. Use PSI to find where your system ...

000

Command Prompt @cmdpromptinc.bsky.social · 19/08/2026

AI doesn't replace engineering judgment. DBA Brian Fehrle shares why keeping humans in the decision loop still matters when AI becomes part of your workflow. youtu.be/srFsNtoCLF4

000

Command Prompt @cmdpromptinc.bsky.social · 18/08/2026

Python code can be correct and still be too slow for the job. Our Mini Cython Series is now on YouTube, with practical sessions on reducing Python overhead and using Cython where performance matters. www.youtube.com/playlist?lis...

000

Command Prompt @cmdpromptinc.bsky.social · 13/08/2026

We’re starting a new three-part series on PostgreSQL shared_buffers behavior in large-memory systems. In Part 1, Greg Dostatni tests the usual 25% guidance on a 128 GB system across point-update and analytics workloads. The results did not tell the same story. www.commandprompt.com/blog/postgre...

commandprompt.com

Beyond Throughput: Efficiency Metrics for Cost-Aware PostgreSQL Tuning | Command Prompt

Tuning shared_buffers isn't just about peak throughput — it's about how much CPU and disk I/O a system consumes per unit of work. The 25% default can require up to 5x more disk I/O than very low or ve...

Command Prompt @cmdpromptinc.bsky.social · 13/08/2026

What changes when AI applications start working with images, video, and audio instead of just text? Marcel Kornacker explains why those workloads require rethinking the role of the database. Watch the full T3D Session: youtu.be/-8kS1WYVctM

MTAR T3D Sessions: Rethinking Databases for AI Applications

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 12/08/2026

Command Prompt provides PostgreSQL consulting and hands-on engineering for production environments. We start with the system your team actually runs and look beyond the database when the work requires it. www.commandprompt.com/contact-us/

000

Command Prompt @cmdpromptinc.bsky.social · 11/08/2026

Could a PostgreSQL major upgrade be as simple as install, restart, and continue? In this Postgres Wishlist episode, James and JD look at pg_upgrade, in-place upgrades, and replication across major versions. youtu.be/cKCGPJwXzS4 #PostgreSQL

MTAR T3D Sessions: Why PostgreSQL Still Needs In-Place Major Version Upgrades

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 06/08/2026

Audax Data Manager Community Edition 1.5 is now available. Whether you're already using or trying Audax Data Manager for the first time, download the latest version and explore what's new in Community Edition 1.5. Follow and star the project: www.commandprompt.com/products/aud...

commandprompt.com

Audax Data Manager | Database Manager and SQL Editor

Discover Audax Data Manager (formerly PgManage), a modern open-source SQL editor and GUI database admin tool for Postgres, MySQL, SQLite, MariaDB.

000

Command Prompt @cmdpromptinc.bsky.social · 03/08/2026

Do you ever feel mentally exhausted by things that technically were supposed to make life easier? Amanda and JD Drake talk about clutter, upgrades, subscriptions, distractions, consumerism, and the hidden stress of constantly managing more. Watch it now: youtu.be/pPSsnL8MqjU

Unlimited with Exceptions presents: Health and Tech: The Stress of More

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 30/07/2026

People still hear "free" and assume compromises. That's exactly the myth Brian challenges in this Postgres Love Letter. The conversation isn't really about cost. It's about why PostgreSQL earned its reputation on quality long before people started talking about savings: youtu.be/NBFaLHRSElk

MTAR T3D Sessions: Why Paying More Doesn't Buy a Better Database

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 29/07/2026

Everyone assumes AI needs bigger data centers. Reza Rassool makes the case for a different approach: distributed AI powered by the computing resources we already own. A thoughtful conversation about infrastructure, privacy, and where AI goes next. Watch here: youtu.be/H79xbDJ3_uE

MTAR T3D Sessions: The Future of AI Isn't More Data Centers

YouTube video by Command Prompt, Inc.

Reposted by Command Prompt

Joshua (JD) Drake @offgridwithjd.bsky.social · 16/07/2026

plx is a PostgreSQL extension that lets you write stored functions and triggers in the dialect you already know (the current set is listed below). When you run CREATE FUNCTION, plx transpiles the body to plpgsql and stores that plpgsql in pg_proc.prosrc. github.com/commandpromp...

GitHub - commandprompt/plx: PostgreSQL extension: write stored functions in Ruby, PHP, JavaScript, or Python dialects that transpile to plpgsql.

PostgreSQL extension: write stored functions in Ruby, PHP, JavaScript, or Python dialects that transpile to plpgsql. - commandprompt/plx

Command Prompt @cmdpromptinc.bsky.social · 09/07/2026

Some conversations are worth following wherever they lead. Pauline Vos joins JD for a conversation that begins with AI and open source before exploring hacktivism, healthcare, religion, and public institutions. Watch episode 58 of More Than a Refresh: youtu.be/CZc6JGEhQj0

MTAR 58: Hacktivism, Institutions, and Asking Better Questions

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 08/07/2026

Writing code is getting easier. Building software worth trusting isn't. How does open source evolve when creating code becomes easier than maintaining it? Joshua D. Drake will be discussing that conversation at FOSSY 2026. Get your tickets: 2026.fossy.ca/attend/ticke...

Command Prompt @cmdpromptinc.bsky.social · 07/07/2026

Open source isn't just about the code. Greg Dostatni explains why PostgreSQL's open foundation gives teams something even more valuable: the flexibility to adapt, migrate, and keep their options open. Watch the latest Postgres Love Letters episode. 🎧 youtu.be/55BtvX_6PLw

MTAR T3D Sessions: Why PostgreSQL Gives You an Exit Strategy

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 06/07/2026

What if the problem isn’t that you’re failing… but that you’re trying to maximize everything? In this episode of H&T, Amanda and JD talk about chronic overthinking, perfectionism, optimization culture, decision fatigue, and the pressure to always find the “best” option. youtu.be/myfc5vCvkX4

Unlimited with Exceptions presents: The Stress of Trying to Optimize Everything

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 02/07/2026

When does PostgreSQL need more than a single database? Scaling PostgreSQL isn't just about sharding. Sugu Sougoumarane explains why the goal isn't to replace PostgreSQL, but to build the infrastructure that allows it to scale. Watch the latest T3D Session: youtu.be/MupV7betIYs

MTAR T3D Sessions: Scaling PostgreSQL Without Replacing It

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 25/06/2026

The newest episode of The End of the Universe starts with public behavior and slowly expands into more, and the tension between protecting your peace and staying connected to community. 🎧 youtu.be/YAfT_ldvHEU

The End of the Universe 05: Protect Your Peace Without Losing Community

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 23/06/2026

Have you ever fixed a production problem by deleting the wrong thing? JD and Ildefonso Camargo start with a question about pg_xlog and pg_wal, then dig into backup tooling, recovery workflows, and why operational simplicity matters just as much as database performance. youtu.be/fAvjNV-GaLA

MTAR T3D Sessions: PostgreSQL's Biggest Problem Isn't PostgreSQL

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 22/06/2026

Why do the same words affect people completely differently? In this episode of Health and Tech, Amanda Nystrom and JD talk about stress, assumptions, emotional wiring, communication, and why “one size fits all” rarely works when it comes to human beings. youtu.be/GlvjrH422Gc

Unlimited with Exceptions presents: One Size Fits None

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 18/06/2026

Can AI help us work faster without replacing what makes our work valuable? Cliff Jurkiewicz joins the show to discuss hiring, AI tools, and why real human experience still matters. Learn more in this T3D EP: youtu.be/AQ6JlaBQyJg

MTAR T3D Sessions: AI Is a Tool. Not the Work.

YouTube video by Command Prompt, Inc.

000

Command Prompt @cmdpromptinc.bsky.social · 11/06/2026

What happens when AI reaches communities outside major tech hubs? MTAR 57 explores rural entrepreneurship, broadband access, sovereign data, and the people trying to adapt as AI becomes part of everyday life. Watch it here: youtu.be/bIMz7dJzbFU