Skype SQLite DB empty and not sure how to read IndexedDB
I have Ubuntu 18.04.2 LTS Desktop and Skype 8.34.0.78 and there's /home/{user_name}/.config/skypeforlinux/databases/Databases.db that opens up in SQLiteStudio and I see the familiar table structure but there's no data in it at all.
So I searched for a string I recently used in Skype chat and found only one file containing it: /home/crewnew/Documents/IndexedDB/file__0.indexeddb.leveldb/000006.log but not sure how to read that file. SQLiteStudio can't open it and neither I can read it with my PHP code that I use to read Skype's main.db generated in Win10 machine:
$db = new SQLite3('skype.db');
$results = $db->query('SELECT nsp_data FROM messagesv12');
while ($row = $results->fetchArray()) {
// And here's the data:
// $messages['cuid']
// $messages['conversationId']
// $messages['creator']
// $messages['createdTime']
// $messages['content']
}
Basically I'm checking Skype db constantly if there are new messages in certain group chat and then send to MatterMost channel the messages but I had issues with WAMP server so I ended up installing Ubuntu and I love it in every way except the Skype DB issue. Maybe I should send Skype messages to MatterMost just in a different way?
18.04 skype
add a comment |
I have Ubuntu 18.04.2 LTS Desktop and Skype 8.34.0.78 and there's /home/{user_name}/.config/skypeforlinux/databases/Databases.db that opens up in SQLiteStudio and I see the familiar table structure but there's no data in it at all.
So I searched for a string I recently used in Skype chat and found only one file containing it: /home/crewnew/Documents/IndexedDB/file__0.indexeddb.leveldb/000006.log but not sure how to read that file. SQLiteStudio can't open it and neither I can read it with my PHP code that I use to read Skype's main.db generated in Win10 machine:
$db = new SQLite3('skype.db');
$results = $db->query('SELECT nsp_data FROM messagesv12');
while ($row = $results->fetchArray()) {
// And here's the data:
// $messages['cuid']
// $messages['conversationId']
// $messages['creator']
// $messages['createdTime']
// $messages['content']
}
Basically I'm checking Skype db constantly if there are new messages in certain group chat and then send to MatterMost channel the messages but I had issues with WAMP server so I ended up installing Ubuntu and I love it in every way except the Skype DB issue. Maybe I should send Skype messages to MatterMost just in a different way?
18.04 skype
1
IndexedDB
isn't SQLite and isn't searched with SQL. It also isn't a Relational Database like SQLite is. Most of the documentation on how to interface with it I've found is JavaScript, unfortunately... such as this tutorial shows or even Mozilla's documentation.
– Thomas Ward♦
Mar 19 at 13:40
Thanks Thomas! So no SQLite in Linux Skype?
– Kaspar L. Palgi
Mar 22 at 12:32
As Skype is closed source software, I don't have the information to answer you; the only way to determine if Skype still uses SQLite is to dissect the code or ask Microsoft yourself.
– Thomas Ward♦
Mar 22 at 13:59
add a comment |
I have Ubuntu 18.04.2 LTS Desktop and Skype 8.34.0.78 and there's /home/{user_name}/.config/skypeforlinux/databases/Databases.db that opens up in SQLiteStudio and I see the familiar table structure but there's no data in it at all.
So I searched for a string I recently used in Skype chat and found only one file containing it: /home/crewnew/Documents/IndexedDB/file__0.indexeddb.leveldb/000006.log but not sure how to read that file. SQLiteStudio can't open it and neither I can read it with my PHP code that I use to read Skype's main.db generated in Win10 machine:
$db = new SQLite3('skype.db');
$results = $db->query('SELECT nsp_data FROM messagesv12');
while ($row = $results->fetchArray()) {
// And here's the data:
// $messages['cuid']
// $messages['conversationId']
// $messages['creator']
// $messages['createdTime']
// $messages['content']
}
Basically I'm checking Skype db constantly if there are new messages in certain group chat and then send to MatterMost channel the messages but I had issues with WAMP server so I ended up installing Ubuntu and I love it in every way except the Skype DB issue. Maybe I should send Skype messages to MatterMost just in a different way?
18.04 skype
I have Ubuntu 18.04.2 LTS Desktop and Skype 8.34.0.78 and there's /home/{user_name}/.config/skypeforlinux/databases/Databases.db that opens up in SQLiteStudio and I see the familiar table structure but there's no data in it at all.
So I searched for a string I recently used in Skype chat and found only one file containing it: /home/crewnew/Documents/IndexedDB/file__0.indexeddb.leveldb/000006.log but not sure how to read that file. SQLiteStudio can't open it and neither I can read it with my PHP code that I use to read Skype's main.db generated in Win10 machine:
$db = new SQLite3('skype.db');
$results = $db->query('SELECT nsp_data FROM messagesv12');
while ($row = $results->fetchArray()) {
// And here's the data:
// $messages['cuid']
// $messages['conversationId']
// $messages['creator']
// $messages['createdTime']
// $messages['content']
}
Basically I'm checking Skype db constantly if there are new messages in certain group chat and then send to MatterMost channel the messages but I had issues with WAMP server so I ended up installing Ubuntu and I love it in every way except the Skype DB issue. Maybe I should send Skype messages to MatterMost just in a different way?
18.04 skype
18.04 skype
asked Mar 19 at 13:32
Kaspar L. PalgiKaspar L. Palgi
1012
1012
1
IndexedDB
isn't SQLite and isn't searched with SQL. It also isn't a Relational Database like SQLite is. Most of the documentation on how to interface with it I've found is JavaScript, unfortunately... such as this tutorial shows or even Mozilla's documentation.
– Thomas Ward♦
Mar 19 at 13:40
Thanks Thomas! So no SQLite in Linux Skype?
– Kaspar L. Palgi
Mar 22 at 12:32
As Skype is closed source software, I don't have the information to answer you; the only way to determine if Skype still uses SQLite is to dissect the code or ask Microsoft yourself.
– Thomas Ward♦
Mar 22 at 13:59
add a comment |
1
IndexedDB
isn't SQLite and isn't searched with SQL. It also isn't a Relational Database like SQLite is. Most of the documentation on how to interface with it I've found is JavaScript, unfortunately... such as this tutorial shows or even Mozilla's documentation.
– Thomas Ward♦
Mar 19 at 13:40
Thanks Thomas! So no SQLite in Linux Skype?
– Kaspar L. Palgi
Mar 22 at 12:32
As Skype is closed source software, I don't have the information to answer you; the only way to determine if Skype still uses SQLite is to dissect the code or ask Microsoft yourself.
– Thomas Ward♦
Mar 22 at 13:59
1
1
IndexedDB
isn't SQLite and isn't searched with SQL. It also isn't a Relational Database like SQLite is. Most of the documentation on how to interface with it I've found is JavaScript, unfortunately... such as this tutorial shows or even Mozilla's documentation.– Thomas Ward♦
Mar 19 at 13:40
IndexedDB
isn't SQLite and isn't searched with SQL. It also isn't a Relational Database like SQLite is. Most of the documentation on how to interface with it I've found is JavaScript, unfortunately... such as this tutorial shows or even Mozilla's documentation.– Thomas Ward♦
Mar 19 at 13:40
Thanks Thomas! So no SQLite in Linux Skype?
– Kaspar L. Palgi
Mar 22 at 12:32
Thanks Thomas! So no SQLite in Linux Skype?
– Kaspar L. Palgi
Mar 22 at 12:32
As Skype is closed source software, I don't have the information to answer you; the only way to determine if Skype still uses SQLite is to dissect the code or ask Microsoft yourself.
– Thomas Ward♦
Mar 22 at 13:59
As Skype is closed source software, I don't have the information to answer you; the only way to determine if Skype still uses SQLite is to dissect the code or ask Microsoft yourself.
– Thomas Ward♦
Mar 22 at 13:59
add a comment |
0
active
oldest
votes
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1126943%2fskype-sqlite-db-empty-and-not-sure-how-to-read-indexeddb%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Ask Ubuntu!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1126943%2fskype-sqlite-db-empty-and-not-sure-how-to-read-indexeddb%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
IndexedDB
isn't SQLite and isn't searched with SQL. It also isn't a Relational Database like SQLite is. Most of the documentation on how to interface with it I've found is JavaScript, unfortunately... such as this tutorial shows or even Mozilla's documentation.– Thomas Ward♦
Mar 19 at 13:40
Thanks Thomas! So no SQLite in Linux Skype?
– Kaspar L. Palgi
Mar 22 at 12:32
As Skype is closed source software, I don't have the information to answer you; the only way to determine if Skype still uses SQLite is to dissect the code or ask Microsoft yourself.
– Thomas Ward♦
Mar 22 at 13:59