- TypeScript 82.4%
- HTML 11.1%
- C++ 3.6%
- CSS 2.4%
- Python 0.5%
| .vscode | ||
| docs | ||
| media | ||
| prebuilds | ||
| prisma | ||
| src | ||
| srcNative | ||
| .env | ||
| .eslintrc.json | ||
| .gitignore | ||
| .prettierignore | ||
| .prettierrc.json | ||
| .vscodeignore | ||
| binding.gyp | ||
| CHANGELOG.md | ||
| package-lock.json | ||
| package.json | ||
| README.md | ||
| tsconfig.json | ||
| vsc-extension-quickstart.md | ||
sql-developer-plus README
This extension adds a number of features to Oracle's SQL Developer VS Code extension. It can also be used standalone but this will limits some features as the database connection and schema sychronisation is not available.
Features
At it's core this extension builds a full database of your workspace's sql files (and PL/SQL) and identifies them as good as possible. It can detect DDL statements for tables as well as for PL/SQL objects like packages, procedures, functions, triggers and types. Furthermore it can parse ORDS REST definitions as well as APEX application scripts. The parsing is done efficiently with the native (C++) implementation of Antlr4.
This allows us to implement a number of features and further more in the future.
Go to definition for (PL/)SQL objects and APEX components
Use ctrl/cmd+click on a (PL/)SQL object or APEX component to go to the definition. Works for all identifiers in the code and APEX component ids. If a database connection is available it will also go to the definition in the database if it is not found in the workspace.
GIF to be added
(Enhanced) Outline's for SQL, PL/SQL, ORDS and APEX
To be implemented
To be written
Inline source code editing for ORDS sources which allows the usage of Intellisense, code formatting, navigation, refactoring and linting.
To be implemented
To be written
Inline source editing for several sources (Region sources, JS, CSS)
To be implemented
To be written
APEX source navigation via id's as well as hover information
To be implemented
To be written
In the future
Trivadis linting for PL/SQL/SQLcl codescan rules
As of today this is possible with my other extension sqlcl-codescan which leverages SQLcl codescan functionality to lint code as well as provide a formatting engine but due to the java nature of SQLcl it is relatively memory hungry and requires additional setup.
To be implemented
Requirements
Windows/Linux/MacOS (Apple Silicon) x64 Versions are supported right now, others like Intel Mac or ARM Linux are not (this is due to the native compliation of Antlr4 - but subject to change it the future hopefully)
To actually use the database features you have you connect to you database using the context menu provided by the extension for the normal SQL developer connection view, this is because as of now the oracle extension does not expose the connection directly.