Fletcher
@fletcheaston.com
he/him
staff swe, casual runner
@fletcheaston on every platform
building software, dreaming of hardware
staff swe, casual runner
@fletcheaston on every platform
building software, dreaming of hardware
Advent of Code 2025 Day 5 done!
The Postgres range types are so good, 10/10 made my life very easy tonight. Also enjoyed using the CTE trick to read, delete, and write data to a table in a single statement
Also forgot to post about Day 4, but finished that last night after a bit of tinkering 😰
The Postgres range types are so good, 10/10 made my life very easy tonight. Also enjoyed using the CTE trick to read, delete, and write data to a table in a single statement
Also forgot to post about Day 4, but finished that last night after a bit of tinkering 😰
December 5, 2025 at 6:47 AM
Advent of Code 2025 Day 5 done!
The Postgres range types are so good, 10/10 made my life very easy tonight. Also enjoyed using the CTE trick to read, delete, and write data to a table in a single statement
Also forgot to post about Day 4, but finished that last night after a bit of tinkering 😰
The Postgres range types are so good, 10/10 made my life very easy tonight. Also enjoyed using the CTE trick to read, delete, and write data to a table in a single statement
Also forgot to post about Day 4, but finished that last night after a bit of tinkering 😰
Advent of Code 2025 Day 3 done!
My Part 1 Solution is extremely fugly, but made good use of a helper function in Part 2 for a more verbose but much cleaner solution
My Part 1 Solution is extremely fugly, but made good use of a helper function in Part 2 for a more verbose but much cleaner solution
December 3, 2025 at 6:24 AM
Advent of Code 2025 Day 3 done!
My Part 1 Solution is extremely fugly, but made good use of a helper function in Part 2 for a more verbose but much cleaner solution
My Part 1 Solution is extremely fugly, but made good use of a helper function in Part 2 for a more verbose but much cleaner solution
Advent of Code 2025 Day 2 done!
The power of helper functions and bigint prevails :)
The power of helper functions and bigint prevails :)
December 2, 2025 at 6:09 AM
Advent of Code 2025 Day 2 done!
The power of helper functions and bigint prevails :)
The power of helper functions and bigint prevails :)
Advent of Code 2025 Day 1 done!
Trying to solve problems using Postgres/SQL this year. Day 1 was really easy, but took awhile to figure out exactly how I wanted to structure this in SQL 😅
Trying to solve problems using Postgres/SQL this year. Day 1 was really easy, but took awhile to figure out exactly how I wanted to structure this in SQL 😅
December 1, 2025 at 6:20 AM
Advent of Code 2025 Day 1 done!
Trying to solve problems using Postgres/SQL this year. Day 1 was really easy, but took awhile to figure out exactly how I wanted to structure this in SQL 😅
Trying to solve problems using Postgres/SQL this year. Day 1 was really easy, but took awhile to figure out exactly how I wanted to structure this in SQL 😅
After a few months off, finally came back to write a technical blog post right before Advent of Code starts up
User-defined ordering is complicated 😅
User-defined ordering is complicated 😅
November 28, 2025 at 6:00 AM
After a few months off, finally came back to write a technical blog post right before Advent of Code starts up
User-defined ordering is complicated 😅
User-defined ordering is complicated 😅
I cannot remember the last time I wasn't flagged by the TSA body scanner. It happens literally every single time
September 20, 2025 at 8:22 PM
I cannot remember the last time I wasn't flagged by the TSA body scanner. It happens literally every single time
Work trip to Orlando for a week, then my partner has a work trip to Philadelphia for a week, then I've got a family thing in Chicago. Next few weeks gonna be a little rough
September 14, 2025 at 4:11 AM
Work trip to Orlando for a week, then my partner has a work trip to Philadelphia for a week, then I've got a family thing in Chicago. Next few weeks gonna be a little rough
Ran nearly 18 of these miles yesterday and my legs are really feeling it today
September 7, 2025 at 3:52 PM
Ran nearly 18 of these miles yesterday and my legs are really feeling it today
"give us 15-20 minutes" and then it's still not ready 40+ minutes later. Like it's cool if y'all are busy, just give me a realistic time to come pick it up 😭
September 7, 2025 at 12:57 AM
"give us 15-20 minutes" and then it's still not ready 40+ minutes later. Like it's cool if y'all are busy, just give me a realistic time to come pick it up 😭
Got recognized by a coworker on Blind by "being positive, doing well, and offering to help"
Can't even remain anonymous, just having too good of a time I guess smh
Can't even remain anonymous, just having too good of a time I guess smh
September 5, 2025 at 4:54 AM
Got recognized by a coworker on Blind by "being positive, doing well, and offering to help"
Can't even remain anonymous, just having too good of a time I guess smh
Can't even remain anonymous, just having too good of a time I guess smh
There's a SECOND sinkhole outside our apartment complex 😭
September 1, 2025 at 7:05 AM
There's a SECOND sinkhole outside our apartment complex 😭
6.8 miles on the treadmill kinda easy 💪🏻
September 1, 2025 at 2:53 AM
6.8 miles on the treadmill kinda easy 💪🏻
Nice and easy 10 miles on the treadmill yesterday
August 31, 2025 at 3:15 PM
Nice and easy 10 miles on the treadmill yesterday
Beat the early access version of Sol Cesto in about 4 hours. Still a bit to do and explore, but got to the end of the run with a pretty strong build and don't feel a need to try for another full run. Really fun chill game!
August 31, 2025 at 12:08 AM
Beat the early access version of Sol Cesto in about 4 hours. Still a bit to do and explore, but got to the end of the run with a pretty strong build and don't feel a need to try for another full run. Really fun chill game!
Pokemon GO getting a change to leveling system/scale??
August 25, 2025 at 2:04 PM
Pokemon GO getting a change to leveling system/scale??
Back from the cruise, haven't been this relaxed in a long time. Glad I took tomorrow off too
August 21, 2025 at 1:54 AM
Back from the cruise, haven't been this relaxed in a long time. Glad I took tomorrow off too
Sailing to Cabo for the next few days, doing absolutely nothing but chilling and reading. Life is good
August 15, 2025 at 6:50 PM
Sailing to Cabo for the next few days, doing absolutely nothing but chilling and reading. Life is good
My local Main Hot Chicken store has updated take-out packaging and it's SO MUCH BETTER than the old packaging. There's a functional lid, the fries come in a bag, and the box no longer leaks. Amazing
August 11, 2025 at 3:59 AM
My local Main Hot Chicken store has updated take-out packaging and it's SO MUCH BETTER than the old packaging. There's a functional lid, the fries come in a bag, and the box no longer leaks. Amazing
14 miles at ~10 min/mile. Not particularly fast, but I felt really good the whole run!
Carrying water sorta sucks until you're a mile away from any pubic water fountain and you've still got a liter of cool water on your back
Carrying water sorta sucks until you're a mile away from any pubic water fountain and you've still got a liter of cool water on your back
August 9, 2025 at 7:09 PM
14 miles at ~10 min/mile. Not particularly fast, but I felt really good the whole run!
Carrying water sorta sucks until you're a mile away from any pubic water fountain and you've still got a liter of cool water on your back
Carrying water sorta sucks until you're a mile away from any pubic water fountain and you've still got a liter of cool water on your back
Pro tip, take the baddie out to an art festival and they'll love you forever
July 27, 2025 at 8:25 AM
Pro tip, take the baddie out to an art festival and they'll love you forever
Wrote about my own custom Genome Browser. It's pretty basic so far, but I'm really happy with how it looks and feels :)
fletcheaston.com/software/pro...
fletcheaston.com/software/pro...
SARS-CoV-2 Genome Browser 1.0 | Fletcher's Weblog
My own interactive genome browser for the SARS-CoV-2 reference genome. View genes, proteins, and nucleotide bases.
fletcheaston.com
July 26, 2025 at 10:34 PM
Wrote about my own custom Genome Browser. It's pretty basic so far, but I'm really happy with how it looks and feels :)
fletcheaston.com/software/pro...
fletcheaston.com/software/pro...
Reposted by Fletcher
I'm recording timelapses for every submission - this took 41 minutes in real time.
Soon you'll be able to submit your own images to be drawn on my kilopixel! Can't wait to share this with the world and see what y'all come up with
Soon you'll be able to submit your own images to be drawn on my kilopixel! Can't wait to share this with the world and see what y'all come up with
July 21, 2025 at 4:59 AM
I'm recording timelapses for every submission - this took 41 minutes in real time.
Soon you'll be able to submit your own images to be drawn on my kilopixel! Can't wait to share this with the world and see what y'all come up with
Soon you'll be able to submit your own images to be drawn on my kilopixel! Can't wait to share this with the world and see what y'all come up with
I've played 3 games of Word Play so far and beaten Easy, Normal, and Hard on my first attempt of each. Kinda cracked
July 21, 2025 at 7:29 AM
I've played 3 games of Word Play so far and beaten Easy, Normal, and Hard on my first attempt of each. Kinda cracked
40 miles a week for the next month, trying to build a bit of speed instead of pure volume. Then back to 10% week over week increases for awhile
July 9, 2025 at 5:15 AM
40 miles a week for the next month, trying to build a bit of speed instead of pure volume. Then back to 10% week over week increases for awhile