openmelody/melody — reverse-engineered prompt

Build me a self hosted blogging and publishing system like Melody. I want to run it on a regular web server with Perl CGI and a SQL database, so someone can upload it to a website folder, open it in the browser, and get a friendly setup wizard.

It should let me manage a personal or small business site, publish blog posts and pages, use templates for the public site, handle comments, provide search, and generate feeds. Please include a simple admin area, basic security for logging in, and a clear configuration flow for MySQL, SQLite, or Postgres.

Also include an upgrade path so an existing install can be backed up and updated, and leave room for plugins or addons later. Keep the interface straightforward and old school web hosting friendly. Look up current docs online if you need to, but focus on making a working first version.