Brady @DataCastworks's Avatar

Brady @DataCastworks

@datacastworks

Regularly posting notes while learning Python, PostgreSQL, and Tableau. Lifelong nerd, Pittsburgh based.

12
Followers
77
Following
30
Posts
19.12.2025
Joined
Posts Following

Latest posts by Brady @DataCastworks @datacastworks

Pretty sure I'm coding wrong

22.01.2026 15:09 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0
Post image

๐ŸŽ‰ Pandas 3 is out!

As of a short while ago, installing #Python #Pandas from PyPI, with either pip or uv, will give you the latest version.

What's new? What has changed? ๐Ÿค”

I've got a whole YouTube playlist to tell you: www.youtube.com/playlist?lis...

22.01.2026 07:07 ๐Ÿ‘ 7 ๐Ÿ” 2 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 1

Ok, so you've got a big JSON, what are you going to do with it?

#postgresql #pythoncoding

10.01.2026 16:13 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Good read. I'm wondering at what level you get cross-talk between the two systems if they're such independent paths? Are there nodes where the two converge, or at least where the traditional metrics and databases serve as one source of context for the AI side?

06.01.2026 03:45 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0
Preview
Healthchecks.io โ€“ Cron Job Monitoring Simple and efficient cron job monitoring. Get instant alerts when your cron jobs, background workers, scheduled tasks don't run on time.

My first home server dropped off the network. I caught it in time for my cron scripts to recover, but it made me realize that the whole thing can fail silently. Iโ€™m using a dead man switch now (healthchecks.io) now so that won't happen again.

@monkeyseemonkeydo.lv #pythoncoding #cron

05.01.2026 23:47 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Thank you for this, as a professional starting out and hearing so much messaging about NoSQL, it's good to remember that it isn't the solution for every company.

05.01.2026 23:30 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Would love to hear more about which credentials or certifications are most valuable to prospective employers. Any initial ideas?

05.01.2026 23:19 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

I paid for the whole computer I get to break the whole computer

03.01.2026 21:03 ๐Ÿ‘ 19 ๐Ÿ” 2 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

My 2 cents: 100 Days of Code, the Complete Python Pro Bootcamp by Dr. Angela Yu if you can access Udemy (free library access here). You build or debug something every class and it's easy to plow through quickly or go slow whatever your pace.

04.01.2026 02:40 ๐Ÿ‘ 2 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

I'm new here but is anyone calling their .env a dot-envy file?

#pythoncoding

02.01.2026 21:01 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

Much like the Oxford comma. Technically either way is correct but that extra comma saves lives.

02.01.2026 02:14 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0
Preview
The benefits of trailing commas Trailing commas make for easier code changes, shorter diffs, and fewer bugs.

The feature (and bug waiting to happen) is also the reason I recommend using trailing commas for lists, dictionaries, sets, and function calls that wrap over multiple lines: pym.dev/trailing-com...

Also note that Guido isn't a fan of this feature either:
lwn.net/Articles/551...

01.01.2026 19:04 ๐Ÿ‘ 2 ๐Ÿ” 1 ๐Ÿ’ฌ 2 ๐Ÿ“Œ 0

I like the takeaway from the explanation: "Use 'if not x' only when you truly mean empty."

01.01.2026 22:48 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

@nws.noaa.gov the API for Norfolk hasn't updated in 24 hours, hope it's something minor!

@noaacomms.noaa.gov #bugreport

01.01.2026 17:35 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Desperately running ScanDisk hoping it will fix things while only delaying the inevitable...

#90skidsremember

01.01.2026 17:15 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0
Preview
Pittsburgh City Paper closes Pittsburgh City Paper is closing after 34 years of operation. Employees at the alt-weekly Pittsburgh City Paper publication posted on social media that the news outlet was closing. Colin Williams, new...

Sad to see Pittsburgh City Paper going away. In 1996, the then-young weekly gave me a shot and I got to learn from John Hayes, Chris Potter, Bill O'Driscoll and Lisa Cunningham, among many others. Our region's media landscape loses a source of lively, community reporting triblive.com/business/pit...

31.12.2025 21:22 ๐Ÿ‘ 28 ๐Ÿ” 7 ๐Ÿ’ฌ 2 ๐Ÿ“Œ 2
Post image

Needed to clean code after my first major rewrite.

'Coverage.py' is awesome, showed exactly what isn't getting called. I silently broke something on the path to email alerts for the error logger. Oops...

@nedbat.com #python #coding

30.12.2025 15:29 ๐Ÿ‘ 4 ๐Ÿ” 1 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

I butchered my beautiful first code. Tore it to pieces to get it working with a different API to get a data pipeline in place before Jan 1.

First production script, first time running amok to hit a deadline.

It works though....

#python #postgresql

30.12.2025 03:56 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

It's just for-loops all the way down

#python #coding

26.12.2025 00:44 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

I always spelled it out, "eff-ay-queues". Now questioning everything I never knew about acronyms ๐Ÿ˜‚

25.12.2025 00:45 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

99 Percent Invisible has me wondering if I've been saying "F.A.Q.s" wrong my whole life. "Facks"!?

How do you say it?

@99pi.org @romanmars.bsky.social @vivianhle.bsky.social #facts

24.12.2025 18:32 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

Learning to code now means learning how to use AI the right way, and I don't know any good resources that teach that.

Feels like being a math major when the calculator was invented.

24.12.2025 05:15 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Highly recommend 100 Days of Code by Angela Yu for python if you have access to Udemy (free through some local libraries). Very beginner friendly and methodical.

24.12.2025 05:10 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

Crisis in progress.

After 2 weeks on my first big project:

The data from the API isn't valid.

Learning about troubleshooting and pivoting and how to reuse what I've already written.

23.12.2025 17:52 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Best to have at least one on your side for the eventual uprising.

23.12.2025 04:36 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

AI for learning:

Don't ask GPT to fix your code.

Ask for it to do a code review and highlight weaknesses without giving you the answers.

#python #postgres #chatgpt #ai #aiforlearning

22.12.2025 21:43 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

I think it can be a nice sanity-check or reference while you build something, but wouldn't trust the outcome without checking the underlying data.

GPT got very confused iterating through cities and states on a recent list I had it proof-read.

22.12.2025 18:00 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Substitute 'y' on the last line to get:
'x.run().run().run()'

So AAA

22.12.2025 17:54 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Top Python Libraries of 2025 (11th Edition)

https://www.reddit.com/r/Python/comments/1pptnyc/top_python_libraries_of_2025_11th_edition/

22.12.2025 03:15 ๐Ÿ‘ 6 ๐Ÿ” 1 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Waking up to error emails from my server...

...means my first production python script is working.

#raspberrypi #python #postgres

21.12.2025 15:17 ๐Ÿ‘ 2 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0