contact
contact

DataGrip

SKU: DATAGRIP Categories: , , Tag:

DataGrip is the database IDE that is tailored to suit specific needs of professional SQL developers and DBAs.

DataGrip is the multi-engine database environment. It supports MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2. If the DBMS has a JDBC driver you can connect to it via DataGrip. For any of supported engines it provides database introspection and various instruments for creating and modifying objects.

 

DataGrip - Features

Key Features:

  • NEW: Now the schema selection UI is a tree with the ability to choose if you want to introspect the current schema/database or, all schemas/databases.
  • NEW: SQL resolution scopes: you can simply map any file or folder to any datasource. This means that all unqualified objects will be resolved to the selected datasource/database/schema.
  • NEW: Create database/schema UI
  • NEW: SQLite better introspection
  • NEW: Column mappings and DDL preview: Now its possible to map every column of the file being imported to a table column in your database, which can be either an existing table or a new one created during the import process.
  • NEW: Export/import tables: Now there is an easy way to export tables and their data from one database/schema to another. It works even if the tables are in different databases from different vendors.
  • NEW: Query console improvements include :DataGrip respects the default search path, better trigger support, smart SQL keys, Jump to colors and fonts
  • NEW: Database objects improvements include: modify table UI improvement, tracking source code changes
  • Exploring your databases: DataGrip is the multi-engine database environment. We support MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2. If the DBMS has a JDBC driver you can connect to it via DataGrip. For any of supported engines it provides database introspection and various instruments for creating and modifying objects.
  • Intelligent coding assistance: Just as any decent IDE should, DataGrip provides smart code completion, code inspections, on-the-fly error highlighting and quick-fixes and refactoring capabilities. It saves your time by making the process of writing SQL code more efficient.
  • Running queries: Writing queries is nothing without being able to run them. Query console in DataGrip is the basic instrument for any SQL developer. Create multiple consoles, each with its own schema and query options.
  • Import options: Enjoy a dedicated UI for importing CSV and TSV files to the database.
  • Export options: Any table or result-set can be exported in a variety of formats including CSV, JSON, XML and HTML. You can even create your own exporting format. It can also be presented as a batch of UPDATE or INSERT statements, which can be helpful for modifying data.
  • Miscellaneous features: Among other things, DataGrip comes with user parameters support, CSV editor, diagram builder, version control support and many other features.

 

DataGrip - System Requirements

OS X

  • Mac OS X 10.8 or higher, including 10.9 (Mavericks)
  • 1 GB RAM minimum
  • 2 GB RAM recommended
  • 1024x768 minimum screen resolution

Linux

  • 1 GB RAM minimum, 2 GB RAM recommended
  • Oracle JRE 1.6+ or OpenJDK 1.7+
  • 1024x768 minimum screen resolution
  • GNOME or KDE desktop

Windows

  • Microsoft Windows 10/8/7/Vista/2003/XP (incl. 64-bit)
  • 1 GB RAM minimum
  • 2 GB RAM recommended
  • 1024x768 minimum screen resolution