Year: 2014

Google Chromecast digisign references

These are notes on digital signage on the Google Chromecast. Google’s docs   Console   Writeup SaaS vendors. (local launch)  (not up yet) Chromecast code repos Limitations The Chromecast device does a good job of displaying media at 1080p resolution.  However, any web pages surrounding that media to provide a user interface are limited… Read more →

Starting a new web site or blogging project? Read this! Seriously.

Mr. Ognjen Duraskovic first got in touch with me with an offer to translate my MMWW WordPress plugin to Spanish and Serbian, which of course, I gratefully accepted. Gracias! хвала! It was an extra-cool offer because MMWW contains all kinds of readable text strings for the photographic details embedded in Exif metatdata. He dealt with all that stuff. Now Ogi has produced… Read more →

Provisioning Windows to do RiseVision development

These are my notes on provisioning Windows (W7PRO, SP1 x64) for working on the open source RiseVision stuff. Here’s where the RiseVision stuff lives on GitHub. Here are Donna Peplinski’s instructions for provisioning your machine. Get GIT. Get node.js from http::// and install it. Use the Windows binary. Run a simple node.js acceptance test according to these instructions. Open… Read more →

Digital signage vendor list

This is a list of vendors for digital signage, in no particular order. RiseVision  Free as in kittens, free as in speech, SaaS, some premium products. WonderSign   $40 per month plus $20 per extra display. SoCal, SaaS, Freemium, hardware systems are offered. 11Giraffes  Prices not published. Deep retail communications products. DISE  Lots of multi-screen support, software solution, Sweden NetDisplay  Software… Read more →

Using SQL to report by time intervals in Oracle

This is an Oracle-specific edition of the article explaining the same subject for MySQL. It’s often helpful to use SQL to group and summarize information by periods of time. For example, we might like to examine sales data. For example, we might have a table of individual sales transactions like so. Sales: sales_id int sales_time date net decimal(7,2) tax decimal(7,2) gross decimal(7,2)… Read more →

Fast nearest-location finder for Oracle

Elsewhere I have written an article on fast location finding for the MySQL and PostgreSQL databases. This article shows an adaptation of that work for the Oracle database. If you need data to work with, here’s a US Zip Code table in SQL suitable for an Oracle database. Please don’t use this data in production. The Great Circle Distance Formula What’s… Read more →

Fast nearest-location finder for SQL (MySQL, PostgreSQL, SQL Server)

I’ve spent enough time goofing around with location-finder software that it’s worth writing up how to do it.   Of course, finding distances on the surface of the earth means using Great Circle distances, worked out with the Haversine formula, also called the Spherical Cosine Law formula. The problem is this: Given a table of locations with latitudes and longitudes,… Read more →

Transcoding JPEG optimizer from Mozilla

The people at Mozilla have produced a transcoding JPEG optimizer. This thing is sweet: it takes ordinary JPEG files and recompresses them much more efficiently without making the images deteriorate. It uses the long-standing and well-tested Independent JPEG Group reference implementation, and adds a bunch of optimizations. It’s not built for GUI users; it’s a command-line utility. For those… Read more →

Digital Sign Gadgets. Tronsmart Vega S89 is a workable choice.

Forget about the CX-919 thing. Unfortunately, something bricked mine before I tried starting to upgrade it. I think I switched off the TV to which it was connected, and that damaged it. That disqualifies it for production use. Plus it only handles 720p resolution. Instead, use the same vendor’s device Tronsmart Vega S89. It handles 1080p, it has WiFi, and… Read more →