Play SQL

Case study

In a short story we’ll show you how to use Spreadsheets and Forms for a practical case. Emma manages a resort on a beach in the south of Spain. They own three boats and they take them to the sea according to weather conditions, demand and repair cycles. She has four skippers and a receptionist. […]

Beta 2.0 Available: Spreadsheets!

Ok, “spreadsheets” is a hyperbole… Since August, I started working on making Play SQL read-write. When datasources are configured so, users will be able to create tables and edit data. With this feature, Confluence can be used as an enterprise repository for tabular data. I hope users will start enjoying advanced macros. I’ll participate in educating […]

Play SQL 1.4 Released

Just a heads up: Highlight: “Query” becomes a top-level object like Pages and Blogs. New query editor, and space permissions are applied. Support for the Charts macro, Support for printing in PDF, Upgrade to Postgresql 9.2-1003-jdbc4. People using JNDI are not affected by this change. A few notes about upgrading: You need to go through the […]

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

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