One of my close friends has been living and working in tech from home for about 10 years in various parts of Oakland. I visited him there (from MA) many times and aside from some intimidation from his neighbors (including an 18-year-old who got in my face, lunged his body toward me and provoked me saying "Fuck you," and numerous additional smaller incidents), I found it lovely and enviable.
Things were going well until the last year in which his van was robbed outside his house and a few months later, his band was robbed out on the street while filming a video. It's the kind of situation that makes you want to say, "This is why we can't have nice things."
IOW, if you plan to fit in and live low-key, Oakland may be just fine for a long time. However, if you acquire various types of assets or participate in lifestyles above a certain threshold, you are more likely to experience "equalizing events."
edit: This friend moved to Alameda last month.