cpu collection website-in-a-box

[skold]

hey guys, ive been thinking about redoing the back-end of my website, and i was wondering if any of you would have any interest at all in using it on your own sites?

i'd use php and sql (mysql is the one i work with) for it, and smarty for a template engine, so the actual look of the site would be completely up to you.

stuff i was thinking of having in it would be flags for each entry, so you could, for example, flag a chip as a co-processor, or as being of the 386 family, manufactured by intel, etc. there'd also be a search function, so people could be pretty specific and search for only coprocessors, or only 386s, or only intel, etc, rather than relying on keyword searches (which would still be possible, mind you)

comment systems are also my specialty, so each cpu would have its own section of comments, which would be threaded for replies.

whether or not anyones interested will determine how open ended i make this.. if im the only one using it its probably not going to be as extensible..

i wouldn't be charging for this, nor would i really support it, im just wondering if anyone would be interested in it.

[gmanbc]

I am interested

Lee
gmanbc

[popo]

It's interesting.
But I'm just too lazy to take pictures for all of my chips.
And I don't have time to do this.
Otherwise, I'd like to construct a Taiwanese chip collector's website.

[skold]

well you wouldnt have to take pics.. you could just put in the info for them and have a text list, basically.. it'd be up to you. its basically just a database of your collection that would be searchable

[popo]

Sounds great!

[Borris70]

i'm also very interested.

i thought also about that, but i don't have enough time

[ahia123]

I'm very interested in this. I have 1 GByte disk space (for pictures) + 100 MByte database space (mysql) ready for this. I had in mind creating a database where the pictures were stored in a file system outside the database while all the text information were stored in database tables (third normal form).

Bjørn

[skold]

ok, what kind of data would you guys want in the database?

this is still in the planning phase for me, so.

im probably going to lose a bunch of you here, i dont know how many of you know databases/php at all..

offhand id think:

flags: -- bitflags obviously -- these would probably be defined in arrays.. something like:
class - 186, 286, 386, 486, etc
manufacturer - amd, intel, cyrix, rise, idt, nexgen
product - athlon, pentium, mp6
interface - socket 370, socket a, socket 7
process - .35, .25, .18, .13, .09 ..

and so on.. if you wanted to add a new one, it'd be as simple as changing a few numbers in a file .. easy to get the hang of.. so for example you could add 'vendorid' and have options like authenticamd.. cyrixinstead.. riseriserise.. etc

so when youre adding a cpu to the db, you'd probably select it from a dropdown.. each option would be a dropdown menu, and youd pick the one thats correct for that cpu, or leave it blank if you dont know or dont want to use it

thered also be a bunch of text fields as well, for things that vary too much to be in a flag.. for example, fsb speeds. so youd be able to type in '800mhz hypertransport' or '66mhz' or '133mhz ddr (266mhz effective)'..

so with the flags and text fields, you could have it output something like

AMD Athlon XP
Socket 370
133MHz DDR (266MHz Effective)

other features id plan on would be threaded comments for each entry.. so someone could specifically leave a comment, for example saying 'the athlon xp is socket a, not socket 370' and you could reply and say 'oops i hit the wrong option, thanks!'

then of course you could click 'edit' on the entry, select the right option, and click save

probably the neatest feature would be searching.. people could search for keywords like 'athlon', and they could also narrow their search from dropdown menus, such as selecting only chips by amd, only athlons, and searching for 1600.. which would pick up the athlon xp 1600+, while avoiding pentium 4 1600mhz cpus..

id also have to have some kind of keyword field for each entry, otherwise a search for 'athlon' wouldnt turn anything up since 'athlon' would be generated by the flag... soo, whenever you select a flag, id just drop the text description for it into the keyword box..

at any rate! what kind of flags/text options would you guys want for any given processor? keep in mind you could leave any of them blank. ill try to organize your suggestions into a workable list of options

[ahia123]

In addition to skold's list:

class - 186, 286, 386, 486, etc
manufacturer - amd, intel, cyrix, rise, idt, nexgen
product - athlon, pentium, mp6
interface - socket 370, socket a, socket 7
process - .35, .25, .18, .13, .09 ..

this is what I can think of:

kind of chip - cpu, fpu, mcu, bsp, ram, rom, prom, support, ...
package - ceramic, white ceramic, plastic, ...
number of transistors
technology - mos, nmos, cmos, pmos, ...
number of pins
architecture - 4-bits, 8-bits, 16-bits, ...
addressing space - 64KByte, 1MByte, ...
data bus width
address bus width
L1 cache
L2 cache
clock speed
FSB speed
temperature range
date code - <year><week>
introduction date
code name
country
second source
description

[Mixeur]

Hi,

It seems that I already began to do this kind of work, a big cpu database in sql...
For the moment i've 933 different kind of x86 cpus in it.
And it is quite long to enter...

Here is all I entered
AMD 386DX-16
AMD 386DX-20
AMD 386DX-25
AMD 386DX-33
AMD 386DX-40
AMD 386DX/DXL-20
AMD 386DX/DXL-25
AMD 386DX/DXL-25
AMD 386DX/DXL-33
AMD 386DX/DXL-40
AMD 386DXLV-25
AMD 386DXLV-33
AMD 386SX-16
AMD 386SX-20
AMD 386SX-25
AMD 386SX-33
AMD 386SX-40
AMD 386SX/SXL-20
AMD 386SXL-20
AMD 386SXL-25
AMD 386SXL-33
AMD 386SXL-40
AMD 386SXLV-20
AMD 386SXLV-25
AMD 386SXLV-33
AMD 486DX-33
AMD 486DX-40
AMD 486DX2-50
AMD 486DX2-66
AMD 486DX2-80
AMD 486DX4-100
AMD 486DX4-120
AMD 486DX4-90
AMD 486DXL-40
AMD 486DXL2-66
AMD 486DXL2-80
AMD 486DXLV-33
AMD 486SX-33
AMD 486SX-40
AMD 486SX2-50
AMD 486SX2-66
AMD 5k86 P75
AMD 5k86 P90
AMD 5x86-P75
AMD 5x86-P75 (PQFP)
AMD Athlon 1000 (FSB200)
AMD Athlon 1000 (FSB266)
AMD Athlon 1000 (Model 2)
AMD Athlon 1000 (Model 4)
AMD Athlon 1100
AMD Athlon 1133
AMD Athlon 1200 (FSB200)
AMD Athlon 1200 (FSB266)
AMD Athlon 1300
AMD Athlon 1333
AMD Athlon 1400 (FSB200)
AMD Athlon 1400 (FSB266)
AMD Athlon 500
AMD Athlon 550 (Model 1)
AMD Athlon 550 (Model 2)
AMD Athlon 600 (Model 1)
AMD Athlon 600 (Model 2)
AMD Athlon 650 (Model 1)
AMD Athlon 650 (Model 2)
AMD Athlon 650 (Model 4)
AMD Athlon 700
AMD Athlon 700 (Model 1)
AMD Athlon 700 (Model 2)
AMD Athlon 700 (Model 4)
AMD Athlon 750
AMD Athlon 750 (Model 4)
AMD Athlon 750 (Slot A Model 2)
AMD Athlon 800
AMD Athlon 800 (Model 2)
AMD Athlon 800 (Model 4)
AMD Athlon 850
AMD Athlon 850 (Model 2)
AMD Athlon 850 (Model 4)
AMD Athlon 900
AMD Athlon 900 (Model 2)
AMD Athlon 900 (Model 4)
AMD Athlon 950
AMD Athlon 950 (Model 2)
AMD Athlon 950 (Model 4)
AMD Athlon XP 1500+
AMD Athlon XP 1600+ (Palomino)
AMD Athlon XP 1600+ (Thoroughbred)
AMD Athlon XP 1700+ (Palomino)
AMD Athlon XP 1700+ (Thoroughbred)
AMD Athlon XP 1800+ (Palomino)
AMD Athlon XP 1800+ (Thoroughbred)
AMD Athlon XP 1900+ (Palomino)
AMD Athlon XP 1900+ (Thoroughbred)
AMD Athlon XP 2000+ (Palomino)
AMD Athlon XP 2000+ (Thoroughbred)
AMD Athlon XP 2000+ (Thorton)
AMD Athlon XP 2100+ (Palomino)
AMD Athlon XP 2100+ (Thoroughbred)
AMD Athlon XP 2200+ (Thoroughbred)
AMD Athlon XP 2200+ (Thorton)
AMD Athlon XP 2400+ (Thoroughbred)
AMD Athlon XP 2400+ (Thorton)
AMD Athlon XP 2500+
AMD Athlon XP 2600+ (Barton)
AMD Athlon XP 2600+ (Thoroughbred FSB266)
AMD Athlon XP 2600+ (Thoroughbred FSB333)
AMD Athlon XP 2700+
AMD Athlon XP 2800+ (Barton)
AMD Athlon XP 2800+ (Thoroughbred)
AMD Athlon XP 3000+ (Barton FSB333)
AMD Athlon XP 3000+ (Barton FSB400)
AMD Athlon XP 3200+ (Barton FSB400)
AMD C80186-1
AMD C80186-3
AMD C80186-6
AMD CG80186-6
AMD CG80186-6B
AMD D8086
AMD D8086-1
AMD D8086-1B
AMD D8086-2
AMD D8086-2B
AMD D8086B
AMD D8088
AMD D8088-1
AMD D8088-1B
AMD D8088-2
AMD D8088-2B
AMD D8088B
AMD Duron 1000
AMD Duron 1100
AMD Duron 1200
AMD Duron 1300
AMD Duron 1400
AMD Duron 1600
AMD Duron 1800
AMD Duron 600
AMD Duron 650
AMD Duron 700
AMD Duron 750
AMD Duron 800
AMD Duron 850
AMD Duron 900
AMD Duron 950
AMD ID8086
AMD ID8086-2
AMD ID8086-2B
AMD ID8086B
AMD ID8088
AMD ID8088-2
AMD ID8088-2B
AMD ID8088B
AMD K5 PR100
AMD K5 PR100 Goldcap
AMD K5 PR120
AMD K5 PR133
AMD K5 PR150
AMD K5 PR166
AMD K5 PR200
AMD K5 PR75
AMD K5 PR75 Goldcap
AMD K5 PR90
AMD K6 166
AMD K6 200
AMD K6 233
AMD K6 266
AMD K6 300
AMD K6-2 266
AMD K6-2 300
AMD K6-2 300 (FSB66)
AMD K6-2 333
AMD K6-2 333 (FSB66)
AMD K6-2 350
AMD K6-2 366
AMD K6-2 380
AMD K6-2 400
AMD K6-2 450
AMD K6-2 475
AMD K6-2 500
AMD K6-2 533
AMD K6-2 550
AMD K6-2+ 450
AMD K6-2+ 475
AMD K6-2+ 500
AMD K6-III 400
AMD K6-III 450
AMD K6-III+ 450
AMD K6-III+ 475
AMD K6-III+ 500
AMD MD8086B
AMD MD8088-2B
AMD MD8088B
AMD N80186
AMD N80186-10
AMD N8086
AMD N8086-1
AMD N8086-2
AMD N8088
AMD N8088-1
AMD N8088-2
AMD N80C186
AMD N80C186-12
AMD N80C186-16
AMD N80C186-20
AMD NG80386DX-25
AMD NG80386DX-33
AMD NG80386DX-40
AMD NG80386DXLV-25
AMD P8086
AMD P8086-1
AMD P8086-1B
AMD P8086-2
AMD P8086-2B
AMD P8086B
AMD P8088
AMD P8088-1
AMD P8088-1B
AMD P8088-2
AMD P8088-2B
AMD P8088B
AMD R80186
AMD R80186-10
AMD R80186-3
AMD S80C186-20
Cyrix 486DLC-33
Cyrix 486DLC-40
Cyrix 486DX-33
Cyrix 486DX-40
Cyrix 486DX-40
Cyrix 486DX2-50
Cyrix 486DX2-66
Cyrix 486DX2-66
Cyrix 486DX2-80
Cyrix 486DX4-100
Cyrix 5x86-100
Cyrix 5x86-100
Cyrix 5x86-120
Cyrix 5x86-120
Cyrix 6x86 P120+
Cyrix 6x86 P133+
Cyrix 6x86 P150+
Cyrix 6x86 P166+
Cyrix 6x86 P90+
Cyrix 6x86-100
Cyrix 6x86L PR166+
Cyrix 6x86L PR200+
Cyrix 6x86LV P166+
Cyrix 6x86MX PR166
Cyrix 6x86MX PR200 (FSB66)
Cyrix 6x86MX PR200 (FSB75)
Cyrix 6x86MX PR233 (FSB75)
Cyrix MediaGX-180
Cyrix MediaGX-200
Cyrix MediaGX-233
Cyrix MediaGX-266
Cyrix MII-233
Cyrix MII-266
Cyrix MII-300 (FSB66)
Cyrix MII-300 (FSB75)
Cyrix MII-333 (FSB75)
Cyrix MII-333 (FSB83) Black Top
Cyrix MII-333 (FSB83) Gold Top
Cyrix MII-350
Cyrix MII-366
Cyrix MII-400
Cyrix MII-433
Cyrix MIIv-333
Cyrix MIIv-400
Fujitsu MBL80286-6
Fujitsu MBL80286-8
Fujitsu MBL80286-8
Fujitsu MBL8086
Fujitsu MBL8086-1
Fujitsu MBL8086-1
Fujitsu MBL8086-2
Fujitsu MBL8086-2
Fujitsu MBL8088
Fujitsu MBL8088-1
Fujitsu MBL8088-2
Harris CD80C88
Harris CD80C88-2
Harris CG80C286-12
Harris CG80C286-16
Harris CP80C88
Harris CP80C88-2
Harris CS80C286-12
Harris CS80C286-16
Harris CS80C286-20
Harris CS80C286-25
Harris CS80C88
Harris CS80C88-2
Harris ID80C88
Harris ID80C88-2
Harris IP80C88
Harris IP80C88-2
Harris IS80C88
Harris IS80C88-2
Harris MD80C88
Harris MD80C88-2/B
Harris MR80C88-2/B
Harris MR80C88/B
IBM 5x86-100
IBM 5x86-100
IBM 6x86 P120+
IBM 6x86 P150+ (6x86-2V2120GB)
IBM 6x86 P150+ (6x86-2V2150GE)
IBM 6x86 P166+
IBM 6x86-100
IBM 6x86L P150+
IBM 6x86L PR166+
IBM 6x86L PR200+
IBM 6x86MX PR166
IBM 6x86MX PR200 (FSB66)
IBM 6x86MX PR200 (FSB75)
IBM 6x86MX PR233 (FSB66)
IBM 6x86MX PR233 (FSB75)
IBM 6x86MX PR266
IBM 6x86MX PR300 (FSB75)
IBM 6x86MX PR300 Black Top (FSB66)
IBM 6x86MX PR300 Gold Top (FSB66)
IBM 6x86MX PR333
IBM Blue Lighting 486DX2-66
IBM Blue Lighting 486DX2-80
IBM Blue Lighting 486DX4-100
IDT Winchip C6 180
IDT Winchip C6 200
IDT Winchip C6 225
IDT Winchip C6 240
IDT Winchip2 200
IDT Winchip2 225
IDT Winchip2 240
IDT Winchip2A PR200
IDT Winchip2A PR233
IDT Winchip2A PR266
IDT Winchip2A PR300
IDT Winchip2B PR200
Intel 386-16
Intel 386-20
Intel 386-25
Intel 386DX-16 (ancien logo)
Intel 386DX-16 (nouveau logo)
Intel 386DX-16 (sans logo)
Intel 386DX-20 (ancien Logo)
Intel 386DX-20 (nouveau Logo)
Intel 386DX-20 (sans Logo)
Intel 386DX-25 (ancien Logo)
Intel 386DX-25 (nouveau Logo)
Intel 386DX-25 (sans Logo)
Intel 386DX-33 (ancien Logo)
Intel 386DX-33 (nouveau Logo)
Intel 386SL-20
Intel 386SL-25
Intel 486DX-25
Intel 486DX-33 (Ancien Logo)
Intel 486DX-33 (Nouveau Logo)
Intel 486DX-50
Intel 486DX2-50
Intel 486DX2-66
Intel 486DX4-100
Intel 486DX4-75
Intel 486SL-20
Intel 486SL-25
Intel 486SL-33
Intel 486SX-16
Intel 486SX-20
Intel 486SX-25
Intel 486SX-33
Intel 486SX2-50
Intel A80186
Intel A80186-10
Intel A80186-16
Intel A80188
Intel A80188-10
Intel A80286-10
Intel A80286-12
Intel A80286-6
Intel A80286-8
Intel A80C186
Intel A80C186-12
Intel A80C186-16
Intel A80C186XL
Intel A80C186XL12
Intel A80C186XL16
Intel A80C186XL20
Intel A80C186XL25
Intel A80C188
Intel A80C188-12
Intel A80C188-16
Intel A80C188XL
Intel A80C188XL12
Intel A80C188XL16
Intel A80C188XL20
Intel A80C188XL25
Intel A80C286-12
Intel C80186-3
Intel C80186-6
Intel C80188-3
Intel C80188-6
Intel C80286-4
Intel C80286-6
Intel C8086
Intel C8086-4
Intel Celeron 1000
Intel Celeron 1100
Intel Celeron 1200
Intel Celeron 1300
Intel Celeron 1400
Intel Celeron 1700
Intel Celeron 1800
Intel Celeron 2000
Intel Celeron 2100
Intel Celeron 2200
Intel Celeron 2300
Intel Celeron 2400 (FSB400)
Intel Celeron 2400 (FSB533)
Intel Celeron 2530 (FSB533)
Intel Celeron 266
Intel Celeron 266 Mobile
Intel Celeron 2660 (FSB533)
Intel Celeron 2700
Intel Celeron 2800 (FSB400)
Intel Celeron 2800 (FSB533)
Intel Celeron 300
Intel Celeron 300 Mobile
Intel Celeron 300A
Intel Celeron 333
Intel Celeron 333
Intel Celeron 333 Mobile
Intel Celeron 366
Intel Celeron 366
Intel Celeron 366 Mobile
Intel Celeron 400
Intel Celeron 400
Intel Celeron 400 Mobile
Intel Celeron 433
Intel Celeron 433
Intel Celeron 433 Mobile
Intel Celeron 466
Intel Celeron 466 Mobile
Intel Celeron 500
Intel Celeron 533
Intel Celeron 566
Intel Celeron 600
Intel Celeron 633
Intel Celeron 650 Mobile
Intel Celeron 667
Intel Celeron 700
Intel Celeron 733
Intel Celeron 766
Intel Celeron 800
Intel Celeron 850
Intel Celeron 900
Intel Celeron 950
Intel CG80286-10
Intel CG80286-6
Intel CG80286-8
Intel D8086
Intel D8086-1
Intel D8086-2
Intel D8086-4
Intel D8088
Intel D8088-2
Intel FA80C186
Intel KU80386EX25
Intel KU80386EX33
Intel LD8086
Intel LD8088
Intel MD8086-2/B
Intel MD8086/B
Intel MD8088-2B
Intel MD80C86-2/B
Intel N80186
Intel N80186-10
Intel N80188
Intel N80188-10
Intel N80286-10
Intel N80286-12
Intel N80286-8
Intel N80C186
Intel N80C186-12
Intel N80C186-16
Intel N80C186XL
Intel N80C186XL12
Intel N80C186XL16
Intel N80C186XL20
Intel N80C186XL25
Intel N80C188
Intel N80C188-12
Intel N80C188-16
Intel N80C188EB13
Intel N80C188EB20
Intel N80C188EB25
Intel N80C188XL
Intel N80C188XL10
Intel N80C188XL12
Intel N80C188XL16
Intel N80C188XL20
Intel N80C188XL25
Intel N80C286-12
Intel N80C88
Intel N80C88-2
Intel N80L188EB13
Intel N80L188EB16
Intel N80L188EB8
Intel NG80386SX-16
Intel NG80386SX-16 (C-STEP)
Intel NG80386SX-16 (COMBO)
Intel NG80386SX-20
Intel NG80386SX-20 (C-STEP)
Intel NG80386SX-20 (LOW POWER)
Intel NG80386SX-25
Intel NG80386SX-33
Intel Overdrive DX2ODP50
Intel Overdrive DX2ODP66
Intel Overdrive DX2ODPR66
Intel Overdrive DX4ODP100
Intel Overdrive DX4ODP75
Intel Overdrive DX4ODPR100
Intel Overdrive DX4ODPR75
Intel Overdrive ODP486DX-33
Intel Overdrive ODP486SX-20
Intel Overdrive ODP486SX-25
Intel Overdrive ODPR486DX-25
Intel Overdrive ODPR486DX-33
Intel Overdrive SX2ODP50
Intel P8086
Intel P8086-2
Intel P8088
Intel P8088-2
Intel P8088-6
Intel P80C86
Intel P80C86-2
Intel P80C86AL-2
Intel P80C88
Intel P80C88-2
Intel P80C88A-1
Intel P80C88A-2
Intel P80C88AL
Intel Pentium 100
Intel Pentium 100
Intel Pentium 100 Goldcap
Intel Pentium 100 Mobile
Intel Pentium 120
Intel Pentium 120
Intel Pentium 120 Mobile
Intel Pentium 133
Intel Pentium 133
Intel Pentium 150
Intel Pentium 150
Intel Pentium 150 Mobile
Intel Pentium 166 (CPGA)
Intel Pentium 166 CPGA
Intel Pentium 166 MMX Embedded
Intel Pentium 166 PPGA
Intel Pentium 200
Intel Pentium 266 MMX Embedded
Intel Pentium 4 1300
Intel Pentium 4 1400
Intel Pentium 4 1500
Intel Pentium 4 1600
Intel Pentium 4 1600
Intel Pentium 4 1700
Intel Pentium 4 1800
Intel Pentium 4 1800
Intel Pentium 4 1900
Intel Pentium 4 1900
Intel Pentium 4 2000
Intel Pentium 4 2000 (0,13µ)
Intel Pentium 4 2000 (0,18µ)
Intel Pentium 4 2200
Intel Pentium 50
Intel Pentium 60
Intel Pentium 60 Goldcap
Intel Pentium 66
Intel Pentium 66 Goldcap
Intel Pentium 75
Intel Pentium 75
Intel Pentium 75 Goldcap
Intel Pentium 75 Mobile
Intel Pentium 90
Intel Pentium 90
Intel Pentium 90 Goldcap
Intel Pentium II 233
Intel Pentium II 233 Box
Intel Pentium II 233 Mobile
Intel Pentium II 266
Intel Pentium II 266 Box
Intel Pentium II 266 Mobile
Intel Pentium II 300
Intel Pentium II 300 Box
Intel Pentium II 300 Mobile
Intel Pentium II 333
Intel Pentium II 333 Box
Intel Pentium II 333 Mobile
Intel Pentium II 350
Intel Pentium II 350
Intel Pentium II 350 Box
Intel Pentium II 366 Mobile
Intel Pentium II 400
Intel Pentium II 400
Intel Pentium II 400 Box
Intel Pentium II 400 Mobile
Intel Pentium II 450
Intel Pentium III 1000EB
Intel Pentium III 1000EB
Intel Pentium III 1100E
Intel Pentium III 1133B
Intel Pentium III 1133EB
Intel Pentium III 1266
Intel Pentium III 1400
Intel Pentium III 450
Intel Pentium III 500E
Intel Pentium III 533B
Intel Pentium III 533EB
Intel Pentium III 550E
Intel Pentium III 550E
Intel Pentium III 600E
Intel Pentium III 600EB
Intel Pentium III 650E
Intel Pentium III 650E
Intel Pentium III 667EB
Intel Pentium III 667EB
Intel Pentium III 700E
Intel Pentium III 700E
Intel Pentium III 733EB
Intel Pentium III 733EB
Intel Pentium III 750E
Intel Pentium III 750E
Intel Pentium III 800E
Intel Pentium III 800EB
Intel Pentium III 800EB
Intel Pentium III 850E
Intel Pentium III 850E
Intel Pentium III 866EB
Intel Pentium III 866EB
Intel Pentium III 900E
Intel Pentium III 933EB
Intel Pentium III 933EB
Intel Pentium MMX 166 ( Box CPGA)
Intel Pentium MMX 166 (Box PPGA)
Intel Pentium MMX 166 (CPGA)
Intel Pentium MMX 166 (PPGA)
Intel Pentium MMX 200 (Box PPGA)
Intel Pentium MMX 200 (PPGA)
Intel Pentium MMX 200(CPGA)
Intel Pentium MMX 233
Intel Pentium MMX 233 (Box)
Intel Pentium MMX Overdrive 125
Intel Pentium MMX Overdrive 150
Intel Pentium MMX Overdrive 166
Intel Pentium MMX Overdrive 180
Intel Pentium MMX Overdrive 200
Intel Pentium Overdrive 120
Intel Pentium Overdrive 125
Intel Pentium Overdrive 133
Intel Pentium Overdrive 150
Intel Pentium Overdrive 166
Intel Pentium Overdrive 63
Intel Pentium Overdrive 83
Intel Pentium Pro 150
Intel Pentium Pro 166
Intel Pentium Pro 180
Intel Pentium Pro 200 (1M)
Intel Pentium Pro 200 (256K)
Intel Pentium Pro 200 (512K)
Intel QA80186
Intel QA80186-10
Intel QA80188
Intel QA80188-10
Intel QD8086
Intel QD8086-2
Intel QD8088
Intel QD8088-2
Intel QM8088D1
Intel QR80186
Intel QR80186-10
Intel QR80188
Intel QR80188-10
Intel R80186
Intel R80186-10
Intel R80188
Intel R80188-10
Intel R80286-10
Intel R80286-12
Intel R80286-6
Intel R80286-8
Intel R80C186
Intel R80C186-12
Intel R80C186-16
Intel R80C186XL
Intel R80C186XL10
Intel R80C186XL12
Intel R80C186XL16
Intel R80C186XL20
Intel R80C186XL25
Intel R80C188
Intel R80C188-12
Intel R80C188-16
Intel R80C188XL
Intel R80C188XL12
Intel R80C188XL16
Intel R80C188XL20
Intel R80C188XL25
Intel S80C186XL
Intel S80C186XL12
Intel S80C186XL16
Intel S80C186XL20
Intel S80C186XL25
Intel S80C188EB13
Intel S80C188EB20
Intel S80C188EB25
Intel S80C188XL
Intel S80C188XL12
Intel S80C188XL16
Intel S80C188XL20
Intel S80C188XL25
Intel S80L188EB13
Intel S80L188EB16
Intel S80L188EB8
Intel SB80C186XL
Intel SB80C186XL12
Intel SB80C186XL16
Intel SB80C186XL20
Intel SB80C188EB13
Intel SB80C188EB20
Intel SB80C188EB25
Intel SB80C188XL
Intel SB80C188XL12
Intel SB80C188XL16
Intel SB80C188XL20
Intel SB80L188EB13
Intel SB80L188EB16
Intel SB80L188EB8
Intel TA80186
Intel TA80186-10
Intel TA80186-12
Intel TA80188
Intel TA80188-10
Intel TA80C186
Intel TA80C186XL
Intel TA80C186XL12
Intel TA80C186XL16
Intel TA80C186XL20
Intel TA80C188
Intel TA80C188-12
Intel TA80C188XL
Intel TA80C188XL12
Intel TD8088
Intel TN80C186-12
Intel TN80C186XL
Intel TN80C186XL12
Intel TN80C186XL16
Intel TN80C186XL20
Intel TN80C188
Intel TN80C188-12
Intel TN80C188EB13
Intel TN80C188EB16
Intel TN80C188EB20
Intel TN80C188XL12
Intel TN80L188EB13
Intel TN80L188EB8
Intel TR80C186
Intel TR80C186-12
Intel TR80C186XL
Intel TR80C186XL12
Intel TR80C186XL16
Intel TR80C186XL20
Intel TR80C188
Intel TR80C188-12
Intel TR80C188XL
Intel TR80C188XL12
Intel TR80C188XL16
Intel TR80C188XL20
Intel TS80C186EB20
Intel TS80C186XL
Intel TS80C186XL12
Intel TS80C186XL16
Intel TS80C186XL20
Intel TS80C188EB13
Intel TS80C188EB20
Intel TS80C188XL
Intel TS80C188XL12
Intel TS80C188XL16
Intel TS80C188XL20
Intel TS80L188EB13
Intel TS80L188EB8
Intel Xeon 1000EB
Intel Xeon 400 (1M)
Intel Xeon 400 (512K)
Intel Xeon 450 (1M)
Intel Xeon 450 (2M)
Intel Xeon 450 (512K)
Intel Xeon 500 (1M)
Intel Xeon 500 (2M)
Intel Xeon 500 (512K)
Intel Xeon 550 (1M)
Intel Xeon 550 (2M)
Intel Xeon 550 (512K)
Intel Xeon 600EB
Intel Xeon 667EB
Intel Xeon 700 (1M)
Intel Xeon 700 (2M)
Intel Xeon 733EB
Intel Xeon 800EB
Intel Xeon 866EB
Intel Xeon 900
Intel Xeon 933EB
Intersil MD80C88/B
MHS D8086
MHS D8086-2
MHS D8088
MHS HM8086
MHS ID8086
MHS P8088
MHS P8088-2
Nec D8088D
Nec D8088D-2
Nec V20 D70108C-10
Nec V20 D70108C-5
Nec V20 D70108C-8
Nec V20 D70108D
Nec V20 D70108D-10
Nec V20 D70108D-5
Nec V20 D70108D-8
Nec V20 D70108G-5
Nec V20 D70108G-8
Nec V20 D70108HG-10
Nec V20 D70108HLM-16
Nec V20 D70108L-5
Nec V20 D70108L-8
Nexgen Nx586 P100
Nexgen Nx586 P110
Nexgen Nx586 P120
Nexgen Nx586 P75
Nexgen Nx586 P80
Nexgen Nx586 P90
Nexgen Nx586 PF100
Nexgen Nx586 PF110
Non renseigné
OKI M80C86
OKI M80C86-2
OKI M80C86A-2
OKI M80C88
OKI M80C88A
OKI M80C88A-10
OKI M80C88A-10GS
OKI M80C88A-10JS
OKI M80C88A-10RS
OKI M80C88A-2
OKI M80C88GS
OKI M80C88RS
Pentium III 500
Pentium III 550
Pentium III 600
Pentium III 600B
Pentium III 600E
Rise MP6 PR166
Rise MP6 PR233
Rise MP6 PR266
Rise MP6 PR333
Rise MP6 PR333
Rise MP6 PR366
Rise MP6 PR366
Siemens SAB80186-1-N
Siemens SAB80186-1-R
Siemens SAB80186-N
Siemens SAB80186-R
Siemens SAB80188-1-N
Siemens SAB80188-1-R
Siemens SAB80188-A
Siemens SAB80188-N
Siemens SAB80188-R
Siemens SAB80188-R
Siemens SAB80286-1-A
Siemens SAB80286-1-N
Siemens SAB80286-1-R
Siemens SAB80286-12-N
Siemens SAB80286-16-N
Siemens SAB80286-A
Siemens SAB80286-C
Siemens SAB80286-N
Siemens SAB80286-R
Siemens SAB8086-1-C
Siemens SAB8086-1-P
Siemens SAB8086-1D
Siemens SAB8086-2-C
Siemens SAB8086-2-P
Siemens SAB8086-2D
Siemens SAB8086-C
Siemens SAB8086-P
Siemens SAB8086D
Siemens SAB8086DQ
Siemens SAB8088-1-P
Siemens SAB8088-12-P
Siemens SAB8088-2-P
Siemens SAB8088-P
Siemens SAB8088D
ST 486 DX-40
ST 486 DX2-50
ST 486 DX2-66
ST 486 DX2-80
ST 486 DX4-100
ST 6x86 P120+
ST 6x86 P150+
ST 6x86 P166+
UMC U5S-SUPER25
UMC U5S-SUPER33
UMC U5S-SUPER33/40
UMC U5S-SUPER40
UMC U5SX 486 A
UMC U5SX 486-33
UMC U5SX 486-33/40
UMC U5SX 486-40

And the caracteristics entered are :

Name, Producer, type, sous-type, frequency, suport (socket), bus, coeff, size, die size, voltage, cache, date of releasing, number of transistors, process, and rarity...

[chipcollector]

I'm also very interested and will definately participate. But isn't there something like this already?

http://en.wikipedia.org/wiki/Cpu#Types_of_CPUs

It's basically the same idea- I've never tried to submit anything but I'm sure it's possible since you can edit what others posted.

[morkork]

Your planned backend system is about the system I use for cpu-collection.de. If you had offered this some 3 years ago I would have saved a lot of time
Some tips from my experience so far:

• introduce flags for the state of your chip, eg. 'online/offline', 'for trade', etc. so you can enter chips to the database without showing them on your site immediately. Good when you get a new chip and don't have all needed data. The flags can also be used for generating views (like a tradelist)
  
• add meta-information flags, eg. 'FPU for 386' or 'mobile version'. Good for grouping your output accordingly.
  
• in your editor don't forget to add something like 'save as new version', so you can just open a similar CPU, change some data and save it as a new chip.
  
• in the backend overview page add some listbox-based standard selects to have an easy way to get a list of chips for editing. (like SELECT <fieldnamebox> FROM table WHERE <fieldnamebox> <'LIKE / != / = '- box> <input field>). Saves a lot of typing.
  
• add a possibility to mass-replace strings in textfields (good when you have to replace a string in all results of a SELECT)
  
• make your result output row display configurable (sometimes you need all information in a result view, sometimes only the comment field or so is relevant)
  
• use some standard selects for generating overview lists in your backend overview (like navigation lists for class, type, etc. so you can just click on an entry and make a select with the clicked entry, eg. list all 386 chips).
  
• add a field for display sort order. Sometimes the order criteria for your website output (like ordered by clock speed or alphabetically) is not exactly what you want, maybe there are different chips with the same criteria and they would look better in another order. The same is for chip classes, you maybe don't want to sort them alphabetically, like 80286 after 6x86.
  

OK, so much for now, if you need more just ask.

[slava]

So does anyone have a working SQL site engine that they can give out for free? I'd love to have one. My site is under construction now, and as I know only a little of HTML, SQL is too much for me.
Regards, Slava