Ranked in these QuestionsQuestion Ranking
Pro Cross platform
DB Browser for SQLite is cross-platform and it's available for Mac, Linux and Windows.
Pro Open source
DB Browser is completely free and Open Source, it's source code is hosted on GitHub and is accessible by anyone.
Pro Simple to use
This tool was made to be used by both developers and end users. It was not made to be a shell for sqlite nor does it require to have knowledge of SQL. It's simply a visual tool to help users work with SQLite databases.
Con May freeze with big files
Even though large SQLite databases are very rare, DB Browser for SQLite freezes in those cases it comes across them.