EMS SQL Manager 2010 Lite for PostgreSQL: Software Gratis untuk Manajemen Database PostgreSQL

EMS SQL Manager Lite untuk PostgreSQL adalah software database client gratis untuk melakukan administrasi dan pengembangan database PostgreSQL. Software gratis ini kompatibel dengan semua versi PostgreSQL sampai versi yang terbaru. Sampai saat ini, EMS SQL Manager Lite untuk PostgreSQL sudah sampai pada versi 4.8.0.1 yang dirilis pada tanggal 15-11-2010, dilengkapi dengan banyak alat database yang memudahkan kita dalam melakukan administrasi database. Menu kontekstual yang ditawarkan software gratis ini akan membuat tugas-tugas manajemen database jauh lebih efisien dan efektif, sebagai contoh sederhana: kita dapat menduplikasi object database (table,view,function,dll) dengan sangat mudah: lakukan klik kanan pada object yang diinginkan, lalu pilih duplicate object, sesuaikan script (jika diperlukan), kemudian finish. Kita bahkan juga dapat menduplikasi object dari satu database ke database lainnya. Berikut ini beberapa fasilitas yang terdapat pada EMS SQL Manager 2010 Lite for PostgreSQL.

Full support of PostgreSQL up to version 8.4

• Support of FILLFACTOR parameter for tables and indices
• Creating indexes concurrently
• Creating domains based on other domains
• Support of CONNECT permission for databases and USAGE permission for sequences
• Changing column types
• Support of argument names in functions
• Support of dollar-quoted strings
• Support of UTF8 data

New state-of-the-art graphical user interface

• Office 11 and Windows XP visual schemes support
• New well-described Wizard System
• Improved database explorer for easy managing of all PostgreSQL objects
• New Windows Toolbar to switch between windows easily, like in Windows Task Bar
• Navigation bars with hot actions in most of the windows
• Ability to save all program settings
• Customizable toolbars for all program windows
• Fully customizable program interface
• Powerful Visual Options module
• Localizable program interface

Rapid database management and navigation

• Multiple host/database connections
• SSL connections support
• Registering selected databases to work with
• Projects to work with the selected database objects only
• Access to PostgreSQL Server through HTTP protocol
• Multiple user-defined tabs for any tree node to access it in one-click
• Working with multiple selected objects at a time
• Grouping/Ungrouping registered databases by host name

Easy management of all PostgreSQL objects

• Creating/dropping databases and schemas
• Managing tables and all their subobjects: fields, indices, triggers, rules, checks and foreign keys
• Managing views, functions, sequences
• Managing types, aggregates, operators, languages
• Managing table/view rules
• Duplicating all database objects
• Renaming all database objects
• Viewing dependencies between database objects

Advanced data manipulation tools

• Plenty of useful tools such as data grouping, fast searching and filtering

Effective security management

• Powerful user and group manager for administering users and privileges
• Grant manager displaying all database object grants in the form of a grid
• Viewing and changing object permissions to database roles in object editors

Excellent visual and text tools for query building

• Multiple SQL editors with code completion, syntax highlight and code folding
• Large script execution (SQL Script editor)
• Favorite Queries (Save and use your frequently used queries easily)

Other useful tools to make your work with PostgreSQL server as easy as it can be

• Extracting metadata into text files or SQL script editor
• SQL Monitor

...and other useful features

• Keyboard templates
• To-do list
• External tool manager

System requirements

• 300-megahertz (MHz) Intel® Pentium II-compatible or faster processor; 600-megahertz (MHz) or faster processor recommended
• Microsoft® Windows NT4 with SP4 or later, Microsoft® Windows 2000, Microsoft® Windows 2000 Server, Microsoft® Windows XP, Microsoft® Windows 2003 Server, Microsoft® Windows Vista
• 64MB RAM or more; 128MB or more recommended
• 50MB of available HD space for program installation
• Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution video adapter and monitor recommended
• Microsoft® Mouse or compatible pointing device
• Possibility to connect to any local or remote PostgreSQL server

Software Database Client Gratis ini bisa di download di Download EMS SQL Manager 2010 Lite