Re: [sqlite] Import 5000 xml files in a sqlite database file

There might be a GUI SQLite client app that can do this; I don’t know (the one I use, SQLiteManager, can only import SQL files.) But it’s really easy to do with a short program in a scripting language like Python/Ruby/PHP. I just searched for [sqlite import xml] and the top hit is the

[sqlite] Import 5000 xml files in a sqlite database file

Hi, I have more than 5000 xml files. All files have the same xml-structure. Each file has different values (timestamps, numbers and strings). I would like to put all these values in a sqlite database tabke, all in one table. => Import the data values into a sqlite database table. Can you

[sqlite] Virtual table acting as wrapper of a regular table

Hello, I am trying to create a simple virtual table that acts as wrapper for a normal database table for a specific query. For example, consider that I have tables A and B in my database and the query: select count(A.id) from A CROSS JOIN B where A.id=B.id Now I am using a virtual table acting