The only way I've found to get around the starting and abandoning problem, is to actually FINISH something.
Next idea you start, cut it in half. Make it the smallest thing possible. Just FINISH it. That will get you motivated and the next time you can go bigger and bigger.
Don't worry about promotion yet. Just try and make something cool. Putting a post on HN or Reddit or something can go a long way.
I used to get projects as far as I could then they'd stop when they needed skills outside of my abilities or because I was over-reaching i.e worrying about scaling issues 20mins into the idea.
I started picking tiny projects I could definitely execute fully myself with a set end point e.g get the site launched. Now everything I start ends up finished because I only need my own skills.
Next idea you start, cut it in half. Make it the smallest thing possible. Just FINISH it. That will get you motivated and the next time you can go bigger and bigger.
Don't worry about promotion yet. Just try and make something cool. Putting a post on HN or Reddit or something can go a long way.