Compare text files in SQL Nov 11, 2007

1 comment Popularity:

Tags: Software, Source code, SQL, SQLite, Text files

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 [...]

Read more...