top | item 36188433

(no title)

westonOG | 2 years ago

Hi, thanks for responding. This tool automates the tasks you stated in your comment. Instead of having to write specialty code every time you need to test your sqls you can click a button and have the tool set up it up for you. Also what happens if you need to test your SQL against multiple database(ie IUAT/Model Office/Production) and/or multiple schemas? This is just one click in my program.

discuss

order

gwn7|2 years ago

I'm sure it can't match the flexibility & features your program offers, but a hacker's way would be providing that functionality via a one liner targeting their database. Assuming that dbs.txt contains a list of connection strings and migration.sql contains a set of SQL commands, an example for Postgres would be:

  cat dbs.txt | xargs -I% sh -c 'cat migration.sql | sed "1ibegin;" | sed "\$arollback;" | psql %'
Don't get me wrong, I'm not trying to shit on your product; just wanted to share the way I accomplish basically the same goal. Congrats on your release and hope it gets the attention it deserves.

westonOG|2 years ago

Don't worry I have a thick skin. It's better for people to tell me what they don't like or if there is a better way to do something than to say they like the product when they really don't. The really nifty thing with my program is you can see what the data would look like. I can't tell if your script does that.