Skip to content

Instantly share code, notes, and snippets.

@mc3k
Last active January 2, 2025 21:03
Show Gist options
  • Select an option

  • Save mc3k/9f1b49da35d585a2da8cbdbfd55411dd to your computer and use it in GitHub Desktop.

Select an option

Save mc3k/9f1b49da35d585a2da8cbdbfd55411dd to your computer and use it in GitHub Desktop.
DROP TABLE IF EXISTS rpi_models;
CREATE TABLE "RPI_Models" (
'Family' TEXT,
'Model' TEXT,
'SoC' TEXT,
'Memory' REAL,
'Formfactor' TEXT,
'Ethernet' TEXT,
'Wireless' TEXT,
'GPIO' TEXT,
'Released' TEXT,
'Discontinued' INTEGER );
INSERT INTO RPI_Models
(Family,Model,SoC,Memory,Formfactor,Ethernet,Wireless,GPIO,Released,Discontinued)
VALUES
("Raspberry Pi","B","BCM2835",256,"Standard","Yes","No","26-pin",2012,"Yes"),
("Raspberry Pi","B","BCM2835",512,"Standard","Yes","No","26-pin",2012,"Yes"),
("Raspberry Pi","A","BCM2835",256,"Standard","No","No","26-pin",2013,"Yes"),
("Raspberry Pi","B+","BCM2835",512,"Standard","Yes","No","40-pin",2014,"No"),
("Raspberry Pi","A+","BCM2835",256,"Compact","No","No","40-pin",2014,"Yes"),
("Raspberry Pi","A+","BCM2835",512,"Compact","No","No","40-pin",2014,"No"),
("Raspberry Pi 2","B","BCM2836 / 7",1024,"Standard","Yes","No","40-pin",2015,"No"),
("Raspberry Pi Zero","Zero","BCM2835",512,"Ultra-compact","No","No","40-pin",2015,"No"),
("Raspberry Pi Zero","W / WH","BCM2835",512,"Ultra-compact","No","Yes","40-pin",2017,"No"),
("Raspberry Pi Zero","2 W","BCM2710A1",512,"Ultra-compact","No","Yes","40-pin",2021,"No"),
("Raspberry Pi 3","B","BCM2837A0 / B0",1024,"Standard","Yes","Yes","40-pin",2016,"No"),
("Raspberry Pi 3","A+","BCM2837B0",512,"Compact","No","Yes","40-pin",2018,"No"),
("Raspberry Pi 3","B+","BCM2837B0",1024,"Standard","Yes","Yes","40-pin",2018,"No"),
("Raspberry Pi 4","B","BCM2711B0 / C0",1024,"Standard","Yes","Yes","40-pin",2019,"No"),
("Raspberry Pi 4","B","BCM2711B0 / C0",2048,"Standard","Yes","Yes","40-pin",2019,"No"),
("Raspberry Pi 4","B","BCM2711B0 / C0",4096,"Standard","Yes","Yes","40-pin",2019,"No"),
("Raspberry Pi 4","B","BCM2711B0 / C0",8192,"Standard","Yes","Yes","40-pin",2020,"No"),
("Raspberry Pi 4",400,"BCM2711B0 / C0",4096,"Keyboard","Yes","Yes","40-pin",2020,"No"),
("Raspberry Pi Pico","Pico","RP2040",0.264,"Pico","No","No","40-pin",2021,"No"),
("Raspberry Pi Pico","W","RP2040",0.264,"Pico","No","Yes","40-pin",2022,"No"),
("Raspberry Pi Pico",2,"RP2350A",0.52,"Pico","No","No","40-pin",2024,"No"),
("Raspberry Pi 5",Null,"BCM2712",2048,"Standard","Yes","Yes","40-pin",2024,"No");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment