Is there any way to get historical order book information for mt. gox? As far as I could tell they don't provide that info in their API https://en.bitcoin.it/wiki/MtGox/API/HTTP/v1#Full_Depth. Is there a database that has this stored?

I'm building a bitcoin website, and have been using bitcoind for database requests which has been fairly slow. We'll only really be looking at history, and not managing any wallet based functions. I'm considering switching to either SQL or Mongo for longer-term use, does anyone have experience using either for bitcoin sites? What database structure do some of the larger sites like blockchain.info use?

Thanks for your help.

I found this post and think the author does a good job of explaining the steps necessary for making Bitcoin more mainstream:

http://thegenesisblock.com/five-easy-ways-you-can-make-bitcoin-a-mainstream-currency/

I'd be interested in hearing your guys' thoughts on these concepts.

The concept came up in another post, and I though I'd throw the question to the BTC Mining community to see how much people sell.

I'm curious how active our community is trading BitCoins (and I'm sure others are as well).  How often are people trading on exchanges like MtGox or any of the smaller ones?

I'm curious how active traders are with bitcoins - and how much they compare with traders on more established exchanges.  Does anyone know what typical order sizes are like, and how often people are trading?

Just curious how often and in what kind of BTC or USD volume "active" traders usually execute orders for.

So, I accidentally loaded my 6970's Bios onto my 5870.  I never backed up the 5870 (Diamond reference) Bios, and I spent hours trying to reflash it.  I use Ubuntu 11.04, and was using a DOS booting USB drive to atiflash the bios.  Atiflash no longer recognizes the 5870 when another card is plugged in as the main.  Using -i it only shows the 1 working card, and using -p 1 it says there is nothing available.  I tried blind flashing the ati stock bios, as well as Diamond and Asus versions with no luck (I couldn't see but I suspect I'm getting the same error using -p0 when blind that shows up with -p 1, no card available).

Is there another way I can get the system to at least acknowledge that the 5870 is plugged into the PCI-e port?  The fan is spinning, and there wasn't a burning smell or anything so I suspect the hardware is undamaged.  Definitely never making this mistake again.

This may have been discussed in the past but I've been searching the forum for 2 days and haven't found anything.

I'm currently running a Diamond 6970 http://www.newegg.com/Product/Product.aspx?Item=N82E16814103182&cm_re=6970-_-14-103-182-_-Product and having a trouble getting the card to Clock over 900. The card is running fine at 900/300 around 370 GHash/sec.  As soon as I move the clock over 900 (even to just 901) it drops to around 330 Ghash, and drops even further the higher it's clocked.  The card appears to be stable at higher clocks except for the GHash issue. Aticonfig reports that the overclocking is running correctly for the core, but memory is displaying at around 150.  I flashed the BIOS because I was unable to get the memory below 1275 with the factory BIOS, but even with the stock BIOS the same problem was happening over 900 core clock.

This is all running on Ubuntu 11.04, Catalyst 11.6, SDK 2.4, and phoenix (latest phatk kernel). I'm running several other 58XX cards in the same system and have not run into any problems.  Any idea what is happening here?

I have 2 5830's that I'm trying to overclock on a linux box, but as far as I can see the only way to do it is in windows.  I don't currently have a windows 7 license to use for my mining rig (but I have one on my laptop).  Anyone know a good way for me to get access to windows for an hour or two to unlock the card?  Is there a trial account or flash drive method to do this?