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

no comments Popularity:

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: Desaturating and resizing images Apr 22, 2008

no comments Popularity:

Tags: Re-targeting, Resizing, SDL, Seam carving

More from the muse called Referer:.

Read more...

Blog Experiment: Comparing text and SQL Apr 20, 2008

1 comment Popularity:

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

A Blogging Experiment Apr 18, 2008

no comments Popularity:

Tags: Blogging

I’m going to try something that is not entirely original but still should be useful. I have found people often come across my page when looking for something with a search engine, yet the page they land on isn’t exactly what they were looking for. Or to say it in other words, I’ll try to help random visitors to find what they are looking for (or, you could argue this is some kind of search engine optimization).

Read more...