Hi from the SeeQR team! We’re so excited to announce that SeeQR v10.0.1 is here! Before we get started with all the changes to SeeQR though, let’s perform a quick recap!
SeeQR is an open source analytic database tool to manage SQL databases that features:
- An Entity Relationship Diagram (ERD) to visualize (or create!) the relationship between tables and columns
- Granular comparisons between the efficiency of different schemas and queries
- Simplified database operations via its clear graphical interface
- Metrics for database performance, from size to query execution times
- PostgreSQL and MySQL support
With SeeQR, developers and architects can make better informed architectural decisions regarding their SQL databases.
New Feature
SeeQR is happy to announce the addition of AWS RDS support. Now you can manage AWS RDS instances running either PostgreSQL or MySQL with SeeQR’s full suite of tools, including its visualization and comparison. We encourage you to set up an AWS RDS database and try it out! For help setting one up, you can refer to our new docs. To learn more about our decision to implement this feature as our primary change to version 10.0.1, keep reading!
Background information
With recent advancements in cloud service providers in both functionality and performance, cloud hosting and serverless architecture has become the norm. More and more of our technology infrastructure is being hosted remotely on the cloud — this means the data is on the cloud via remote databases!
Why should we care about cloud based databases?
- They are designed to be scalable, customers may add or remove capacity as needed
- Cloud hosting reduces expenses, as part of the operating and hardware overhead is distributed among customers
- Improved security, inherit the provider’s security practices
- Reduced administration, providers handle the server so you can focus on your application
As of Q3 20221* Amazon Web Services (AWS), Microsoft Azure and Google Cloud hold 34%, 21%, and 11% of the market share respectively, with the top 8 companies controlling 80% of the market. Amazon is the clear market leader and it follows that as we roll out additional SQL database support, we focused on AWS RDS first!
SeeQR’s codebase is now at version 10 and that includes some other changes as well! During the lifetime of the project as multiple contributions from open source developers have been made, inefficiencies have accumulated over time. We’ve made significant performance improvements under the hood and these changes have reduced processing overhead enabling our Electron-based application to manage hardware resources better. In addition to the cloud feature, process improvements and application facelift, we have relaunched the SeeQR website with new documentation. Check it out here: http://www.seeqrapp.com/
Recap
SeeQR is a powerful efficiency tool that can help guide developers make better informed decisions on optimizing and visualizing SQL databases and queries! You can test it out for yourself by downloading the latest build at the official SeeQR website. If you like what you see, support us by starring the app’s GitHub repo and clapping this article. If you’d like to dive even deeper into PostgreSQL optimization, read this in-depth guide about PostgreSQL optimization through indexing. As an open source project, we can’t thank the community enough for your support! Cheers!
The SeeQR 10.0 Team
Junaid Ahmed: LinkedIn | Github
Chase Sizemore: LinkedIn | Github
Oscar Romero: LinkedIn | Github
Anthony Deng: LinkedIn | Github
Previous Articles
- 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
References