pftq.com
November 4th, 2018
Posted by pftq

Anuwera Extended (Piano vers.)

Pieced together draft compilation of the piano improvisations I've been playing on the main Anuwera melody throughout the year.  Might try to orchestrate this into something more later.

1248 unique view(s)
September 16th, 2018
Posted by pftq

SQL to SQL Copy

This is a quick application for copying all rows from one SQL table to another of the same columns.  It is particularly useful for copying between SQL tables on different servers, as then it is not as simple as just running a single SQL query.  Note that this assumes there are no existing rows of the same primary key already in the destination table.
 
As with my other scripts, this was created in C# for a few tasks I needed to get done, but perhaps others out there might also find it useful.

You can download it here: SQL to SQL Copy
1058 unique view(s)
August 26th, 2018
Posted by pftq

Offkilted Tides (Piano)

Just something short I improvised a few days ago.  Trying to warm myself back up before doing something longer. Tongue

500 unique view(s)
July 22nd, 2018
Posted by pftq

VR Jetpack Game Website

Put together an official website for the VR Jetpack Game I've been making... Not too shabby for a day's work (or just three hrs really). Got to get back to working on the actual game! Tongue

----------------
591 unique view(s)
June 18th, 2018
Posted by pftq

Price Lookup via Cryptocurrency Screener

Extra benefit of the Cryptocurrency Screener sheet I shared earlier in the year is that you can use it to lookup prices without API limits (which @jbuty's plugin seems to hit).

Below are sample formulas you can use in Google Sheet to query my sheet for cryptocurrency prices:

1. Lookup via Cryptocurrency Screener sheet only (if you don't want to install any plugins):
Quote
=IFERROR(INDEX(QUERY(IMPORTRANGE(
"https://docs.google.com/spreadsheets/d/12iLyLbSI2odBy4uAIXEm7bLCTds0SApKjsso9UKJ25Q/", "Screener!A:C"), "SELECT Col3 WHERE Col2='BTC'"), 2), 0)

2. Lookup via both Cryptocurrency Screener and CryptoFinance plugin (latter being backup to minimize quota use):
Quote
=IFERROR(INDEX(QUERY(IMPORTRANGE(
"https://docs.google.com/spreadsheets/d/12iLyLbSI2odBy4uAIXEm7bLCTds0SApKjsso9UKJ25Q/", "Screener!A:C"), "SELECT Col3 WHERE Col2='BTC'"), 2), IFERROR(CRYPTOFINANCE( "BTC", "price") , 0))
537 unique view(s)