A new IDE for writing SQL is being developed by Jet Brains that may take over a lot of the existing tools. It is currently in a restricted Early Access Program of which I have not yet been accepted. I’m simply reporting based on the features they publish on their website. The new tool is called 0xDBE.
0xDBE is built on top of the Jet Brains IntelliJ platform which has been used for a number of IDE tools such as the Jet Brains Idea which is a very popular tool for writing Android apps amongst many other things.
Picture the capabilities we have come to admire in tools such as ReSharper integrated with SQL Syntax and their powerful IDE and you begin to see the possibilities for 0xDBE.
In the features and screenshots on their web site they are working on features such as:
- Code Completion based on context and schema
- Search and Replace in existing data sources or SQL files
- Code Analysis and quick fixes for things such as using reserved words as objects
- Powerful Editor
- Code Formatting (something I really enjoy in Visual Studio that will be great in SQL)
- Table Editor for managing table contents
- Navigation to code (much like you have come to know as Find Usages, etc. in Visual Studio)
- Schema Management
- Integration with Version Control
A final feature about this product that is very useful is that it is not tied to a specific database. Much like other products such as TOAD it can connect to many different vendor specific SQL engines.
You can find out more at http://www.jetbrains.com/dbe. Check it out and share what you think?
Cheers,
Ben