PHP and SQL: Calculate or Query Distance Between Points of Latitude and Longitude

Reading Time: 3 minutes This month I’ve been programming quite a bit in PHP and MySQL with respect to GIS. Snooping around the net, I actually had a hard time finding some of the Geographic calculations to find the distance between two locations so I wanted to share them here. The simple way of calculating a distance between two points is using the Pythagorean formula to calculate the hypotenuse of a triangle (A² + B² = C²). This is

Databox: Track Performance and Discover Insights in Real-Time

Reading Time: 2 minutes Databox is a dashboarding solution that where you can choose from dozens of pre-built integrations or use their API and SDKs to easily aggregate data from all of your data sources. Their Databox Designer doesn’t require any coding, with drag and drop, customization, and simple data source connections. Databox Features Include: Alerts – Set alerts for progress on key metrics through push, email, or Slack. Templates – Databox already has hundreds of templates ready to

Grow: Build The Ultimate Internet Marketing Dashboard

Reading Time: 2 minutes We’re big fans of visual performance indicators. Currently, we automate monthly executive reports to our clients and, within our office, we have a large screen that displays a real-time dashboard of all our clients’ internet marketing key performance indicators. It’s been a great tool – always letting us know which clients are getting superior results and which ones have an opportunity for improvement. While we currently use Geckoboard, there are a couple of limitations we’re

5 Signs You’re Outgrowing Your MySQL Database

Reading Time: 3 minutes The data management landscape is complex and quickly evolving. Nothing emphasizes this evolution more than the emergence of ‘super apps’ — or applications that process millions of user interactions per second. Factor in Big Data and the cloud, and it becomes clear that e-commerce merchants need a new generation of databases that can perform better and scale faster. Any online business without an updated database is likely running MySQL, a database barely updated since its

Improving Magento Performance and Your Business Results

Reading Time: 4 minutes Magento is recognized as a top e-commerce platform, powering up to one-third of all online retail websites. Its massive user base and developer network create an ecosystem where, without much technical expertise, almost anyone can get an e-commerce site up and running quickly. However, there’s a downside: Magento can be heavy and slow if not properly optimized. This can be a real turn-off for today’s fast-paced customers who expect quick response times from the websites