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 […]

Categories
Content CSS HTML JavaScript Laravel Leadership Links Marketing PHP SEO Web

Link Share: Issue #2

Today I want to share the podcasts I listen too frequently. Some shows have changed my life. Some shows are new. Some have been around for a long time. The Tim Ferriss Show The Stack Overflow Podcast The Laravel Podcast The GaryVee Audio Experience The CSS Podcast The Case Jarvis LIVE Show Syntax. Planet Money […]