Print the report to a HTML/XLSX/CSV/PDF and save your SQL query with the report. Preview a report with custom headers/footers/formatting. Highlight SQL errors if you choose to create queries by hand (no errors if you use the drag and drop visual query designer). Iteratively go back and modify your SQL if the results are not as expected. Choose which columns you want to see in the grid/report. See the hex that relates to a particular record and identifies exactly where in a DB/journal/WAL the record comes from. Export a selected blob or all blobs in DB to a file. Display latitude and longitude fields on a map. Display a number as meaningful text (sent/received/draft etc.). Import pictures held in the file system to associate and display in a query/report. Find and display pictures in blobs (JPG, PNG, GIF, TIF etc.). #Sqlite browser filter mac#
Convert numbers to dates (Unix10/13, Windows 64 bit, NSDate/Chrome, Mac absolute and more).See the resulting table in a grid form and further sort and filter results.View the resulting SQL select commands of the above.Add groups, aliases and where clauses if required.Perform more complex visual joins on multiple tables.Perform a simple visual select on some or all of the fields in a table.Break down complex Binary Plist and facebook orca2 blobs and perform queries on resulting data.
Identify multiple previous database states from DBs with WAL files.Automatically recovered deleted and partial records from DBs and associated journals/WALs.
0 kommentar(er)
