Did you ever compare Postgres and MySQL for FindMeOn? Was Postgres
really that much better than MySQL in performance? What tools do you
use to create queries, admin the db, etc?
On Mon, Mar 3, 2008 at 11:44 AM, Jonathan Vanasco <[address removed]> wrote:
> On Mar 2, 2008, at 1:04 AM, Yuriy Krylov wrote:
> > My first startup was in offering social networking and online
> > career management services to music professionals [masked]). We
> > hosted some great networking events in midtown while building out
> > the Beta. Team fell apart before we could launch - I'm still
> > sitting on a well thought-through, well branded product. Still
> > have some solid grass-roots connections. Would be very interested
> > in getting closer to that space again.
> > Jonathan, what's going on with Roadsound? Is it permanently tabled?
> FindMeOn has been taking up 100% of my bandwidth for the past two
> years, so I haven't been able to get back to RoadSound aside from
> some patent responses.
> We had the whole thing running and stable, it just had a clunky
> interface and the coding couldn't scale well -- at last refactoring
> it was ~380 tables in postgres , and many 'simple' sounding searches
> for data would require 12 table joins ( ah, the benefits of offering
> a system for giving versioned meta-data and media with customizable
> views ) -- that's not an issue for speed or anything, but even using
> comprehensive views, the DBA role was nightmarish to add or modify
> features. We were focus-group testing it with a bunch of major &
> indie bands, labels & pr-firms and they all loved it. What's not to
> love though? We took 'manage 4 sns sites' to 'manage 1 feed' (now
> that would be 20 sns sites), we integrated their data streams
> together, and we offered ways to host websites, widgets or power your
> flash sites with up-to-date data. We were just too early -- If we
> worked on that app in 07 instead of 04/05, we would have had 10MM in
> funding. Instead we heard "but there's myspace!"
> // Jonathan Vanasco