Blog Experiment: More SQL and Text Matching Apr 25, 2008

no comments Popularity: 3%

Tags: Search algorithms, SQL

In Viewer2, there is a feature that allows fast text searches on huge databases with tens of thousands of filenames. Here’s how I did it.

Read more...

Blog Experiment: Comparing text and SQL Apr 20, 2008

no comments Popularity: 3%

Tags: Database, FAQs, Help, Help and Tutorials, Microsoft SQL Server, MySQL, Programming, SQL

A lot of visitors come from search engines to my page about a little hack I made that acts as a very thin layer between text files and SQLite. Most of the search queries are something akin to “compare text files in SQL”, “SQL text compare” or other SQL and text comparison related searches. So, I’m going to write what I know about the subject.

Read more...

Compare text files in SQL Nov 11, 2007

no comments Popularity: 1%

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

Read more...