DEV Community

loading...
zchtodd profile picture

zchtodd

I'm a software developer that loves to write, make cool little apps, and help others learn about programming!

Location Raleigh, NC Joined Joined on  Twitter logo
Work

Software Developer

All 43 comments

#SQL30 Day 1: Wildfires

Nice! I think of window functions as the heavy artillery.....

Pytest Features, That You Need in Your (Testing) Life

Awesome article... I use pytest pretty regularly but some o...

How to query with PostgreSQL wildcards like a Pro

Great article! I always forget that you can use underscore...

Generate dummy data with Postgres

The generate_series function is so useful!

#SQL30 Day 10: Random Sampling

Somehow I ended up overwriting the solution for day 9 with ...

What was your win this week?

I've kept up with the daily SQL challenges that I started p...

Postgres Is Underrated—It Handles More than You Think

I'm not sure if it fits your use case perfectly, but take a...

What database do you use?

PostgreSQL is probably my favorite database too, and I tota...

What database do you use?

I'm curious about what Mongo offers in those situations, be...

What database do you use?

I've never used MS SQL myself. One really random feature t...

Personality Tests Don't Belong In Job Interviews

I've experienced the personality test phenomenon myself, bu...

What do you use for Python development?

Hey, great question. Here are my favorites: I use a prog...

#SQL30 Day 3: Weather Data

Added a hint to this one, in case I went a little too obscu...

#SQL30 Day 2: Stock Price Variance

Almost identical to what I ended up doing, with the excepti...

#SQL30 Day 3: Weather Data

Oops, I was afraid I'd end up forgetting a table. Fixed!

What is key to a great home office setup?

I would say the most important thing is a door that stays c...

👨‍💻🤖 The 3 best auto formatters for Python

I never looked back after I discovered black. It's amazing...

How do template literals in JavaScript work under the hood?

Pretty cool! I would be a little intimidated to delve into a...

Svelte for Angular Developers

This is awesome, and very timely for me. I'm been using An...

What was your win this week?

I started a series of SQL challenges this week, and I'm pos...

#SQL30 Day 1: Wildfires

That's an awesome solution, thanks for writing that. I don...

Git Workflow: How much change is too much change for one commit for you?

Committing and pushing acts partly as a form of backup for ...

#SQL30 Day 1: Wildfires

Thanks!

Use the right tool to get identity values back after an insert

Nice! Although I have to admit I've never seen an identity...

Vim quickies/ cheatsheet

I've been working with Vim for quite a while, but there's a...

Tools of the Week #1

Cool! Docker is definitely something where I know enough t...

How to become a senior developer?

I wouldn't be surprised if there was a little fear of the u...

Are Timed Coding Interviews A Good Indicator Of Job Performance?

I can identify with that. Unfortunately I think those kinds ...

Are Timed Coding Interviews A Good Indicator Of Job Performance?

Not sure it qualifies as a terrible interview, but I have g...

Are Timed Coding Interviews A Good Indicator Of Job Performance?

Haven't run into it myself yet, but I have heard about it. ...

Linked Lists in JavaScript and Ruby

Nice! I like the side by side with two languages, it's lik...

Why you can't (and shouldn't) remember everything when learning to code

Good article and completely agree. I hang out on /r/learnp...

Learning to Succeed Through 96 Failures

I like this mindset toward side projects because I too ofte...

Are Timed Coding Interviews A Good Indicator Of Job Performance?

I'm glad I haven't encountered the "record a video" phenome...

How Architecture Improved My Coding Skills

Great article, I enjoyed reading it! I feel like balancing u...

Poll: Do you read the question or answers first on Stackoverflow?

Yeah I think so. Usually I can tell faster that way if it'...

Poll: Do you read the question or answers first on Stackoverflow?

It's kinda weird but a lot of times I'll go straight to the...

Guide: Type Hinting in Python

Nice guide to type hints. I've always been on the fence ab...

Computer Vision and OCR with Python

Cool! We use tesseract where I work to read data off of so...

How to become a Developer while being a Student

To your point about not having free time or energy, I feel ...

Arrested (Web) Development - Part 1

I love the idea! It also makes me realize just how much co...

Coding Abomination: Conway's Game of Life in TSQL

I always love crazy SQL stuff like this that goes beyond wh...

Let's discuss about databases?

ORM vs no ORM is an interesting debate that seems to come u...

loading...