what about a wifi router running tomatousb ? http://tomatousb.org/

This is a nice variant, although the factors that it runs only on obsolete hardware and that it is Linux 2.4, make me not use this.

Thank you for your time and recommendation.

it actually supports k2.6 since 2010. It runs on some of the newest Asus routers, so I wouldn't say those are obsolete.

Still, it is kind of a hack.

Thanks for notifying me of this, and in itself the idea of making room in a router to make some serving tech available is not such a bad idea.

It's amazingly useful to have realtime throughput rates

tail -f query.log | pv -tri 1 > /dev/null

I think both are OK. Personally, I like whiteboards to outline solutions. A sheet of paper may serve the same purpose.

Once I decided how to solve the problem, vim comes in handy :)

I'd go for ROR, or maybe Sinatra + your favorite ORM.

If you don't want to host your own servers, you can grab an ec2 free micro instance, or just go with heroku or cloudfoundry.

Hi,

I wrote a bunch of jQuery plugins for IndexTank on https://github.com/flaptor/indextank-jquery/tree/indextankiz...

I'm working on instant search right now .. So I'll have it available soon

What you see on your timeline at the time you sign up is indexed right away. After that, the app gets all your tweets and those from who you follow. As twitter has an hourly limit for API calls, it may take some time to index your friends history.

It depends on how many friends you have and how much they tweet

Thanks, this is useful. I don't understand why Twitter itself doesn't provide this option. I can search for tweets near me, people, tweets with links, etc. but not what I missed when I wasn't online. Could you combine this with other services such as Facebook or email?

Are you saying that you can't understand why Twitter's services provide an incentive for you to be online all the time?

Good point, hadn't thought of that. I do wonder if proper search would affect people's time on Twitter. I don't find myself coming back for fear of missing out on something, but I do scroll down a lot when I visit. This must be expensive to them, as it causes lots of unnecessary db queries.

probably they didn't do it because it takes too many resources to have a separate index for every user.

I thought about adding Facebook status updates to the index. If people start asking for it, I'll consider doing it.

I'm doing something like that on my app. Even requesting 200 tweets per API call, it takes a while to index when you have lots of friends.

I'm fetching your timeline, you friends timelines, and indexing them with IndexTank.

It's incremental, so it may take a while. There's a limited number of allowed twitter API calls per hour, so in case you have lots of friends it'll take some time to have them all indexed.

About the status, there's a status bar on the upper right corner.

And you keep them even after they fall from Twitter search or the user timeline right, so eventually you'll be able to find tweets that are otherwise unreachable right?

I keep all the tweets. So the answer is Yes, you'll be able to find tweets that twitter's search does not let you find.

I can choose between a Nexus S or an IPad.

How long did it take you to build it? Can't you use Twitter search to do this though?

It took me about 3 days to build it. It's my first ruby / heroku app, so I learned a lot. Sinitter (http://sinitter.moocode.com/) saved me a lot of coding, though.

I'd add grooveshark to that mix