วีดีโอ

This talk was recorded at the FOSDEM 2023 PGDay in Brussels. Please see the original recording along with other great talks from the day at fosdem.org/2023/schedule/track/postgresql/ Talk Description: In a world where data continues to grow at an overwhelming rate, knowing how to load and insert data into PostgreSQL as efficiently as possible is a key skill for any software or data engineer. Wh...

For the 2022 Advent of Code I wanted to use #PostgreSQL and #SQL to solve the puzzles each day. Day 10 was a quicker solution, although still got myself into something more convoluted than necessary. I show and explain a much simpler solution from Vik Fearing. Star 2 was the most unique solution so, using an aggregate to "draw" letters on the screen to solve the second puzzle. #adventofcode 00:...

For the 2022 Advent of Code I wanted to use #PostgreSQL and #SQL to solve the puzzles each day. Day 9 was a challenge for me, particularly Star 2. Ultimately, I used arrays and recursive CTEs to solve this puzzle, but not without a number of trial and error. #adventofcode 00:00 - Start 01:03 - Puzzle description 02:50 - Star 1 - First attempt 07:21 - Star 1 - Solution 11:05 - Star 2 11:51 - Sta...

For the 2022 Advent of Code I wanted to use #PostgreSQL and #SQL to solve the puzzles each day. In Day 8 I spent a bit more time talking about some of the functions I used to solve the puzzle, including what Set Returning Functions (SRF) are and how features like WITH ORDINALITY can be helpful in solving some of these puzzles. Quick note: I realized after recording the video that one of my "cle...

For the 2022 Advent of Code I wanted to use #PostgreSQL and #SQL to solve the puzzles each day. In Day 7, we use recursive a CTE again to help build a directory structure and solve the puzzle. #adventofcode

For the 2022 Advent of Code I wanted to use #PostgreSQL and #SQL to solve the puzzles each day. In Day 6, I combine ideas from the last couple of days, using recursive CTEs, arrays, and distinct counts to solve the puzzle #adventofcode

For the 2022 Advent of Code I wanted to use #PostgreSQL and #SQL to solve the puzzles each day. In Day 5, I take a deep dive into recursive CTEs and arrays to solve this puzzle. #adventofcode 00:00 - Intro Day 5 11:08 - Recursive CTEs In-depth 24:10 - Star 1 25:10 - Star 2

For the 2022 Advent of Code I wanted to use #PostgreSQL and #SQL to solve the puzzles each day. In Day 4, I show how to use both arrays and range types, along with the built in #Postgres operators to find range overlaps and containment #adventofcode

For the 2022 Advent of Code I wanted to use #PostgreSQL and #SQL to solve the puzzles each day. In Day 3 puzzle, I look at ways to split strings, use the Position function to count string values, and more. #adventofcode

For the 2022 Advent of Code I wanted to use #PostgreSQL and #SQL to solve the puzzles each day. In Day 2, I demonstrate how to use simple VALUES tables and and Common Table Expressions (CTE) to solve the puzzle. #adventofcode

For the 2022 Advent of Code I wanted to use #PostgreSQL and #SQL to solve the puzzles each day. For the Day 1 puzzle, I show two different ways to solve the problem based on my own work and some solutions by others in the #PostgreSQL community. #adventofcode

In this video overview, I discuss why I'm presenting a hands-on session about PostgreSQL at the PASS Data Community SUMMIT 2022 this year, the kinds of topics we'll cover, and what you can expect if you attend the training. Background music by Bensound.com #PostgreSQL #SQLServer #PASSDataSummit