I have Django 1.8 website at www.vancouverfountains.com. The site shows water fountains around the Vancouver, BC area. The data includes fountain locations designated by lat and lon that I wanted to show on a single Google Map. I used the accepted answer from a stackoverflow question to create a Google Map with multiple markers that had the store name with a…

Read More

Wirebase was a concept created in 2001 before broadbrand, wired or wireless was widely available. It was shopped around to a bunch of VC’s and potential investors ultimately got lost in the dot.com bubble crash.   A copy of the website (long since gone) is maintained at the Internet Archive: https://web.archive.org/web/20010227065841/http://wirebase.com/ Our business plan and presentation can be downloaded below:…

Read More

Flask-SQLAlchemy relationship associations are useful to easily retrieve related records from a related Model. In a Python Flask application I wanted to use a many-to-many relationship between Photos and Tags (eg many categories assigned to one or more photos). To do this I had the following things set up in my application: 3 database tables Photos Tags Photo_Tags 3 model.py…

Read More

Car2Go has API available that can be used to view real time car and parking availability, as well as book reservations. I used the API to create the cardivvy.com site. It’s a nice compact presentation of all of Car2Go cities the world over. Each city’s Car2Go service area that can be viewed on a Google Map. The service area is…

Read More

There is no question that Microsoft’s new BI ecosystem promises to offer some great new functionality for Excel that extends its capabilities. However learning about all of the new stuff requires a not insignificant investment of time and effort. There are lots of moving parts! This BI ecosystem ranges across Microsoft’s cloud offerings including Office 365, Office 2013 and Power…

Read More

When learning to develop Django and Flask Python applications using virtual environment I did not know that I should activate the virtual environment before running the application. Well, more precisely, I did know the virtual env should be activated but rather I assumed it would be activated somehow auto-magically. I was using MS Visual Studio 2015 RC and its new…

Read More

Started using the Django web application framework recently. It took a while to figure out why Django made a big deal about its ‘static’ folders and files. Aside from creating the folders, you have to include references to them in the application configuration. It turned out to be pretty straightforward. First:  static files are things like css, js and image…

Read More

Use one CakePHP application and one MySQL datababse to provide website for multiple domains. All domains have to be hosted on shared hosting. Shared hosting has to allow pointing multiple domains to one subdomain directory. CakePHP application files are put into the shared subdomain directory. Create your CakePHP application as normal but add the following: Table called domain (or whatever…

Read More

Excel Power Query can make a connection to MySQL database but requires that you have a MySQL Connector/Net 6.6.5 for Microsoft Windows. Instructions for that on Microsoft site. Once you have the connector you can get MySQL db table data into your Excel file using Power Query in two ways.  The method you select will be dependent on how you…

Read More