#tap
- pgTAP 0.12 Released
https://justatheory.com/2008/10/pgtap-0.12
Indexed 7/1/2025
- pgTAP Best Practices Slides Available
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!
Indexed 10/7/2025
- pgTAP 0.11 Released
https://justatheory.com/2008/09/pgtap-0.11
Indexed 7/4/2025
- Test.Simple 0.20 Released
https://justatheory.com/2005/08/test-simple-js-0.20
It gives me great pleasure, not to mention a significant amount of pride, to announce the release of Test.Simple 0.20. There are quite a few changes in this release, including a few that break backwards compatibility—but only you’re writing your own Test.Builder-based test libraries (and I don’t think anyone has done so yet) or if you’re subclassing Test.Harness (and there’s only one of those, that I know of).
Indexed 4/8/2026
- Test.Simple 0.11 Released
https://justatheory.com/2005/07/test-simple-js-0.11
I’m pleased to announce the release of Test.Simple 0.11. This release fixes a number of bugs in the framework’s IE and Safari support, adds JSAN support, and includes an experimental harness for Macromedia^Adobe Director. You can download it from JSAN, and all future releases will be available on JSAN. See the harness in action here (or verbosely!). This release has the following changes:
Indexed 4/14/2026
- Test.Simple 0.10 Released
https://justatheory.com/2005/06/test-simple-js-0.10
Indexed 7/3/2025
- pgTAP 0.16 in the Wild
https://justatheory.com/2009/02/pgtap-0.16
I’ve been writing a lot tests for a client in pgTAP lately. It’s given me a lot to think about in terms of features I need and best practices in writing tests. I’m pleased to say that, overall, it has been absolutely invaluable. I’m doing a lot of database refactoring, and having the safety of solid test coverage has been an absolute godsend. pgTAP has done a lot to free me from worry about the effects of my changes, as it ensures that everything about the databases continue to just work.
Indexed 11/23/2025
- 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.
Indexed 2/25/2026
- pgTAP 0.20 Infiltrates Community
https://justatheory.com/2009/03/pgtap-0.20
Indexed 4/11/2026
- 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.
Indexed 11/20/2025
- pgTAP 0.21 Drops
https://justatheory.com/2009/05/pgtap-0.21
I just dropped a new version of pgTAP following a few marathon hack sessions since my talk at PGCon (movie here, BTW). Actually, the new performs_ok() function came about as I wrote the presentation, but all the rest came on the flight home and in the few days since. Not sure when I’ll hack on it this much again (it’s getting a bit big at 5,758 lines of PL/pgSQL and SQL).
Indexed 1/22/2026
- TestSimple 0.02 Released
https://justatheory.com/2005/04/test-simple-js-0.02
Indexed 7/4/2025