Here’s a list of handy Vim commands

Posted on March 15, 2023 by zzz_zwp

Vim is a powerful and versatile text editor with numerous commands that can make editing more efficient. Here are some of the most useful commands for Vim: Basic movement: h, j, k, l: Move the cursor left, down, up, and … Continue reading →

Uses This Product Listing

Posted on December 27, 2018 by zzz_zwp

We were curious what products were recommended the most in interviews at “Uses This”. Below you will find a listing of all the product mentions we could find and the number of times it was mentioned as of this date. … Continue reading →

Postgresql Commands to Import / Export (pg_restore, pg_dump) databases

Posted on November 6, 2018 by zzz_zwp

Here are a couple commands for dealing with importing and exporting (or restoring and dumping) Postgres databases. This assumes Postgres is running on localhost. These commands should seem similar to mysqldump / mysql mydb < mydump.sql import / exporting / … Continue reading →

mkdir(1) – Linux manual page

Posted on October 25, 2018 by zzz_zwp

Ruby on Rails Infinite Scroll Patterns

Posted on September 11, 2018 by zzz_zwp

Here’s a variety of methods for accomplishing infinite scroll with Ruby on Rails. This functionality is sometimes referred to by a variety of names including Infinite pagination, ajax pagination, endless page. These methods utilize will_paginate or kaminari gems and some … Continue reading →

Stop ksfetch / Keystone Fetch / Google Software Updater Network Requests on Mac

Posted on May 16, 2017 by zzz_zwp

If you notice this process which seems to make network requests quite often you may wonder what the heck it is. Apparently it is a Google software updater process. To me it seems to run much too frequently. I prefer … Continue reading →

Daily Backup Sqlite3 Database Shell Script

Posted on April 5, 2017 by zzz_zwp

Here’s a basic script to generate database backups for an Sqlite3 database. Simply copying the .sqlite3 database file may work but there may be issues and data corruption if the database is locked or actively being used. The better option … Continue reading →

Bash One-liner to Make All File Names Lowercase

Posted on February 10, 2015 by zzz_zwp

for f in *; do mv $f `echo $f | tr ‘[:upper:]’ ‘[:lower:]’`; done Source: bradchoate.com: Lowercase Filenames.

Create a bootable installer for OS X Mavericks or Yosemite – Apple Support

Posted on November 15, 2014 by zzz_zwp

Create a bootable installer for OS X Mavericks or Yosemite – Apple Support.

SELECT option_name, option_value FROM wp_options WHERE option_name IN ('_site_transient_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4','_site_transient_timeout_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4')

SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (1771, 1734, 1728, 1725, 1721, 1698, 1683, 1660, 1658, 1656) ORDER BY t.name ASC

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (470,52,489,471,472,490,478,484,466,477,492,483,479,476,480,475,465,485,486,481,482,70,14,37,473,464,474,469,35,1,491,82)

SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (468) ) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC

SELECT wp_comments.comment_ID FROM wp_comments JOIN wp_posts ON wp_posts.ID = wp_comments.comment_post_ID WHERE ( comment_approved = '1' ) AND wp_posts.post_status IN ('publish') ORDER BY wp_comments.comment_date_gmt DESC LIMIT 0,5

SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC

[0] => themes/twentyeleven/inc/theme-options.php [1] => themes/twentyeleven/inc/widgets.php [2] => themes/twentyeleven/index.php [3] => themes/twentyeleven/header.php [4] => themes/twentyeleven/searchform.php [5] => themes/twentyeleven/content.php [6] => themes/twentyeleven/sidebar.php [7] => themes/twentyeleven/footer.php [8] => themes/twentyeleven/sidebar-footer.php

$_SERVER = array ( 'SERVER_SOFTWARE' => 'Apache', 'REQUEST_URI' => '/', 'LSPHP_ENABLE_USER_INI' => 'on', 'PATH' => '/usr/local/bin:/usr/bin:/bin', 'TEMP' => '/tmp', 'TMP' => '/tmp', 'TMPDIR' => '/tmp', 'PWD' => '/', 'HTTP_ACCEPT' => '*/*', 'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate', 'CONTENT_LENGTH' => '0', 'HTTP_HOST' => 'www.zzzzzzzzz.net', 'HTTP_REFERER' => 'https://zzzzzzzzz.net/', 'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'HTTP_X_HTTPS' => '1', 'UNIQUE_ID' => 'Z4rl5rukpgX0MSIUt1ReTwABIgo', 'QS_ConnectionId' => '173715607094745750267034', 'SCRIPT_URL' => '/', 'SCRIPT_URI' => 'https://www.zzzzzzzzz.net/', 'HTTPS' => 'on', 'SSL_TLS_SNI' => 'www.zzzzzzzzz.net', 'HTTP2' => 'on', 'H2PUSH' => 'off', 'H2_PUSH' => 'off', 'H2_PUSHED' => '', 'H2_PUSHED_ON' => '', 'H2_STREAM_ID' => '3', 'H2_STREAM_TAG' => '267034-343-3', 'SERVER_SIGNATURE' => '', 'SERVER_NAME' => 'www.zzzzzzzzz.net', 'SERVER_ADDR' => '192.185.137.117', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '18.118.138.113', 'DOCUMENT_ROOT' => '/home1/zzz/public_html', 'REQUEST_SCHEME' => 'https', 'CONTEXT_PREFIX' => '', 'CONTEXT_DOCUMENT_ROOT' => '/home1/zzz/public_html', 'SERVER_ADMIN' => 'webmaster@zzzzzzzzz.net', 'SCRIPT_FILENAME' => '/home1/zzz/public_html/index.php', 'REMOTE_PORT' => '28470', 'SERVER_PROTOCOL' => 'HTTP/2.0', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'SCRIPT_NAME' => '/index.php', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => 1737156070.9692280292510986328125, 'REQUEST_TIME' => 1737156070, 'argv' => array ( ), 'argc' => 0, );

0.4251	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1`
0.2668	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1`
0.3119	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_scan_log/18.118.138.113/1737156070.984' LIMIT 1`
0.2789	`SELECT option_value FROM wp_options WHERE option_name = 'gzipcompression' LIMIT 1`
0.3400	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_encryption_keys_set' LIMIT 1`
0.3359	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' LIMIT 1`
0.4370	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_ssl_activation_active' LIMIT 1`
0.4861	`SELECT option_name, option_value FROM wp_options WHERE option_name IN ('_site_transient_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4','_site_transient_timeout_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4')`
0.5209	`SELECT option_value FROM wp_options WHERE option_name = 'preload_cache_counter' LIMIT 1`
5.4462	`SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish'))) ORDER BY wp_posts.post_date DESC LIMIT 0, 10`
0.4940	`SELECT FOUND_ROWS()`
9.7811	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (1771,1734,1728,1725,1721,1698,1683,1660,1658,1656)`
0.9160	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1771,1734,1728,1725,1721,1698,1683,1660,1658,1656) ORDER BY meta_id ASC`
1.5860	`SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (1771, 1734, 1728, 1725, 1721, 1698, 1683, 1660, 1658, 1656) ORDER BY t.name ASC`
1.2271	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (470,52,489,471,472,490,478,484,466,477,492,483,479,476,480,475,465,485,486,481,482,70,14,37,473,464,474,469,35,1,491,82)`
0.6671	`SELECT * FROM wp_posts WHERE ID = 1716 LIMIT 1`
0.5250	`SELECT option_value FROM wp_options WHERE option_name = 'https_migration_required' LIMIT 1`
0.4568	`SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1`
0.8759	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 468`
1.7970	`SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (468) ) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC`
1.3320	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1670,1671,1672,1681,1682) ORDER BY meta_id ASC`
0.7899	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (1542,1534,1579,1544)`
0.6890	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1542,1534,1579,1544) ORDER BY meta_id ASC`
1.4000	`SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC`
0.7930	`SELECT * FROM wp_users WHERE ID IN (1)`
1.0180	`SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC LIMIT 0, 5`
1.4951	`SELECT wp_comments.comment_ID FROM wp_comments JOIN wp_posts ON wp_posts.ID = wp_comments.comment_post_ID WHERE ( comment_approved = '1' ) AND wp_posts.post_status IN ('publish') ORDER BY wp_comments.comment_date_gmt DESC LIMIT 0,5`
6.6631	SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
0.8130	`SELECT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') AND tt.count > 0 ORDER BY t.name ASC`

z z z z z z z z z