Join the DZone community and get the full member experience.
RazorSQL - Query, Edit, Browse, and Manage Databases. RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, macOS, Mac OS X, Linux, and Solaris. RazorSQL has been tested on over 40 databases, can connect to databases via either JDBC or ODBC, and includes support for the following databases. JDoodle is a free Online Compiler, Editor, IDE for Java, C, C, PHP, Perl, Python, Ruby and many more. You can run your programs on the fly online and you can save and share them with others. Quick and Easy way to compile and run programs online. The SQL editor is a graphical Java program that allows you to connect to JDBC compliant databases. Some new enhancements for its latest release include using RText as the default editor instead of the classic Netbeans editor, a new plugin for the Netezza database.
The mssql extension enables mssql commands and T-SQL IntelliSense in the code editor when the language mode is set to SQL. Select File New File or press Ctrl+N. Visual Studio Code opens a new Plain Text file by default. Select Plain Text on the lower status bar, or press Ctrl+K M, and select SQL from the languages dropdown.
Join For FreeThis is an update to Two very useful open source SQL editors. A year later and I have added one more SQL editor to my first list. I keep this post updated to give context to lists of Open Source SQL front ends such as this one Open Source SQL Clients in Java and SQuirreL SQL Alternatives. I constantly try Open Source SQL front-ends and this post includes the ones I think you should seriously consider.
Working in Business Intelligence (BI), I write and execute SQL statements every day. Actually it is more like every other minute. The SQL tool I use is very important to me. Over the years I have mainly stuck to SQuirreL SQL Client and wandered off every once in a while to try out different tools. One thing is for sure, no one tool will have everything you need. At some point you have to make a choice based on the features most important to you.
Different database vendors will most likely have their own front-end specifically developed for their database. Oracle has SQL Developer and Sybase has Interactive SQL and so on. I would recommend any budding BI practitioner to probably start with the tool supplied by the database vendor. You are not likely to have compatibility and connectivity issues allowing you to get productive much quicker.
If you use more than one database at a time and want to use the same an Open Source SQL front-end I would recommend one of the following:
Don’t be fooled by the dated screen shots on the web pages, these tools look better than that. They are incredibly feature filled tools that with some learning will meet you SQL development needs. Each tool needs a series of blog posts to do justice to the available features. Here are some features technical and not technical that they have in common that have led me to recommend these tools.
Non-Technical Reasons
- Open Source Software, all three are free for commercial use. The source code is available for those with the necessary skills to debug or contribute features.
- All under active development with regular builds being released. Probably about a build (new version) a month. I use the latest testing builds and don’t stick to the stable versions. For the faint at heart stick to the stable release versions.
- Active forums, community members and primary developers, to some degree answer some questions posed on the forums or mailing list.
- Cross platform, all applications run on different platforms ,Windows, Linux and Mac, due to the fact that are written in Java.
Technical Reasons
- JDBC used for database connectivity, which means that 99.9999% of the time you will be able to connect to any database. Most databases provide a JDBC driver.
- Data explorer component from all products are quite customisable. It is possible to customise the schema’s that display, customise the SQL statements generated such as the INSERT, UPDATE or DDL statements created.
- Data import and export wizards for data in various formats including CSV, Microsoft Excel formats XLS and XLSX.
- All the tools keep SQL history. You can customise how many statements are kept in history.
I would urge you to take a serious look at these two tools because you will not get much better generic Open Source SQL tools. I have not included HeidiSQL because it is MySQL specific and runs on Windows only. It is a fantastic tool when you are only using MySQL. TOra is another great tool that I found only works well with Oracle. Invisible 2 3 – easily hide your personal files file.
![Sql Editor 3 6 2012 Sql Editor 3 6 2012](https://s33046.pcdn.co/wp-content/uploads/2020/01/query-results-to-text.png)
Am I missing a great Open Source SQL front end out there? I would like to hear from you.
sql,open source,sql editor
Published at DZone with permission of Mpumelelo Msimanga, DZone MVB. See the original article here.
Sql Editor 3 6 2012 Download
Opinions expressed by DZone contributors are their own.
MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X. Receipts 1 9 72.
MySQL Workbench Home
View Screenshot:
Windows, Linux, OS X
Visual Database Design
View Screenshot:
Windows, Linux, OS X
Performance Dashboard
View Screenshot:
Windows, Linux, OS X
Design
MySQL Workbench enables a DBA, developer, or data architect to visually design, model, generate, and manage databases. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort.
Learn More »
Learn More »
Develop
MySQL Workbench delivers visual tools for creating, executing, and optimizing SQL queries. The SQL Editor provides color syntax highlighting, auto-complete, reuse of SQL snippets, and execution history of SQL. The Database Connections Panel enables developers to easily manage standard database connections, including MySQL Fabric. The Object Browser provides instant access to database schema and objects.
Learn more »
Learn more »
Administer
Paint code 3 4 56. MySQL Workbench provides a visual console to easily administer MySQL environments and gain better visibility into databases. Developers and DBAs can use the visual tools for configuring servers, administering users, performing backup and recovery, inspecting audit data, and viewing database health.
Learn more »
Learn more »
Sql Editor 3 6 2012 Full
Visual Performance Dashboard
MySQL Workbench provides a suite of tools to improve the performance of MySQL applications. DBAs can quickly view key performance indicators using the Performance Dashboard. Performance Reports provide easy identification and access to IO hotspots, high cost SQL statements, and more. Plus, with 1 click, developers can see where to optimize their query with the improved and easy to use Visual Explain Plan.
Learn More »
Learn More »
Database Migration
Sql Editor 3 6 2012 Review
MySQL Workbench now provides a complete, easy to use solution for migrating Microsoft SQL Server, Microsoft Access, Sybase ASE, PostreSQL, and other RDBMS tables, objects and data to MySQL. Developers and DBAs can quickly and easily convert existing applications to run on MySQL both on Windows and other platforms. Migration also supports migrating from earlier versions of MySQL to the latest releases.
Learn more »
Learn more »