A guide to advanced data modeling in Amazon DynamoDB, covering access patterns, single-table design, and filtering strategies.
Key takeaways from a talk on Amazon DynamoDB data modeling, covering primary keys, access patterns, and single-table design strategies.
A guide to quickly exploring and understanding a new PostgreSQL database using psql, covering initial setup and table inspection.
Explains DynamoDB single-table design patterns for scalable, high-performance NoSQL data modeling in serverless applications.
A guide to designing a data model for a Django survey application, covering models for Survey, Question, Option, and Submission.
A deep dive into single-table design for DynamoDB, covering its concepts, benefits, and trade-offs for scalable applications.
Explains DynamoDB filter expressions, their limitations, and when to use them versus proper table design for efficient queries.
A tutorial on using Mongoose's Population feature to link MongoDB collections, preventing document size limits by separating blog posts and comments.
A tutorial on setting up a local MongoDB database, covering installation, starting the server, and basic operations using the Mongo Shell and Compass.
A technical guide on splitting delimited text into a table using DAX functions like PATH, GENERATESERIES, and PATHITEM for Power BI data modeling.
A guide on creating a Power BI Push Dataset using Power BI Desktop and the PowerBIPS.Tools module to simplify API dataset creation.
Demonstrates how to model and query graph-like data in MongoDB using the Aggregation Framework's graph lookup, inspired by a scenario from 'Designing Data-Intensive Applications'.
A guest post in a series exploring methods and best practices for tracking document versions within MongoDB databases.
Explains how to use PostgreSQL's COMMENT feature to document tables, columns, and SQL for better data understanding and maintenance.
Explains how to implement user-defined ordering in RavenDB, moving from a complex MSSQL approach to a simpler document-based solution.
Announcing the alpha release of jsonschema 0.2, detailing new features like additionalProperties validation, interactive mode, and bug fixes.
