maemo.org - Talk

maemo.org - Talk (https://talk.maemo.org/index.php)
-   Development (https://talk.maemo.org/forumdisplay.php?f=13)
-   -   Has anyone found the communications SQLite DB on N900 yet? (https://talk.maemo.org/showthread.php?t=34057)

code177 2009-11-06 20:50
Has anyone found the communications SQLite DB on N900 yet?
 
Hey guys. I was wondering (future project) if anybody has found the SMS SQLite database on the N900 yet, and if so, do we know how to access it?

Thanks!

qwerty12 2009-11-06 21:08
Re: Has anyone found the communications SQLite DB on N900 yet?
 
The rtcomm-eventlogger API is meant to be used to access the SMSes. Yerga has mentioned in a post, somewhere, the exact filename of the DB (sorry, I don't know it).

frals 2009-11-06 22:19
Re: Has anyone found the communications SQLite DB on N900 yet?
 
~/.rtcom-eventlogger/el.db

:)

danielwilms 2009-11-09 08:13
Re: Has anyone found the communications SQLite DB on N900 yet?
 
Quote:
Originally Posted by code177 (Post 367736)
Hey guys. I was wondering (future project) if anybody has found the SMS SQLite database on the N900 yet, and if so, do we know how to access it?
But please use the API, which was mentioned by qwerty12 to access the database and don't manipulate it directly.

code177 2009-11-09 23:55
Re: Has anyone found the communications SQLite DB on N900 yet?
 
Good to know, thanks everyone! :)

matrim 2009-11-12 20:33
Re: Has anyone found the communications SQLite DB on N900 yet?
 
Does anyone know if the rtcom-eventlogger supports saving draft messages? I've got it working to save and read sent messages but can't see any docs that give info on if it works with drafts

Helmuth 2009-11-18 16:04
Re: Has anyone found the communications SQLite DB on N900 yet?
 
As far as I know are draft messages not supported yet. :(

danielwilms 2009-11-19 08:59
Re: Has anyone found the communications SQLite DB on N900 yet?
 
Hi,

Quote:
Originally Posted by matrim (Post 374031)
Does anyone know if the rtcom-eventlogger supports saving draft messages? I've got it working to save and read sent messages but can't see any docs that give info on if it works with drafts
the eventlogger does not support the saving and reading of drafts, as it is just a messaging-UI feature. It is just a temporary storage.

Cheers Daniel

matrim 2009-11-19 10:44
Re: Has anyone found the communications SQLite DB on N900 yet?
 
Quote:
Originally Posted by danielwilms (Post 381824)
Hi,



the eventlogger does not support the saving and reading of drafts, as it is just a messaging-UI feature. It is just a temporary storage.

Cheers Daniel
Thanks, do you know where the main app stores it's draft messages?

danielwilms 2009-11-19 11:51
Re: Has anyone found the communications SQLite DB on N900 yet?
 
Hi,

Quote:
Originally Posted by matrim (Post 381955)
Thanks, do you know where the main app stores it's draft messages?
unfortunately there does not exist any public API to access the database. Manipulating it directly is kind of risky and might break things on the UI level. In other words, there is no nice way right now to integrate this functionality within applications.

Cheers Daniel

nex 2010-01-18 23:12
Re: Has anyone found the communications SQLite DB on N900 yet?
 
Hi,

I know accessing el.db directly is discouraged, but in lieau of a script accessible (sh, python) public API, could this for example be dangerous to the integrity of the db as it's read-only?

# sqlite3 el.db "select count(id) from Events where service_id=3;"

to get an sms count?


All times are GMT. The time now is 23:42.

vBulletin® Version 3.8.8