{"repo":"cre-dev/xml2db","free":true,"listed":false,"github":"https://github.com/cre-dev/xml2db","clone":"git clone https://github.com/cre-dev/xml2db.git","description":"A Python package to load complex XML files into a relational database","language":"Python","stars":27,"topics":["data-engineering","data-loader","database","mssql","postgresql","python","relational-databases","sqlalchemy","xml","xmlschema"],"license":"MIT","category":"databases-storage","readme_excerpt":"Loading XML files into a relational database xml2db is a Python package that parses and loads XML files into a relational database. It handles complex XML files which cannot be denormalized to flat tables, and works out of the box, without any custom mapping rules. It fits naturally into an Extract, Load, Transform pipeline: it loads XML files into a relational data model that stays close to the source data while remaining easy to query as flat database tables. The raw data can then be transformed using DBT, SQL views, or stored procedures to produce more user-friendly tables. Starting from an XSD schema which represents a given XML structure, xml2db builds a data model, i.e. a set of database tables linked to each other by foreign keys relationships. Then, it allows parsing and loading XML files into the database, and getting them back from the database into XML format if needed. This package uses sqlalchemy to interact with the database, so it should work with different database backends. Automated integration tests run against PostgreSQL, MySQL, MS SQL Server and DuckDB. You may have to install additional packages to connect to your database (e.g. psycopg2 or psycopg for PostgreSQL, pymysql or mysqlclient for MySQL, pyodbc for MS SQL Server, or duckdb-engine for DuckDB). Please read the package documentation website for all the details! Installation The package can be installed, preferably in a virtual environment, using pip : CLI After installation, xml2db is available as","default_branch":null,"files":null,"tree":[],"storefront":"/r/cre-dev","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/cre-dev/xml2db/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}