All Posts
Just Paddle
I really think too much. I have a lot of fear in me that keeps me from doing things I love to do. It's unhealthy and also self-obsessive (there are 3 "I's" and 2 "me's" above). I really need to stop thinking and just... do...
· Rob Conery
Creating a Full Text Search Engine in PostgreSQL, 2022
Writing a full text index in PostgreSQL is an art form. You need to know what your users are looking so you can build the right index AND you need to understand how they write their search terms. Thankfully, Postgres is here to help.
· Rob Conery
The Fabulous Linked List
It’s always fun to study the basics, and in this video we dive into the linked list and how to create one from scratch. Sounds ridiculous, but it can rescue an interview!
· Rob Conery
What's the Difference Between Vue 2.0 and Vue 3.0?
The third version of a framework, library or tool generally sucks, at least in my experience. Will this be the case with Vue 3? Let’s find out!
· Rob Conery
What's Your Exit Plan?
Retirement is one thing, being where you want to be and doing what you want to do when your current job is finished in another thing entirely. What’s your exit strategy?
· Rob Conery
Importing a CSV Into PostgreSQL Like a Pro
Importing data into PostgreSQL can be time consuming and painful – unless you toss the GUI tools and use scripts.
· Rob Conery
What’s the Best Hashing Algorithm for Storing Passwords?
Most people will default to bcrypt when choosing a hashing algorithm for storing sensitive information - but why? Are there other choices? Indeed! In this video we'll take a look at scrypt, PBKDF2 and my favorite: argon2
· Rob Conery
Virtual, Computed Columns in PostgreSQL 12
PostgreSQL 12 introduced a feature I've long wished for: computed columns that are indexable and stored on disk! They're amazing and in this post I'll show you how they work and how things kind of go...
· Rob Conery
Mod and Remainder Are Not The Same
A remainder and a modulus look so very similar, but they are not the same thing and worse, are treated differently by different programming languages. Do you know how your language handles mod?
· Rob Conery
Simple Monthly Reports in PostgreSQL
Working with dates and series of dates is easy in PostgreSQL, especially using generate_series
· Rob Conery
It's Time To Get Over That Stored Procedure Aversion You Have
There is a lot of opinion about stored procedures out there that are just...
· Rob Conery