News for hackers. Stuff that matters.
Re:To ORM or Not to ORM by lenkite on Tuesday May 07, 2019 @05:11PM (#19853485)
We use liquibase https://www.liquibase.org/ for tracking, managing and applying any schema changes. The liquibase changelogs are part of our project releases.
Re:To ORM or Not to ORM by OJFord on Tuesday May 07, 2019 @05:37PM (#19853682)
> Supports XML, YAML, JSON and SQL formats

XML is the default on the page, but wow the SQL is _so_ much shorter and more readable than the others! To the extent that I wonder what's the point, the obvious is machine readabaility, but one not three, and is SQL really so machine-unreadable that it's worth the extra depth and complexity?

Re:To ORM or Not to ORM by radiowave on Tuesday May 07, 2019 @06:54PM (#19854198)
With Liquibase, when you write changesets using SQL, you have to write the rollback code yourself. When you write them with Liquibase's built-in operations in (for example) XML, the rollback is derived automatically.

I write SQL almost daily, but for the things that can easily be expressed with Liquibase's operations, I can write them faster and with fewer errors in XML, so long as I'm using a text editor with XML schema support (hence: autocompletion and validation as-you-type). PyCharm works well for this.