About the customer
Proxima Software di Vanini Mirco is an IT consultancy firm specializing in mobile personnel automation, logistics, warehouse automation, industrial process automation, and related areas. The company has a proven track record of delivering high-tech software solutions to meet the diverse needs of its clients at both local and national levels.
Microsoft MVP
since 2012
25+
years in operation
Country
Italy
Product used
Challenges faced
Mirco Vanini, recognized as Microsoft MVP for the Developer Technologies category, managed the process of transitioning several customers' projects from Microsoft SQL Server to PostgreSQL.
One project involved significant code rewriting for an order processing system with a legacy codebase. Another project involved migrating retail programs that relied on Microsoft SQL Server as their storage solution to PostgreSQL.
During these transitions, the team faced some challenges that needed to be resolved promptly:
01
Accelerate the Postgres-specific code writing
02
Efficiently analyze and optimize the code
03
Streamline database schema updates
Available third-party tools didn't quite meet the PostgreSQL's specificity. Mirco Vanini did extensive research online and reached out to several product vendors. Ultimately, he chose dbForge Studio for PostgreSQL, which offered all the necessary tools in one easy-to-use package available on Windows and macOS platforms.
"It has certainly halved both update and optimization times… We have reduced errors in update processes to zero."
Senior Developer, Microsoft MVP
Results achieved
+50%
productivity boost
100%
error-free updates
After integrating dbForge Studio for PostgreSQL at work, Mirco Vanini observed a significant boost in productivity for all aspects of Postgres-related jobs. The platform's powerful features enabled developers to code more quickly and efficiently. Overall, dbForge Studio for PostgreSQL helped the Proxima Software team reduce their time and effort by up to 50%.
Key features Mirco is excited about
IntelliSense-like code completion
dbForge Studio for PostgreSQL offers context-aware, PostgreSQL-specific suggestions. It recommends individual keywords, object names, and complete code phrases, helping users minimize manual typing, thus letting them enhance code quality. Also, the SQL editor includes a syntax validation tool, a code snippets library, a powerful code formatter, and more.
Query Profiler
The Query Profiler feature enables users to review, analyze, and optimize query performance. It presents query plan information visually, detailing the execution plan hierarchy to help users identify and address performance issues. A significant benefit of this feature is the ability to compare profiling results after each query modification. This allows users to select the most efficient version of the query before executing it.
Schema Compare
The Schema Compare feature simplifies the process of comparing and synchronizing PostgreSQL and Amazon Redshift databases. It identifies all schema differences and generates precise SQL scripts to deploy database changes on both on-premise and cloud-based platforms. Additionally, users can automate recurring schema comparison and synchronization tasks via the command line.
Get extra benefits with Devart for Enterprise
Grow your business with Devart - become our Enterprise client and get a customized package of MySQL management software, tailored to your business needs and demands.
-
Bonuses for corporate clients
These may include fast and effective deployment, corporate budget optimization, and a number of special deals.
-
Dedicated manager
We will save your time by providing a dedicated manager to consult you and guide you through all the purchasing and licensing processes.
Similar stories
More success stories
THWS University
"The highest benefit was to have to use only ONE tool for all important database tasks."
dbForge Studio for MySQL
Hexagon
"The easiest tool to work with, it provides everything we require with efficiency and high performance..."
dbForge Studio for Oracle
FER
"It's the best possible GUI for creating/modifying database objects and building complex SQL queries..."
dbForge Studio for PostgreSQL