Outbox with PostgreSQL

[Msirkovsky]

Hi,
first, thank you for the great work on this library. I’m wondering if there is an example showing how to implement the outbox pattern with PostgreSQL. I’m trying to send a command to the outbox using PostgreSQL.
My code:

services.AddBrighter(options =>
    {
        options.CommandProcessorLifetime = ServiceLifetime.Singleton;
        options.HandlerLifetime = ServiceLifetime.Transient;
    })
    .AutoFromAssemblies()
    .UseExternalBus(new RmqProducerRegistryFactory(
        new RmqMessagingGatewayConnection
        {
            Name = "MyCommandConnection",
            AmpqUri = amqpUriSpecification,
            Exchange = new Exchange("paramore.brighter.exchange", durable: true, supportDelay: false),
            DeadLetterExchange = new Exchange("paramore.brighter.exchange.dlq", durable: true, supportDelay: false),
            Heartbeat = 15,
            PersistMessages = true
        },
        [
            new RmqPublication
            {
                Topic = new RoutingKey("GreetingMade"),
                MaxOutStandingMessages = 5,
                MaxOutStandingCheckIntervalMilliSeconds = 500,
                WaitForConfirmsTimeOutInMilliseconds = 1000,
                MakeChannels = OnMissingChannel.Create
            }
        ]
    ).Create())
    .UsePostgreSqlOutbox(new PostgreSqlOutboxConfiguration(connectionString, outBoxTableName))

but, when I call
await commandProcessor.DepositPostAsync(randomCommand);
I'm getting:

Unhandled exception. System.InvalidOperationException: No async outbox defined.
   at Paramore.Brighter.CommandProcessor.DepositPostAsync[T](T request, IAmABoxTransactionConnectionProvider connectionProvider, Boolean continueOnCapturedContext, CancellationToken cancellationToken) in /_/src/Paramore.Brighter/CommandProcessor.cs:line 638
   at Paramore.Brighter.CommandProcessor.DepositPostAsync[T](T request, Boolean continueOnCapturedContext, CancellationToken cancellationToken) in /_/src/Paramore.Brighter/CommandProcessor.cs:line 608

Not sure what async outbox is. Thanks a lot.

[lillo42]

Hey @Msirkovsky, the current implementations of PostgreSQL outbox don't have support for async methods 😞 , today we are focused on V10, which should be released soon. and that version will have support to async

[Msirkovsky]

Ok, got it. Thanks for the information.

[jakoss]

I hope i'll get some story points next week on our project so i can create async version for v9, ticket: #3665