Episode 101 – Devart DbForge Studio

List on dbForge Products
( I will try to be comprehensive )

Paid Products

SQL Server Database Tools

  • dbForge Studio for SQL Server
  • dbForge SQL Complete
  • dbForge Index Manager for SQL Server
  • dbForge Data Pump for SQL Server
  • dbForge Fusion for SQL Server
  • dbForge Data Generator for SQL Server
  • dbForge Transaction Log
  • dbForge Documenter for SQL Server
  • dbForge Source Control for SQL Server
  • dbForge SQL Tools
  • dbForge Compare Bundle for SQL Server
  • dbForge Query Builder for SQL Server
  • dbForge Data Compare for SQL Server
  • dbForge Schema Compare for SQL Server

MySQL Database Tools

  • dbForge Data Compare for MySQL
  • dbForge Fusion for MySQL
  • dbForge Documenter for MySQL
  • dbForge Studio for MySQL
  • dbForge Compare Bundle for MySQL
  • dbForge Query Builder for MySQL
  • dbForge Data Generator for MySQL
  • dbForge Schema Compare for MySQL

ORACLE Database Tools

  • dbForge Compare Bundle for Oracle
  • dbForge Studio for Oracle
  • dbForge Data Generator for Oracle
  • dbForge Schema Compare for Oracle
  • dbForge Documenter for Oracle
  • dbForge Fusion for Oracle
  • dbForge Data Compare for Oracle

POSTGRESQL Database Tools

  • dbForge Data Compare for PostgreSQL
  • dbForge Studio for PostgreSQL

ADO.NET Providers

  • dotConnect for Oracle
  • dotConnect for Zoho CRM
  • dotConnect for SugarCRM
  • dotConnect for Magento
  • dotConnect for QuickBooks
  • dotConnect for Dynamics CRM
  • dotConnect for BigCommerce
  • dotConnect for MailChimp
  • dotConnect for Salesforce Marketing Cloud
  • dotConnect for SQLite
  • dotConnect for Salesforce
  • dotConnect for SQL Server
  • dotConnect for DB2
  • dotConnect for PostgreSQL
  • dotConnect for MySQL
  • dotConnect Universal

Delphi Data Access Components

  • EntityDAC
  • Universal Data Access Components
  • PostgreSQL Data Access Components
  • Oracle Data Access Components
  • SQL Server Data Access Components
  • MySQL Data Access Components
  • Virtual Data Access Components
  • SQLite Data Access Components
  • InterBase Data Access Components
  • SecureBridge

EXCEL Add-Ins

  • Excel Add-in for NetSuite
  • Excel Add-in for Mailchimp
  • Excel Add-in for QuickBooks
  • Excel Add-in for BigCommerce
  • Excel Add-in for Magento
  • Excel Add-in for SQL Server
  • Excel Add-in for SQLite
  • Excel Add-in for HubSpot
  • Excel Add-in Database Pack
  • Excel Add-in for Zendesk
  • Excel Add-in Cloud Pack
  • Excel Add-in Universal Pack
  • Excel Add-in for Salesforce Marketing Cloud
  • Excel Add-in for Freshdesk
  • Excel Add-in for SugarCRM
  • Excel Add-in for Oracle
  • Excel Add-in for Dynamics CRM
  • Excel Add-in for PostgreSQL
  • Excel Add-in for Zoho CRM
  • Excel Add-in for MySQL
  • Excel Add-in for Shopify
  • Excel Add-in for Salesforce

SSIS Data Flow Components

  • SSIS Integration Database Bundle
  • SSIS Integration Universal Bundle
  • SSIS Data Flow Components for PostgreSQL
  • SSIS Data Flow Components for MySQL
  • SSIS Data Flow Components for Google BigQuery
  • SSIS Data Flow Components for Salesforce
  • SSIS Data Flow Components for MailChimp
  • SSIS Data Flow Components for Amazon Redshift
  • SSIS Data Flow Components for Stripe
  • SSIS Data Flow Components for Freshdesk
  • SSIS Data Flow Components for Freshdesk
  • SSIS Data Flow Components for Zoho Desk
  • SSIS Data Flow Components for Zoho Invoice
  • SSIS Data Flow Components for Zoho Inventory
  • SSIS Data Flow Components for Shopify
  • SSIS Data Flow Components for Zoho Books
  • SSIS Data Flow Components for Streak
  • SSIS Data Flow Components for Pipedrive
  • SSIS Data Flow Components for Insightly CRM
  • SSIS Data Flow Components for HubSpot
  • SSIS Data Flow Components for Freshworks CRM
  • SSIS Data Flow Components for Snowflake
  • SSIS Data Flow Components for NetSuite
  • SSIS Data Flow Components for ActiveCampaign
  • SSIS Data Flow Components for Oracle
  • SSIS Integration Cloud Bundle
  • SSIS Data Flow Components for QuickBooks
  • SSIS Data Flow Components for Zoho CRM
  • SSIS Data Flow Components for Dynamics CRM
  • SSIS Data Flow Components for Magento
  • SSIS Data Flow Components for SugarCRM
  • SSIS Data Flow Components for Salesforce Marketing Cloud
  • SSIS Data Flow Components for DB2
  • SSIS Data Flow Components for Twitter Ads
  • SSIS Data Flow Components for Google Analytics
  • SSIS Data Flow Components for Google Ads
  • SSIS Data Flow Components for Zoho People
  • SSIS Data Flow Components for WordPress
  • SSIS Data Flow Components for Podio
  • SSIS Data Flow Components for Jira
  • SSIS Data Flow Components for Asana
  • SSIS Data Flow Components for ShipStation
  • SSIS Data Flow Components for DEAR Inventory
  • SSIS Data Flow Components for Slack
  • SSIS Data Flow Components for SurveyMonkey
  • SSIS Data Flow Components for SendPulse
  • SSIS Data Flow Components for EmailOctopus

ODBC Drivers

  • ODBC Driver for MailChimp
  • ODBC Driver for HubSpot
  • ODBC Driver for Amazon Redshift
  • ODBC Driver for Salesforce
  • ODBC Driver for Oracle
  • ODBC Driver for Dynamics CRM
  • ODBC Driver for xBase
  • ODBC Driver for Zoho CRM
  • ODBC Driver for Dynamics 365
  • ODBC Driver for SQL Server
  • ODBC Driver for NexusDB
  • ODBC Driver for MongoDB
  • ODBC Driver for Salesforce Marketing Cloud
  • ODBC Driver for PostgreSQL
  • ODBC Driver for MySQL
  • ODBC Driver for SQLite
  • ODBC Driver for SQL Azure
  • ODBC Driver for BigCommerce
  • ODBC Driver for Magento
  • ODBC Driver for SugarCRM
  • ODBC Driver for FreshBooks
  • ODBC Driver for QuickBooks
  • ODBC Driver for InterBase
  • ODBC Driver for Firebird
  • ODBC Driver for NetSuite
  • ODBC Driver for Google BigQuery
  • ODBC Driver for ASE
DB-Express Drivers
  • dbExpress Driver for SQLite
  • dbExpress Driver for Oracle
  • dbExpress Driver for MySQL
  • dbExpress Driver for PostgreSQL
  • dbExpress Driver for InterBase
  • dbExpress Driver for SQL Server
Productivity tools
  • Code Review Bundle
  • Code Compare
  • Review Assistant
  • Entity Developer


Free Products / Tools

  • dbForge Studio for SQL Server Express / MySQL Express / Oracle Express / PostgreSQL Express ** Free Edition **
  • dbForge DevOps Automation for SQL Server
  • dbForge Schema Compare for PostgreSQL
  • dbForge SQL Complete Express / SQL Decryptor
  • dbForge Event Profiler for SQL Server
  • dbForge Search / Monitor
  • SQL Formatter for SQL Server
  • Excel Add-ins (some)
  • ADO.NET Data Providers (some)
  • Delphi Data Access Components (some)
  • Other Products ( Code Compare, Review Assistant, T4 Editor, dbMonitor)

===========================================================

PROLOGUE

Honestly it is overwhelming. I mean a lot of products. Maybe its just broken into smaller chunks to create more individual items to be able to sell maybe it is necessary to have this many products this specifically packaged.

Sure I would not want to be on their sales department cause just to learn all the different products they sell and develop let alone the bundles and the way you can combine them together its a huge undertaking in my opinion so kudos for their sales department I am sure it is not an easy job.

Apart from the amount of tools and products once you overcome this generic shock the sheer amount of the different items cause once the dust settle you probably can figure out your way how to navigate through their different product offerings and categories.

I would split in my mind as below but feel free to disagree or do it a better way which suits You.

Tools for Developers like ODBC Drivers, DBExpress Drivers, SSIS Data Flow Components, Delphi and ADO.NET providers so they can program the desired applications or user interfaces to join the pieces together for the End Users.(( I would call them Data Visualizers later it makes sense )) They make the Database Engines / Servers and the Custom Applications or Web Apps on the users computer work in a seamless and easy to use manner without the need for them to know a line of code or get into configuring different pieces to work together to achieve the desired results.
(( need to know programming and not necessarily need to know data ))

Tools for Data Scientists like the Studio products and Database Tools (Compare, Schema, Data Generators, Query Tools) so they can work and mold the data inside the databases ( not necessarily working with special applications and for example websites built by the developers but working with the data on the Database Engine directly)
(( need to know data but not programming 🙂 )

Tools for Data Analysts whom are in my opinion one step above a generic End User whom might be using the Custom Applications or Web Apps developed by the Developers but perhaps not doing that much in depth analytics or deep dive into the data and its meaning or trends than Data Analysts. I might be mistaken tough … Its just my intuition . With the Excel-Add-Ins They are the end users who are neither programmers (developers) nor Data Scientists working with the Data directly on the Database Severs but they make sense and meaning out of the data from the databases via Excel and these Excel Add-Ins or perhaps PowerBI to present it in a Visually Pleasing and Humanly Understandable Manner while they are obviosuly more tech savvy then a generic end user who perhaps open a report from PowerBI or Excel to look at some data already present there but not actually getting into analyzing it or digging deep and customize it any further that is why I referred to them as Data Visualizers above kind of like they are using it with a R/O access the data available to them while the Data Analysts I see more someone with a Limited – R/W access and with a much broader toolset to achieve his/her goal.

Today I want to talk about some of Devart’s paid products

They just had big Black Friday and Cyber Monday sales / deals with up to 50% off on certain products.

A New Year Sale is coming up

If you were unable to pick anything up or missed it completely you can use the below coupon code to get 10% discount for Studio and SQL Tools

Coupon code:

10TSTPODCAST
(( thats TSRPODCAST spelled wrong 🙂 ))

Two key reasons why choose dbForge products ahead of the competition:

  • Perpetual Licenses
    No Subscription here.. You buy it once and You use it / own it
  • Discount Programs
    Can save money participating in many Devart Discount Programs

dbForge Studio for MySQL

dbForge Studio for MySQL is a powerful GUI tool for MySQL and MariaDB for database administration, management, and development.

It is a full-fledged IDE that helps create and execute queries, develop and debug stored routines, automate database object management, compare and synchronize databases, analyze table data, and much more. Its rich functionality is delivered under an intuitive interface.

It is the perfect tool to transition to from MySQL Workbench for those who are looking for a broader set of features and increased performance.

It contains everything you need to work with MySQL databases more effectively.

Let me talk about some of its features. For a complete and exhaustive list of features and information please visit:
https://www.devart.com/dbforge/mysql/studio/features.html

Compare the different Editions:
https://www.devart.com/dbforge/mysql/studio/editions.html

Database Development

Code Snippets and Code Formatting are the most precious features of the dbForge Studio for MySQL tool.

  • Extensive code snippets library
  • Ample formatting options
  • Formatting profiles to suit any taste
  • Formatting code from the Command Line

https://i0.wp.com/devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/code-completion.png?w=840&ssl=1
MySQL Code Completion
https://devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/code-completion.png
MySQL Code Snippets

Snippets are small reusable chunks of code that can be easily inserted in scripts when needed.

The Code Snippets functionality facilitates entering repetitive code patterns and thus saves substantial time and effort. You can use the pre-defined snippets supplied with dbForge Studio for MySQL, or create your own. The use of snippets puts you in the driver’s seat – you code faster and make fewer typos. Handy MySQL Snippets Manager
Studio’s Snippets Manager allows adding new snippets and deleting or modifying the existing ones. In the Manager, you can add and modify snippet shortcuts, literals, and the snippet text itself.

MySQL code snippets manager
Snippets Manager https://devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/snippets-manager.png

Database Compare and Sync

When modifying MySQL database structure, transferring data between servers, analyzing differences between databases, you will:

Database Compare and Sync
https://www.devart.com/dbforge/mysql/studio/images/schema-compare.png

Import/Export Data

Fill MySQL databases with external data using our export and import tools. They support more than 10 popular data formats and allow customizing the whole process. Templates, automating data import and data export tasks through command line are also available.

Copy Database

Transfer MySQL Server databases from one server instance to another with a handy Copy Databases tool. The tool allows you to:

  • Customize copying settings
  • Copy databases together with data
  • Drop a database if it already exists on a target server

Database Designer
Database Diagram
https://devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/database-diagram.png

Use database diagram for creating, analyzing, reverse-engineering, printing and customizing your MySQL databases and for:

  • Viewing foreign key relations
  • Displaying DB objects with properties
  • Execution of stored routines
Visual Query Builder


Visual query creation with diagram and expression editor. Queries of any complexity can be created in several seconds. The GUI tool automatically adds joins between tables and allows working with INSERT, UPDATE, DELETE statements.

Visual Query Builder
https://devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/query-builder.png
Data Generator


Populate your MySQL tables with thousands of rows of realistic test data. Data Generator supports all MySQL data types, includes a large number of meaningful generators with customizable settings, and allows generating data via the command-line interface.

Sophisticated MySQL Formatter

Level-up your scripting abilities with the advanced formatting tool that allows beautifying your code to get it exactly as you like it. The tool is highly customizable and MySQL formatting behavior can be easily configured to fit even the most demanding needs.

Let dbForge Studio for MySQL take care of formatting your queries and spend the freed up time on what really matters – making your code work flawlessly. MySQL Formatter Wizard allows formatting SQL code in multiple files or even folders in the wink of an eye. With the bulk formatting option, you can quickly and easily enforce common coding standards within a team or organization.

MySQL beautifier - formatting options
MySQL Formatter
https://devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/mysql-formatter.png
Built-in formatting profiles

dbForge Studio for MySQL boasts the ability to add new and customize the existing formatting profiles. The default profile can be easily modified up to your needs. On top of that, you can create any number of your own profiles that would comply with the required formatting standards.

Switch between profiles in one click
With this option, you can work in the style you prefer and then easily switch to your team profile when you are ready to deliver. Hundreds of users report the MySQL formatting functionality to be irreplaceable in their everyday work.

MySQL beautifier - formatting profiles
Built-in formatting profiles
https://devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/formatting-profile.png

MySQL Debugger
MySQL Debugger
https://devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/sql-debugger.png


The first debugger for MySQL offers step-by-step code execution, breakpoints, watches, a call stack, a variables evaluation mechanism to automate debugging of MySQL stored routines and triggers, and keeps MySQL server’s logic during the execution of the stored procedure.

Database Administration

Tools for MySQL database administration and management include means for:

  • Managing user privileges
  • MySQL service control
  • Managing server variables
  • Table maintenance
  • Managing server sessions

Database Projects

The Database Project is a collection of SQL scripts and query files which allows you to logically organize them in one place and in an offline mode. With this technology you can compare a database project with a database, by receiving a synchronized script, and deploy database changes.

Table Designer

Visual Designer
https://devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/table-designer.png

Visual designer for modifying or creating table structure, indexes, primary keys, defaults, and CHECK constraints. Get full control over the changes you have made. The heuristics feature will suggest a column type on creating a column based on the name you enter.

Documenter

A tool for generation of MySQL and MariaDB database documentation. Documenter allows you to:

  • Retrieve an overview of the database structure
  • View inter-object and inter-database dependencies
  • Customize documentation with style templates
  • Generate documentation files in the HTML, PDF and Markdown formats
Formatting from
the Command Line

dbForge Studio for MySQL supports a command-line interface thus allowing you to quickly and easily automate and schedule your formatting tasks.

This option lets you automatically format multiple MySQL scripts as a pre-commit hook or as a Continuous Integration (CI) step, which can significantly simplify time-wasting and laborious DevOps operations.

MySQL Formatting from the Command Line
Formatting from the Command Line
https://devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/format-from-cml.png
Intelligent SQL Coding

Intelligent code completion, formatting, MySQL prompt, and code snippets bring convenience and effectiveness to your SQL code writing. Code navigation, obtaining quick object information, and syntax check are performed instantly.

Working on a Test MySQL Database
Random Data inside the Table

Data Generator for MySQL

Generating Meaningful Random Data for the Tables in the Database


I mention Data Generator cause for me it is as useful as any other tool in devart’s products to be able to fill my test tables and databases with meaningful real-life like data to able to test and fine tune a design before it even considered to be discussed as a candidate for a production environment.

Database tools
(SQL tools, mysql tools, oracle tools, postgresql tools)

SQL Tools product from devart when looking at the comparison at devart’s website there are only a few differences here and there what one tool can or can not do compared to the other ( Database Tools Vs Studio products). When I tried to sum the differences up in a clear manner in a couple of words I could not do it so I suggest you check it out for yourself to see which one has or does not have the given function you require.

While in the case of SQL Tools there is an option as much as I can see to get the 15 tools together as SQL Tools Vs the individual items ( such as Query Builder or Schema Compare) there is no Tools’ set grouping the individual items of the same for the other Database Engines ( MySQL, Oracle, PostgreSQL) unfortunately.

Probably it is because of SQL being more popular than the other platforms or engines?

I think it could be nice to buy like in the case of SQL Tools to have all the tools in one package for a discounted price instead of the need to purchase them piece by piece ( Data Generator, Data Compare , Schema Compare, Query Builder, Documenter , Fusion) except the occasional mini bundles of 2-3 items of the tools here and there for Oracle and PostgreSQL and MySQL tools as well.

I feel there is a fine line and certain overlap in features and possibilities between these two product families.

https://www.devart.com/dbforge/mysql/

For many the individual tools or in case of SQL Tools ( the set of tools) are enough for their need/s but for Database Development I think the Studio tools are the best suited as they offer most probably everything you might need.

Closing thoughts

I think if you work or study anything related with Databases these tools can be very useful for you to get things done quicker and in a more efficient manner from a leading developers of database management software, ALM solutions and data providers for most popular database servers.

I wish their apps or at least the main Studio ones were available for Linux as well. It would be a great alternative to Jetbrains Datagrip and Navicat Premium 16 both of which run under Linux and one of the only applications which does close to what devart’s Studio does.

Links

Free SQL Courses


https://www.freecodecamp.org/news/learn-sql-free-relational-database-courses-for-beginners/

  1. Relational Database Curriculum (freeCodeCamp)
  2. SQL Tutorial – Full Database Course for Beginners (freeCodeCamp)
  3. Learn SQL In 60 Minutes (Web Dev Simplified)
  4. SQL For Beginners Tutorial (Amigoscode)
  5. MySQL Database – Full Course (freeCodeCamp)
  6. MySQL Tutorial for Beginners – Full Course (Programming with Mosh)
  7. MySQL Crash Course | Learn SQL (Traversy Media)
  8. SQL for Data Science (UC Davis)

Episode 100 – UltraEdit

An Idera Inc Company

Idera Inc. brands deliver the B2B software tools that technical users trust most. From database administration to application development to test management, our solutions help you do more for less so you can achieve your strategic goals.

Idera Inc. holds many brands including UltraEdit of which I will talk today in more detail.

Full List of Brands:
https://www.ideracorp.com/brands

Idera – Powerful Database Management
Wherescape – Data Warehouse and Infrastructure Automation
Aquafold – Cross Platform Database Solution
Embarcadero – RAD Studio, Delphi, C++ Builder , Interbase
Testrail – Web Based Test Case Management Solution
Sencha – Web Application Development Platform ( Javascript Framework)

UltraEdit – Text Editing Tools

UltraEdit is a market-leading suite of text editing tools for Windows, Mac and LINUX users. UltraEdit is renowned for its configurability and easy-to-use products, including UltraEdit, UEStudio, UltraCompare, UltraFinder and UltraFTP. The many hundreds of product features across UltraEdit’s suite of tools help a wide spectrum of users increase their productivity and make their daily tasks easier.

The Products FROM ultraedit

UltraEdit (Windows, Mac, Linux)
The World #1 Text Editor

UltraCompare (Windows, Mac, Linux)
Text, File and Folder Compare

UEStudio (Windows Only)
UltraEdit with Git integration and added functions

UltraFinder (Windows Only)
Powerful File and Folder Search

UltraFTP (Windows Only)
Powerful FTP Client

UE/UC Mobile Versions (Portable) (Windows Only)
Portable/USB versions of UltraEdit and UltraCompare products

CloudSync and Pieces for UltraEdit (beta) (Windows Only)
Sync Settings and Customizations across your machines
Manage Your Code Snippets

Prologue

My favourite feature with the IDM Tool’s is as always the fact that at least the two main products are fully cross-platform UltraEdit and UltraCompare

They have versions for Windows , Mac and Linux and also Portable/USB versions (Windows Only).

For now the other three products in their offering UEStudio and Ultrafinder and UltraFTP are Windows only applications. I had some success however under Crossover v21 under Mac OS X and under Wine in Fedora 34 with these products.
I definitely hope for the future that as those tools mature along the way they become cross platform as well or at least running as smooth as possible under the wine emulation layer ( Wine under Linux which is the underlying technology for the commercial application CrossOver for Mac as well )

Why there is no Free version of Ultraedit Products such as UltraEdit or UltraCompare or the others? Is it open or closed source software?

First the elephant in the room. UltraEdit’s products are closed source products. While I myself a big advocate of Open Source software I do understand the need of having intellectual property such as a great text editors source code such as UltraEdit to be closed sourced.

Honestly. In the world of text editors and additional tools like Diff/Compare applications you simply can not make a living only from offering paid support for a tool which is rock solid and never breaks down. Enterprises love signing and paying for support for mission critical applications such as Operating Systems ( Red Hat Linux or Windows Server or HyperVisors such as VMWare) or Infrastructure Monitoring tools like Zabbix or Grafana or NagiosLS but I have never heard of them paying for support for their text editors in case it breaks down.

Combine this with the fact that if UltraEdit’s tools were open sourced for example on Git and being the solid they are never breaks what would make you stop of compiling those tools for yourself and just rock on?

But then what would make money for companies like IDM or others to keep being able to offer you great cross platform products if everyone compiled it for themselves or used the Free Edition? Would they still being able to afford to pay the developers who work bringing new features and rock solid stability to these applications you all love? Probably they would need to include annoying ads or telemetry or other ways to make money of their users data and turning it into hard cash they can use to keep the boat floating. Personally I prefer to pay a competitive but fair price for the application/s I love and use to make sure they are still with me tomorrow.

None of the above their products have.
No Ads, No Telemetry, Not Selling of their users data.


For UltraEdit to be able to expect its developers to bring quality and commitment to the table they have to be fed which is in the 20th and 21st century is made with a salary. The better the developer/s the more they cost. A lot more. Based on the tools such as UltraEdit or UltraCompare their developers are anything but cheap labour.


Also they have no free, limited set of features version of their apps. They do have trial versions for you to try out and see it for yourself and a 100% money back guarantee. Thats how sure they are about their product/s.

For me the benefit outweighs the cost literally. I prefer a tool which is closed source and a paid application being able to constantly bring out bug fixes, new features and push the limits further Vs an application which is open source and perhaps the developer/s abandon it in the middle of version 0.9 beta because of the lack of funds or time / commitment they can spare anymore for a project which bares no fruit.

Money on the table means commitment and expectations for both the company who develops the product and also towards the customers.

UltraEdit is doing it based on this closed source paid model in the lat 25 years and it looks like it works.Their main products matured over time and constantly adding new features while polishing bugs and imperfections here and there.

UltraEdit

most flexible, powerful, and secure text editor out there and it is cross platform and I love it.

Power Tips for UltraEdit for Linux
https://www.ultraedit.com/support/tutorials-power-tips/ultraedit-linux/

Screenshot of UltraEdit on Linux / Ubuntu
The world’s best text editor is better than ever on Linux. The UltraEdit text editor for linux is ideal for C/C++, HTML, Javascript, XML, PHP, Python, and Java programmers… beginners, power users, and everyone in between.


Available as DEB , RPM or generic TAR

UltraCompare Pro comes free with your UltraEdit purchase
Together, UltraEdit and UltraCompare give you the ideal text and source code editor as well as the ability to effortlessly manage your changes, visually inspect your differences, and exercise quick and easy merge operations. It’s the only integrated editing/comparison solution of its kind.

UltraEdit does have its learning curve. It can be a pro or a con depends on how you look at it. It is way more powerful than a simple notepad or even Notepad++ is so you can not expect to be a master of it in one afternoon. There is a great community forum where you can get help to start out with UltraEdit and also a Wiki page and some tutorials but it takes time to master it. The cross platform nature at least for me makes it worth the effort as I know that I can take these skills with me no matter where I end up needing them the next time. Be it a windows or linux workstation or even an only apple products allowed wannabe startup I know I have the basics covered when it comes to working with text and my text editor

animation of IntelliTips in UltraEdit
Dynamic code auto-completion with IntelliTips
UltraEdit provides code-aware and context-aware auto-complete suggestions. See class members, function tips, and more for most modern porgramming languages…and configure as much or as little to suit your needs.
Best of all – it just works, out of the box. No risky third party plugins or esoteric config editing required.
animation of UltraEdit's multi-caret
Multi-caret/multi-select
UltraEdit features the most powerful and intuitive multi-caret editing and multi-selection capabilites in the business. Once your cursors or selections are where you want them to be, you can copy, cut, paste, select and delete just the same as you normally would.
animation of UltraEdit's column mode
Column mode
When editing horizontally just isn’t quite good enough, Column Mode is there for you. Use Column Mode to intuitively edit along the Y axis anywhere in your document. It’s just one of the many powerful ways UltraEdit helps you edit tabular data or code files.
animation of UltraEdit's FTP
Integrated FTP, SSH & Telnet
Whether you need to make quick edits to a file on a server or upload a massive codebase, UltraEdit’s integrated FTP capabilities and SSH/Telnet make it easy to work with remote files and interact with servers from a single, powerful application.
screenshot of HTML and Markdown live preview in UltraEdit
HTML / Markdown live preview
Want to see your rendered HTML or Markdown changes on the fly, as you edit them? UltraEdit’s live preview makes this possible. Double-click an element in the preview to jump to its definition in source. And with Github Flavored Markdown (GFM) code highlighting and compatibility, UltraEdit is the only editor you’ll need for your repos.

Key features

Disclaimer:
While the Linux version of UltraEdit does not initially include all of the features/functionality available in the Windows version, each future release will include additional functionality which is present in the Windows version but not yet available in the Linux version. Please check back frequently for updates on new additions on this link.

  • Easily open and edit large files – 4 GB and beyond!
  • Multi-caret editing and selection
  • Line change indicator
  • Column (block) mode editing
  • Powerful search: Find & replace in files, regular expressions, inverse search, etc.
  • File compare with integrated UltraCompare
  • Code syntax highlighting for nearly any programming language
  • Code folding and hierarchical function listing
  • Beautify and reformat source code
  • Powerful XML handling: XML tree, reformatting, validation, etc.
  • Templates
  • Integrated Ctags (symbols listing)
  • Password prompt for editing privileged files
  • Column markers
  • File and data sorting
  • Integrated FTP client (supports FTP, SFTP, and FTPS)
  • Document navigation map
  • Filtered spell checker
  • Unicode/UTF-8 support
  • Split/duplicate window editing
  • Hex editing
  • Macros and scripts for automated editing
  • File encryption and decryption
  • CSV data reformatting
  • Powerful and configurable tools
  • Project support
  • Robust bookmarking

Top Features of UltraEdit ( for me)

Cross Platform
Intellitips code completion
Syntax Highlighting
Find and Replace
Delete Lines Containing String ( new from version X.X)
Smart Highlight All
Save and Close
Open Last Closed Tab
Save As and Leave
Dynamic XML and HTML Attribute Highlighting
Themes
Ability to Open and Handle Very Big Files with Ease

UltraCompare

Power Tips for UltraCompare
https://www.ultraedit.com/support/tutorials-power-tips/ultracompare/

UltraCompare gives you the ability to rapidly compare 2 or 3 files from multiple locations at once, and merge conflicts and differences visually.

Key features

  • Compare 2 or 3 files or folders at a time
  • Merge differences
  • Filter view to show just matches or differences
  • Highlight diffs by character, word, or line
  • Ignore whitespace, line endings, case
  • Ignore lines starting with, ending with, everything between…
  • Manually align compare
  • Edit files as you compare them
  • Paste and compare text snippets
  • Preview HTML files in browser
  • Scan and navigate differences with mini-map
  • Print compare result
  • Compare files from the Internet via URL
  • Compare files and folders from FTP/SFTP
  • Compare Word Docs (.doc/.docx), PDFs, and RTFs
  • Rule-based automated folder sync
  • Find and resolve duplicate files
  • Save and reload most used comparisons with sessions
  • Drag-and-drop folders and files to compare them
  • Native command line support
  • Integrate with Git, Subversion, CVS, more
  • Change application and compare colors with themes
  • Show compare vertically or horizontally
  • Save difference and result reports
Sessions
With UltraCompare’s session functionality, you can have multiple comparison and merge sessions open in multiple tabs, each only a click away. Each session is like a new instance of UltraCompare, letting your run multiple types of operations, each with the appropriate configuration.
Ignore options
Ignore options in UltraCompare let you fine tune your comparison to ignore line terminators, white space, entire blank lines and more.
Find duplicates
UltraCompare’s powerful Find Duplicates functionality makes it easy to simply comb through your file system for pesky repeats. Let us do the heavy lifting for you.
Ignore/compare columns
Sometimes you only want to compare or exclude a known number of columns. This feature lets you specify which span or spans of columns you’d like to compare or exclude from comparison.
UltraEdit Integration
UltraEdit makes it easy to load a file straight from the editor and right into UltraCompare.

UEStudio

UEStudio & UltraCompare = git workspace
UEStudio integrates with your Git, Subversion, or CVS workflow.

Power Tips for UEStudio
https://www.ultraedit.com/support/tutorials-power-tips/uestudio/

Native integration of all your Git branches. Easily navigate your local / remote repositories. Edit. Save. Resolve conflicts. Merge. Push. Pull.

UltraEdit Vs UEStudio
https://www.ultraedit.com/products/uestudio/differences.html


Git editor

Why use an editor and a separate Git management tool? As a Git editor, UEStudio combines the world’s best text editor and the power of Git all within a single application. Edit and update your source files, then commit them with the stroke of a hotkey or the click of a mouse.

Preview Git markdown
Markdown is an essential ingredient of many Git repos. UEStudio features live preview for Markdown (and HTML) so you can update your repo’s README.md file and double-check formatting without ever opening your browser.


UEStudio is built upon the world’s best text editor, UltraEdit, and delivers additional features for teams and developers – like deep Git integration. You can clone, checkout, update, commit, push / pull, and more directly from within UEStudio to manage your Git repositories.
Easily manage and track your Git branches with UEStudio’s user-friendly branch manager. Create new branches, push, pull, merge, and rebase. See which branches are merged into the active branch, and easily checkout with a double-click.
Review changes to your Git repository’s working directory before you commit them with UltraCompare’s handy Git review mode. Select your repository, branch, and file, and see a text compare of the working copy of the file against the repository version.
UltraCompare gives you an easy way to see files with merge conflicts in the Conflicts window. From here, you can easily see how many conflicts you have to deal with, then resolve them in UltraCompare’s Git merge mode.

Prefer doing your Git work on the command line? UltraCompare natively integrates as Git difftool and mergetool so you can fire it up the GUI only when you need it.
Many common Git commands available are available in UEStudio’s project and explorer context menus. But if you enjoy the power and flexibility of the command line, you can run Git commands from the shell drectly from within UEStudio.

Review Git changes
Want to see what specifically you’ve changed in your repository’s working directory since your last commit? Open up your repository in UltraCompare and click on the different files for a quick text compare of the working copy and the indexed version.
Compare versions of files
Ever wanted to compare a file from a repo to a previous version of itself, or perhaps its state in a different branch? Or perhaps you want to compare your uncommitted changes to the HEAD version? UltraCompare’s Git version compare makes it this possible.

UltraFTP

UltraFTP is a personal, stand-alone FTP client built upon the framework of other IDM applications like UltraEdit and UltraCompare. Designed with maximum usability and performance in mind, UltraFTP offers full theme support, session support, an explorer interface, drag-and-drop transfers, and more. Even better, UltraFTP integrates with UltraEdit/UEStudio, UltraCompare, and UltraFinder to provide a seamless editing and publishing experience both on local and remote systems. UltraFTP supports FTP, SFTP, and FTPS protocols.

UltraFTP v21.00 includes one of the most highly requested features: synchronized browsing! When enabled, UltraFTP will automatically follow your local or remote navigation in the other pane. This feature is helpful if you’re working with the same folder structure on both your local system and FTP server.

V21 also includes a new Settings area with several useful options to tweak UltraFTP’s behaviors, including configuring file double-click action, setting whether files open in UltraEdit or UEStudio, and more.

With the new version, you’ll enjoy more seamless integration between UltraFTP and UltraEdit or UEStudio. As long as FTP accounts are shared between applications, UltraFTP will pass the remote file path to the other applications, allowing you to download, edit, and save back to the server directly. And launching a compare out of UltraFTP has been improved to provide a more intuitive experience.

screenshot of UltraFTP transfers
UltraFTP is designed for speed, efficiency, and security. With threaded transfers, multiple sessions, and broad server support, UltraFTP is the perfect for solution for both basic and power users of FTP.
screenshot of UltraEdit integration in UltraFTP
UltraFTP integrates seamlessly with other IDM applications. In addition to sharing FTP accounts among IDM applications, you can open remote files directly in UE / UES, edit and save them back to the server, compare local and remote files in UltraCompare, and more.
screenshot of local and remote folder sync in UltraFTP
Folder sync is a simple, intuitive and fast way to sync a local folder with a folder on your FTP server. Just click the Folder sync button in the ribbon, set your sync rule, then go.
screenshot of customizable UI in UltraFTP
Light or dark theme, widescreen or classic split pane view, local / remote panes or remote only…UltraFTP is designed with to accommodate the way your unique style of work.


Threaded transfers for max speed
Slash your transfer time by up to 25%? UltraFTP’s threaded transfer architecture is designed with performance in mind. When transferring large batches of files, UltraFTP stands alone, beating out the competition with transfer times up to 25% faster in some cases.
Preview remote files
Want to take a quick peak at a source file or an image on the remote server…without downloading it first? UltraFTP’s integrated File Preview allows you to see your local and remote files without having to open them externally.
UE, UES, UC integration
UltraFTP integrates seamlessly with other IDM applications. Launch a compare of two or three files or folders in UltraCompare. Edit an FTP file directly in UltraEdit or UEStudio. And best of all, with shared FTP accounts, your FTP sites are accessible in all your IDM applications.

UltraFinder

Power Tips for UltraFinder
https://www.ultraedit.com/support/tutorials-power-tips/ultrafinder/

UltraFinder is your personal search engine for your PC, network, and remote servers!

Find any file, word, text string, pattern, duplicate and everything else you need in seconds…on your hard drive, on your shared and network volumes, on your removable drives, or even on a remote FTP/SFTP server! UltraFinder is a quick and lightweight Windows search program designed to find text in files anywhere. UltraFinder also allows you to find duplicates and eliminate or delete duplicates, keeping your computer clean and uncluttered while conserving hard drive space. Search your way with a variety of settings to tweak your search to perfection.

Your Windows operating system offers limited find options — UltraFinder includes two powerful but quick and easy to use modes for finding what you need when you need it: Find Files and Find Duplicates.

screenshot of UltraFinder search
UltraFinder can locates files by their name or contents. With support for plain text, PDF, Word doc and other Office files, and the ability to find files on your local, network, or even FTP drives, there’s almost nothing UltraFinder can’t find.
screenshot of UltraFinder search options
Duplicate files create clutter and eat valuable system disk space, but who has the time to manually search for duplicate files on a drive or server? UltraFinder makes it easy to locate and clean up duplicate files on your system.
screenshot of find duplicates in UltraFinder
Want to find matches by pattern or filter? Set up a regexp search for maximum flexibility. Want a faster search on your hard drive? Search the Master File Table (MFT) directly. Countless other options make it a breeze to tune your search to your exact liking.
screenshot of UltraEdit integration in UltraFinder
UltraFinder integrates seamlessly with UltraEdit and UEStudio. Take any number of results and send them over UltraEdit for editing, or launch an UltraFinder session directly from UltraEdit / UEStudio.
screenshot of UltraEdit integration in UltraCompare
Want to verify a couple of duplicate files are actually duplicates before you delete them? Or want to see differences between two files from your file search? With UltraCompare integration you can easily launch a compare of the two files.

Key Features

FIND FILES
  • Master File Table (MFT) search methods for lightning fast results
  • Search for files by content or by name (partial or full)
  • Search file contents or file names with regular expressions (Perl, Unix, and UltraEdit native)
  • Search network or FTP locations
  • Specify specific folders, entire drives, or even specific files as search targets
  • Filter subdirectories, file names, and file extensions to exclude from the search
  • Search based on whole or partial word match
  • Search for case sensitive matches
  • Negative search (find files that DON’T match)
  • Search for text in PDF files
  • Search for text in Word documents (.doc/.docx)
FIND DUPLICATES
  • Search folders or entire drives
  • Search duplicates by a variety of criteria:
    • Content
    • Name
    • Dates
    • Size
  • Tweak duplicate searches with a variety of criteria settings (file dates, file sizes, etc.)
  • Ignore special case files like 0-byte, system/hidden files, Recycle Bin files, etc.
  • Set include/exclude filters for files and folders
  • Powerful searches using regular expressions (Perl, Unix, or native)
  • Resolve found duplicates (rename, delete, move, open)

CloudSync and Pieces for UltraEdit

Make every system your favorite system!

still image
Available as an option for our popular subscription products, Cloud Sync empowers you to instantly and securely share, sync, and deploy your settings across all personal systems or team instances. With Cloud Sync, sync your:
  •  Application settings
  •  Themes
  •  FTP & SSH accounts
  •  Macros & scripts
  •  Layouts
  •  Wordfiles
  •  Templates
  •  Taglists

Want to backup or restore a system? Cloud Sync does it! Need even more mojo? Soon you’ll be able to share files and snippets too!

https://www.ultraedit.com/products/cloud-services.html

Is it secure?

Absolutely. Cloud Sync is hosted on Google’s Firestore platform. As such, your sync data is protected by the tightest security available for any cloud. Additionally, you choose what settings and information can be synced through the cloud, and all synced data is encrypted from endpoint to endpoint. Your synced data is only shared between your installations of UltraEdit and can’t be read by anyone or anything else.

See sync details

View information about your last sync for each setting in the “Details” tab. If your system isn’t set as the master system, you can click the Make Master button to do so. The Edit Nickname allows you to rename your current system. And if you want to remove the system from the sync account, click the Remove System button. In this view you can also review your current cloud contents and sync details.

Reset a system

Also at the bottom of the “Details” tab is the Reset System button. Because your settings are secured and merged into a master sync snapshot in the cloud, this button enables you to restore settings from the cloud back to your master system, for example in the event of a system failure.

Review all synced systems

Open the menu and click the “Instances” option to see a listing of all systems under your sync account. See which system is master, the last sync time, and the sync direction for each system.

Cloud Sync is just the beginning of IDM’s Cloud Services… Meet Pieces for Ultraedit

Get more done with file & snippet sharing!

Effortlessly save, find and reuse code snippets and files straight from UltraEdit!

Never leave your editor.
Pieces for UltraEdit is designed with your workflow in mind. Save and reuse code across many files on right click.

Organize, search, and browse your snippets.
Launch Pieces Desktop to browse and search your snippets.

Pieces is an application ( Windows and MAC Only) https://code.pieces.app/ which integrates with Your existing IDE and let you save code to the cloud.

With Pieces for UltraEdit, you can…

  • Save code you reuse across many files
  • Save code you’re about to delete in case you need to get it back
  • Save code when resolving merge conflicts so you can get it back easily if needed
  • Temporarily drop code into Pieces that you know you’ll need to move soon
  • Save a snippet from Stack Overflow or any site directly to your editor
  • Save notes and example snippets for reference from an article or docsite
  • Create a knowledge base of key snippets for new hires / contributors
  • Share code, scripts, and more with colleagues so they can insert wherever they want
  • Store templates that you reuse often – HTML structures, CSS blocks, JavaScript loops, switch cases, imports, class structures, function blocks, decorator objects, and more
Use anonymously or with an account.
Run Pieces right off an install without signing up or in.
Want to access your Pieces across systems or share through the cloud (when available)? Set up an account to sync your Pieces and Pieces Desktop settings.

Send snippets to UltraEdit with the Chrome / Edge extension.
Add the Chrome / Edge web browser extension for Pieces to send selected code and snippets from any site or page to UltraEdit. Get the extension

thumbnail graphic of Pieces for UltraEdit
Save code from UltraEdit to the cloud
Stop re-writing the same code. Store snippets and and files in Pieces. Access from any instance or machine.

thumbnail graphic of Pieces for UltraEdit
Blazingly fast search
Find just the right code when you need it. Pieces auto-indexes by language, structure and more.

thumbnail graphic of Pieces for UltraEdit
Effortless upload
Right click/send snippets right from inside UltraEdit without breaking your flow.
thumbnail graphic of Pieces for UltraEdit
Beam a snippet straight from Pieces to your cursor in Ultraedit
Dark mode / light mode
Works offline
Share snippets with colleagues (coming soon)
Save screenshots, URLs and other types of content (coming soon)

Perpetual Vs Subscription model ( IDM All Access )

Perpetual – Boxed Copy of the actual version of the application ( with free upgrade to the next release included ). In case of UltraEdit it comes with UltraCompare Pro included. Your personal license is valid up to 3 installation any combination of platforms ( You get the Windows/Mac/Linux versions and can have 3x concurrent installations with one personal license )

Subscription – It is a subscription model which means you have it until you maintain your subscription active. The All Access Subscription costs 100 $USD and includes everything IDM Offers including UEStudio and the mobile/portable versions of the tools while it provides up to 5 unique installs Vs 3 Unique installs coming with Perpetual Licensing model per application. However when it expires the applications stop working and you can either renew your subscription or convert on a per application basis to a perpetual licensing model which comes with free upgrade to the next release only Vs the constantly having access to the latest version as with the subscription model. (( Perpetual licensing could be significantly more expensive if You need more than just UltraEdit and UltraCompare bundled with it ))

UltraEdit with UltraCompare ( Win/Mac/Linux versions ) valid for 3 separate installs with your personal license and upgrade to the next release for free costs 120 $USD.

The UltraEdit Suite + Mobility containing UE, UC , UF, UFTP except UEStudio and the mobile/portable version costs 190 $USD.

UEStudio , UltraFTP and UltraFinder under Crossover v21 under Mac OS X and wine under linux

UEStudio 64Bit for Windows installed in a prepared MobaXterm Bottle I had there with a lot of pre-requisites already inside Crossover v21 under Mac OS X Monterey 12.0.1
UEStudio 64Bit for Windows >> Some text elements looks like they are missing but overall much better than what I have expected.. Lets use it a little bit.
UEStudio 64Bit for Windows >> The Ribbon / Menu elements are all there.

UltraCompare for Windows >> Inside Crossover v21 under Mac OS X Monterey 12.0.1
UltraFinder also seems to work under Crossover v21. The missing font I hope I can solve installing some missing dependencies.

UltraFTP also seems to work under Crossover v21. The missing font I hope I can solve installing some missing dependencies.



I had MobaXterm Bottle already up and running prepared for another article with a lot of pre-requisites installed (.NET versions and Visual C++ Redists , etc) I used this pre-existing bottle to try to install UEStudio 64bit version for Windows together with UltraCompare for Windows and UltraFTP and UltraFinder inside there. The installations completed OK.

The experience was/were the same under Wine with Fedora 34 as expected as CrossOver is based on the underlying technology of Wine.

I really think UEStudio, UltraFTP and UltraFinder are on a great track to be 100% usable under Wine. Native Linux apps would be the best of course but if it can run perfectly under emulation layers like Wine under Linux that is good enough for me for now.

Links

Community Forums
http://forums.ultraedit.com/

UltraEdit for Linux features
https://www.ultraedit.com/products/uex/features.html