Hello everyone! We at SeeQR are very proud to announce that version 12 is now officially live!
SeeQR, for those of you who haven’t seen us before, is a free and open source management application for SQL databases. It allows developers to create, edit, and optimize databases and queries. SeeQR features an interactive entity relationship diagram (providing a graphical interface for organizing table relationships), as well as performance measurements for query executions — including comparisons by groupings and much more. SeeQR is built for the whole lifecycle of your SQL databases.
Introducing SeeQR V.12: The Maintainability Update: SeeQR, as an open source tool, counts on contributions both from within the SeeQR team and from the open source community at large. Version 12 is all about setting our contributors up for success. This launch brings the SeeQR codebase up to date with modern engineering best practices emphasizing modularity, test-ability, and adherence to recognizable design patterns.
In addition to modernizing the codebase, the SeeQR team is also excited to share several key performance improvements for the application, as well as some critical bug fixes. Let’s dive in.
Modernizing the SeeQR codebase
While SeeQR’s contributors have been hard at work introducing new features, so too have the teams responsible for several major dependencies. To name just a few, Electron released important new security features, and React version 18 released automatic batching and a new concurrency mechanism. SeeQR is now up to date with these latest versions.
We are also excited to launch a completely overhauled backend design. The team responsible for version 12 meticulously broke apart, modularized, and re-routed application flow to adhere to a Model View View-Model (MVVM) design pattern. In the process, inefficiencies were engineered away — resulting in performance improvements.
Version 12 also laid key foundations for modernizing state management in SeeQR’s frontend. If you’re interested in contributing, don’t hesitate to reach out; check below for SeeQR V.12’s contact details.
Performance Improvements and Bug Fixes
In some cases, users working with large databases reported significant load times when selecting these databases in the entity relationship diagram view. Load speeds for these cases have been increased by >100% (making load time almost instantaneous) with the release of version 12. Contributors will be happy to hear that build time, package install time, and application launch speed have all been significantly improved as well.
Users also reported an issue regarding authentication for local PostgreSQL instances. Version 12 addresses this issue, and ensures that all logins resolve properly.
SeeQR is a powerful tool for developers to analyze key metrics related to complex query executions on relational databases in any application. We strive to help developers make quality organizational decisions about their application architecture. If this all sounds interesting to you, head on over to the SeeQR website where you can download the latest build and try it out for yourself!
If you’re thinking about contributing to SeeQR, or just want to learn more, head on over to our GitHub repository, and/or feel free to contact the SeeQR V.12 team:
Annabelle Ni LinkedIn | Github
Previous Articles:
- SeeQR V.11 — A New Way to Explore
- Unleashing the Power of Cloud-Based Databases with SeeQR
- SeeQR database and query design optimized
- How to boost early stage database planning efficiency
- Three features to look for in your schema performance testing tool
- Visualize and optimize SQL databases and queries with SeeQR
- Design the optimal schema for your SQL database
