Notifications
Clear all

mobile Sqlite

13 Posts
4 Users
0 Reactions
1,337 Views
Logan
(@logan)
Trusted Member
Joined: 15 years ago
Posts: 66
 

You could always post your code? I don't have any examples right now…

For issues with code there is always StackOverflow!


   
ReplyQuote
(@alabri)
Active Member
Joined: 8 years ago
Posts: 6
Topic starter  

I tried hardly to find something similar to my requirements but I couldn't this is why I asked for your help to be honest I don't have experience in Python


   
ReplyQuote
jaclaz
(@jaclaz)
Illustrious Member
Joined: 18 years ago
Posts: 5133
 

I tried hardly to find something similar to my requirements but I couldn't this is why I asked for your help to be honest I don't have experience in Python

Well, in what you have experience?
Almost *any* sctipting or programming language could probably do what you want.

I mean, one thing is
1) suggesting a snippet of code or a few lines in a script language
another thing is
2) teaching a (say) Python course, minimal as it might be
and yet another is
3) writing a script or program "on demand"

Loosely the script or program could
1) run a file (Linux) command to each file [1]
2) if the result is positive add the file to a list of found database files

Then
3) parse the list and open, one by one each item with a "proper" SQLite viewer

Anything more than that (like directly accessing data inside the SQLite database, parsing and interpreting it, verifying it is a valid database, etc. ) implies a very good knowledge of both the scripting/programming language used AND of the SQLite file format(s).

jaclaz

[1] or a "head" command, or anyway check the first 16 bytes of the file, see
https://unix.stackexchange.com/questions/48812/fast-way-to-determine-if-a-file-is-a-sqlite-database
http//www.blakepell.com/2014-01-13-vbnet-csharp-function-to-efficiently-check-if-a-file-is-a-sqlite-database


   
ReplyQuote
Page 2 / 2
Share: