Thursday, June 20, 2019
Home Tags Mysql

Tag: mysql

MySQL: Enabling Trace Query Logging for Debugging Purposes

Overview: I use the following script constantly to temporarily turn on/off MySQL query logging. With this enabled, "tail -f" can provide a wealth of live...

SpringBoot and Hibernate Micro-service: Tending to your Data Relationships

Overview: Once you learn a few tricks, SpringBoot-JPA and Hibernate object/entity relational mapping (ORM) can really speed up development and extensibility of your next REST project....

MySQL: Installing a Parallel MySQL 5.7 Instance with SCL: Leaving Legacy...

Overview: I have been on many projects where the existing or legacy stack could not be altered, but a significant new level of functionality requiring...

Open Street Maps Nominatim Part 3: Adding US Census TIGER Address...

Part 1 | Part 2 | Part 3 Overview: The base Open Street Maps (OSM) planet files shall not contain street/house address numbers for the United...

Open Street Maps Nominatim Part 2: Importing Planet File

Part 1 | Part 2 | Part 3 Overview: The following instructions explain how to create a Nominatim database from an OSM planet file. It is...

Open Street Maps Nominatim Part 1: Standing up a Reverse Geocoding...

Part 1 | Part 2 | Part 3 Overview: This is the first of three articles discussing the process to stand up an OSM Nominatim instance....

MySQL: Quick Session Collation Script

Overview: As discussed in many threads and Stack Overflow postings, collation settings were not as important in MySQL V5.OLDDAYS. With MySQL 5.5 onward, the impact...