CHANGELOG.md

Changelog

All notable changes to this project will be documented in this file. See standard-version for commit guidelines.

5.4.0 (2024-11-01)

Features

• track tax codes and read replica for client billing (#4) (6728f66)

5.3.0 (2024-07-02)

Features

• add taxable column for billing (#3) (8058282)

Backend Changes

• add license (5f38703)

5.2.0 (2024-03-04)

Features

• 10dlc: support multiple numbers per sending location (#2) (dd56994)

5.1.0 (2024-03-02)

Features

• public commit (926092f)

5.0.1 (2024-02-07)

Bug Fixes

• telnyx: avoid sdk to associate 10dlc campaign (#422) (b9e58b7)

Backend Changes

• remove unused telnyx envvar references (#420) (492c242)

5.0.0 (2024-01-31)

Features

• support sending mms without media (#418) (d0f0a9f)

Bug Fixes

• update-dump: add cap add flag (#419) (4a2b1ed)
• update lookup to use telnyx v2 api (#417) (d89bb97)

4.0.3 (2023-11-29)

Bug Fixes

• twilio: upgrade to v4.18.1 (#416) (7832a69)

4.0.2 (2023-07-27)

Bug Fixes

• hotfix: update telnyx dlr schema for delivery_failed and sending_failed (96265bb)

4.0.1 (2023-07-26)

Bug Fixes

• add missing . to worker event prefix (#402) (d54e54f)
• fix delivery report shape (#404) (66f589d)
• park failed cron jobs (#403) (85614c0)

Backend Changes

• fix slow rollup query (#406) (6ff3ff5)

4.0.0 (2023-07-24)

4.0.0-rc.8 (2023-07-23)

Bug Fixes

• skip hydrating decomissioned sending locations (#401) (3c63829)

4.0.0-rc.7 (2023-07-23)

Backend Changes

• hotfix: log sending location for Incorrect10DlcNumberCountError (#400) (266430a)

4.0.0-rc.6 (2023-07-22)

Bug Fixes

• hotfix: pass pg pool instead of slonik pool (bf242a5)

4.0.0-rc.5 (2023-07-21)

Backend Changes

• Add default TZ in env example (#388) (b6c2dda)
• park failed jobs (#399) (1a32318)

4.0.0-rc.4 (2023-07-12)

Bug Fixes

• hotfix import of event emitter (7e661af)

4.0.0-rc.3 (2023-07-12)

Features

• add worker statsd emitter (#397) (9f0c3ee)

Bug Fixes

• register notice-sending-location-change task (#393) (2f02f25)

Backend Changes

• drop unused columns on outbound_messages (#395) (65cc66c)

4.0.0-rc.2 (2023-07-07)

Features

• validate task payloads with zod (#391) (e39e550)

Backend Changes

• use constants for task identifiers (#390) (1d91ea7)

4.0.0-rc.1 (2023-07-06)

Bug Fixes

• add ioredis-mock as prod dependency (314f073)

4.0.0-rc.0 (2023-07-05)

⚠ BREAKING CHANGES

• eject assemble-worker (#373)

Features

• use redis for caching profile and sending account info (#387) (7fec8e1)

Backend Changes

• add cache-backed process-10dlc-message (#384) (267f237)
• eject assemble-worker (#373) (bc9f664)

3.4.0-rc.0 (2023-06-30)

Features

• add dry run service and mode (#378) (b512fe1)

3.3.4 (2023-06-29)

Bug Fixes

• handle case where dlr match is not found (#382) (5373320)

Backend Changes

• enable TS strict mode (#386) (5582044)
• pull up common process message functionality (#383) (aacd1d7)

3.3.3 (2023-06-16)

Bug Fixes

• update cron task payload shape (#377) (b6c77c3)

3.3.2 (2023-06-15)

Bug Fixes

• graphile-worker: fix cron item param name (96cbda8)

Backend Changes

• migrate graphile-scheduler to graphile-worker cron (#375) (cf3cf76)
• upgrade graphile-worker to v0.14.0 (#370) (e7c9204)
• conventional-commits: set explicit types (#374) (8b99654)

3.3.1 (2023-06-15)

Bug Fixes

• enable non-generic query plan for sms.resolve_delivery_reports() (#372) (6184660)
• use supported graphile worker api (#369) (e60b714)

3.3.0 (2023-06-09)

Features

• add channel-specific provisioning for new GraphQL-created sending locations (#367) (088c6b6)

3.2.0 (2023-06-06)

Features

• automate daily maintenance of high-write tables (#366) (dd838c2)
• resolve bandwidth delivery reports (#361) (e02d7d1)

3.1.1 (2023-04-17)

Bug Fixes

• 200 response for unmatched inbounds (#351) (c2f316e)
• docs: update readme and add nvmrc (#342) (29d1cba)

3.1.0 (2023-01-09)

Features

• add 10dlc channel (#325) (3554d67)

Bug Fixes

• prevent routing to fulfilled pending requests (#338) (7e9293d)
• forward-inbound-message: log unexpected errors (#340) (57608d0)

3.0.0 (2022-10-27)

⚠ BREAKING CHANGES

• process grey route to redis (#327)

Features

• process grey route to redis (#327) (e5f617d)

2.15.1 (2022-09-30)

Bug Fixes

• pass correct campaign id (#333) (0181623)

2.15.0 (2022-09-28)

Features

• use shared task list (#330) (07fec0f)

2.14.2 (2022-09-28)

Bug Fixes

• fix transaction usage in wrapper (#331) (6213963)

2.14.1 (2022-09-27)

Bug Fixes

• fix backfill of tendlc_campaign ids (a288952)

2.14.0 (2022-09-27)

Features

• add 10DLC campaigns (#322) (6367c80)
• add 10DLC MNO metadata (#323) (dfc52e2)
• support TCR sending accounts (#321) (a67fcce)

Bug Fixes

• delete fresh phone commits when decmomissioning numbers (#329) (f27ff43)
• fix partial index for invalidating from number mappings (#328) (ca5e2f0)

2.13.3 (2022-09-19)

Bug Fixes

• resolve messages awaiting from numbers in task (#324) (12a4663)

2.13.2 (2022-09-19)

Bug Fixes

• add to_number to from_number_mappings backfill distinctness (e60a646)

2.13.1 (2022-09-19)

Bug Fixes

• add last_used_at to backfill (d22eb40)

2.13.0 (2022-09-19)

Features

• add prev mapping table (#311) (4b354d9)

Bug Fixes

• handle webhook 3xx redirects correctly (#318) (1424a62)

2.12.0 (2022-08-17)

Features

• slow down delivery reports (#317) (b435359)

Bug Fixes

• pg: override slonik ssl options (#307) (cf8d857)

2.11.4 (2022-08-08)

Bug Fixes

• poll-number-order: increase max attempts (#313) (0bd3bef)
• exit on unhandled promise rejection (#314) (b9ecf04)

2.11.3 (2022-07-28)

Bug Fixes

• bandwidth: fix down migration (6840ef4)

2.11.2 (2022-07-28)

Bug Fixes

• bandwidth: include migrations (6850ec4)

2.11.1 (2022-07-28)

Bug Fixes

• bandwidth: fix 10dlc campaign association (0ccf738)

2.11.0 (2022-07-28)

Features

• bandwidth: support 10dlc campaign tn association (#310) (d31fe76)

2.10.5 (2022-07-25)

Bug Fixes

• decomission-sending-location: avoid using named queues (#306) (38b78ce)

2.10.4 (2022-07-15)

Bug Fixes

• telnyx: support limiting number search quantity (#308) (a9057af)

2.10.3 (2022-06-27)

Bug Fixes

• telnyx: account for new error response (#304) (55ecd54)

2.10.2 (2022-06-24)

Bug Fixes

• bandwidth: handle no available numbers case (#303) (c4bfd0b)

2.10.1 (2022-06-03)

Bug Fixes

• bandwidth: claim number before initiating purchase order (#300) (bf68765)

2.10.0 (2022-05-07)

Features

• add service profiles (#283) (0572c16)

2.9.0 (2022-05-07)

Features

• allow configuring log level (#285) (dcfabe3)

Bug Fixes

• set explicit index name and fix down migration (#293) (d2cce32)
• tune querying pending number request capacity (#292) (b7f7a1f)

2.8.0 (2022-04-25)

Features

• add toll-free channel: relations and sending (#288) (87aa124)
• lookup: expose additional lrn data (#289) (ebd415a)

Bug Fixes

• update trigger security for creating sending locations (#290) (4b88f3b)

2.7.0 (2022-04-20)

Features

• add bandwidth service (#284) (1bdc9ca)

2.6.1 (2022-04-20)

2.6.0 (2022-04-01)

Features

• switch to service classes (#275) (4079122)

2.5.4 (2022-03-28)

Bug Fixes

• do not replace PhoneNumber scalar with String (#267) (7e8bfa6)
• handle delivery report with null error codes (#265) (0e71dd6)
• handle promise rejection in auth (#270) (f42e8cd), closes #260
• use 401 unauthorized response for missing token (#271) (4005961)

2.5.3 (2022-03-24)

Bug Fixes

• fix routing to support graphiql (#262) (b669aad)
• fix running dev:watch with nodemon (#261) (08c6344)
• lock down graphql schema (#263) (7299f48)

2.5.2 (2022-03-18)

Bug Fixes

• tg__sync_profile_provisioned: make security definer (#259) (192a025)

2.5.1 (2022-03-15)

Bug Fixes

• update typescript to fix build (a1b9ae1)

2.5.0 (2022-03-15)

Features

• codify grey route channel (#252) (aece7d3)

Bug Fixes

• pending-number-request-capacity: use new awaiting number table (#248) (5cb5093)
• send-message: handle invalid from number error (#256) (4bbf752)
• telnyx: set profile id in number order (#253) (d0d6bf1)

2.4.1 (2022-02-03)

Bug Fixes

• purchase-number: log twilio error message (#249) (ff21f87)

2.4.0 (2022-01-07)

Features

• add awaiting number table (#245) (a65f129)

2.3.1 (2021-12-31)

Bug Fixes

• auth: throw error from client ID resolver (#244) (9ccaad8)

2.3.0 (2021-11-11)

Features

• add attach_10dlc_campaign_to_profile (#240) (92e49dc)

Bug Fixes

• skip creating jobs during migration backfill (1415f9c)

2.2.0 (2021-09-29)

Features

• v2.x: support provisioning 10dlc numbers (#228) (15dc79e)

Bug Fixes

• 2.x: backfill twilio service ids (#236) (527c15e)
• 2.x: perf - avoid full routing table scans (#224) (4bff9a3)

2.1.2 (2021-08-13)

Bug Fixes

• v2.x: prevent duplicate number purchases (#213) (d099afe)

2.1.1 (2021-07-23)

Bug Fixes

• cast string to timestamp to fix queue-cost-backfill (#210) (d37b14e)

2.1.0 (2021-04-16)

⚠ BREAKING CHANGES

• timescaledb: Requires running against postgres database with timescale extension installed.

Features

• allow configuring per-number limits (#206) (e86e41d)
• timescaledb: use timescaledb (#203) (23e9bf3)

Bug Fixes

• perf improvements (#207) (6f028be)

2.0.0 (2021-04-06)

⚠ BREAKING CHANGES

• timescaledb: Requires running against postgres database with timescale extension installed.

Features

• allow configuring per-number limits (#206) (e86e41d)
• timescaledb: use timescaledb (#203) (23e9bf3)

1.18.0 (2021-03-12)

Features

• add migrations for stripe billing data (#93) (c46c6ae)
• add usage rollups (#198) (512ab03)
• docs: timescale designs (#201) (5bc2161)
• outbound_messages_routing: simply prev mapping idx (#174) (878a4ff)

Bug Fixes

• usage-rollups: unique periods (ee6afa5)
• fix syntax for queue-backfill-cost (#204) (c8df496)
• rollup usage (#205) (5265c6d)

1.17.0 (2021-03-09)

Features

• add usage rollups (#198) (512ab03)

1.16.0 (2021-03-05)

Features

• add migrations for stripe billing data (#93) (c46c6ae)

Bug Fixes

• fix syntax for queue-backfill-cost (#204) (c8df496)

1.15.0 (2021-02-26)

Features

• docs: timescale designs (#201) (5bc2161)
• outbound_messages_routing: simply prev mapping idx (#174) (878a4ff)

1.14.2 (2020-11-05)

Bug Fixes

• backfill-cost: oldRows update path (#197) (94e8f8d)

1.14.1 (2020-11-04)

Bug Fixes

• worker: dont run graphile worker if no tasks (c7c4af8)

1.14.0 (2020-10-29)

Features

• purchase-number: configurable concurrency (#192) (1fce891)

1.13.0 (2020-10-26)

Features

• purchase-number: use telnyx best effort (#183) (67aa467)
• send-message: move to higher concurrency assemble-worker (#180) (ba3a22e)
• send-message: perf logging (#186) (0a50bf6)

Bug Fixes

• perform send-message in transaction (#184) (f76e8e6)
• forward-delivery-report: better query (6887cff)
• forward-delivery-report: handle already updated delivery report (1c5ee22)
• forward-delivery-report: working query (8d9b621)
• fulfill-request: join on indexed column (#189) (924ac17)
• sell-number: one job at a time (#175) (3c008a5)
• worker: accidentally set concurrency to 1 (323a041)
• worker: remove final trailing comma (6aea527)
• add missing select (050f578)
• send-message: construct date with explicit UTC timezone (#178) (2f0dd27)

1.12.0 (2020-10-23)

Features

• forward-delivery-report: message id resoluton in forward job (#177) (eb2fd1d)
• process-message: make prev mapping validity configurable via env (#176) (aaa2a34)

1.11.1 (2020-10-20)

Bug Fixes

• forward-delivery-report: dont use unindexed routing.id (#173) (58d31b2)

1.11.0 (2020-10-20)

Features

• process-message: optionally skip old outbound messages check (5061312)
• process-message: optionally skip old outbound messages check (#171) (f565f9d)
• send-message: move to graphile worker (#168) (df38efd)
• backfill twilio cost (#167) (44e310b)

Bug Fixes

• resolve-delivery-reports: resolve bby firedate (#172) (380a49c)

1.10.0 (2020-10-14)

Features

• graphile-worker: env var concurrency (#166) (f20076d)

1.9.0 (2020-10-14)

Features

• outbound message routing (#162) (e816d4d)

Bug Fixes

• assemble task wrapping (#163) (e88f8db)
• drop or update old outbound_messages indexes (#164) (b003c6e)

1.8.1 (2020-10-13)

Bug Fixes

• assemble task wrapping (#163) (e88f8db)
• drop or update old outbound_messages indexes (#164) (b003c6e)

1.8.0 (2020-10-08)

Features

• outbound message routing (#162) (e816d4d)

1.7.0 (2020-10-02)

Features

• store network data separately (#159) (116cee1)

Bug Fixes

• reconcile prod schema (#155) (4eb1a08)

1.6.4 (2020-10-01)

Bug Fixes

• pass GraphileWorkerLogger instance (#157) (47b8ae3)
• worker: temp disable graphile logger (47be3c2)

1.6.3 (2020-09-25)

1.6.2 (2020-09-25)

1.6.1 (2020-09-24)

Bug Fixes

• send-message: positive validitiy period (2046fba)

1.6.0 (2020-09-24)

Features

• send-message: add send before parameter (#150) (d250bdf)

Bug Fixes

• worker: properly rollback transaction (0a079a8)

1.5.2 (2020-09-22)

Bug Fixes

• throw error if no order is created (#148) (e04a666)
• process-message: dont wrap in transaction (4c99941)

1.5.1 (2020-09-20)

1.5.0 (2020-09-20)

Features

• fresh_phone_commitments: remove truncated day (#143) (f195f23)
• phone-commitments: bring back with for update skip locked (#135) (2427c68)
• process-message: break out into js w/ timing (#138) (b0684ab)
• worker: control jobs to run with envvar (#142) (ceb2ff1)

1.4.0 (2020-09-17)

Features

• process-message: add statsd logs (#137) (930b606)

1.3.0 (2020-09-16)

Features

• phone-mappings: deprecate fresh_phone_commitments (#133) (9c1b736)
• process-message: post metrics (#136) (f36e797)

1.2.0 (2020-09-15)

Features

• outbound_messages: record cost of sent messages (#124) (82f8802)
• purchase-number: support voice urls (#127) (1fdbe2d)
• sending_locations: add activePhoneNumberCount computed column (#126) (926c6b0)
• backfill replies script (db0a20c)
• twilio sell all numbers script (0d64c72)

Bug Fixes

• poll-number-order: fall back on phone number status (#131) (ca53e69)
• replies: ignore inbound short-code messages (#129) (3ab0046)
• handle null telnyx cost property (#128) (58a783d)
• verify that delete requests succeeded (#123) (95b3f4c)

1.1.0 (2020-09-08)

Features

• sending_locations: add activePhoneNumberCount computed column (#126) (926c6b0)

Bug Fixes

• replies: ignore inbound short-code messages (#129) (3ab0046)

1.0.1 (2020-09-08)

Bug Fixes

• handle null telnyx cost property (#128) (58a783d)

1.0.0 (2020-09-07)

Features

• outbound_messages: record cost of sent messages (#124) (82f8802)
• purchase-number: support voice urls (#127) (1fdbe2d)
• backfill replies script (db0a20c)
• twilio sell all numbers script (0d64c72)

Bug Fixes

• verify that delete requests succeeded (#123) (95b3f4c)

0.1.10 (2020-07-07)

Bug Fixes

• await purchaseNumberTelnyx (0cce9d5)
• handle case when telnyx number is no longer available (a7557e0)
• throw error for no matching numbers (2e9a742)

0.1.9 (2020-07-07)

Features

• use jobs to poll for telnyx number order completion (#122) (3686e05)

0.1.8 (2020-07-03)

Bug Fixes

• forward delivery report extra (#120) (f482aae)

0.1.7 (2020-07-02)

Features

• handle twilio invalid destination number (af17934)
• purchase-number: find a new suitable area code on failure (#118) (ca35774)

Bug Fixes

• switch up and down migrations (0d090e1)

0.1.6 (2020-06-28)

Features

• handle known sendMessage error codes (#116) (9e06abd)
• send delivery report on service sent (#117) (ea856ae)

0.1.5 (2020-06-27)

Features

• pending_number_request_capacity: cache commitment counts (#107) (82aa73f)

Bug Fixes

• accept url shortener domain option (c332156)
• ensure sending locations have area codes (#114) (4b73407)
• handle case where to is array (d23b96e)
• log the complete error with context (#106) (a1ce97a)
• prevent divide by zero error in lookup progress (#112) (4df50c7)
• select the nearest sending locations (#113) (bb23c5f)

0.1.4 (2020-06-17)

Bug Fixes

• convert Errors to objects to log properly (66026bf)

0.1.3 (2020-06-17)

Bug Fixes

• reply error handling (#105) (a8f4607)
• set url shortener settings (#104) (5794bec)

0.1.2 (2020-06-15)

0.1.1 (2020-06-15)

Features

• create separate telnyx profiles for each client (#101) (0bf23fa)
• purchase-number: find a new suitable area code on failure (#96) (bbf1191)

Bug Fixes

• disable postgraphile query logging (#102) (9928318)
• ignore empty addPhoneNumbersToRequest payload (#95) (b0868fe)