SSH Browser (Revision #37)

SSH Browser

Aqua Data Studio 11.0 features an SSH Browser that provides an overview of your Linux Server. The purpose of the SSH is to help you visualize and maintain your SSH Server. The SSH Browser in Aqua Data Studio v11.0 makes uses of procfs (or the proc filesystem), a special filesystem in UNIX-like operating systems that presents information about processes and other system information in a hierarchical file-like structure, providing a more convenient and standardized method for dynamically accessing process data held in the kernel than traditional tracing methods or direct access to kernel memory. Typically, it is mapped to a mount point named /proc at boot time. You can quickly view server version information, including: OS, CPUs, Memory, Disks, File Systems, Network Interfaces and the different Users. Currently this feature is not  supported in MAC OSX, but would be added in a future release.

 

The following different components of the Server can be quickly viewed: 

• OS
• CPUs
• Memory
• Disks
• File Systems
• Network Interfaces
• Users

OS

 Connect to a Database Server, Reconnect and Disconnect: 

In the FluidShell prompt, use the \connect command to establish connection to a RDBMS server. You can reconnect to the database server using \reconnect command and end the current transaction using the \disconnect command

 Execute command:

\exec Executes an OS command. The command takes the form \exec COMMAND [args]

 List Databases, List Schemas, List Tables, List Views:

\list displays the list of databases, schemas, tables or views defined in the connected RDBMS server. The connection to the RDBMS server needs to be established before the \list command is executed. 

 Commit a Transaction, Rollback and AutoCommit Options:

Use the FluidShell prompt to connect to a database server, execute SQL commands and commit transactions. \commit ends the current transaction and makes permanent all changes performed in the transaction. Use \rollback command to rollback the current transaction to the beginning and use \autocommit to control the current database connection's autocommit mode.  The options for this command are autocommit [on, off]. When autocommit is invoked with no arguments, it prints the current auto-commit status.

 Go command and sql-history:

\go command sends the contents of the work buffer to the database. The command \sql-history displays the SQL statement history table with the time the sql commands were executed in the FluidShell prompt. 

CPUs

 Select, Insert, Update and more: 

You can use the FluidShell prompt to connect to any database server and execute SQL commands such as select, insert, update and more. You can combine the SQL commands with pipeline commands and also use redirect command to output SQL commands to a file, or send a file to a command as input.

Memory

 Import data into a table and Export table data into CSV, Excel: 

The Import Data Command in the FluidShell allows data of different formats to be imported and inserted into tables. The Export Command allows data from tables to be exported in a variety of formats.

Disks

 Create a new Directory, Change Directory, List Present Working Directory and Delete Directory: 

Use the FluidShell prompt in Aqua Data Studio to execute Operating System commands -  \mkdir  [directory] command to create a new directory. \cd   [directory] changes to the directory, \pwd tells your present working directory and \rmdir  [directory] deletes a directory.

 Create a file, List your Files, Move, Copy, Rename and Remove: 

Use \touch  [filename] command in the FluidShell prompt to create a new file.The \ls command lists your files, \mv command moves your files from one directory to another, \cp copies a file, \rm deletes the file, \ren renames the file.

 Sync target and source Directories: 

You can syncronize a local target directory with files and subdirectories of source directory using \syncdir command.

File Systems

 Compress using zip, tar and gzip algorithms: 

FluidShell contains a collection of different algorithms to compress files.\zip command compresses and packs files into a single ZIP archive that is compatible with PKZIP. By default, packing a directory to a zipfile always implies that the subdirectories below should be included in the archive. \tar command stores/extracts files and/or directories to/from an archive file known as a tarfile. \gzip command reduces the size of named files using the GZIP algorithm. Each file is replaced by one with the extension .gz

 Uncompress archived file using unzip and gunzip: 

\unzip command extracts files from a ZIP archive to the named directory, or current directory if no directory specified. \gunzip takes a list of files and replaces each file whose name ends with .gz with an uncompressed file without the original extension

Network Interfaces

 Open an SSH Terminal: 

Use \ssh command in the FluidShell prompt to open an SSH terminal tab in Aqua Data Studio 11.0.

 Secure Copy Files over the Network: 

You can secure copy files over the network using the \scp command. This command copies files between the local host and a remote host. File names may contain a user and host specification to indicate that the file is to be copied to/from that host; current user is assumed if the user portion is omitted. Directory copy is done recursively by default. Copying files between remote hosts is not allowed, and, copying files on the local host is not supported.

Users

 Send messages to one or more recipients in FluidShell: 

Use the FluidShell prompt in Aqua Data Studio to send a message to one or more recipients -  \sendmail command has options to add attachments, bcc, cc, set message in HTML content as well as text content, set message subject, set host address and port of the SMTP server. \sendmail also has options to instruct SMTP to use SSL connection or authenctication.