Development environment, yes. Test suite, no. Test suite and CI would be ideal, but there are more important things that come first. Thanks for the offer. The SQL and schema side isn't complex or difficult though, it's changing the Arc code to use it. Which sounds easy, but there's duplicate data and unnecessary iteration at every turn. We're also slowly moving Arc code to Racket. The API is on github. We'd certainly welcome any pull requests. Right now, the big thing someone could do, would be to add API endpoints and SQL queries or views to return JSON data for all the information on a given webpage, or section of a page.
I'll have a look at that github repo over the weekend. Is that schema.sql file current? Are you using MySql/Mariadb/Postgres ... something else? edit: OK it's clear after looking at the source code.