db
Dev tools
database snapshot tool
SHOW HN2019
224points
88comments
#167of 2,195 in 2019
Top 8%of 2019 by points
How HN took it
DebatedReal support and real criticism
7 positive, 11 neutral or asking, 0 mixed, 10 critical, out of 28 comments about the project. Thread score -0.12.
Idea: 6 for, 9 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Useful for integration tests and dev/staging workflows
From 2 comments
Seems useful as a tool for integration tests. Makes it a bit cleaner to update the state of a database and test against the application level code
simbakhadder on HNNice idea to speed up the proccess of development and testing. Does the snapshot generated include the views, triggers and stored procedures?
llagerlof on HN
Objections
Existing migration tools like Liquibase and Flyway already cover this
From 3 comments
There are multiple tools that attempt to do this, some specific to a framework some not. To name a few, - flyway - liquibase - dbmate - alembic for python/sqlalchemy - django…
MadWombat on HNLooks nice, but I don't see what advantages it has compared to liquibase or flyway.
llcoolv on HNThe way I have been doing database versioning and rollout for years is with Liquibase (https://www.liquibase.org/). It is based on the Database refactoring book that came out…
PaulKeeble on HN
Only supports MySQL and phpMyAdmin connection is broken
From 2 comments
Yes, so far this is MySQL only. I don't think adding Postgres support would be that far fetched, have a look at…
akie on HNYes, that's why I originally added it. After a day of hacking I had it (mostly) working on one particular instance of phpmyadmin, but when I tried it on another one it completely…
akie on HN
Requests
Add PostgreSQL support
From 2 comments
This is a really cool idea. Thanks for sharing this. I will definitely give it a go if you have postgres.
kuczmama on HNYes, so far this is MySQL only. I don't think adding Postgres support would be that far fetched, have a look at…
akie on HN
Questions
What advantage over dumping MySQL to git or using migrations
From 2 comments
I'm not sure what advantage this has over putting MySQL dumps into git (or manually versioning them with filenames)?
k-godwin on HNIs this approach materially different/more scalable than using the active record, ORM, and seed file patterns supported by popular MVC frameworks (e.g., like how Rails does it…
egyptiankarim on HN
Alternatives named
Liquibase
From 2 comments
The way I have been doing database versioning and rollout for years is with Liquibase (https://www.liquibase.org/). It is based on the Database refactoring book that came out…
PaulKeeble on HNThere are multiple tools that attempt to do this, some specific to a framework some not. To name a few, - flyway - liquibase - dbmate - alembic for python/sqlalchemy - django…
MadWombat on HN
Flyway
From 2 comments
There are multiple tools that attempt to do this, some specific to a framework some not. To name a few, - flyway - liquibase - dbmate - alembic for python/sqlalchemy - django…
MadWombat on HNLooks nice, but I don't see what advantages it has compared to liquibase or flyway.
llcoolv on HN
Dolt
From 1 comment
We built a Git-style version controlled SQL database called Dolt (https://github.com/liquidata-inc/dolt) mentioned deep in this thread. It allows diffs and merges across schema…
timsehn on HN
Titan Data
From 1 comment
I'm working on a project looking to solve a similar problem, but using a very different mechanism to provide git-like semantics for any database that runs in a container…
ericschrock on HN