Thursday, February 25, 2010

SQLA Has Backup!

SQLA is the new community question-and-answer website devoted to SQL Anywhere that started Beta testing back on November 8, 2009.

SQLA is still in Beta, but it IS ready for more traffic now that The Really Big Obstacle has been overcome: We have backup!

(if anyone wants a copy of the XML dump of all SQLA content, just email me at breck.carter at

So... SQLA is ready for prime time!

Time to invite more people to participate.

But first... it's time for the administrator (that's me) to update the SQLA FAQ to reflect all the wonderful results from the past few weeks of experimentation with SQLA... the StackExchange software REALLY IS SO MUCH BETTER than the best NNTP client-server setup, the best bulletin board software, the best "threaded forum" websites.

Updating the FAQ will take a bit of time, mainly because SQLA is not StackOverflow... SQLA works by a completely different set of rules than mostly FEWER rules, FEWER restrictions, MORE freedom to use the site effectively.

Hard to explain... that's another "to do" item for me, come up with a sales pitch.

In the meantime, if you want to know more about the people behind the StackExchange software that runs SQLA, where it came from, where it's going, this recent podcast from Joel Spolsky answers questions submitted by administrators who operate websites just like SQLA. And there's hundreds of them.

Who doesn't have an hour to listen to Joel Spolsky? Well, maybe you don't, so here are SOME of the high points (there's lots more, including stuff I did not know like the StackExchange software is a separate fork of StackOverflow, and it's StackOverflow going the venture capital route, not StackExchange):

Joel sits down with the Stack Exchange team, who are working on the hosted version of Stack Overflow at the Fog Creek offices in New York City.
  • Meet the Stack Exchange team -- David Fullerton, Aaron Maenpaa, and Emmett Nicholas.

  • For Stack Exchange sites that have a smaller community, Stack Exchanges may email users more aggressively, to invite users to answer less trafficked SE questions. Joel proposes that weekly roll-up emails might work well on smaller Stack Exchange sites.

  • Stack Exchange is a hosted service; it's currently running on 2.5 servers and soon a third.

  • Stack Exchange has an export feature, so all the data in your site can be dumped out to a file, similar to the way the monthly Stack Overflow cc-wiki data dumps work.

  • Joel blogged about Stack Overflow looking for venture capital -- that should not affect Stack Exchange. In any case, even if it did, you can use your own domain name which you take with you, and as mentioned above, you can export all your data. There should be competition, and smart competitors will support the Stack Overflow and Stack Exchange export formats.

  • Stack Exchange pricing is already at maximum, primarily to reduce demand to a level that the current SE team can support. It can only go down over time! It is definitely our goal to make it easier over time for everyone who wants a Stack Exchange site to have one. We're exploring a lot of possibilities including ad subsidized; it's also possible that larger corporate adoption of Stack Exchange may subsidize the smaller community sites as well.

  • Right now every Stack Exchange site has its own IIS website (even though they all share the same app pool), but that turns out to be not a great performance model for lots of small sites. 

  • One of the Catch-22s of a Stack Exchange site is that fundamental actions like voting up and creating tags require reputation, but nobody has any reputation on a new site. The Stack Exchange team added a "bootstrap mode" which relaxes a lot of these requirements so you can get your site up and running.

  • David notes that a smooth admin / owner setup process is essential to the Stack Exchange service model. You also can't have a ghost town -- you need some questions bootstrapped into the system before you even show it to the broader public. This is analogous to the private invitation-only betas we did for Stack Overflow, Super User, and Server Fault.

  • If you'd like to provide additional feedback to the Stack Exchange team, we encourage you to visit Meta Stack Exchange and help us dogfood our own system.

1 comment:

Unknown said...

for dbsrv10 with -gn option what is the max number that we can set? is there any performance hit by increasing number of concurrent server requests.