Fast Pagination in MySQL with Keyset Pagination
LIMIT 20 OFFSET 100000 looks innocent, but MySQL must read and throw away 100,000 rows to return 20. Deep pages get slower and slower. The p...
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
Redis vs Valkey: What Changed and Which to Use
For years Redis was BSD-licensed open source. In 2024 Redis (the company) switched new versions to source-available licences. In response, c...
Reacting to Data Changes with MongoDB Change Streams
Change streams let your application subscribe to changes in a collection, database or entire cluster. Instead of polling, you get each inser...
Fixing Security Misconfiguration: Headers, Defaults and Errors
Many breaches don't need a clever exploit, just a setting left at the wrong value. Security misconfiguration is consistently near the top of...
Free utilities
All tools Developer tools
110 quick tools that run in your browser — nothing to install.
JSON Formatter
Format, validate, minify and sort JSON with exact error positions.
Open toolBase64 Encoder
Encode and decode Base64 text and files, with full Unicode and URL-safe support.
Open toolHash Generator
Generate MD5, SHA, PBKDF2 and Bcrypt hashes right in your browser.
Open toolPassword Generator
Create strong random passwords or passphrases with entropy and crack-time estimates.
Open toolHTML Editor
Write HTML and preview it live, with formatting, import and export.
Open toolRegex Tester
Test regular expressions with live highlighting and capture groups.
Open toolColor Palette Generator
Generate harmonious colour palettes and export them as CSS variables, SCSS or JSON.
Open toolImage Compressor
Shrink JPG, PNG and WebP images in your browser with a quality slider and before/after sizes.
Open toolQR Code Generator
Create QR codes for links, text, Wi-Fi, contacts, email and SMS; download PNG or SVG.
Open toolPDF Merger
Combine several PDFs into one, in the order you choose — all in your browser.
Open toolcURL to Code
Convert cURL commands into fetch, Axios, Python requests, PHP, Go and Node.js code.
Open toolCron Helper
Explain cron schedules in plain English and see the next runs.
Open toolNever miss a new tutorial
Join the newsletter and get new articles delivered to your inbox. Free, and you can unsubscribe anytime.