GNU Emacs is described as a free extensible and customizable text editor for the Lisp programming language.
N/A
Microsoft Visual Studio Code
Score 9.3 out of 10
N/A
Microsoft offers Visual Studio Code, an open source text editor that supports code editing, debugging, IntelliSense syntax highlighting, and other features.
$0
Redgate SQL Toolbelt Essentials
Score 9.5 out of 10
N/A
Redgate's SQL Toolbelt Essentials includes industry-standard tools for SQL Server development & deployment, enabling users to include SQL Server databases in agile processes and enabilng developers to embed robust and scalable development practices.
$1,209
per year per user (1-4 users)
Pricing
GNU Emacs
Microsoft Visual Studio Code
Redgate SQL Toolbelt Essentials
Editions & Modules
No answers on this topic
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
GNU Emacs
Microsoft Visual Studio Code
Redgate SQL Toolbelt Essentials
Free Trial
No
No
Yes
Free/Freemium Version
No
Yes
No
Premium Consulting/Integration Services
No
No
No
Entry-level Setup Fee
No setup fee
No setup fee
No setup fee
Additional Details
—
—
—
More Pricing Information
Community Pulse
GNU Emacs
Microsoft Visual Studio Code
Redgate SQL Toolbelt Essentials
Considered Multiple Products
GNU Emacs
Verified User
Engineer
Chose GNU Emacs
Of course, Vim is a good contender for comparison as well, so I'll include it. I find Emacs much easier to learn, which will help speed up productivity for newer users. It seems much faster than VIM and VSCode, especially under load. It's highly highly customizable, in ways …
When you start using [Microsoft Visual Studio Code], it lands more on the "text editor" side of the spectrum, akin to Vim/Emacs/Sublime. Aligned with this, it's fast and easy to install and setup, and competes with the best of them as a great general purpose tool. But then it …
As I explained above, definitely switch to VSCode unless you are heavily invested/comfortable with the alternatives, in which case it may not be worth it for now. Vim users may differ, but did I mention VSCode also has a highly integrated and mature Vim plugin? I used to be a Vi…
Visual Studio Code offers a better one-stop-shopping experience if you are multi-lingual. There are plugins for just about every language imaginable making it great if you want one experience in every language you write code in. You don't get that with WebStorm or even with the …
Emacs is best utilized on a Unix system where it can be easily installed and accessed. It allows for quick editing of files on a system whether you are accessing it locally through the console or remotely via an ssh connection. Once users familiarize themselves with the Emacs shortcuts, it becomes a pretty efficient text manipulation program. On a standard Windows computer, it is less likely to use Emacs for code editing, especially if you have a local repository on your host machine.
As a general workhorse IDE, Microsoft Visual Studio Codee is unmatched. Building on the early success of applications such as Atom, it has long been the standard for electron based IDEs. It can be outshone using IDEs that are dedicated to particular platforms, such as Microsoft Visual Studio Code for .net and the Jetbrains IDEs for Java, Python and others. For remote collaborative development, something like Zed is ahead of VSCode live share, which can be quite flakey.
We use SQL Compare to troubleshoot performance problems quite a bit since our data model is more like a template and not everything is 100% in sync and customization occurs between different client databases. We continually get pulled into performance issues and the developers will say Client A is performing different than Client B, why? Using SQL Compare, we usually find that one client was tuned and had indexes altered or added that weren't deployed to all clients or other objects weren't deployed correctly during the release. On the other hand, since our data model practices allow client databases to drift I tried to create a new golden image by trying to compare multiple databases based on the same data model and found it to be a very difficult process to complete using SQL Compare. SQL Compare gave me too much information and doesn't allow enough filtering to eliminate a lot of the noise.
GNU Emacs is a text editor that can do almost anything that you want to do with it. It is fairly easy to extend the functionality using Emacs Lisp with a large library available.
It can be easily customized using themes as well as custom code to change the look and feel as well as how everything works.
Simple and easy comparison of database schemas and data. Differences can be copied or synced from one database to another with a click of a button.
You can save "projects" so that you can easily rerun a previous comparison whenever you need to.
It has a very simple, easy to learn interface. I've never needed to read any documentation or watch any tutorials in order to figure out how to do something.
Emacs is old, so it's a little crufty and not too easy to pick up and start using. There is a community package called Spacemacs that simplifies a lot of things that you do with Emacs. It is probably better suited to beginners.
Sometimes, the choices that were made to integrate certain functionality change the basic models for that functionality. This is seen primarily in the version control system support, where multiple version control systems are supported and "unified" to a standard Emacs-y way of doing things. This can be confusing to the new user not familiar with the Emacs way.
Emacs has, as its foundation, a lisp interpreter. This means that the extension language for Emacs is emacs-lisp. Some people find lisp hard to understand and have difficulties writing Emacs extension code, or understanding existing code.
The customization of key combinations should be more accessible and easier to change
The auxiliary panels could be minimized or as floating tabs which are displayed when you click on them
A monitoring panel of resources used by Microsoft Visual Studio Code or plugins and extensions would help a lot to be able to detect any malfunction of these
Pricing.... I wish there was an inexpensive developer version I could buy for myself.
Portability.... I would like to use it from a flash drive so I can use it where ever I am asked to work.
Unbundled.... This may be available already but I dont' recall I can buy it cheaply as a stand-alone product. Its only part of the bundle - cost effectively.
Solid tool that provides everything you need to develop most types of applications. The only reason not a 10 is that if you are doing large distributed teams on Enterprise level, Professional does provide more tools to support that and would be worth the cost.
Microsoft Visual Studio Code earns a 10 for its exceptional balance of power and simplicity. Its intuitive interface, robust extension ecosystem, and integrated terminal streamline development. With seamless Git integration and highly customizable settings, it adapts perfectly to any workflow, making complex coding tasks feel effortless for beginners and experts alike.
Overall, Microsoft Visual Studio Code is pretty reliable. Every so often, though, the app will experience an unexplained crash. Since it is a stand-alone app, connectivity or service issues don't occur in my experience. Restarting the app seems to always get around the problem, but I do make sure to save and backup current work.
Microsoft Visual Studio Code is pretty snappy in performance terms. It launches quickly, and tasks are performed quickly. I don't have a lot of integrations other than CoPilot, but I suspect that if the integration partner is provisioned appropriately that any performance impact would be pretty minimal. It doesn't have a lot of bells and whistles (unless you start adding plugins left and right).
Everything that you need to know about Emacs can be found on the internet. There are many Emacs "cheat sheets" that list out all of the shortcuts for Emacs. There are videos on how to use Emacs. Emacs is easily installed using the standard Linux package managers and can also be easily updated through them as well. There are tutorials on how to customize Emacs to your liking.
Active development means filing a bug on the GitHub repo typically gets you a response within 4 days. There are plugins for almost everything you need, whether it be linting, Vim emulation, even language servers (which I use to code in Scala). There is well-maintained official documentation. The only thing missing is forums. The closest thing is GitHub issues, which typically has the answers but is hard to sift through -- there are currently 78k issues.
Of course, Vim is a good contender for comparison as well, so I'll include it. I find Emacs much easier to learn, which will help speed up productivity for newer users. It seems much faster than VIM and VSCode, especially under load. It's highly highly customizable, in ways other editors don't stack up against. Its lack of bloat also is a nice addition to a great product.
Visual Studio Code stacks up nicely against Visual Studio because of the price and because it can be installed without admin rights. We don't exclusively use Visual Studio Code, but rather use Visual Studio and Visual Studio code depending on the project and which version of source control the given project is wired up to.
I've used Visual Studio Database Projects for this type of work in the past with some success, but Redgate SQL Compare is faster, more transparent, and simply easier to use. Faster is self explanatory. More transparent, means that it's much easier to set up your desired options for schema change deployment scripts. Easier to use, It's really dead simple. Start a project, connect your source, connect destination, click compare.
It is easily deployed with our Jamf Pro instance. There is actually very little setup involved in getting the app deployed, and it is fairly well self-contained and does not deploy a large amount of associated files. However, it is not particularly conducive to large project, multi-developer/department projects that involve some form of central integration.
