About the customer
Garpenholm Produktion is a Sweden-based company that provides IT and media production services in a variety of areas, including Networks, Servers, Cyber Security, Applications, and System Development.
Country
Sweden
Product used
Challenges faced
The company's primary operations at the time included the development of infrastructure monitoring and documentation systems, media forensics and IT security. Over time they had to start building more complex SQL queries due to tighter integration of their products with 3rd-party solutions. When more advanced queries came into play, the team encountered a number of challenges:
01
Lack of proper tools for building complex nested queries with numerous table joins
02
Inconvenient UI and insufficient responsiveness of the tools used previously
03
The need to achieve seamless integration with the clients' product ecosystems
The team tried a few MySQL tools that, despite being good, did not simplify the building process. The routine of building complex queries still was time-consuming and did not allow the developers to speed up and catch up with the required performance. In a while, the company's CTO, Fredrik Garpenholm, found a solution that offered easy visual building of queries, regardless of their complexity. It was dbForge Query Builder for MySQL.
"dbForge Query Builder enhances our R&D and software development processes. It gives our clients an even better platform with better integration into their environment."
CTO at Garpenholm Produktion
Results achieved
+100%
query building productivity
As Fredrik noted, the tool provided the functionality required to double the daily productivity. That said, we'd like to quote him a few more times and highlight the features that he found the most vital.
Key features Fredrik is excited about
Drag-and-drop query building
"With Query Builder, we got a simple GUI to build complex MySQL queries with the drag-and-drop feature. Now that we've been using it for some time, I estimate a 100% increase of query building productivity."
Conversion of visual queries into SQL
"Regular operations became very easy. I build the query in the GUI and copy the text-formatted output to our source code. Query Builder gives a better overview and gives no typos."
Hierarchy (inner/outer JOINs)
"What I like about Query Builder is that the team that develops it goes beyond the basic functionality
and delivers some extra value in every detail. For example,
I can easily create 5 types of joins between tables and set complex conditions for any of them."
Get extra benefits with Devart for Enterprise
Grow your business with Devart - become our Enterprise client and get a customized package of MySQL development and 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
High Sports Group Limited
"With the help of this tool, we were able to turn around requests most effectively..."
dbForge Query Builder for MySQL
Tridax Software
"dbForge Query Builder is lightweight, affordable software, which enables fast query building..."
dbForge Query Builder for MySQL
KS EDV CONSULTING
"dbForge Studio for MySQL turned out to be the most powerful and effective means to achieve our goals."
dbForge Studio for MySQL