Re: [sqlite] Skype client using SQLite?
On Tue, 28 Aug 2007 15:13:47 +, [EMAIL PROTECTED] wrote: >In reference to > > http://www.sqlite.org/cvstrac/tktview?tn=2592 > >This is the first public indication we have had that >Skype is using SQLite in their windows clients. However, >the person who wrote the ticket seems to be a bit confused. >Can any able hackers in the SQLite community confirm that >the Skype windows client is using SQLite? It would be >nice to add them to the page of high-profile users. I don't know if they qualify for http://www.sqlite.org/famous.html , but Comodo Firewall Pro v3.0 (an internet software firewall for MS Windows) uses SQLite in the logviewer. The schema is quite simple: CREATE TABLE FWLog ( ProcessName VARCHAR(255), Action INT, Pid INT, LogDate DOUBLE, SourceAdd DOUBLE, DestinationAdd DOUBLE, ProtocolINT, Direction INT, SourcePort INT, DestinationPort INT ); CREATE TABLE HipsLog ( FlagINT, LogDate DOUBLE, Parent VARCHAR(255), Target VARCHAR(255) ); http://www.personalfirewall.comodo.com/ -- ( Kees Nuyt ) c[_] - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Skype client using SQLite?
On Tue, 28 Aug 2007 18:44:50 +0200, you wrote: >On Tue, 28 Aug 2007 15:13:47 +, you wrote: > >>In reference to >> >> http://www.sqlite.org/cvstrac/tktview?tn=2592 >> >>This is the first public indication we have had that >>Skype is using SQLite in their windows clients. However, >>the person who wrote the ticket seems to be a bit confused. >>Can any able hackers in the SQLite community confirm that >>the Skype windows client is using SQLite? It would be >>nice to add them to the page of high-profile users. > [snip] > My own Skype installation doesn't show any trace of SQLite. > Either they don't use it, or they've hidden it very well. Oops, found it: C:\Users\\AppData\Roaming\Skype\\dyncontent\bundle.dat -- ( Kees Nuyt ) c[_] - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Skype client using SQLite?
On Tue, 28 Aug 2007 15:13:47 +, you wrote: >In reference to > > http://www.sqlite.org/cvstrac/tktview?tn=2592 > >This is the first public indication we have had that >Skype is using SQLite in their windows clients. However, >the person who wrote the ticket seems to be a bit confused. >Can any able hackers in the SQLite community confirm that >the Skype windows client is using SQLite? It would be >nice to add them to the page of high-profile users. I think he is confused indeed. The use of C:\Windows\Temp\ as temp folder, and the problems he has to get voice working in not only Skype but also other messenger programs seem to indicate an old version of Windows (95 or 98, maybe ME). Newer versions (WinNT family) would use a folder within a user profile. Assuming an old Windows installation we might also assume an old version of the virusscanner that still uses a version of SQLite that prefixes its tempfiles with sqlite instead of etilqs. My own Skype installation doesn't show any trace of SQLite. Either they don't use it, or they've hidden it very well. CyberLink seems to use SQLite for its PowerDVD and/or PowerProducer programs to store references. Table names: ATSC_Frequency ATSC_FrequencyTable Country CountryToATSC_FrequencyTable CountryToDVBT_FrequencyTable DVBS_Channel DVBS_Frequency DVBS_Region DVBS_Satellite DVBT_Frequency DVBT_FrequencyTable DVBT_FrequencyTableToFrequency DVB_IPService Version Regards, -- ( Kees Nuyt ) c[_] - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Skype client using SQLite?
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 28, 2007 8:14 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Skype client using SQLite? > > In reference to > >http://www.sqlite.org/cvstrac/tktview?tn=2592 > > This is the first public indication we have had that > Skype is using SQLite in their windows clients. However, > the person who wrote the ticket seems to be a bit confused. > Can any able hackers in the SQLite community confirm that > the Skype windows client is using SQLite? It would be > nice to add them to the page of high-profile users. > Bundle.dat file also confirmed on Windows Skype, found it: C:\Documents and Settings\\Application Data\Skype\\dyncontent\bundle.dat In my case the tables are populated. Example below. sqlite> .schema CREATE TABLE bupdate (uri text, type text, meta text, prio integer,id integer, b ody blob, terms blob); CREATE TABLE events (id intenger, event integer, event_time integer); CREATE TABLE install (uri text, type text, meta text, prio integer,id integer, b ody blob, terms blob); CREATE TABLE itemkeys (id integer, keys text); CREATE TABLE reported (id integer, exposed_cnt integer, exposed_time integer, ex ec_cnt integer, close_cnt integer); CREATE TABLE stats (id integer, exposed_cnt integer,exposed_time integer, exec_c nt integer, close_cnt integer,last_expose_start integer, exposing_now integer); CREATE INDEX bupdate_id on bupdate (id); CREATE INDEX bupdate_uri on bupdate (uri); CREATE INDEX events_id on events (id); CREATE INDEX install_id on install (id); CREATE INDEX install_uri on install (uri); CREATE INDEX itemkeys_id on itemkeys (id); CREATE INDEX reported_id on reported(id); CREATE INDEX stats_id on stats (id); sqlite> select * from install; uri|type|meta|prio|id|body|terms ui/banners/main/81|text/x-rich|information|1|81|How is your call quality? Please give us your feedba ck|☺ - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Skype client using SQLite?
On 8/28/07, Jeremy Hinegardner <[EMAIL PROTECTED]> wrote: > On Tue, Aug 28, 2007 at 03:13:47PM +, [EMAIL PROTECTED] wrote: > > In reference to > > > >http://www.sqlite.org/cvstrac/tktview?tn=2592 > > > > This is the first public indication we have had that > > Skype is using SQLite in their windows clients. However, > > the person who wrote the ticket seems to be a bit confused. > > Can any able hackers in the SQLite community confirm that > > the Skype windows client is using SQLite? It would be > > nice to add them to the page of high-profile users. > > I can confirm that there is a sqlite db in my Skype on Mac OSX > > In the file $HOME/Library/Application\ > Support/Skype//dyncontent/bundle.dat Also confirmed on Windows. It appears to contain downloaded UI data -- icons, tips, promotions, etc. It's notable that the contact list, chat history etc are using something other than SQLite. Hard to tell if what's in that ticket is actually from Skype or not, but at least they're using SQLite for some things. - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Skype client using SQLite?
The same file appears on the windows version -Original Message- From: Jeremy Hinegardner [mailto:[EMAIL PROTECTED] Sent: 28 August 2007 17:05 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Skype client using SQLite? On Tue, Aug 28, 2007 at 03:13:47PM +, [EMAIL PROTECTED] wrote: > In reference to > >http://www.sqlite.org/cvstrac/tktview?tn=2592 > > This is the first public indication we have had that > Skype is using SQLite in their windows clients. However, > the person who wrote the ticket seems to be a bit confused. > Can any able hackers in the SQLite community confirm that > the Skype windows client is using SQLite? It would be > nice to add them to the page of high-profile users. I can confirm that there is a sqlite db in my Skype on Mac OSX In the file $HOME/Library/Application\ Support/Skype//dyncontent/bundle.dat % echo .schema | sqlite3 bundle.dat CREATE TABLE bupdate (uri text, type text, meta text, prio integer,id integer, body blob, terms blob); CREATE TABLE events (id intenger, event integer, event_time integer); CREATE TABLE install (uri text, type text, meta text, prio integer,id integer, body blob, terms blob); CREATE TABLE itemkeys (id integer, keys text); CREATE TABLE reported (id integer, exposed_cnt integer, exposed_time integer, exec_cnt integer, close_cnt integer); CREATE TABLE stats (id integer, exposed_cnt integer,exposed_time integer, exec_cnt integer, close_cnt integer,last_expose_start integer, exposing_now integer); CREATE INDEX bupdate_id on bupdate (id); CREATE INDEX bupdate_uri on bupdate (uri); CREATE INDEX events_id on events (id); CREATE INDEX install_id on install (id); CREATE INDEX install_uri on install (uri); CREATE INDEX itemkeys_id on itemkeys (id); CREATE INDEX reported_id on reported(id); CREATE INDEX stats_id on stats (id); % od -c -N 16 bundle.dat 000S Q L i t e f o r m a t 3 \0 Although in mycase, all the tables are empty. enjoy, -jeremy -- Jeremy Hinegardner [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Skype client using SQLite?
On Tue, Aug 28, 2007 at 03:13:47PM +, [EMAIL PROTECTED] wrote: > In reference to > >http://www.sqlite.org/cvstrac/tktview?tn=2592 > > This is the first public indication we have had that > Skype is using SQLite in their windows clients. However, > the person who wrote the ticket seems to be a bit confused. > Can any able hackers in the SQLite community confirm that > the Skype windows client is using SQLite? It would be > nice to add them to the page of high-profile users. I can confirm that there is a sqlite db in my Skype on Mac OSX In the file $HOME/Library/Application\ Support/Skype//dyncontent/bundle.dat % echo .schema | sqlite3 bundle.dat CREATE TABLE bupdate (uri text, type text, meta text, prio integer,id integer, body blob, terms blob); CREATE TABLE events (id intenger, event integer, event_time integer); CREATE TABLE install (uri text, type text, meta text, prio integer,id integer, body blob, terms blob); CREATE TABLE itemkeys (id integer, keys text); CREATE TABLE reported (id integer, exposed_cnt integer, exposed_time integer, exec_cnt integer, close_cnt integer); CREATE TABLE stats (id integer, exposed_cnt integer,exposed_time integer, exec_cnt integer, close_cnt integer,last_expose_start integer, exposing_now integer); CREATE INDEX bupdate_id on bupdate (id); CREATE INDEX bupdate_uri on bupdate (uri); CREATE INDEX events_id on events (id); CREATE INDEX install_id on install (id); CREATE INDEX install_uri on install (uri); CREATE INDEX itemkeys_id on itemkeys (id); CREATE INDEX reported_id on reported(id); CREATE INDEX stats_id on stats (id); % od -c -N 16 bundle.dat 000S Q L i t e f o r m a t 3 \0 Although in mycase, all the tables are empty. enjoy, -jeremy -- Jeremy Hinegardner [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -