Play SQL

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

Starting the blog, fine-tuning the dev

So i started this development months ago but now i’m finally going online … Main reason is that i have been entirely focusing on the development, and before starting to go public, i wanted to be sure of what i was doing. Anyway, just stay tuned, here will come much more in the coming weeks.