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 ConsoleFrom 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:
- Go to Google Fonts and browse around and select ones you like, then click the bar in the footer to get an installation guide. This generated link is the important part:
- https://fonts.googleapis.com/css?family=Lato|Montserrat|Oswald|Quicksand|Roboto
- Because it is a “heavy thing”, I pared that list down to Montserrat for paragraph text and Quicksand for headings.
- Put one-shot loading of the link into functions.php (details on wiki); example:
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' );
- Specify the style in CSS (details on wiki):
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.
- first I had to [emerge -av glibc] as it was ancient
- do not put comments in [/etc/portage/package.use/zzz_autounmask]
- used advice from gentoo perl docs:
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…
- mediawiki required an update, I had to manually tweak my multi-site LocalSettings overrides since some themes were removed, and some were added.
- I decided to go through all the phabricator tweaks that it complains about.
- I fell into an update of my fork of Simple Web Server, not really related except that it was YA deep rabbit hole.
- Files served up were made real pretty with this; I had to tweak the .htaccess to make it correctly mo safe.
- Moving to boost 1_69_0 was actually a lot of (CPU) work.
- While I was moving things around, I set up a nice git flow for my stock app, with branches:
- develop
- feature/postgress-archive
- refactor/use-archive-db
- master
- release/1.55.41-pre-archive-database
- develop
