SQL

Here’s a short snippet that I recently used to remove some camel case records and make them lowercase. UPDATE `table` [More…]

Here’s a short snippet that I recently used to replace a bunch of old HTTP links with the now-supported HTTPS. [More…]

On MacOS, Sequel Ace imports CSV’s with newlines at the end. This snippet updates the data to remvoe those lines: [More…]

While making a remittance checker I was running into issues with the huge amount of records coming in that needed [More…]