The chances are, you’ll be working with a lot of connections/databases/tables at the same time.

If data filter feature is to display a certain number of rows, this feature is to show a certain number of columns from the table and hide the rest.

You can use multiple filters all at once. It will display only the certain rows that meet the criteria that you specify and hide the unwanted parts of it from the current view. The filter can be used to narrow down the data in your table. Don’t forget to hit cmd + S to commit the change to the server. The most common way is to double-click on the cell and hit enter once the edit is completed. With the spreadsheet-like view, you can easily modify data using inline editing feature. To add a query to favorite, select the query from the editor, right click then add to favorite. You can see all your favorite queries from the Favorite tab in the left sidebar. You can quickly see the queries that you use frequently by adding them as the favorite, so you can get them with a click. To open an item from the result list, double-click on the item or use the up arrow and down arrow key to select the item then hit enter. TablePlus will search for databases, tables, views, snaps, functions. You can expect this feature to run as the Search Spotlight on Mac. Choose the driver, then copy and paste the database URL to import. While creating a connection to the databases, if remembering username and password is a hassle for you, try this feature from TablePlus. TablePlus is a modern, native client with intuitive GUI tools to create, access, query & edit multiple relational databases: MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, and Redis.ĭownload the app from the official website.

Tableplus add rows sqllite