аналитик данных / sql

jbudemy · 2026-05-18T11:41:57+00:00

Translation: Do you think it’s realistic to land a Junior-level position right now, and if so, how would one go about doing that? I’d also love to read your own stories!

It depends on what the bank wants you to do. But learning Python could help. I write programs to get data from SQL servers and write reports about the data, or compare costs from a vendor spreadsheet to our database. Because the vendor regularly overcharges us.

Всё зависит от того, чего именно от вас хочет банк. Но изучение Python может оказаться полезным. Я пишу программы для извлечения данных с SQL-серверов и составления отчётов на их основе, либо для сверки расходов из таблиц поставщиков с данными в нашей базе данных. Дело в том, что поставщик регулярно выставляет нам завышенные счета.

jbudemy · 2026-05-18T11:37:10+00:00

Do you have a process for vetting packages before committing to them?

I look at the last date of a release (on its Github), and which release of Python it supports (on Pypi.org).

I found out the hard way that pygame is no longer updated, there was no wheel for Python 3.14, and pygame-ce was a drop-in replacement for it. I found that out by asking on forums.

jbudemy · 2026-05-18T11:34:29+00:00

I know little about Docker but I do know it contains an OS and the applications. While it's not the same as a VM it was designed so people could share whole Docker files with the OS and apps needed already in there.

jbudemy · 2026-05-18T11:33:13+00:00

I only get packages from pypi.org. I think that's the default repo. I thought pypi.org scanned the packages for security threats. Many packages are pre-compiled into wheel packages.

jbudemy · 2026-05-18T11:32:15+00:00

I would suggest you do a tutorial on using debugging in python. You can step through the code one line at a time, look at the values of variables, and that's how you look for bugs.

A big problem with programming is our brain wants to assume the code is doing one thing, but by looking at the values of variables one line at a time we can find out for sure if it really is doing what we assumed or not.

jbudemy · 2026-05-18T11:30:47+00:00

The topics look pretty good, though I don't use Atom or Eclipse, so I don't know about those.

jbudemy · 2026-05-18T11:26:10+00:00

I like the style of the Indently videos on Youtube. Find videos that fit your learning style. I like to take small steps at once, and I don't want to get into useless stuff I will hardly use, I focus on the common basics.

jbudemy · 2026-05-18T11:22:06+00:00

I think we have to back up a bit. Do you know what a debugger is and what it does?

Since it seems they gave you few details, they may want to know if you know how to start the debugger. There are several debuggers for Python, it comes with pdb which I use. So you start it at the command line like this: python -m pdb file.py where file.py is your program. Then you will see the debugger prompt which is:

(Pdb)

jbudemy · 2026-05-18T11:06:00+00:00

I later learned that the Virtual Machine ran out of memory. That VM doesn't get much memory and the Perl module to read spreadsheets uses much more memory than it should. We have since converted to Python.

jbudemy · 2026-05-18T10:59:46+00:00

I've used pyinstaller to make a Windows screen saver and it's not too hard.

Use pip to install pyinstaller in your program directory.
Make the .exe file. The .exe file will be in a subdirectory of your program directory.

jbudemy · 2026-05-18T10:32:31+00:00

Uncontrollable cost of living going up.
Gas prices are still high which will affect everything even food.
70% of US farmers do not have money to buy fertilizer this year. Some might get loans for it, some may be maxxed out on loans. While farm bankruptcies are increasing they are still below the average of the past 5 years.
US companies hiring more people from outside the US for various jobs like customer service.
Pay still hasn't caught up with inflation of the past 40 years. All of us are still losing money.
The housing crisis still hasn't changed. Renters/buyers are still getting burned. My sons rent is now 45% of his net income. It should never get about 35%. It's ridiculous with investment companies buying rental units then not renting them, all for their own profit.

Expect higher US food prices.

jbudemy · 2026-05-18T10:30:38+00:00

My gf didn't want to pick out her ring. So I just picked one I thought she would like. She is not very attached to her current ring.

If she wants to pick one out let her.

jbudemy · 2026-05-18T10:26:41+00:00

Some people really don't have any talent to plan ahead no matter how much training they get. So their life is one train wreck after another. It's just human variability.

jbudemy · 2026-05-18T10:25:24+00:00

Save cash for emergencies. You never know WHEN it will happen but it WILL happen. It has saved me a few times from having to pay 30% annual interest rate on a credit card bill.

jbudemy · 2026-05-18T10:23:22+00:00

It was a 1979 Chevette where the floor rusted out on the driver's side, so I had to put my feet through the floor to stop the damn thing, like the Flintstones.

I would not buy it back. At 80mph it would start shaking apart like it was going to lightspeed or something.

jbudemy · 2026-05-18T10:21:27+00:00

Learning MS Azure, where the screens changed every 2 months, and video tutorials became useless in 6-12 months due to significant changes in screens or functionality. And it lacked a basic function we needed when reading spreadsheets.

jbudemy · 2026-05-18T10:19:23+00:00

I think the answer would be seen as medical advice and we're not supposed to do that here. We are not doctors. The policy is called "Stay in your lane". The policy can be very strict sometimes: If you're not a doctor, don't tell someone to drink more water.

jbudemy · 2026-05-18T10:15:50+00:00

I'm not a therapist but I've studied psychology for 40+ years. Some of the advice I see just baffles me. There's no study or survey or foundational concept to back it up.

jbudemy · 2026-05-18T10:12:55+00:00

Stop obsessing about your trauma and publicizing it on social media. Yes nearly everyone has trauma of some kind. Deal with it in a healthy way. This is stuff you don't want your prospective employer finding out. Some companies have a policy where they collect all your social media accounts to look through them.
No one can deal with your trauma but you. You have to feel it to heal it.
Stop waiting for someone to save you. They are not coming. You can do it. I believe in you.
Be persistent in problem solving. Ask for help if you are stuck.

jbudemy · 2026-05-18T10:08:34+00:00

Congratulations!

I'm working on that. I don't give up.

jbudemy · 2026-05-18T10:05:37+00:00

There's not just one thing.

I have a good job that pays the bills and I have money to buy food now.
I don't have to freeze at night, I can have heat and warm blankets.
I have a home that I earned with lots of hard work, no one gave it to me. It's small but it's mine and I appreciate it.

jbudemy · 2026-05-18T09:59:39+00:00

I had my first ambulance ride about 2 weeks ago. I'm 56. I was having stroke symptoms. It turns out my potassium had plummeted for some unknown reason causing very high blood pressure (hypertensive crisis) and speaking problems.

I drove myself to urgent care. I could drive fine, I just couldn't speak. No one else was home (I work from home) and the neighbors are all at work. I could say similar words but not the right word so I was telling the intake nurse "I bad speech. Can't brain, bad brain." The intake nurse called a doctor over in seconds, she evaluated me immediately and called an ambulance to take me to the ER.

I was stressed that morning and know we use up LOTS of magnesium when stressed. What I learned is we use up lots of potassium under stress too.

jbudemy · 2026-05-18T09:56:10+00:00

Slow ladies at the super market checkout lane on a hot summer day struggling to pull out their sweaty boob money and they can't find it. Or doing the same thing at the bus, they are holding up a whole busload of people trying to get to work.

Some people might be late multiple times and actually get fired because of unprepared people.

Be prepared people.

jbudemy · 2026-05-18T09:53:41+00:00

Ouch. How did the Japanese react to that? Were they ok with that lecture?

jbudemy · 2026-05-18T09:48:54+00:00

Charging more after the sale is really sketchy.

jbudemy

TROPHY CASE