Database

The open standard document format from the OASIS OpenDocument Format (ODF) family, used by LibreOffice, Apache OpenOffice, and other applications for word processing documents.

An open-source, royalty-free lossy audio codec in the Ogg container, offering quality comparable to or better than MP3 without patent restrictions.

A modern, open-source, royalty-free audio codec excelling at both speech and music across a wide bitrate range, with ultra-low latency for real-time communication.

The OpenType font format — the modern standard for digital typography, extending TrueType with PostScript outlines, advanced layout features, and cross-platform support.

Apple's proprietary word processing and page layout format for the Pages application, part of the iWork suite, with tight Apple ecosystem integration and dual word-processing/layout modes.

Apache Parquet columnar storage format — a highly efficient binary format for analytics workloads, supporting compression and encoding optimizations.

Adobe's universal document format for fixed-layout, platform-independent document exchange with support for text, images, vector graphics, forms, and digital signatures.

PNG is a lossless compressed raster image format with full alpha transparency

The modern Microsoft PowerPoint presentation format based on Open XML, storing slides, layouts, themes, animations, and media in a ZIP-compressed package of XML files.

Apple ProRes is a family of lossy and visually lossless video codecs designed for high-quality professional video editing, post-production, and broadcast delivery.

Protocol Buffers (Protobuf) — Google's language-neutral binary serialization format for structured data, used in gRPC, inter-service communication, and data storage.

PSD is Adobe Photoshop's native file format, preserving layers, masks, blend

QOI (Quite OK Image Format) is a simple, fast lossless image format designed

The RAR archive format — proprietary compression with strong encryption, recovery records, and multi-volume splitting for high-ratio archiving.

RAW files contain minimally processed sensor data from digital cameras,

The RPM package format — Red Hat's software package manager for installing, updating, and managing applications on Fedora, RHEL, CentOS, SUSE, and other enterprise Linux distributions.

A Microsoft-developed text-based document interchange format that encodes formatted text with control words, providing cross-platform rich text exchange without binary complexity.

Structured Query Language files — text files containing database queries for schema definition, data manipulation, migrations, and seed data.

SQLite single-file relational database — a self-contained, serverless, zero-configuration SQL database engine stored as a single cross-platform file.

The STEP file format — the ISO standard for exchanging complete CAD product data including 3D geometry, tolerances, materials, and assembly structure across engineering tools.

The STL 3D model format — the standard for 3D printing, representing surface geometry as a mesh of triangles in either ASCII or binary encoding.

SVG is an XML-based vector image format for two-dimensional graphics that

The TAR archive format — Unix/Linux standard for bundling files while preserving permissions, ownership, and symlinks, typically paired with a compression layer.

TGA (Targa) is a raster image format supporting alpha channels and simple

TIFF is a flexible, high-quality raster image format widely used in

Tom's Obvious Minimal Language — a configuration file format emphasizing readability with explicit, unambiguous semantics. Used by Cargo, pyproject.toml, and Hugo.

A plain-text tabular data format using tab characters as field delimiters, avoiding the quoting complexities of CSV and widely used in bioinformatics, linguistics, and data processing.

The TrueType font format — Apple and Microsoft's scalable font technology using quadratic Bezier outlines, the foundation of digital typography on every major platform.

The simplest document format — unformatted text encoded in character sets like UTF-8, ASCII, or Latin-1, readable by virtually every computing device and application.

The USDZ format — Apple's AR-ready 3D file format based on Pixar's USD, designed for sharing immersive 3D content on iOS, macOS, and visionOS.

Variable fonts — a single font file containing a continuous range of styles (weight, width, slant, optical size) controlled by design axes, replacing entire font families.

vCard (.vcf) contact format — the universal standard (RFC 6350) for exchanging electronic business card and contact information between applications.

WebAssembly (Wasm) binary format — a portable, high-performance binary instruction format for running compiled code in browsers and server-side runtimes.

The standard uncompressed audio format for Windows, storing raw PCM audio data with full fidelity for professional editing and archival.

WebM is an open, royalty-free multimedia container format developed by Google for the web, using VP8, VP9, or AV1 video with Vorbis or Opus audio.

WebP is a modern image format developed by Google that provides both lossy and

Microsoft's proprietary audio codec family for the Windows platform, including lossy, lossless, and professional variants.

WMV is Microsoft's proprietary video codec and format, used within the ASF container, once common for Windows-based media distribution and streaming.

The WOFF and WOFF2 web font formats — compressed font containers optimized for efficient web delivery, enabling custom typography on websites with smaller file sizes.

XCF is the native file format for GIMP (GNU Image Manipulation Program),

The legacy binary spreadsheet format used by Microsoft Excel from 1997 through 2003, storing worksheets, formulas, and formatting in an OLE2 compound file structure.

The modern Microsoft Excel spreadsheet format based on Open XML, storing worksheets, formulas, charts, pivot tables, and formatting in a ZIP-compressed package of XML files.

Extensible Markup Language — a verbose but powerful structured data format widely used in enterprise systems, document formats, and legacy APIs.

The XZ compression format — high-ratio single-stream compression using LZMA2, the modern standard for software distribution as tar.xz on Linux.

YAML Ain't Markup Language — a human-friendly data serialization format popular for configuration files, CI/CD pipelines, and infrastructure-as-code.

The ZIP archive format — structure, creation, extraction, encryption, and cross-platform compatibility for the most widely used compressed archive format.

The Zstandard (zstd) compression format — Facebook's modern compressor offering dramatically better speed-to-ratio tradeoffs than gzip, with dictionary support and streaming capabilities.

Master the strategies and techniques for safeguarding database integrity and ensuring business continuity through robust backup and recovery plans.

Implement and manage various caching strategies to reduce database load, improve application response times, and

Configure and manage database connection pools to maximize throughput, minimize latency, and

Design and structure data for databases to ensure integrity, optimize performance, and support business logic effectively. Activate this skill when initiating new database projects, refactoring existing schemas, troubleshooting data consistency issues, or when planning for future application scalability and data evolution.

Harden database systems against unauthorized access, data breaches, and service disruption by implementing robust security controls. Activate this skill when designing new data infrastructure, auditing existing systems, responding to security incidents, or establishing a comprehensive data governance framework.

Implement and optimize full-text search capabilities in databases to provide fast, relevant,

Design, implement, and query graph databases to effectively model and analyze highly connected data.

Optimize database query performance by understanding, designing, and implementing effective indexing strategies.

Manage database schema and data changes in a controlled, versioned, and reversible manner.

Strategize and apply effective data modeling and access patterns for non-relational databases.

Apply common Object-Relational Mapping (ORM) patterns to efficiently interact with databases,

Identify, diagnose, and optimize slow database queries to improve application responsiveness and

Architect and manage database replication topologies to achieve high availability, disaster