Git has many advantages over SVN, but its killer feature is cheap private branches. This becomes invaluable when working on multiple tickets, or when you want to quickly compare two versions of the code. I’ve been doing this for a little more than a year and a half. This section will get you through setting up Git-SVN, and will give a quick overview of the workflow I’ve found to work.
Paginating Queries in Oracle SQL
Here’s what I’ve used a couple of times to paginate my queries. It adds a limit and offset to your query results so you don’t have to do it Java-side:
Two-dimensional grid with Oracle SQL
I found a fun way to generate a 2D grid in Oracle SQL and I thought I’d share.
Discourse posts to Jekyll entries
I’ve been looking into a way of publishing Discourse posts as Jekyll entries. I run a gaming community that uses a Discourse forum. In it, there are pages (rules, tutorials etc.) that I’d like to feel more permanent, more easily accessible. I got around this by curating permalinks, but then there are nice-to-haves like mission debriefs - or even a monthly blog that could keep non-members engaged. This is where we run into the forum’s limitations as a platform.
Discourse sign-up Notifications
Our forum registration is open to anyone, but we need to be notified of new members so that the Recruitment Officers (ROs) can get in contact with them. Setting registrations to require manual approval is not an option, because not every RO is a moderator.