PostgreSQL Indexing: B-tree, GIN, Partial and Expression Indexes
Indexes are the single biggest lever for query performance. The right one turns a full table scan into a lookup of a few pages; the wrong on...
Free tutorials & developer tools
Tech concepts, explained simply.
Clear, practical tutorials on PHP, Laravel, MySQL, JavaScript, Vue JS, Angular, REST APIs, Git and more — plus handy tools to speed up your everyday development work.
Animated examples of SQL, Laravel, PHP and JavaScript code being written and run, from Technical Simple tutorials.
0:00 / 1:00
Fresh from the blog
Latest articles
MySQL Indexing and EXPLAIN: Making Slow Queries Fast
Most slow MySQL queries are missing an index or can't use the one that exists. EXPLAIN shows you which. Find slow queries SET GLOBAL slow_qu...
Caching with Redis: Patterns, TTLs and Stampedes
A cache in front of a slow database query or API can cut response times from hundreds of milliseconds to one. Getting freshness and failure...
MongoDB Schema Design: Embed or Reference?
"Schemaless" doesn't mean "no design". In MongoDB, schema design starts from one question: what does the application read together? Embed wh...
Free utilities
Developer tools
Quick tools that run in your browser — nothing to install.
HTML Editor
Write HTML and preview it live, with formatting, import and export.
Open toolJSON Formatter
Format, validate, minify and sort JSON with exact error positions.
Open toolRegex Tester
Test regular expressions with live highlighting and capture groups.
Open toolCase Converter
Convert text to UPPER, lower, Title, Sentence and more in one click.
Open toolBase64 Encoder
Encode and decode Base64 with full Unicode and URL-safe support.
Open toolJWT Decoder
Inspect a JSON Web Token’s header, payload and expiry.
Open toolCron Helper
Explain cron schedules in plain English and see the next runs.
Open toolHash Generator
Generate MD5, SHA, PBKDF2 and Bcrypt hashes right in your browser.
Open toolTodo List
A simple, private task list that remembers your work between visits.
Open toolNever miss a new tutorial
Join the newsletter and get new articles delivered to your inbox. Free, and you can unsubscribe anytime.