Play SQL

Play SQL 1.4 Beta available

Dear users, Play SQL is evolving in the hope it becomes an ergonomic database manager. Since I’ve been providing support for enthusiastic Play SQL users, I noticed some recurring questions: How come the tables don’t appear in PDFs? How to prevent users from launching their own queries? Can we integrate Play SQL with the graph plugin? […]

New Beautiful Table Browser for Confluence 5.0

Already! I’ve released the version of my SQL plugin for Confluence 5.0. It has a new index page for tables. The SQL Table Index page Following my series on the review of the Confluence 5.0 Beta, I’ve identified a few areas where SQL integration would make sense. The highlight of this version is the Table […]

Confluence 5.0 Beta: Review (3/3)

This article is third in a sequel about the upcoming Confluence 5.0. See Part 1 and Part 2. In the previous parts, I’ve explored what it was to be a Confluence 5.0 user. For this last article, I’ll search for the opportunities it brings to a plugin developer. Administrator Tasks On the administration side, Confluence 5.0 […]

Confluence 5.0 Beta: Review (2/3)

This article is second in a sequel about the upcoming Confluence 5.0. Previous part. The Editor Edit: There are a few changes in the editor which you can see on Atlassian’s blogs: Many small bugfixes which make it more reliable, Increased speed to load the Editor, Responsive toolbar for smaller screens, Improved macros: There’s a […]

Confluence 5.0 Beta: Review (1/3)

I’ve just discovered the beta of Confluence 5.0 has been out for 5 days and I’m delighted of the work Atlassian has performed. I’ve investigated it to understand how should I make Play SQL fit the new scheme and I’m pretty excited to share my notes. Overall Impression Atlassian sends us into a new era: […]

How to connect Play SQL to an Oracle database

My preferred database is Postgres, but you can use the database-agnostic connection and there are all reasons for it to work well in read-only mode. I’ve tested it myself with Oracle. If you need Spreadsheets and your company is using Oracle, we redirect you to Heroku Postgres, so you can host your database online. Having […]

[Release] Christmas Release 1.1.0

Focused on ‘timeouts’, this release is a gift to the system administrators! Do you have massive tables in your database? Have you ever noticed the users’ joy when someone runs a long query, doesn’t wait for the answer, and re-runs 10 instances of the query? Do you have a club under your desk if you […]

[Release] New Administration Screen – v. 1.0.1

I’ve noticed it wasn’t obvious to users how datasources are configured at the global and space levels. Also, I wanted to use Backbone.js in a publicly supported project and see how it helps me improve the quality of the user interface. The version 1.0.1 of the Play SQL plugin was released today and is available […]

[Release] First version available

Finally the first release of the plugin is available here!!! Enjoy it and check the documentation and the setup pages for more information about how to use it.

Why PostgreSQL and HSQLDB?

PlaySQL comes with 2 drivers, Hsqldb and PostgreSQL. While you can connect to other databases in theory, I’ve chosen those two because they perfectly represent a minimum valuable product for my plugin. Why HSQLDB? Hsqldb is a database-in-a-file engine. That means, it is a classic SQL database which stores all data in a local text […]