database

10 posts
Issue57

The big bad guide on database testing

Check for data mapping, ACID properties and data integrity of your DB, and ensure they implement your business logic accurately.…

Issue54

Secure databases in complex backend systems with these 5 best practices

Keep application and database servers on different physical machines, with a high-performance host for the apps & high-level security for databases. Encrypt data residing on servers with a private key and also encrypt before transit.…

Issue37

The question of multiple databases and pre-production complexity

When working with long pipelines break up changes into smaller chunks that are easier to develop, test, and deploy. Deal with the complexity of distributed applications with a purpose-built tool.…

Issue32

Top 10 security best practices for MongoDB

Enable & configure role-based access control. Configure TLS. Restrict network exposure - ensure the instance is only listening on the localhost interface.…

Issue32

How to overcome 5 common database challenges

Data Security: use the database’s built-in security features; or use what your company is already using for security purposes; or reinforce both in your application.…

Issue29

5 tips for wrapping your database with a REST API

Don’t let implementation details leak into your API. Use clear resource concept names. Don’t use abbreviations or naming conventions in URLs.…

Issue18

How Shopify manages petabyte-scale MySQL backup and restore

Use incremental snapshots of data for backup after one initial full snapshot to reduce both storage and recovery times. Save on storage costs by deleting all but the last two copies for recovery purposes.…

Issue9

Bad Practices in Database Design: Are You Making These Mistakes

Bad Referential Integrity Not Taking Advantage of DB Engine Features Poor Indexing & Naming Conventions…

Issue9

A one size fits all database doesn’t fit anyone

When to consider what type of database: Relational: when referential integrity with strong consistency is needed. Key-value: when access patterns require low-latency Gets/Puts for known key values.…

Issue5

When SQL Isn’t the Right Answer

When you’re looking for something that’s easy to interface with and quick to develop.…