Here are the top 10 features of QueryPie that we introduced to the world!
1. Dashboard Connection List ( enter connection information )
You can easily create and enter database connection from the main dashboard. Database connection lists are sorted by color which makes finding and accessing specific databases very easy.
2. Selecting Database and Search the Objects from the Object Panel
When you connect to the database, you can select the database in the upper left corner and see a list of tables, views, procedures, functions, events, triggers with tree-view. You can also search directly for these objects. Merely double-click a table to view table information in the right side object information panel.
3. Convenient Object Information Panel and Data Filtering
You can compare several table information using panels and view Data, Structure, Index, Relation, Trigger, Information and Scripts in the table. You can also use the data filtering to find and search only the specific data you want to view.
4. Execution multiple SQL Queries
Run multiple queries at the same time and view all the results instantly without having to switch between panels.You can view the Run result panels side-by-side or stacked, making comparisons more convenient.
5. SQL Auto-Complete
Powerful SQL auto-complete simplifies query writing. Automatic keyword/table/column information and query completion enhances database productivity and makes writing SQL easier.
6. Auto-Commit Option Settings and Code Review Capabilities
Auto-Commit mode is simple to turn on and off. When Auto-Commit is disabled, you can check a list of uncommitted transactions at the top and perform commit or rollback operations to enable code review.
7. Import / Export Data and view Downloaded list
The top icon provides a simple import / export function. The bottom icons in the status bar let you view and manage the list of downloaded files.
8. SQL History and Copy SQL
When you click the right SQL History button, you can view the history of queries run. Simply press the Copy button to copy, re-run or share the query.
9. Edit directly in the Data Grid
You can create, update and delete data easily right on the data grid.
10. Preferences: General / Editor / Shortcut Keys / Accounts
You can set up your work environment by clicking on the profile picture in the bottom left of the application. Select your preferred language, establish connections, set up font size for the editor and grid and view shortcut details.
Please look forward to the new QueryPie features that will be added in the future :)