Skip to content

Instantly share code, notes, and snippets.

@philotas
philotas / README.md
Created February 8, 2023 15:32 — forked from lopspower/README.md
Hexadecimal color code for transparency

Hexadecimal color code for transparency

Twitter

How to set transparency with hex value ?

For example, you want to set 40% alpha transparence to #000000 (black color), you need to add 66 like this #66000000.

Download This sample on Google Play Store

@philotas
philotas / gist:6633035d0814512b5156633ca942b680
Created January 4, 2023 23:52 — forked from tonykwon/gist:8910261
MySQL - Row size too large - BLOB prefix of 768 bytes is stored inline
-- Error Message: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
--
-- our table name that has this issue is XYZ
--
SET GLOBAL innodb_file_format=Barracuda;
SET GLOBAL innodb_file_per_table=ON;
ALTER TABLE XYZ ROW_FORMAT=COMPRESSED;
@philotas
philotas / gist:d55fc2c0d6b1d8042c71779395965586
Created January 4, 2023 23:52 — forked from tonykwon/gist:8910261
MySQL - Row size too large - BLOB prefix of 768 bytes is stored inline
-- Error Message: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
--
-- our table name that has this issue is XYZ
--
SET GLOBAL innodb_file_format=Barracuda;
SET GLOBAL innodb_file_per_table=ON;
ALTER TABLE XYZ ROW_FORMAT=COMPRESSED;
@philotas
philotas / roku-proxy-setup.md
Created June 15, 2022 09:01 — forked from triwav/roku-proxy-setup.md
Roku Proxy Setup

This is largely based off of this article by Hulu and their roku-dev-cli tool.

Requirements:
The main requirement is a Mac with 2 available network interfaces WIFI <-> WIFI, LAN <-> WIFI, etc. This should work on other platforms as well but isn't covered here.

Setup
The first thing we need is Homebrew. If you've never used it before it's a great package manager for macOS that makes installing programs easier. Open Terminal and paste
/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
and hit enter

1. Goto http://dev.mysql.com/downloads/mysql/
2. Select Platform: "Mac OS X"
3. Download mysql-5.5.11-osx10.6-x86.tar.gz
(Mac OS X ver. 10.6 (x86, 32-bit), Compressed TAR Archive)
4. Unzip it
5. Copy include folder into /Applications/MAMP/Library
6. Copy lib/* files into /Applications/MAMP/Library/lib
----
1. Goto http://sourceforge.net/projects/mysql-python/
This is compatibility issue due to upstream change in chrome 80 version. https://groups.google.com/a/chromium.org/forum/#!msg/blink-dev/h-JwMiPUnuU/sl79aLoLBQAJ https://bugs.chromium.org/p/chromium/issues/detail?id=685385
It will be resolved in the next release of Tizen Studio. Until then, if you use the options below, inspector will be launched properly.
Go to Window > Preferences > Tizen Studio > Web > Chrome -> Extra parameters : add "--enable-blink-features=ShadowDOMV0 --enable-blink-features=CustomElementsV0"
@philotas
philotas / HOWTO_Tizen_Deploy_WGT_TV_on_macOS_Catalina.md
Last active December 5, 2019 09:43
HOWTO: deploy App WGT on Tizen with macOS Catalina Tizen Studio IDE 1.3

After years of not beeing able to get a newly installed Tizen IDE to deploy applications onto the TV, I found this way to make Tizen Studio 1.3 successfully deploy apps onto the TV again.

follow the instructions in the links below to setup an environment which lets you deploy Apps to Samsung Tizen

1) Install Tizen SDK 1.3

http://blog.infernored.com/how-to-get-back-tizen-studio-1.3-and-tv-extensions-3.0

2) When SDK does not start, change Java JDK to jdk1.8.0_151

https://developer.tizen.org/forums/sdk-ide/tizen-studio-2.0-not-working-on-macos-sierra

@philotas
philotas / fabfile.py
Created December 11, 2010 17:39 — forked from onyxfish/fabfile.py
from fabric.api import *
"""
Base configuration
"""
env.project_name = '$(project)'
env.database_password = '$(db_password)'
env.site_media_prefix = "site_media"
env.admin_media_prefix = "admin_media"
env.newsapps_media_prefix = "na_media"