Ok, so there is this commercial software X that uses an SQLite DB (or rather multiple SQLite DBs that can be added/removed) for storage, so anyone can look at the scheme by just opening it.
We want to write and distribute (open source) a software Y to perform a similar task in another environment. It would be convenient to use a DB scheme that is close enough to software X format such that software X will be able to read it (and we know this would work).
Is that generally permitted? Since we do not only want to read/extend the files written by the software X, but also generate new files from scratch. So I am worried that typing out a SQLite schema suspiciously similar to the one used in X datafiles might be copyright infringement - what is your opinion?
Would this change if the format was incompatible with the original format, just laid out in a rather similar way such that someone who knew how to do it could easily convert it?
Does it matter whether I do this in the US or in the EU, and does it matter for where the users are?