Community discussions

MikroTik App
 
ceres
just joined
Topic Author
Posts: 7
Joined: Fri Nov 05, 2010 7:18 pm

Pull data from Dude sqlite database

Thu Apr 15, 2021 3:33 pm

I've wrote a simple php class to extract some data (Devices, Maps, Types and, partially, Links) directly from The Dude database file.

The idea came from this topic: viewtopic.php?t=145928 and the main decode method is a port of the python code wrote by 0ki here: https://github.com/0ki/mikrotik-tools/b ... decoder.py

Feel free to clone my github repository and use/modify/improve the code.

I'll be happy to accept any pull request (there's a ton of things that can be done...)

Repo url: https://github.com/diegotibi/dude
 
User avatar
genesispro
Member Candidate
Member Candidate
Posts: 168
Joined: Fri Mar 14, 2014 12:33 pm

Re: Pull data from Dude sqlite database

Wed Apr 21, 2021 1:34 pm

hmmm would it also connect to a live dude db file?
If yes have you also tried to modify it and see the changes live in the Dude?
Mikrotik Rulez
 
ceres
just joined
Topic Author
Posts: 7
Joined: Fri Nov 05, 2010 7:18 pm

Re: Pull data from Dude sqlite database

Thu Apr 22, 2021 11:10 pm

Opening the DB "live" is possibile, in theory, it's only matter of sharing the media where the database is stored.

Modify the database is also possible, since it's known how to decode the data it's also possible to encode it back.
I've no plans on writing an encode method since I don't need one, feel free to do by yourself if you want.

Who is online

Users browsing this forum: maigonis and 11 guests