Database IDE tailored for Business Analysts. Child with a great potential.
What do you like best?
Popsicle makes SQL as a tool well accessible to the business user, taking away file management, connection configuration struggle, and most importantly dealing with Git. The UI is simplistic yet complete, with a file manager, guidance toward the one-query-per-file convention, intellisense that performs, and accessible share/export/vizualise features one click away. Seamlessly working connections are one of the many back-end advantages of its very solid back-end. Group collaboration is well facilitated and the personnel keen to interact and receive feedback.
Because the product is in its infancy, the penetration pricing makes the whole package a great deal in spite of its current weaknesses.
What do you dislike?
Being relatively new, users may encounter missing features and experience some difficulties dealing with some aspects of the UI. My opinion is that some of the controls could be moved and reduced in size to allow for larger window for the code and output. The intellisense is improving quickly but some aspects of it are still clunky. Support for mutliple cursor and further mouse interaction will also be appreciated.
Recommendations to others considering the product:
Give PopSQL a try, if you are working between a database server and the soft side of the business. It may become a valuable partnership that simplifies many things.
What problems are you solving with the product? What benefits have you realized?
I use PopSQL to store and version control my SQL scripts, many of which are definitions of views stored in our data warehouse, while others provide me with easy way of sharing ad-hoc or periodic tabular reports with the CEO and our financial analyst through Slack, so I don't have to deal with Excel.
