TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Show HN: Mgrt – Simple SQL Migrations

2 pointsby bkqabout 6 years ago

1 comment

stephenrabout 6 years ago
Having recently written a shell-based migration tool due to my frustration at trying to support the Python one we were using previously, this is an interesting topic to me.<p>As with the python tool we had been using, this doesn&#x27;t appear to support SSL connections for mysql&#x2F;postgresql?<p>I&#x27;m also dubious about the &quot;format&quot; used - the python tool we had been using, and the new shell tool I wrote to replace it, both just read regular SQL files in a series of directories (one called `up.sql` and one called `down.sql`). This meant that migrating from one tool to another was <i>ridiculously</i> easy, and if trying to debug, an entire SQL file can just be read into `mysql`&#x2F;etc. Having the files separated (and without any special syntax required) also makes creating them much simpler - anything that can write out SQL can do it - even e.g. schema-change tools that record changes between two known states.<p>Anyway, good luck with it. Ultimately these tools usually come about to solve some problem or scratch some itch, so I hope your itch is scratched!
评论 #19520034 未加载