Question: I have a question related to some guidances to solve a problem. I have with me an xml file, I have to populate it into a database system (whatever, it might be sqlite, mysql) using scripting language: Python.

Does anyone have any idea on how to proceed?

* Which technologies I need to read further?
* Which environments I have to install?
* Any tutorials on the same topic?

I already tried to parse xml using both by tree-based and sax method in other language, but to start with Python, I don't know where to start. I already know how to design the database I need. 

Another question, is Python alone possible of executing database ddl queries?

Answer: 
If you are accustomed to DOM (tree) access to xml from other language, you may find useful these standard library modules (and their respective docs):

* xml.dom
* xml.dom.minidom

To save tha data to DB, you can use standard module sqlite3 or look for binding to mysql. Or you may wish to use something more abstract, like SQLAlchemy or Django's ORM.
I know it's an old post, but I think it's worth noting for reference to future visitors who need one-time solution: The simplest way I found was to use **Libre Office Calc**, particularly `Data` --> `XML source` feature.

<https://help.libreoffice.org/latest/lo/text/scalc/01/xml_source.html>

Once imported into ODS, one can save it easily as CSV (i.e. to import to SQLite), but having the Open Document Sheet may itself suffice in many cases user's needs, i.e. using `Automatic filter feature` to search and filter data. I had no problem processing 15K rows.

If the task has to be done repeatedly, it has to be scripted and Python libraries are a good way to do it. However I had some troubles using `xml.etree` and in my case LibreOffice was a perfect fit.