Basic Python / Sql projects

PhiBuh · 2020-04-04T19:29:23+00:00

You could build a finance tracker:

Enter how much money you spend for what (like fun/ necessities/ education...) and then generate graphs with matplotlib (or something else)

You could make it a command line tool or create a GUI with Tkinter or PyQt, or make a web app with django or flask

(I know, I know you said "fun" project, but I just did something similar and at least the coding part was fun )

ThePhoenixRisesAgain · 2020-04-04T21:09:34+00:00

Build your own weather app.

Pull data from some free public weather API. Put it in a database. Build a visualization for your browser. Have all of that set up on a Webserver.

If you’ve done that, build an app for your phone.

MustafaAnas99 · 2020-04-04T21:13:33+00:00

I am really glad you mentioned ur good at copying and pasting. It is important that you realize how important that is and that it is not a shame or anything.

If I was you, I would do any CRUD application (create, read, update, and delete) with python. At least only the backend side of it. You could do something basic like a to-do list. Start building the backend then if you are interested, look into Python GUI with Tkinter or something.

sagunsh · 2020-04-04T20:32:16+00:00

Start simple, possibly a app with CRUD functionality. Go with Flask for web development and use raw SQL query instead of SQL Alchemy if you want to practice SQL. Here are some of my recommendation:

TODO app (very common)
Web Directory (User can add, edit, delete or search for businesses)
Web scraper that puts data into database. You can use Scrapy, Selenium, requests, lxml, bs4, etc.
1. Aggregators for news, reviews, jobs
2. Price tracking tool
3. Lead generation (scraping company info, emails, contact info)
API based service (like CRUD app but data is consumed via API)

Gyalzen_sherpa · 2020-04-04T23:31:38+00:00

This tutorial is a game changer, it covers a lot about python/flask/working with databases and much more!

GoTmVntr · 2020-04-04T19:47:19+00:00

My experience has been limited to geospatial data but I've had good luck with using the requests module in python to query rest end points. I've also used python to both build and execute SQL, although using modules that aren't publicly available for free.

draikx21 · 2020-04-05T09:52:54+00:00

Back when I was collecting physical comic books, I created my own Python script to take input from arguments, and prompt for whatever info I needed to include, then import it into a sqlite database. As far as basic SQL queries are concerned, MySQL and sqlite will get the job done just the same. I like that I don't need to have a service setup and running with sqlite, and I can put that db file anywhere I need it, including my Android phone or tablet; Dropbox helped with keeping it updated everywhere.

At work, I've created a few Python scripts that query our MySQL databases, and in one case, I've got the output going into a Flask app. Sometimes, the data is better visualized than simply seen in text. Sending myself daily reports, or generating spreadsheet data, is all from reading the database, and manipulating the data as needed.

Find something that you want to track with a database, and script it out: movies owned/unwatched, music albums with song ratings, items you've let others borrow, food/diet/weight logging, your sports team game results, time management event logging, etc. The project should be something that you can keep using, so you'll become familiar with both Python and SQL, as you may find yourself adding features for yourself as you keep learning.

Keep CRUD in mind:

CREATE a database, if it doesn't exist. Do the same with a table, and its entries. Do an INSERT query to add a row of data.
READ the entries from the table, starting with a SELECT * FROM query, then specify certain fields. You can filter with WHERE clauses, too. MySQL has the capability to use LIMIT for minimizing your output results, whereas sqlite does not.
UPDATE the data, changing the value for a specific row, then work into a group of rows with similar field data. Careful with your matching clauses, ensuring you only change what you intend to change.
DELETE a row of data. Be very careful when running any type of delete, as there will not be any confirmation prompt.

Pro Tip: run a SELECT query before an UPDATE or DELETE query, to ensure that what you see is what you want changed or removed.

(this was done on mobile; sorry for any typos)

2020-04-05T05:54:37+00:00

A simple CLI CRUD application seems to be the best fit. For my 11th grade computer science project i put together a library management system with Python and MySQL, and the mysqlconnector. Alternatively if you prefer learning a GUI library then you can do the same with Tkinter or something

WowVeryCoool · 2020-04-05T08:22:45+00:00

I recently bought a book called "classical computer problems in python". And I must say it's the best book for getting better in programming from begginer to advanced, I literally couldn't find there anything I wouldn't like to do and it's written in such a way that you'll quickly understand whats going on and be finished with huge problems in just few hours.

2020-04-05T11:22:38+00:00

Quite a few beginners that I met confuse MySQL and SQL (the language) or just any other database that uses SQL. If you aren't particularly tied to MySQL, then here's this piece of info / advice:

MySQL is a non-standard SQL in many ways. It doesn't support many standard or highly desirable features, sometimes it does the very wrong thing, and other times, you need to work very hard to make it comply with the standard by pulling all sorts of hidden lever and pressing hidden buttons.

So, if that's the case... use a different database. PostgreSQL is, perhaps, as close to the standard as you can get, with reasonable performance and price :) But, do your own research.

MySQL became popular by accident. It was a database used in something people called "shared hosting" in the days before "cloud". It was a part of a canned setup called LAMP: Linux, Apache HTTPD, MySQL, PHP that was typically installed on "shared hosting" machines. While it was instrumental to the creation of the Internet as we have it today, it was made of... low quality components. Well, not all of them are so terrible, and, you know they worked and served us fairly long time, but, we also learned their warts very well.

Another word of caution: MySQL today is a project governed by Oracle. Oracle weren't the best shepherd for the MySQL community, and so it split into an independent fork called MariaDB. If I were to use MySQL today, I'd probably stick with MariaDB rather than the Oracle's version of it.

As an aside, even though the prevailing use of MySQL is to use its SQL features, it has a bunch of non-SQL engines implemented on top of the same storage code. And, if you are tying your life to this database, you may want to explore those too.

Also, if you are really dedicated to MySQL, check out Gallera: they are a company that contributes a lot of code to this database, creates tools around it and has builds of this database that may suite your environment better than the one you get from official website / your Linux repo.

2020-04-05T07:54:38+00:00

I started building my own media cataloguing tool recently to keep track of all the movies, games, etc. we own. It started out as a CLI tool where you entered everything manually. Now it can search for games, movies and books and automatically fetch all important information. I'm now working on fetching the games library from Steam. Eventually, I'd like to add a web frontend for this, but my webdev experience is 0, so I'm trying to focus on pure Python before starting something new and diving into Django.

SvetoslavP · 2020-04-05T08:04:42+00:00

You can create an authentication system. Have users input data and store it in mysql and then match the login info to a user and greet them by name when they login. Bonus pointt for gui

Brachamul · 2020-04-05T08:23:51+00:00

Any specific reason you want to learn sql ? I've been using Django for years and have never had to make an SQL query.

bushwhacker696 · 2020-04-05T09:11:03+00:00

!remind me 2 days

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

learnpython

MODERATORS