Categories
Freelancing Tips Web

Scheduling Meeting Times

Dropping poor meeting invites will end your freelancing days fast. Sending exceptional meeting invites can land a lifelong client. If you are sending 4, or even 20, messages to schedule a meeting you are stressing your clients. Meeting invites shouldn’t take more than two communications via emails. Your job as a freelance professional is to […]

Categories
Fix SQL Tips Web

How to Reset the Primary Key Sequence ID in PostgreSQL

I run into an issue today with PostgreSQL. I had manually entered a row into a table and it caused the primary key to fall out of sequence. To reset the primary key sequence ID on the PostgreSQL table I used the setval and pg_get_serial_sequence functions. Source: How to reset postgres’ primary key sequence when […]

Categories
PHP Tips Web

PHP UUID without a Library

A little bit of PHP is sometimes all you need to solve a problem. In our case, we need just a little PHP code to generate a UUID. When you need more I recommend using Ben Ramsey‘s PHP UUID package. P.S. When using a UUID in the database I’d still run a unique check for […]

Categories
Story Tech Web

Q1 2020 Desk Setup

I’m a somewhat minimalist when it comes to my physical workspace and tooling. My desk setup is a bit comical during these unprecedented times but none-the-less effective. I’ve built up this collection over the course of ten plus years. If I’m writing to my younger self… take your time and switch to Apple from Windows […]

Categories
CSS Design HTML Tips Web

Jump-to Links Done Right

A quick CSS tip to kick off the week: to stop jump-to links from touching the top of the page when clicked use the scroll-margin-top property. Using the CSS property will give your design a touch of breathing room. Now, you will not want the page scroll “snapping” scroll-margin-top creates to be always-on (you will […]