Searchable Coin Database Website

NBSQLGeek

Trying to get some ideas here, I have created a Web site with a searchable database of coin values for Actual sale prices from EBAY and grouped by grading services like PCGS, ICG , NGC and so forth Their is a MIN sale AVG sale and MAX Sale. I also wanted to know if this would be a good idea since i have time for thgis database stuff as a hobby, is to create a database of coin images all set to a certain size to keep stadardized and have their grades. Basically have a location for everyone to visually compare their coins to for grading.

What do you think?

flaminio

I think there was one created, but only for copper? The memory fades...

Anyway, I think it's a great idea. It would really help in determining "real world" prices.

NBSQLGeek

Coppercoins has one for copper hes getting more and more pics added. Looks nice.

coppercoins

NBSQLgeek - I'm wondering if there's any chance we could work together on this to serve a common goal. I would be willing to host it and share all the files I have so far if you want to help work on it. The basic idea, at first anyway, was to collect the information for copper only because that's all the time I have for it; however, plans to eventually try to include all US coins is being thought out. The problem comes in data collection, massaging, and inclusion into data tables. Hundreds of thousands of auctions run each year that would be eligible for this type of database, so careful data table construction is a definite must.

If you want to contact me regarding a possible joint venture on this, send me a PM and I will provide a toll free number where you can contact me.

NBSQLGeek

Are you using SQL Server and a form of ASP?

I know I can not complete this on my own. Especially with being a Sr database admin for a living is a lot of time of my life.

Im interested and would like to get in touch about your thoughts.

BSqr

NBSQLGeek,

At least your don't wear your certs on your sleeve...

Geoman

NBSQLGeek,

Maybe you could also get together with Jan (ie: dingodog) as he is developing some coin software, and they might include something like you mentioned.

NBSQLGeek

Ok just testing right now to see if I have things in the right order and what else I will ave to change to the asp and data tables.

LINK

dwood

Now this is AWESOME!

Keep us posted! (I'd love to be able to link to it from some sites I'm designing, with BLATANT credit and Kudos!...hint hint

flaminio

If I could make one suggestion? The white-on-grey might look very stylish, but it's terribly hard on the eyes. A bit more contrasting combination might be better...

NBSQLGeek

I can understand about the colors if you have a suggestion about the colors please let me know since IM a guy and cant dress myself.

Now about the layout, this will change to something else a whole lot better, IM working on the schema for the tables and a bunch of scripts to make this more compact and easier to read. More like the PCGS layout but with daily updates.

Thought?

BTW please email me admin@fusionpunch.com

crito

Wonder if you could schedule eBay searches of completed auctions by category, run the saved results through some custom VBScript parsing code in a DTS package, which would then update your database tables, which could also fire a trigger, which calls xp_makewebtask, which would automatically update your website with the new info. just a thought

CouchP

I am a Software Developer with good skills in Database design, web service creation and ASP integration using C# and ASP.NET. I would like to assist with the database and data object creation if possible.

NBSQLGeek

crito thats my thoughts exactly, my company does this sort of stuff already for siemens.

My thoughts now is how to get the ending data from the auctions at ebay.

I crave data!

flaminio

<< <i>I can understand about the colors if you have a suggestion about the colors please let me know since IM a guy and cant dress myself. >>



The Blue-on-Grey you have for the rest of the site looks nice. Can you use that for your tables as well?

NBSQLGeek

Yeah I can thorw colors anywhere.

NBSQLGeek

Looking for a application to spider ebay and retrieve the prices from ebay.

Any ideas?

cosmicdebris

Excellant job so far.

CouchP

Ive written spiders before, I cn hep in this regard, We called the last one I wrote Pack, and had an Alpha (Scheduler), Omega (cataloger) and beta(the web walker). Worked so well we never had to mess with it once it was up. Uses fuzzy logic and word/phrase matching with an AI like scoring system and training session system.

I don't have the source any more, was in VB5.

coppercoins

Your first big problem is going to come in the fact that there is no way to extract the information properly out of the titles except by hand. 10 different people run the same date, mint, grade of coin, and all ten are going to run the items with different (sometimes very different) titles. The only way to properly and accurately extract the correct data from the titles is to do it by hand.

NBSQLGeek

Have an application to extra the titles , seller , feedback , high bids , total sale price , everything, and Im able to extra this data and import into SQL server. I can have this perform so smoothly. I can have a database with over 100,000 records in one week.

The bad thing is this app is $179.00. And will need to build up donations to accomplish this task.

marcmoish

nice effort, this board rules



Marc