homeBlog | Tags | Archives | Projects | Search | Stats | Contact

Compare text files in SQL

Nov 11, 2007

no comments
Popularity: 1%

Here’s a quick hack that allows loading text files as tables in a sqlite database. Why? It’s pretty nice to compare files in SQL.
txtsql can be run as follows: txtsql.exe file.txt file2.txt …
Every text file is loaded as a table with two columns: row (line number) and data (the actual text). When saved with save [...]

Read more...