How to use SQL together with another programming language?

Question

I learned Python and SQL. But I think there should be another course teaching how to use SQL commands together with another programming language such as C or Python

Answer 1

You need to learn how to link SQL and python yourself, there is no complete guide for that. But there will always be other guides which you can use to link around, etc. Always remember that search engine exists

Answer 2

Indeed, there is almost no real use to a program language without databases (or really few).

I'm sure that there must be a class that manages SQL for phyton.

Answer 3

Well then, the choice has to be made first. sqlite is a very lightweight dbms. So if your project is not very big, you can use it. And also sqlite module is already available in Python library, so you won't have to install anything. Later at some point, you may switch to MySQL or even MongoDB if you wish

Answer 4

The instructions to interact with database through sql is a part of python code
Here is a good tutorial
http://www.python-course.eu/sql_python.php

Answer 5

Are you using sqlite or MySQL? Python has a built in module for sqlite. The MySQL connector needs to be installed

Answer 6

@Rishi Well see that's the thing. I have learned python, but I don't know whether I shoud use Mysql or sqlite. And it says nothing about how to implement databases into the python program

Answer 7

Thanks for your answer Rishi. and another question is, that is the same SQL programming codes are embedded inside a python code? Or the statements we want with SQL are saved in a file and then called from python?