SchemaWright

Start free.
The rest for one coffee a month.

The free part is not a demo: the first two levels of lessons on a live Postgres, 2 exercises with the same battery as the rest, and the Foundations lectures. Start there, and subscribe when you want the rest.

Monthly

$12a month

Cancel any time, from the same place you subscribed.

Annual

Save $45 a year

$99a year

One payment, and no renewal to think about for a year.

12 x Monthly$144Annual$99

Both plans hold every rule.

The same thing, paid monthly or once a year. Nothing is held back for a higher tier, because there is no higher tier.

subscription.test
  • PASSEvery exercise across all six tracks
  • PASSYour DDL run on a real Postgres, not a parser
  • PASSThe hidden battery, with a hint on each test you fail
  • PASSA design review of naming, types and trade-offs
  • PASSProgress and best score kept per exercise

5/5 Every rule holds.

Lessons first, then the exercises.

Short lessons on a Postgres running in your browser: you predict what it does, break the rule, then write the fix. Levels 0 and 1 are free, all 15 of their lessons. The levels after them come with the subscription, and are being written one lesson at a time: 20 so far.

  1. 00FoundationsFree, 5 lessons
  2. 01IntegrityFree, 10 lessons
  3. 02Modelling11 lessons, subscribers
  4. 03Normalisation9 lessons, subscribers
  5. 04Indexes and the plannerBeing written
  6. 05Concurrency and queuesBeing written
  7. 06Changing schemas in productionBeing written
  8. 07Scale and architectureBeing written

2 open now. 20 more with a subscription.

  1. 01The two constraints every table needs, freefree
  2. 02The order with no customer, freefree
  3. 03The key the business insists on renaming, with a subscription
  4. 04Columns that refuse what should never be stored, with a subscription
  5. 05Exactly one of them is the main one, with a subscription
  6. 06A category tree with no way back to the root, with a subscription
  7. 07Soft delete without breaking sign-ups, with a subscription
  8. 08A record of who changed what, that nobody can change, with a subscription
  9. 09Every draft kept, exactly one of them live, with a subscription
  10. 10A balance that cannot be wrong, with a subscription
  11. 11Uniqueness that stops at the tenant boundary, with a subscription
  12. 12Isolation that survives a forgotten WHERE clause, with a subscription
  13. 13Invoice numbers that start at 1 for every customer, with a subscription
  14. 14A price that changes without erasing what it was, with a subscription
  15. 15The day it happened depends on where you are standing, with a subscription
  16. 16Two people cannot hold the same desk at once, with a subscription
  17. 17Tags that a search can actually trust, with a subscription
  18. 18The invoice that must not change when the price does, with a subscription
  19. 19One column must be copied, the other must not, with a subscription
  20. 20An index serves a question, not a column, with a subscription
  21. 21The column is indexed and the query still scans, with a subscription
  22. 22A number that is right and cheap at the same time, with a subscription

Free, open nowUnlocked by a subscription

And lectures, read from the original papers.

Long-form, cited to the page, with pieces you can try. Foundations is free. The tracks after it come with the subscription, and are being written one lecture at a time.

LecturesI     Foundations  freeII-V  subscribers
  1. IFoundationsFree, 2 to read
  2. IIInside the engineBeing written
  3. IIIAnalytics at scaleBeing written
  4. IVData for AI and machine learningBeing written
  5. VData qualityBeing written

Cancelling is one button.

In the Stripe portal, and it takes effect at the end of the period you already paid for. No email, no retention flow.

The card never touches this server.

Checkout and the billing portal are both hosted by Stripe. Nothing about your payment method is stored here, because none of it arrives here.