Example to convert a field from real type to integer type:
update bracketevents set json = jsonb_set(json, '{sq_id}', ((round(cast(json->>'sq_id' as real))::text)::jsonb));
All that just remove the $*(@ decimals… how particular…
Example to convert a field from real type to integer type:
update bracketevents set json = jsonb_set(json, '{sq_id}', ((round(cast(json->>'sq_id' as real))::text)::jsonb));
All that just remove the $*(@ decimals… how particular…
While debugging, you can use the Debug Console to print memory, including the content of strings that are clipped by default in the variables and watch windows.
View > Open View > Debug Console
From there, send gdb a command to print memory – 300 characters of a string in this example:
-exec x/300sb Query.c_str()
Make sure you use a char*, not a string object – if it’s a string, just tack on .c_str().
This article is a great explanation of the details. To explain.. no, too much. To sum up:
function custom_add_google_fonts() {
wp_enqueue_style(
'custom-google-fonts',
'https://fonts.googleapis.com/css?family=Montserrat|Quicksand',
false
);
}
add_action( 'wp_enqueue_scripts', 'custom_add_google_fonts' );
body { font-family: Montserrat, sans-serif; font-weight: normal; }
#content h2 { font-family: Quicksand, sans-serif; font-weight: bold; }
The never ending browser war… I will always strive to make Firefox my browser. But a browser is too important for compromise.
In linux and Windows, I just added the Tab to Window/Popup – Keyboard Shortcut to my Chrome, with c-sh-PgUp/Down keys to pull/push the current tab from/to Chrome windows. Chrome is working well as long as I keep the tab count low enough (~100) to prevent chrome from completely fucking my system. I gotta get that number higher. Make me a believer again FF.
Today I updated my gentoo server’s eselected PHP from 5.6 to 7.2 and wordpress phabricator and mediawiki didn’t even hiccup. WordPress went from a steaming pile of stubborn version upgrade refusal right back into line. I used mysqldump to back up all my databases, less than a GB. I git pulled phabricator’s stable branch (updated weekly from master) and ran a boatload of database patches that went smooth as coconut milkfat. I git-skipped the .arcconfig files so i could just update them in place. OK… why did that all just work?
Update: I went ahead and made the phabricator-recommended changes to mysql and PHP, including installing a PHP memory-based cache:
emerge -DavuN dev-php/pecl-apcu
And that, of course, cascaded me into a gentoo server update.
emerge -uDNav --with-bdeps=y --backtrack=100 --autounmask-keep-masks=y @world
And away we go…
UPDATE: ok these are a few more of my “favorite” things…