SQLite Database Browser is a visual tool used to create, design and edit database files compatible with SQLite. Its interface is based on Qt, and is meant to be used by users and developers who want to create databases or edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands. Controls and wizards are available for users to: * Create and compact database files * Create, define, modify and delete tables * Create, define and delete indexes * Browse, edit, add and delete records * Search records * Import and export records as text * Import and export tables from/to CSV files * Import and export databases from/to SQL dump files * Issue SQL queries and inspect the results * Examine a log of all SQL commands issued by the application. SQLite Database Browser is not a visual shell for the sqlite command line tool. It does not require familiarity with SQL commands.
SQLite Database Browser is a visual tool used to create, design and edit database files compatible with SQLite. Its interface is based on Qt, and is meant to be used by users and developers who want to create databases or edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands. Controls and wizards are available for users to: * Create and compact database files * Create, define, modify and delete tables * Create, define and delete indexes * Browse, edit, add and delete records * Search records * Import and export records as text * Import and export tables from/to CSV files * Import and export databases from/to SQL dump files * Issue SQL queries and inspect the results * Examine a log of all SQL commands issued by the application. SQLite Database Browser is not a visual shell for the sqlite command line tool. It does not require familiarity with SQL commands.
To install sqlitebrowser, run the following command in macOS terminal (Applications->Utilities->Terminal)
sudo port install sqlitebrowser
To see what files were installed by sqlitebrowser, run:
port contents sqlitebrowser
To later upgrade sqlitebrowser, run:
sudo port selfupdate && sudo port upgrade sqlitebrowser
Reporting an issue on MacPorts Trac
The MacPorts Project uses a system called Trac to file tickets to report bugs and enhancement requests.
Though anyone may search Trac for tickets, you must have a GitHub account in order to login to Trac to create tickets.