Really nice tool, robust, easy to use and fast.
Great for:
-Quickly navigating both the schema objects and the data.
-Testing SQL and modeling different schema approaches.
-Reporting, I have saved a lot of time grinding on spreadsheets.
The only constraints I have found is:
-it does not support the SQLite dot commands ( i.e. .HEADERS , .MODE). I would believe this is intentional as it would make exporting SQL results much -more complex, but it would be nice if there was a way.
-You cannot copy all of the data in SQL results tab, you can select individual rows or export to CSV. It would be really nice to command C the entire result set and paste into another document.
lm6068 about
Base - SQLite Editor