537 reputation
212
bio website
location
age
visits member for 2 years, 1 month
seen Dec 12 at 11:51

profile for uprego on Stack Exchange, a network of free, community-driven Q&A sites


Nov
17
awarded  Yearling
Nov
5
comment How to compare databases?
Favoring my approach of sorting the rows outside SQL am having results enough good for me, to date. Source.
Oct
31
comment How to compare databases?
I was thinking of using only pg_dump... Yeah but having dirtrees support in the comparison tool, is OK dumping the tables' contents to single files using psql. But I will try not to use that approach, so that the binary checksum will be a script option, it will be possible to have a single file, and that single file would be restorable whenever binary columns would not have been checksummed. I'm trying to develop something asap...
Oct
31
comment How to compare databases?
I don't know a way of sorting the rows other than with an external script that performed the row sort for each table (lines between lines matching "^COPY" and "^\\.") and copied verbatim all the remaining information in a pg_dump text dump.
Oct
15
comment How to compare databases?
I like it and at some point it's sure I'll give a try. However I'm not sure the schema will be comparable (they are mutant schemas of hundreds of tables and constraints), but I like very much the idea of passing an ORDER BY or something to the dump instruction. It would be needed also an additional step to abbreviate binary/base64/blob columns, but there should be alternatives for coding that, e.g. awk, sed, Python.
Oct
14
comment How to compare databases?
Okay, but maybe for pg_dump maintainer adding an option for canonical output would be no big deal. If meld is OK, and it is, isn't it the natural approach trying to leverage it?
Oct
14
asked How to compare databases?
Oct
11
comment Visual editor for graphviz DOT files
Gephi currently doesn’t provide a complete support of the DOT format. Subgraphs are not supported, nor custom attributes or size. Only labels and colors are imported if present. Directed and undirected graphs are supported. - https://gephi.github.io/users/supported-graph-formats/graphviz-dot-format/
Oct
1
comment Visual editor for graphviz DOT files
Maybe gephi is the tool.
Sep
30
comment vim: library of common substitutions without plugins?
Note for readers: @: can be used for repeat the action.
Sep
30
asked vim: library of common substitutions without plugins?
Sep
29
asked Visual editor for graphviz DOT files
Sep
24
awarded  Autobiographer
Sep
4
comment How to search recursively for a string in linux?
Were using grep -r | sed s/:.*//.
Jun
12
comment Cannot concatenate videos ffmpeg
If you are using your own build, you might consider trying building another significant version...
May
16
accepted ntfs disk dying or..? rsync and mkdir failing, strange behavior
May
16
asked ntfs disk dying or..? rsync and mkdir failing, strange behavior
May
5
awarded  Caucus
Jan
30
comment Why is it that I can ssh in but not out?
What have you tried? Did you try finding in man ssh that there exists a verbose mode?
Jan
24
comment linux bash settings for vim
Interesting. Which one's the distribution?