mame-db

Build a list of roms supported by the Multiple Arcade Machine Emulation project, and insert them into a database.

Requirements

• ruby & nokogiri
• postresql
• mame

Instructions

$ brew install mame  # or sudo apt-get install mame
$ mame -listxml > romlist.xml
$ ./xml2csv romlist.xml > romlist.csv
$ createdb mame
$ psql mame < schema.sql
$ psql mame < seed.sql
$ psql mame

Queries

-- Vertical roms
select
  id,
  name,
  substr(description, 1, 30) as description,
  year,
  substr(manufacturer, 1, 30) as manufacturer,
  width,
  height,
  rotate
from romlist
where rotate = 90 or rotate = 270
order by
  year,
  name;

-- Vertical roms from 1982
select
  id,
  name,
  substr(description, 1, 30) as description,
  year,
  substr(manufacturer, 1, 30) as manufacturer,
  width,
  height,
  rotate
from romlist
where
  year = '1982' and
  (rotate = 90 or rotate = 270)
order by
  year,
  name;