Play SQL

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 […]

A plugin for databases in Confluence

Why introducing databases in Confluence®? In my teams, Confluence has always been the glue between the company’s systems. The content is unstructured by nature. Take the release notes as an example: Here you have a list of JIRA issues mixed with textual explanations of the upgrade tasks. This is the mission of Confluence: Being a […]

Going Live

At the beginning, I just developed it as a hobby: We needed a tool for both automatic and manual testing. Surefire test reports (the JUnit plugin for Maven) were convenient, but they couldn’t be mixed with manual testing for non-automated checks. In the end, I created a database, used PostgreSQL and an ad-hoc plugin for […]