SQLite Tools

Assembling the list of tools for SQLite that I've posted in other, separate, posts:

• DB Browser for SQLite
• SQLite Studio

 

Android 6.0 Marshmallow for Nexus 7

Here are the steps and the links for installing the Android 6 on Nexus 7 WiFi 2013.

Device: Nexus 7 2013 WiFi, razor / flo

Bootloader keys: volume down (press and hold), then power (press and hold).

Factory images:
https://developers.google.com/android/nexus/images?hl=en


TWRP: 
https://twrp.me/https://twrp.me/devices/asusnexus72013wifi.html
fastboot flash recovery twrp.img


SuperSU
https://www.chainfire.eu
Modified boot images:
http://forum.xda-developers.com/apps/supersu/wip-android-6-0-marshmellow-t3219344
fastboot flash boot boot.img
SuperSU binary
http://forum.xda-developers.com/apps/supersu/2014-09-02-supersu-v2-05-t2868133
flash through TWRP.


Source: How to root
http://www.ibtimes.co.uk/how-root-android-6-0-marshmallow-build-mra58k-nexus-5-6-7-9-nexus-player-1522653

f.lux for Android

The recommended app is Twilight (link).

5 Best Alternative Apps like F.lux for Android

Model Tree Structures

Here is a good overview of the structures that can be used to store a graph / tree model in a flat / relational database.
Model Tree Structures in Mongo DB(link)