Postico 2.0 RC6 U2B macOS

Postico 2 is a database app with a very strong focus on its core audience: people who use databases. Our customers range from researchers and analysts to app developers and students. Whether you want to enter data, search data, or perform SQL queries, Postico has you covered.

New: Multi-File Query Editor
The new SQL query editor makes working with a lot of queries easier than ever
• Create multiple SQL files and organize them into folders
• Open the same file in multiple tabs or windows
• Postico autosaves changes so you never lose your work
• Drag any SQL file into the sidebar to add it to Postico
• Edit SQL files with other text editors like VS Code, Atom, Sublime, Textmate, .
• Auto-format SQL queries with Ctrl-F: pgFormatter is now built in!
Data Entry, Editing, and Search
Click a table in the sidebar, and see the data instantly. Add rows, edit them, or filter them. Powerful features like the foreign key picker or the row detail sidebar make editing all kinds of tables a breeze.
Table Structure Editor
Postico has a powerful graphical structure editor for creating and altering tables. Add a column, edit data types, set a default value. Columns, indexes and constraints are unified in a single editor, so you see everything at once.
And the more technically inclined can view the structure as raw SQL (DDL view).
New: Function Editor
You can now edit functions and stored procedures.
New: Distraction-free Updates
Postico now updates silently in the background. We know that you have more important things on your mind than dealing with software updates. So unless you disable automatic updates, Postico will never interrupt you with an update notification again.
Improved: Connection Settings
The streamlined interface means that your servers are never more than two clicks...

Read more

Continue reading...