Skip to content

Instantly share code, notes, and snippets.

View GlassGruber's full-sized avatar
💭
🪟 🔫 👣 :feelsgood:

Gruber GlassGruber

💭
🪟 🔫 👣 :feelsgood:
View GitHub Profile
/*
-- Executed querie(s) at 2020-03-12 16:48:02 took 0.078 s --
------------------------------------------------------------
EXPLAIN SELECT JSON_EXTRACT(j.acts, CONCAT('$[', i.n - 1, ']')) AS act,
j.len,
i.n
FROM
(SELECT scores.actions AS acts,
JSON_LENGTH(subs.actions) AS len
FROM `table_scores` AS scores) AS j
@GlassGruber
GlassGruber / 10-Bit H.264
Created November 29, 2017 00:52
10-Bit H.264 explanation
10-Bit H.264
For all those who haven’t heard of it already, here’s a quick rundown about the
newest trend in making our encodes unplayable on even more systems: So-called
high-bit-depth H.264. So, why another format, and what makes this stuff
different from what you know already?
First off: What is bit depth?
In short, bit depth is the level of precision that’s available for storing color
information. The encodes you’re used to have a precision of 8 bits (256 levels)
@GlassGruber
GlassGruber / .htaccess
Created September 10, 2017 05:19
Advanced PHP Error Handling via htaccess
#
## PHP error handling for production servers
## source: https://perishablepress.com/advanced-php-error-handling-via-htaccess/
#
# disable display of startup errors
php_flag display_startup_errors off
# disable display of all other errors