I've been reading a lot about agile, stories, and INVEST recently, and trying to apply it to my work (with a view to introducing it all more broadly within our organisation).
I can see the value of Independence (and other points) within the INVEST mnemonic, but I'm not sure how it should work in some scenarios.
As an example, I'm writing a tool from scratch at the moment. The basic intent is so that it can pull lists from a database. So of course, I can write stories like:
As a user, I would like to be able to get a list of all users from the database.
As a user, I would like to be able to get a list of comments from a specific user.
Seems simple - but I haven't yet written the common framework these commands will run through. I guess this is another user story:
As a developer, I would like an interface to the database so I can produce lists that the user requests from a command line.
Oops - there's now a dependency...
How is Independence achieved in situations like this?