Console enables viewing, adding, editing, and deleting Cloud Firestore data. Security rules can be created and updated through the Rules tab. Indexes can be managed and queries can be filtered. Usage monitoring is available through the Usage tab
Location History saves details of all visited places and routes. Feature works on any device with Google account and enabled Location History. Data remains stored even when feature is turned off
SQLite is a lightweight, serverless database system for small to medium applications. SQLite3 comes pre-installed with Python and requires no additional setup. It stores data in a single file on the computer
Ctrl+0 hides a column, Ctrl+Shift+0 unhides it. Ctrl+9 hides a row, Ctrl+Shift+9 unhides it. Multiple columns can be hidden by selecting adjacent cells
ALTER TABLE modifies existing table definitions. ACCESS EXCLUSIVE lock required unless explicitly specified. Multiple subcommands can be combined for bulk changes
Excel can automatically group data into up to eight levels. Data must have column headers and no blank rows. Grouping can be done through Data > Group > Auto Outline