Show HN: Stellar – Git for PostreSQL and MySQL • Hacker News Board

Show HN: Stellar – Git for PostreSQL and MySQL

#1

Post by obsession » Fri, Aug 22, 2014, 10:56 AM UTC

Show HN: Stellar – Git for PostreSQL and MySQL
github.com

Re: Show HN: Stellar – Git for PostreSQL and MySQL

#2

Post by iurisilvio » Fri, Aug 22, 2014, 11:45 AM UTC

I expected something related with Stellar coins.

Looks like a good project, I definitely want an easy way to manage development databases.

Re: Show HN: Stellar – Git for PostreSQL and MySQL

#3

Post by level09 » Fri, Aug 22, 2014, 11:53 AM UTC

This is a nice project. I used to have my database dump tracked by git (in binary mode). anytime my db changes I'll have to overwrite the file with the new database dump and include it with the commit.

I'm just wondering if this project offers anything special/better than the method I described.

Re: Show HN: Stellar – Git for PostreSQL and MySQL

#4

Post by codeoclock » Fri, Aug 22, 2014, 11:53 AM UTC

Unfortunate name, excellent project :)

Re: Show HN: Stellar – Git for PostreSQL and MySQL

#5

Post by lucian1900 » Fri, Aug 22, 2014, 11:59 AM UTC

This sort of thing is useful, but already supported by Postgres through transactional DDL. Migrations that fail will have their transaction reverted.

Re: Show HN: Stellar – Git for PostreSQL and MySQL

#6

Post by mbrock » Fri, Aug 22, 2014, 12:20 PM UTC

I wish projects like these would always include some basic info in their README about: (1) how it works, and (2) how it might fail.

Re: Show HN: Stellar – Git for PostreSQL and MySQL

#7

Post by obsession » Fri, Aug 22, 2014, 12:23 PM UTC

lucian1900 wrote: post #5

This sort of thing is useful, but already supported by Postgres through transactional DDL. Migrations that fail will have their transaction reverted.

Transaction is only reverted if the migration fails. Stellar helps you if your migration succeeds but does the wrong thing (deleting wrong column, missing WHERE in UPDATE statement).

Re: Show HN: Stellar – Git for PostreSQL and MySQL

#8

Post by areski » Fri, Aug 22, 2014, 12:24 PM UTC

mbrock wrote: post #6

I wish projects like these would always include some basic info in their README about: (1) how it works, and (2) how it might fail.

Totally agree, peoples needs to know how it works before starting using it.

Re: Show HN: Stellar – Git for PostreSQL and MySQL

#9

Post by mdellabitta » Fri, Aug 22, 2014, 12:24 PM UTC

lucian1900 wrote: post #5

This sort of thing is useful, but already supported by Postgres through transactional DDL. Migrations that fail will have their transaction reverted.

What if you're writing a migration that includes DML, and it fails partway through? Wouldn't it be good to be able to restore the DB state automatically and try again?

Re: Show HN: Stellar – Git for PostreSQL and MySQL

#10

Post by jamesmoss » Fri, Aug 22, 2014, 12:24 PM UTC

Interestingly they don't show MySQL benchmarks in the readme; I suspect it might be because the MySQL implementation is pretty basic

https://github.com/fastmonkeys/stellar/blob/master/stellar/o...