There are various opportunities after being a Data Analyst. Everyone is thinking of doing at-least one course on python and a database. But since there are various databases out there with various functionalities, it becomes difficult to choose one from different databases like MySQL, PostgreSQL, Sybase and Oracle which are supported by python as well.
So we have to make a decision by choosing a suitable database which is “SQLite3“, according to me. I have also worked on MySql Workbench which I found to be very heavy application to work on.
These days connecting a apllication with the database plays an important role. Because of the need to save the data securely as much as possible. Python is well-known as the language for data science. But its use in web development is very notable, specially because of Django and Flask.
Below are the 3 reasons why SQLite3 is the best suite for experimentation with Python :-
- Lightweight Database
We know that SQLite3 is a very lightweight database which make its very easy to use and handle. It do not require any separate database process to be maintained.
We can also store the database in our internal storage based on our use.
2. Both are written in C
We have studied that python compiler is written in C while SQLite3 is also a C library that provides a lightweight disk-based database.
Both written in C makes it more compatible to run and work with each other.
3. Easy Integration
SQLite3 and Python can be very integrated simply by using a header file “include sqlite3”, this will be enough to do the job.
4. Sql like SQLite3
SQLite makes use of the very easy english-like SQL codes, which makes it more viable for use by the programmers as in the picture above, even with Python.
5. Prototyping
Lastly, It is wise of you to use SQLite3 with python to store data because prototyping in the lightweight SQLite3 helps in migrating the code to heavier weight / larger databases such as PostgreSQL or Oracle.
The Thesis Whisperer 