I'm looking to build a command-line tool that will enable me to read an arbitrary XML file combined with a mapping to fill an existing (arbitrary) SQLite database with data. What I'm looking for are conceptual ideas on how to solve this. I've got a possible theoretical solution in mind, but am looking for other ideas to get this done. Hopefully someone will confirm my idea will work, or show me I'm thinking about it in the wrong way. I won't share what I think at this time, to prevent pushing my thought process onto yours.
Jump to Post
Before I start thinking about this (whoops, it's already too late) do you have any initial ideas on how to map the hierarchical structure of XML onto a relational structure (SQLite)? Are there any restrictions on the level of nesting of the XML source?
All 2 Replies
We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.