select distinct json_metadata->>'UserId'
from events
where
(json_metadata->>'UserId')::text is not null
and (json_metadata->>'UserId')::text not like '%-%-%'
limit 1000;
is it the old "it needs to be fully flexible... [6 months passes] ... same old 3 reports being hammered daily" applecart?
That shit is in full effect here.
Npgsql.NpgsqlException: Npgsql.NpgsqlException : FATAL: 53300: sorry, too many clients already
SHOW max_connections;
then put that in your connection string
DROP DATABASE cannot be executed from a function or multi-command string
urgh
var nextCheckpoint = !events.IsEnd ? events.NextCheckpoint : events.StreamEvents.Last().Checkpoint;
.NextCheckpoint
probably should not be null right?
await dbConnection.ExecuteAsync("UPDATE projections.checkpoint SET checkpoint = @checkpoint;", new { checkpoint = nextCheckpoint.ToString() });
i'm just doing this at the moment
var nextCheckpoint = events.IsEnd ? Checkpoint.End : events.NextCheckpoint;
return new AllEventsPage(
allEventsSlice.FromPosition.ToString(),
allEventsSlice.NextPosition.ToString(),
allEventsSlice.IsEndOfStream,
GetReadDirection(allEventsSlice.ReadDirection),
events);
so we're assuming that allEventsSlice.NextPosition is never null