IDE PL/SQL, Oracle - Mysql - MSSQL - PostgreSQL - SQLITE

M. Escoffier - Dba Oracle, creator of open source software Panda-Sql.


Panda-SQL

CopyEcran1

CopyEcran2

CopyEcran3

CopyEcran4
Panda-Sql is a free IDE Tool, Pl/Sql editor and browser, for Oracle, Mysql, MsSql (sql server), PostgreSQL and SqLite databases.   This software is  open source   under   GPLv3   licence, lightweight (13MB) and available in   French   and   English . Its use is simple and intuitive and it runs on Windows and Linux
( natively via Wine , installation procedure).

Best compromise between simplicity and functionality, this professional tool offers all the essential functions for database management. It is mainly dedicated to database administrators, developers and data support professionals.

For intensive use, only essential and common functions, simplicity and speed were selected, and in this context it may represent a simplified and   free   alternative to   TOAD   or SQL developer . You can achieve the greater part of current operations and faster than both software mentioned above.

Access to the database can use either the traditional client connection of the workstation (eg tnsname for Oracle) or access via a Web Service Soap (Apache Server and cgi-bin service) . The Web Service server is included in the package. In the case of data access via the web service, no Oracle client or database driver is required on the workstation.

The same interface allows to work on   Oracle, MSSQL, MySQL, PostgreSQL and SqLite databases. The implementation for Oracle is the most complete.

The interface has been simplified to the maximum, combining functions    PLSQL Sql Editor ,   Browser ,  
Sessions m onitor ,   SGA Trace   for Oracle, Compare.

The Browser implements quick and efficient features like   filtering on the current column , changing the data by columns or   navigation by  
related   lines and  tables . A diagram can be used to display the referenced tables and columns for the current table.

The Sql and Pl/Sql editor assisted by the   automatic completion   enables fast editing queries and facilitates maintenance of procedures, functions, and packages.

For Oracle a PLSQL Debugger , with simple and intuitive use, will assist you in developing your code.

The Query Results can be exported to Excel , Word or clipboard .

A comparison tool allows you to compare and synchronize sql scripts, your Pl/Sql code, the results of your queries on data or meta data by simple copy / paste.

Interface with Word offers predefined styles  tables for automatic formatting, including facilitating  framing of A4 lists.

This program is free In no event shall the author be liable for any damage caused to your databases using this software.

Requirements: Windows operating system ( 32-bit or 64-bit ) Oracle client ( 32-bit ) 11g minimum for windows 7 or more.



News

Panda-SQL

Version 5.0.0

  • Bug fixed: Mysql, Mariadb: Compilation triggers, procedures, functions.
  • Preferences, Mysql: Add SQL_MODE parameter.
  • Sql Editor: Default automatic completion.
  • Browser: Add Diagram tab.
  • Browser, MariaDB: Packages management.

Mai 2020

Version 4.0.0

  • Bug fixed: Bad management of table tabs.
  • Bug fixed: Oracle: Double Query Execution in Some Cases.
  • Bug fixed: Order by does not work in Some Cases.
  • Bug fixed: Oracle, Script generation, "Not null" constraint missing.
  • Bug fixed, Truncated line numbers.
  • Bug fixed: Views and synonyms: filter + sort combination does not work.
  • Oracle: DBMS_STATS in background.
  • Oracle: Sga trace: Add Cpu Time, Elapsed Time, Query Time in seconds and numeric sorting on these 3 columns.
  • Oracle: Add view V_PANDA_SLOW_QUERIES for Enterprise Edition.
  • Oracle: Modification "referenced by": search in the tree of references up to level 10.
  • Main Menu: Click in the banner to change color.

Dec 2019

Version 3.3.0

  • Bug fixed: Oracle: Execution block PlSql, double execution.
  • Bug fixed: In some cases, the table selected in a tab was not the correct one.
  • Oracle: Add "Waiting Event" column in the list of sessions.
  • Oracle, MySql, MariaDB: Add current database OS in the windows banner.
  • Oracle: Add V_PANDA_TOP10_FG_EVENTS view for Enterprise Edition.
  • Oracle: Editor, Button Run Pl/Sql, Compilation Package + Body separated by "/", status check.
  • Preference Management.
  • Running a batch of queries: automatic refreshing of the "Logging" tab.
  • Data tab: Disabling unit delete confirmation.
  • Improved navigation by tables / rows linked, add this function via the web service.
  • Version never expires.

May 2019

Download

Panda-Sql

Sources and installer are available on sourceforge :  Here
Before downloading, please leave me a message below, just mention your City, Country and main DBMS (email optional)
Formulaire de contact :
Compteur Global gratuit sans inscription