IDE PL/SQL,
Oracle - Mysql - MSSQL - PostgreSQL - SQLITE
M. Escoffier - Dba Oracle, creator of open source software Panda-Sql.
Panda-SQL
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.