A general question about python and sql
Hi, thanks a lot for the great content here and on Yoy Tube.. I am trying to understand what are the benifits of using the Python modoul sqlite3.
What is the advantage of doing that over just using SQL? Thanks.
Hello Kfir,
SQLite could be advantageous if you are only building a prototype app, where the data is stored in the disk, no multiple user, and you know that the database will not become large in the future.
When your database needs to upscale and need to add more security for the multiple users that access the database, then you would need SQL for that project.
Hi, thanks for the answer, but my question was why use the Python modules in order to connect to SQL server ? Thanks.!
I see, I admit I didn't quite caught that in your question.
Why use Python to connect to an SQL server? There is actually more than connecting that happens when analysts do it.
You can perform data pre-processing inside SQL, but it can be tedious. With Python, you can connect to a database to extract your data. Then, using some well-known packages such as Pandas and Numpy, you can pre-process your data, create basic charts for exploring its characteristics, and run different analyses, or even apply ML models.