#testing

• https://justatheory.com/2009/07/pgtap-test-your-results

  I’m pleased to announce that, after much thinking, committing, and not an insignificant amount of hair-pulling, pgTAP 0.22 has finally landed. Download it here. Many, many thanks to all who commented on my previous posts, made suggestions, and helped me on IRC to figure out how to get all this stuff to work. The crazy thing is that it does, quite well, all the way back to PostgreSQL 8.0.

• Committed: pgTAP Result Set Assertion Functions

  https://justatheory.com/2009/07/pgtap-results-eq

  Regular readers will know that I’ve been thinking a lot about testing SQL result sets and how to how to name result testing functions, and various implementation issues. I am very happy to say that I’ve now committed the first three such test functions to the Git repository. They’ve been tested on 8.4 and 8.3. Here’s what I came up with.

• https://justatheory.com/2009/11/pgtap-best-practices

  Last month I gave two presentations at the PostgreSQL Conference West. The first was a variation on Unit Test Your Database!, which I’ve now given about six times (and will at least two more times, including tomorrow night for Portland PLUG and in two weeks at the JPUG 10th Anniversary Conference). The second was a new talk, a 90-minute tutorial, called “pgTAP Best Practices.” And here it is (download and Slideshare). Enjoy!

• Octothorpe Without Javascript - Octothorpes Demo

  https://demo.ideastore.dev/pure-http

  If you don't want to use javascript or display #s on the front end, you can use the pure-HTTP method.

• Introducing MyTAP

  https://justatheory.com/2010/07/introducing-mytap

  After some prodding from the MySQL Community Manager, some OSCON hacking yields tangible results.

• Test Everything with TAP Source Handlers

  https://justatheory.com/2009/11/tap-parser-sourcehandler

  I’ve just arrived in Japan with my family. We’re going to be spending several days in Tokyo, during which time I’ll be at the JPUG 10th Anniversary PostgreSQL Conference for a couple of days (giving the usual talk), but mainly I’ll be on vacation. We’ll be visiting Kyoto, too. We’re really excited about this trip; it’ll be a great experience for Anna. I’ll be back in the saddle in December, so for those of you anxiously awaiting the next installment of my Catalyst tutorial, I’m afraid you’ll have to wait a bit longer.

• Page with Spaces in URL - Octothorpes Demo

  https://demo.ideastore.dev/page%20with%20spaces

  This page uses an alternate server, which can easily be set with a page variable.

• Testing the Tutorial App

  https://justatheory.com/2009/11/catalyst-testing

• Introducing pgTAP

  https://justatheory.com/2008/06/introducing-pgtap

  So I started working on a new PostgreSQL data type this week. More on that soon; in the meantime, I wanted to create a test suite for it, and wasn’t sure where to go. The only PostgreSQL tests I’ve seen are those distributed with Elein Mustain’s tests for the email data type she created in a PostgreSQL General Bits posting from a couple of years ago. I used the same approach myself for my GTIN data type, but it was rather hard to use: I had to pay very close attention to what was output in order to tell the description output from the test output. It was quite a PITA, actually.

Follow #testing on RSS or use the

curl -X GET \
  -H "Content-type: application/json" \
  -H "Accept: application/json" \
  "https://octothorp.es/~/testing"