This is all very new to me and I'm coming at this from needing an sql resource and was pointed in the direction of python and sqlite. I think the pair in general is just what I've been looking for, but am uncertain how to find which exact bits I should be using, particularly in terms of versions.
I was originally planning on building a resource and application to manipulate my own data, but have to stumbled on a way of making this even better with biopython.
I should be able to functionally map out what I think I need, but before I even get started in earnest I need to get some fundamental bits confirmed:
Should I learn 3.X and just use various modules of 2.7 for the bits of biopython I need, or just keep everything pre-3? This fundamental decision also seems to have a cascading effect on libraries and other resources? (qt, pyqt, sip, scintilla)
sqlite, slqlite3, BioSQL, SQLalchemy? What are the adv/disadvantages of each- where can I find them?
I'm on a windows pc- can you recommend an editor. I've tried dreampie and eric, but again I think there are version issues (with eric?) that need to be addressed before everything can be complied?
Is there are central resource that walks one through the lot?
I've been reading a lot and not having been able to unstuck myself thought I could turn here.
Sorry for the deluge and many thanks in advance...