Page 1 of 1

Pull data from Dude sqlite database

Posted: Thu Apr 15, 2021 3:33 pm
by ceres
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

Re: Pull data from Dude sqlite database

Posted: Wed Apr 21, 2021 1:34 pm
by genesispro
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?

Re: Pull data from Dude sqlite database

Posted: Thu Apr 22, 2021 11:10 pm
by ceres
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.