Category: MySQL

Articles about the MySQL relational data management system.

Numerical Data Types Matter

by Ollie on March 24, 2014 in MySQL • 0 Comments

Disasters resulting from bad numerical computing Read more →

Useful MySQL query cheat sheet

by Ollie on March 8, 2014 in MySQL • 0 Comments

useful query patterns Read more →

Publicly Available Datasets

by Ollie on February 28, 2014 in MySQL • 0 Comments

Pro PublicaData StoreUS Zip Code Dataoneanotherhereopen data herepublishes lots of information hereMaxMindInternet Protocol addresseshereOpen Refine Read more →

The Vincenty great-circle distance formula

by Ollie on February 23, 2014 in Geography, MySQL, Reference • 2 Comments

http://en.wikipedia.org/wiki/Great-circle_distance Read more →

SQL Reporting by time intervals

by Ollie on January 30, 2014 in MySQL, Reference, SQL Time Processing • 6 Comments

Using MySQL’s geospatial extension for a location finder

by Ollie on January 20, 2014 in Geography, MySQL, Reference • 6 Comments

version 5.7.5 or later of MySQLALTER TABLE flags ADD SPATIAL INDEX (coordinates)MbrContains(box,geo)GeomFromText(‘LINESTRING(LatSW LonSW, LatNE LonNE)’)42.81/-70.81GeomFromText(‘LINESTRING(42.6650 -71.0076,42.9549 -70.6124)’)helpful details Read more →

Stored function for haversine distance computation

by Ollie on January 20, 2014 in Geography, MySQL, Reference • 0 Comments

Mean Absolute Deviation

by Ollie on January 15, 2014 in MySQL • 0 Comments

Mean Absolute DeviationMySQL feature request for MAD()AVEDEV Read more →

What’s a date?

by Ollie on July 4, 2012 in MySQL, SQL Time Processing • 0 Comments

here Read more →

Processing dates and times in SQL

by Ollie on July 4, 2012 in MySQL, SQL Time Processing • 0 Comments

stackoverflow.comOracleMySQLPostgreSQLMicrosoft applicationsUnix and LinuxRichard T. Snodgrass Developing Time-Oriented Database Applications in SQLonline Read more →