I’ve done this with DBIx::Class, Catalyst, and JSON::XS + Catalyst::View::JSON/Catalyst::Action::REST. It’s totally out of the scope of a short answer here though and probably overkill for what you’re doing.

If I were starting a small personal project today I would first try Mojolicious + Mojolicious::Plugin::REST and see if that was all it took. You can also search (meta|search\.)cpan.org for “CRUD” to find all sorts of other options and approaches.

I apologize I don’t have some prefab or sample code for you today; no time. :|