I have developers come to me occasionally mystified by this error messages like this: ERROR 1055 (42000): ‘<tablename>.<columnname>’ isn’t in GROUP BY What does that mean, exactly, and why is the query getting kicked back? To illustrate, let’s say we have a tabe, geodata, which has this data for all US cities–the table has just ..
Category : Development
aka Setting up DBeaver for use with Redshift. Step by step Setting up DBeaver for use with Redshift is not the most intuitive thing you’ll ever do. A common misconception is that since Redshift is (sorta) built on Postgres, then a Postgres driver is the correct choice. Alas, nope. Here is a quick how-to for setting up DBeaver correctly as possible for Redshift. Here’s the standard DBeaver opening screen Right-click on your Redshift connection and choose “Edit Connection (F4)” That will present you with ..
The screen utility is not included on some server builds. You *have* to have screen or tmux as a DBA or long-running scripts and DML will timeout and the ssh daemon will boot you off the server. As a workaround, I copy the “screen” binary from /usr/bin/screen on a server that does have it installed ..
Online no-code application development: https://adalo.com..
Stupid command line tricks: I often run SQL jobs that can take many days to fully execute, and I always pipe the error and stdout to a file. As such, you end up with lots of lines like this in the output:Query OK, 81218 rows affected (52.76 sec)Here’s a silly one-liner that will quickly total ..
https://www.w3schools.com/howto/howto_css_table..
gron transforms JSON into discrete assignments to make it easier to grep for what you want and see the absolute ‘path’ to it. It eases the exploration of APIs that return large blobs of JSON but have terrible documentation. ▶ gron “https://api.github.com/repos/tomnomnom/gron/commits?per_page=1” | fgrep “commit.author” json[0].commit.author = {}; json[0].commit.author.date = “2016-07-02T10:51:21Z”; json[0].commit.author.email = “mail@tomnomnom.com”; json[0].commit.author.name ..
Make sure you’re using GNU find and GNU sed. find . -type f -exec sed -i ‘s/OLDSTRING/NEWSTRI..
The “last packet successfully received from the server XXXXX milliseconds ago” errors are virtually always caused by stale connections. There are a number of possible solutions, most having to do with small code changes. Here are things to try to alleviate the issue. I apologize in advance if these have already been tried; I’m shooting ..
There are times when you need to move WordPress around within your server, and times when you need to move WordPress from one server to another. You don’t need to reinstall. WordPress is flexible enough to handle all of these situations. When Your Domain Name and URLs Do Not Change Moving your domain without changing ..
Many people want WordPress to power their site’s root (e.g. http://example.com) but they don’t want all of the WordPress files cluttering up their root directory. WordPress allows you to install it into a subdirectory, but have your blog exist in the site root. As of Version 3.5, Multisite users may use all of the functionality ..
Below is a fairly comprehensive list of most widely used performance testing tools for measuring web application performance and load stress capacity, current as of this post date (2012-09-19). These load testing tools will ensure your application performance in peak traffic and extreme stress conditions. The list includes open source as well as licensed performance ..
Quickie to add a semicolon to end of non-commented lines (useful paired with the SHOW GRANTS bash script) #!/usr/bin/perl — open DATA, “$ARGV[0]”; while () { $liner=$_; if (“$liner” =~ /^#/) { print $liner; } else { chomp($liner); print “$liner” . “;n”; } } c..