The Ghost team writes about development of the Ghost publishing platform, including releases, architecture changes, and migrations.
HN commenters link it to explain Ghost 1.0 details, such as auto-updates via Ghost-CLI, and the decision to drop PostgreSQL support.
Postgres was an option for production along MySQL and SQLite3 was suggested for development instances. Sqlite3 is still supported.
The mentioned why they dropped it here: https://dev.ghost.org/dropping-support-for-postgresql/
> Without active community support, Postgres has always been, and always will be a second-class citizen. For that reason, we are dropping official Postgres support from Ghost core.
I answered this question in as much detail as possible in the blog post I wrote at the time (which was also linked in the above comment) https://dev.ghost.org/dropping-support-for-postgresql/
Sure, this release includes Ghost-CLI, which enables auto-updates for the first time. Details here: https://dev.ghost.org/ghost-1-0-0/
More technical article worth reading: https://dev.ghost.org/ghost-1-0-0/