postgres

Tutorial on using Postgres recursive Common Table Expressions (CTEs) to navigate a JSON tree structure.

Postgres Explain Visualizer (Pev) is a tool I wrote to make EXPLAIN output easier to grok. It creates a graphical representation of the query plan.

Grails GORM supports five increasingly powerful querying mechanisms: 1) dynamic finders, 2) where clauses, 3) criteria, 4) HQL, and 5) SQL.

You should use OAuth 2.0 client credentials flow to secure REST APIs used in your web application.

There’s been some discussion in web development circles recently about whether RESTful (a.k.a Client MVC, a.k.a. Single page) web applications are a good idea. Or, more accurately, whether they’re a better idea than just serving up…

Groovy and XSLT are two great options for working with XML. While both have their uses, I was curious about combining them to generate an XSLT transform with a Groovy script. It turns out that doing this is pretty straight forward,…

Brothers and Sisters, I’ve come here today to preach the word of the mighty RESTa as revealed to us by the Great Profit Fielding, blessed be his dissertation.

There’s a good variety of options available for transforming xml. In addition to the standards (XSLT and XQuery), Groovy has excellent XML manipulation support with MarkupBuilders and XMLSlurpers. I wanted to know how XSLT and Groovy…

JSON-oriented document stores like Mongo and Couch have really become the darlings of the web application crowd. Of course, JSON (or BSON) isn’t the only game in town. When it comes to document store formats, the other white meat if…

Solutions of the “magical” variety go out of their way to hide (obfuscate?) the underlying implementation. They present the developer with a Faustian bargain: I’ll make it easy for you to get things done so long as you don’t question…

For far too long now I have sat idly by as the NoSQL movement spread across our industry. The time has come to stand up to the scourge of NoSQL. Today, I am calling on developers everywhere to join a new movement dedicated to bringing…

A while back I blogged about strategies for putting your database artifacts under source control. At the time, I thought that a schema synchronization approach (implemented by Visual Studio Database project) was the way to go. Among…

To create functional tests for your web applications, you need data in your database. The crucial thing about this test data is that it should be stable. Otherwise, your tests are not deterministic and that makes them useless. For…

All good devs know that your source code should be in source control. There are many reasons for this, but one of the most important ones is the ability to rebuild and deploy your entire application whenever you want. Database…

Very few things in technology impress me more than web applications which are able to massively scale. The ability to serve up gagillions of requests to bajillions of users in milliseconds is nothing short of amazing. And, for whatever…