3 ms·
Classic problems in a state based vs migration based management of your database code. What's wrong with information schema and an order by? If you are using mi
by hobs 2y ago
Classic problems in a state based vs migration based management of your database code. What's wrong with information schema and an order by? If you are using migrations then the creation dates should be generally in the right order as well.
- peterldowns 2y agoI’m not sure I understand — can you elaborate on “what’s wrong with an information schema and an order by”? I don’t see how that’s connected to the problems I described with pg_dump or the solution offered by pgmigrate, but I’d be curious to learn another way of solving be problem.
- hobs 2y agoJust the problem with ordering of state in a database not matching the other database after you ran migrations. Information schema being the authoritative schema for all the information about the meta state in most database systems (or at least the cross platform one) means you can write a query against these views and (if I am not mistaken) re-assemble state that's identical by ordering the application of the objects in the order they were created originally.
- fooododododo 2y agoIs everything in pgdump in the information schema?