#MySQL
4 items tagged “MySQL”
BlogNode.js6 min read
Building a Fast, Cached Nearby-Places Search in Node.js (No PostGIS Required)
How I built location search, map-pin clustering, and viewport caching for a mobile app on plain MySQL — bounding-box pre-filtering, Haversine distance in SQL, and Redis-cached viewport queries instead of a dedicated geospatial database.
#Node.js
SnippetsNode.js2 min read
Nearby-Places Query: Bounding Box + Haversine in MySQL
A reusable pattern for 'what's near me' search on plain MySQL — a fast bounding-box pre-filter followed by an exact Haversine distance calculation, sorted and paginated in SQL.
#Node.js
SnippetsNode.js2 min read
Redis-Cached, Server-Clustered Map Pins for a Viewport
Serve map pins for whatever bounding box a user is currently viewing, cached in Redis by the exact viewport, with overlapping pins clustered in SQL before they ever leave the server.
#Node.js
ProjectsHealthcare Software2 min read
Clinical Management System — Karuna Hospital
A hospital management system built to digitize patient records, appointments, reports, and clinical workflows.
#PHP