27 Dec · Robert Eisele
Finding People Near You with MySQL 8.4
A modern radius-query pattern for MySQL 8.4. Geographic points are stored in an SRID-restricted WGS 84 column and indexed with an InnoDB R-tree....
MySQL
Contents
- Analyze User Activity Patterns with MySQL and PHP
- A Programmable Query Layer on Top of MySQL
- Avoid N+1 Queries with MySQL JSON Aggregation
- Build a Circular Buffer in MySQL
- Building a Tag Cloud with MySQL
- Calculate Age Correctly in MySQL
- Calculate the Next Birthday in MySQL
- Can MySQL Query Parsing Be Avoided?
- Copy an InnoDB Table Between MySQL Servers Without a Dump
- Efficient Flag-Based Counts in MySQL
- Efficient Pagination in MySQL
- Finding Friends of Friends with MySQL
- Finding People Near You with MySQL 8.4
- Full-Text Location Search with MySQL 8.4
- How It Was Possible to Get Root Access Through MySQL
- Import Wikipedia into MySQL with MediaWiki
- Indexing Text Columns in MySQL 8.4
- Mask IPv6 Addresses with MySQL
- Model Many-to-Many Relationships in MySQL
- MySQL Wishlist Revisited for MySQL 8.4
- Persisting a Custom Sort Order in MySQL
- Preserve ON UPDATE CURRENT_TIMESTAMP in MySQL
- Reliable Asynchronous Writes with MySQL
- Running Standard Deviation in MySQL
- Set and Clear Bit Flags Atomically in MySQL
- Should MySQL VARCHAR Lengths Be Powers of Two?
- Statistical Analysis with MySQL 8.4
- Stream SQL to MySQL with Netcat
- TF-IDF Related-Article Ranking with MySQL 8.4
- The Best SQL Mode Configuration for MySQL 8.4