TrailsNH turns 15 years old today. I registered the domain name on November 17th 2008. It took me another 6 months before the first version of website was ready to go live. I created TrailsNH out of my passion for hiking and coding, and to share my skills with other hikers. I wanted to create … Continue reading TrailsNH Turns 15 Years Old
Tag: MySQL
TrailsNH DB Outage
Yesterday, November 4th TrailsNH had a 5 hour database outage. The database was near but not over the maximum space allocation, and a mistake made by my hosting company caused them to shut down access to the database. Three days prior (November 1st) my hosting company informed me I was over the limit by almost … Continue reading TrailsNH DB Outage
How Do I Check MySQL Database Usage?
Has your MySQL database exceeded the size limit? This query will help you review which tables are using the most space
Add Leaflet Map to Property CRM
For this freelance project, I extended the client’s CRM System to add a mapped view of their data. This included extending the CRM MySQL schema to store the location, geo tag all properties so they could be mapped, and finally building the map display.
Building a Custom Trail Map Using OSM and Mapbox
Here is an high level overview of the process I use for building my own custom hiking trail map. The data I’m using (trails, summits, etc…) are available as open source from OSM. After I fetch and clean up the data I use MapBox to generate the map tiles, in a map style I designed. The custom trail … Continue reading Building a Custom Trail Map Using OSM and Mapbox
Mailways: Job Tracking System
I’m building an internal application for Mailways in Allenstown NH. The app will have everything we need to track a job thru producion. I built my own PHP framework and use jQuery Mobile for a touch-friendly presentation. The app will be accessed on the shop floor using tablets.
TrailsNH.com: Northeast Trail Conditions
TrailsNH.com is a pet project of mine that stems from my love of hiking, database, and web based technologies. The site is driven by bots I created to gather hiking trip reports and related information from all over the internet. The system GeoTags the location of each report, then indexes and organizes the information so hikers can find … Continue reading TrailsNH.com: Northeast Trail Conditions
