QuackDB Logo
HomeFeaturesAbout
Sign In
HomeFeaturesAbout
DocumentationArticlesComparePrevious versionContact
Sign In
Home / Articles

Articles

The query ran. Was the answer right? Stories, checks and small examples for working with data.

Latest

  • BackupsGitLab had backups. The copy it needed came from a load test.4 min read
  • NotebooksThe chart is still there. The SQL notebook will not run.4 min read
  • ExportsThe export worked. Then the spreadsheet changed the data.4 min read

Featured

Artist's illustration of the Mars Climate Orbiter spacecraft above the surface of Mars

Data quality · 4 min read

The numbers looked right. Mars Climate Orbiter still disappeared.

A lost spacecraft is an extreme example of an ordinary data problem: a valid number can mean the wrong thing.

Read article

Highlights

Start with the data

4 checks

Before you trust the table

  • Missing values
  • Inconsistent categories
  • Implausible ranges
  • Duplicate keys
Run the checks

Browse by topic

  • Data quality
  • Backups
  • Notebooks
  • Exports
  • PostgreSQL
  • SQLite
  • Schemas

More articles

  • PostgreSQL · 4 min read

    Before you paste that PostgreSQL connection string

    The quickest route to a database should not leave its password in your shell history.

    Read article
  • SQLite · 4 min read

    An empty SQLite file does not mean your data is gone

    One typo in a filename can send you into a brand-new database. Start by opening the existing file read-only.

    Read article
  • Schemas · 4 min read

    The join ran. Why did the total triple?

    A diagram is useful when it tells you how many rows a join can produce. Follow one order through the tables.

    Read article

Stay in the loop

New releases and community news, straight to your inbox.

Hear about new features, the Mac App Store launch and what the QuackDB community is building. A few emails a year, never spam. Not for you? Opt out any time.

QuackDB Logo

A native database client for macOS. One workspace for PostgreSQL, MySQL, SQLite, SQL Server and Supabase.

Product

  • Get QuackDB
  • Previous version
  • Documentation
  • Articles
  • Compare

Support

  • Report a bug
  • Discord
  • Contact

Company

  • About
  • Privacy Policy
  • Terms of Service
  • Privacy choices

© 2026 QuackDB. All rights reserved.