How to perform better document version control on Excel files and SQL schema files

The answer I have written here can be applied in this case. A tool called xls2txt can provide human-readable output from .xls files. So in short, you should put this to your .gitattributes file: *.xls diff=xls And in the .git/config: [diff “xls”] binary = true textconv = /path/to/xls2txt Of course, I’m sure you can find … Read more

Build and Version Numbering for Java Projects (ant, cvs, hudson)

For several of my projects I capture the subversion revision number, time, user who ran the build, and some system information, stuff them into a .properties file that gets included in the application jar, and read that jar at runtime. The ant code looks like this: <!– software revision number –> <property name=”version” value=”1.23″/> <target … Read more

Compare version numbers without using split function

Can you use the Version class? https://learn.microsoft.com/en-us/dotnet/api/system.version It has an IComparable interface. Be aware this won’t work with a 5-part version string like you’ve shown (is that really your version string?). Assuming your inputs are strings, here’s a working sample with the normal .NET 4-part version string: static class Program { static void Main() { … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)