A Small Note On Python SQL via Linux from a Noob

in Learn2code5 months ago


Since I’ve been trying to learn about python again, I decided to jump several hoops to also take up on SQL. I can honestly say, setting up python and sql on linux wasn’t fun at all. There are many hoops just to get the work done . Anyway, I swear, documentation out there are either unclear, unmaintained, outdated that makes me pull my hair and stayed up all night to figure out missing packages or any errors that I encounter. This was different from my experience using windows and it’s been years since I use windows. Now, if I were to use one, I probably wouldn’t know.

After I set up my environment for python3, running scripts were easier. On the side, I also installed juypter that I got exposed to after reading the python book I read. Since I decided to jump hoops to Python SQL, there were more problems that I have to install some kind of “bridge” that would allow me to use SQL with python. Basically I have to install something called pyodbc or pymssql driver from microsoft. I just realized that at the moment of writing this, I must have missed a few steps and I’ll troubleshoot that later. Just last night, I tried hivesql and I logged in with ease but since I am new to python-SQL interraction, I am mostly still learning how to read the data and the code. Maybe I’ll fetch some data or maybe I’ll just focus on python first and actually dive into it rather than jumping through hoops like what I am doing now.

In another note, I made this community to share, learn, ask any coding problems that you come across. It’d really be nice if we have our own style stackoverflow that are helpful and you don’t have to write lenghty blog post but just enough to mention your problem and how you’d want the community to help you. Anyone can chip in and write the answer while getting some actual reward when solving the problem. I guess, that’s the direction that I am going with the community. You can also drop your ubuntu problems, tips, what you recently solve and microsoft problems you come across. Who knows, maybe someone will help you solve it!

If you’re interested in moderating the community and growing it, let me know too. Especially if you are new to programming and want to learn together!


Don't hesitate to upvote for more content like this ! You can also support me on Buymeberries!

image.png𝘔𝘢𝘤 𝘪𝘴 𝘢 𝘴𝘦𝘭𝘧-𝘦𝘮𝘱𝘭𝘰𝘺𝘦𝘥 𝘯𝘪𝘯𝘫𝘢. 𝘈 𝘵𝘺𝘱𝘪𝘤𝘢𝘭 𝘪𝘯𝘵𝘳𝘰𝘷𝘦𝘳𝘵 𝘪𝘯 𝘭𝘰𝘷𝘦 𝘸𝘪𝘵𝘩 𝘭𝘪𝘵𝘦𝘳𝘢𝘵𝘶𝘳𝘦, 𝘣𝘰𝘰𝘬𝘴, 𝘵𝘦𝘤𝘩𝘯𝘰𝘭𝘰𝘨𝘺 𝘢𝘯𝘥 𝘱𝘩𝘪𝘭𝘰𝘴𝘰𝘱𝘩𝘺. 𝘛𝘩𝘪𝘴 𝘪𝘴 𝘩𝘦𝘳 𝘱𝘦𝘳𝘴𝘰𝘯𝘢𝘭 𝘣𝘭𝘰𝘨 𝘵𝘩𝘢𝘵 𝘤𝘰𝘷𝘦𝘳𝘴 𝘩𝘦𝘳 𝘫𝘰𝘶𝘳𝘯𝘦𝘺 𝘥𝘦𝘭𝘷𝘪𝘯𝘨 𝘪𝘯𝘵𝘰 𝘱𝘩𝘰𝘵𝘰𝘨𝘳𝘢𝘱𝘩𝘺, 𝘵𝘳𝘢𝘷𝘦𝘭, 𝘯𝘰𝘰𝘵𝘳𝘰𝘱𝘪𝘤𝘴, 𝘱𝘳𝘰𝘥𝘶𝘤𝘵𝘪𝘷𝘪𝘵𝘺, 𝘮𝘪𝘯𝘪𝘮𝘢𝘭𝘪𝘴𝘵 𝘭𝘪𝘧𝘦𝘴𝘵𝘺𝘭𝘦, 𝘤𝘺𝘣𝘦𝘳𝘴𝘦𝘤𝘶𝘳𝘪𝘵𝘺, 𝘢𝘯𝘥 𝘭𝘢𝘯𝘨𝘶𝘢𝘨𝘦𝘴. 𝘐𝘯 𝘩𝘦𝘳 𝘧𝘳𝘦𝘦 𝘵𝘪𝘮𝘦, 𝘴𝘩𝘦 𝘦𝘯𝘫𝘰𝘺𝘴 𝘭𝘦𝘢𝘳𝘯𝘪𝘯𝘨 𝘷𝘢𝘳𝘪𝘰𝘶𝘴 𝘵𝘩𝘪𝘯𝘨𝘴. 𝘐𝘧 𝘺𝘰𝘶 𝘭𝘪𝘬𝘦 𝘩𝘦𝘳 𝘤𝘰𝘯𝘵𝘦𝘯𝘵, 𝘥𝘰𝘯'𝘵 𝘩𝘦𝘴𝘪𝘵𝘢𝘵𝘦 𝘵𝘰 𝘶𝘱𝘷𝘰𝘵𝘦, 𝘭𝘦𝘢𝘷𝘦 𝘢 𝘤𝘰𝘮𝘮𝘦𝘯𝘵 𝘰𝘳 𝘢 𝘧𝘦𝘦𝘥𝘣𝘢𝘤𝘬. 𝘈 𝘳𝘦-𝘣𝘭𝘰𝘨 𝘪𝘴 𝘢𝘭𝘴𝘰 𝘢𝘱𝘱𝘳𝘦𝘤𝘪𝘢𝘵𝘦𝘥.

Man, I really wish to get back at learning how to code...
But for now life has been keeping me redirected somewhere else .
Happy to see you grinding in the space as always dear. ;)

man we've missed your content all around here. Hope everything is alright with you, cheers!!

Yeah I'm good...
I've been busy creating my own business here in Iran...
In fact I have 3 new posts, check them out if you got the time.
I'm gonna try being around more often. :)

People are picking Python more and more, glad to see that. I have also completed the basics of python and then lost track. Wish to get back with some project practices to run again.
Good initiative by creating this community, would love to be active here.

Just post in the community whenever you're stuck with something 😄 I want to create that based on my personal exp dealing with linux probs but always find no exact answer and keep forgetting to document the answer when I did that. I just think that short help content like that should have a place on hive too! especially when places like stackoverflow and askubuntu are also famous and is super helpful!

Ah yes, Stackoverflow! that's where I rush when I get any problem but yeah creating a hub within ourselves is a great idea. Will contribute as much as I can. Thanks!

Good idea for a community... I will sub and try to remember to check in. My day job has me doing a lot of SQL, and I know Java fairly well... bit of python, bit of c#, bit of vb.net... so I might be able to help now and then.

I'd totally need your help😄 I am currently learning python SQL and working it on linux has been a headache. I am not sure if I missed some steps with installing that pyodbc but I'll figure that out later. Also feel free to document some of troubleshoot that you find which might helpful for others too. I have one simple stuff that apparently is still visited so often like installing times new roman in my ubuntu 😂

Can do - I generally do everything on Windows, but I recently had to re-setup Windows Terminal to be pretty for my git stuff so maybe I could touch on that. It's not troubleshooting so much as it is 'make your command line look nicer on windows'

Thank you!! will totally tag you if I have questions on SQL. Beforehand though, I'd apologize if I ask something stupid haha :D

There are no stupid questions when you're picking up a new language. Ask any time, here or on discord. I'm sure we share some - just dm me at SanguineHaze#7826 on discord if you need anything.

I started learning Python a couple of years ago for my Thesis, then I decided to dive into Python again and other languages because I want a career shift. My course is not Computer Science or Computer Engineering so I really consider myself a newbie to programming. And this community is timely tho. I would love to hop in and learn together with the pro and aspiring programmers here on Hive. 😊

Awesome, just want to keep the community super casual and helpful place as long as it adheres to the other COC of community, like plagiarising and such. Although with code, there are plenty of free to use/redistribute and such that we all can use. So, let's learn together and incase you have some problems just ask away in the community!

Well, I'd like to be part of this community even I don't have a good connection. I really love coding. I'm a newbie at python but it's a really easy language for starters.

Yay, DM me for details and such!

The rewards earned on this comment will go directly to the people( @macchiata ) sharing the post on Twitter as long as they are registered with @poshtoken. Sign up at https://hiveposh.com.

Interesting proposal to solve programming problems. Python and SQL is usually a headache, the good thing is that you are on Linux, and that maybe better than trying it on Windows.

It is! you can always ask for help etc if you have any problems even with windows or you can help others if they have some problems too 😊

Great idea for a community! I hope many people will get help here and perhaps I can help someone some day :D

For SQL I can highly recommend the hivesql.io stuff from @arcange! It is almost free (1hbd one time payment) and he thought about everything. Super cool way to learn SQL in my opinion :)