SeeQR V.11 — A New Way to Explore

SeeQR
3 min readJul 6, 2023

--

Hey all — The team is super excited to announce that the latest version of SeeQR is now live!

As you may already know, SeeQR is an open source tool designed to help developers create, manage, and optimize their databases and database queries. Throughout the lifecycle of the application, we’ve been able to do this by integrating features such as:

  • PostgreSQL, MySQL, and RDS support;
  • An interactive Entity Relationship Diagram (ERD) to visualize, create, and edit databases/database relationships;
  • Database and query performance tests/metrics;
  • ..and so on!

With SeeQR V.11, we’re proud to unveil a couple new features that should help developers optimize their database schemas even further.

New 3D Schema Visualization Environment

As the complexity of relational databases grows, so too does the challenge of understanding the intricate relationships between tables and their primary and foreign keys. Our entity relationship diagram (ERD) visualizer still remains an excellent tool to generate and visualize relational information within database instances; however, it can often be difficult to map out and distinguish complex relationships in a two-dimensional format.

Enter: our new schema visualization environment!

To address this limitation, we’ve added a new immersive schema visualization environment that aims to provide greater clarity vis-à-vis attribute relationships to database administrators and developers. With this feature, users can navigate through their database structures in three-dimensional space, offering a new perspective on the relationships between tables.

This environment is also fully interactive —in addition to being able to rotate, zoom, and traverse through the selected database, users can also hover over and select table and database nodes to quickly obtain more specific information.

Granular Performance Testing

We’ve also expanded the functionality of the existing performance tests on SeeQR — users can now run tests on multiple queries and receive more granular performance test results as they pertain to samples and sample times.

Additionally, our performance test feature now has the ability to compare the same query across different relational database management systems (RDBMS); now, users have the ability to generate performance data for their queries to better inform larger-scale architectural decisions.

SQLite Support

Version 11 also finally introduces support for SQLite! Now, SQLite users can also obtain meaningful performance test results and visual representations of their databases. (We’re still working on incorporating some minor functionality regarding ALTER queries for SQLite databases — please stay tuned for updates!)

At SeeQR, we’re constantly working behind-the-scenes to continue to help developers optimize their relational databases and make better-informed architectural decisions. We can spend all day talking about our tool and all of its new and existing features (e.g updating some visual components), but more than anything else, we’d love for you to check it our for yourself by downloading the latest build at the official SeeQR website!

Thanks so much for your continued support! For more information on how you can contribute, or to learn more about our app, please feel free to visit (and star) our GitHub repo and reach out to us below:

The SeeQR V.11 Team:

Ching-Yuan (Eric) Lai: LinkedIn | GitHub

Jamie Zhang: LinkedIn | GitHub

Julian Macalalag: LinkedIn | GitHub

Nathan Chong: LinkedIn | GitHub

Previous Articles:

--

--