Web Design & Development
How to Get Relational Data Modeling Right
Designing database tables and relationships so data stays consistent and queries stay simple. Key takeaways Normalization: reduces duplicated data Foreign keys:...
Marcus Adeyemi
Builds and maintains the web work. Writes about front-end architecture, performance, accessibility and the unglamorous parts of keeping a site alive.
531 articles
Web Design & Development
Database Indexes, Done Properly
Structures that let databases find rows quickly without scanning entire tables. Key takeaways Lookups: indexes speed up filtering and sorting Write cost: every...
Web Design & Development
Database Transactions, Done Properly
Grouping database operations so they either all succeed or all fail, keeping data consistent. Key takeaways Atomicity: all operations in a transaction succeed o...
Web Design & Development
Storing Money Values: What Actually Works
How to represent prices and amounts in code and databases without rounding errors. Key takeaways Floating point: binary floats cannot represent many decimal val...
Web Design & Development
Object Storage for User Files: What Actually Works
Storing uploaded files in an object storage service rather than on application servers. Key takeaways Buckets: files are stored as objects with keys Access cont...
Web Design & Development
A Practical Guide to Generating PDFs from Web Applications
Producing PDF documents such as invoices, reports and certificates from web applications. Key takeaways Approaches: HTML-to-PDF rendering or direct PDF librarie...
Web Design & Development
CSV Imports and Exports: What Actually Works
Letting users upload and download data as spreadsheet-friendly CSV files. Key takeaways Encoding: character encoding mismatches corrupt names and symbols Formul...
Web Design & Development
How to Get Headless WordPress Right
Using WordPress as a content store behind a separate front end built with another framework. Key takeaways REST API: WordPress exposes content through a REST AP...
Web Design & Development
Composer and PHP Dependencies: The Decisions That Matter
The dependency manager for PHP projects, which installs libraries and manages versions. Key takeaways composer.json: declares dependencies and version constrain...
Web Design & Development
PHP OPcache: The Decisions That Matter
The PHP extension that stores compiled script bytecode in memory so scripts are not recompiled on every request. Key takeaways Bytecode cache: avoids recompilin...
Web Design & Development
A Practical Guide to Managing npm Dependencies
Handling JavaScript package dependencies, versions and security in Node.js and front-end projects. Key takeaways package-lock.json: pins the exact installed tre...
Web Design & Development
TypeScript for Web Projects, Done Properly
A typed layer over JavaScript that checks types at build time and improves editor support. Key takeaways Compilation: TypeScript compiles to JavaScript Strictne...
Load more articles
Showing 288 of 531