How do I use both SQL and Python in the same project?

• sqlitestudio

  41 4,243 9.0 C

  A free, open source, multi-platform SQLite database manager.

Raw SQL can be written in any IDE and text editor. However, you may benefit from using a dedicated SQL IDE/Tool for your work. When writing SQL it helps to see the tables, be able to write queries, debug, cancel long or wrong queries and write exploratory queries free flow (and cancel long or wrong queries) before deciding on what to finalise and execute via Python. They also usually come with a spreadsheet style result set which make it easier to copy data when writing notes etc. Which tool depends on which flavour of SQL you are writing, which depends on which implementation of SQL you are using. For a beginner project, SQLite is fine and an IDE you could use is SQLite Studio, though there could be others (and maybe better ones, or ones that are extensions to other code IDEs). You don't have to use it you could just write inline with your python and print the result but using one will save you a lot of time.

• smashbrosgui

  2 0 0.0 Python

  GUI that connects to a AWS-hosted MySQL database I created based off of the popular Nintendo video game: Super Smash Brothers Ultimate. Displays matchup data and will act as ETL for the database as well. Plan on adding graphing capabilities as well as advanced statistics as well.

I personally made a GUI that displays info from a database using views and sprocs. https://github.com/ianpeck/smashbrosgui

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project