Hi Andre,

I voted already earlier. I'm not asking a solution right away, I'm more concerned that this kind of crucial functionality is missing and haven't seen any activity from the vendor.

Calendar search is probably easier to make, email cna be trickier.

My understanding is that calenda rdata is in sqllite db..

Full text search is its own animal with its own type of indexes, and when you throw in dynamic changes, it becomes that much more complex. But the tracker might be able to help maintain these data structures in real time.

Each non-stop word maintains its own list of every place it appears. System wide. It's not app specific. Anyway, a very interesting problem that has been solved before, and could be fast on the n900.

Yep, full-text indexing is science of it's own.., I've worked years with Lucene.

Calendar uses sqlite, I'll play with my calendar db to get the table structure out and try some sql to fetch specific content out.

Drop me a private mail, this could be interesting thing

Rather than working directly with calendardb, it might be worth seeing if there's a documented API you could use, as that might save a bit of research (and a bit of breakage if they change the table structure but keep the API). A quick Google finds http://maemo.org/api_refs/5.0/5.0-fi...annotated.html but I don't know if it's current.

I prefer to brainstorm in an open forum. If you want to quickly get a schema, sqlite3 should already be on your device, so you can do the following:

sqlite3 <db>
.tables
.schema <table>

Also, fts should be part of the sqlite source, but I don't think it's built by default.

its build and work

You are right, the problem for me is that I'm not a programmer though I work in IT business.
I'd think that calendar data even in the worst case is relatively small, so using sql to locate items matching a search string could (at least) to be a starting point.
What would be neat is that the search would list results categorized by context (like description, birthday, event name etc.) sorted by date, for example.
Otherwise we'd need a separate search index that should be kept in sync with changes in calendar DB.

Actually, the backend calendar is almost certainly capable of this, even if the interface isn't capable of inputting it. Try creating the events with these repetitions in Outlook (or calrndar app of your choice which can then), save the event as an .ics file and email it to your n900. Open the attachment and it will be impolrted to your Calendar with the repetition you set. Don't try and edit it on the n900 though, as it will save it with one of the periodicities the front-end can handle. I have this working for a number of 4-weekly repetitions, and assume it will work for other periods. Not ideal, I realise, but it at least gets the alarm repeat you want on the device.

I did some testing with sqlite and calendar db. I downloaded mmy db to PC and used sqlite3 cmd tools (win). Most important data from search perspective are in calendars and components tables. Calendars keeps track of all calendars and components holds all dates descriptions and summaries etc.

Sqllite supports SQL's LIKE operator, so I was able to query the db with wildcards. Pretty easy to find, say, birthdays or meeting dates with certain customer.

I didn't find docs about date/time formatting (stored as integers).