Unix Timestamp vs ISO 8601 for Discord Bots: Database Architecture Guide

-- Recommended Schema for Discord Event Scheduler in PostgreSQL
CREATE TABLE guild_scheduled_events (
    id BIGSERIAL PRIMARY KEY,
    guild_id BIGINT NOT NULL,
    event_name VARCHAR(128) NOT NULL,
    start_time TIMESTAMPTZ NOT NULL,
    created_at TIMESTAMPTZ DEFAULT NOW()
);

-- Create an efficient B-Tree index for upcoming event queries
CREATE INDEX idx_events_start_time ON guild_scheduled_events (start_time);

-- Query upcoming events and extract epoch seconds for Discord message
SELECT 
    id,
    event_name,
    start_time,
    EXTRACT(EPOCH FROM start_time)::BIGINT AS discord_epoch
FROM guild_scheduled_events
WHERE start_time > NOW()
ORDER BY start_time ASC
LIMIT 10;

// Mongoose Schema for Discord Moderation Mutes
const muteSchema = new mongoose.Schema({
  guildId: { type: String, required: true },
  userId: { type: String, required: true },
  expiresAt: { type: Date, required: true }, // Native BSON Date
  reason: String
});

// Compound index for querying active mutes
muteSchema.index({ guildId: 1, expiresAt: 1 });

// Helper method to generate Discord dynamic timestamp
muteSchema.methods.getDiscordTag = function() {
  const epoch = Math.floor(this.expiresAt.getTime() / 1000);
  return `<t:${epoch}:R>`;
};

// Schedule a giveaway announcement at target epoch
await redis.zadd('event_queue', targetEpochSeconds, JSON.stringify({
  channelId: '102938475610293847',
  message: 'Giveaway entry window has ended!'
}));

// Worker polling loop (runs every 5 seconds)
const now = Math.floor(Date.now() / 1000);
const dueEvents = await redis.zrangebyscore('event_queue', 0, now);

for (const eventJson of dueEvents) {
  const event = JSON.parse(eventJson);
  await client.channels.cache.get(event.channelId)?.send(event.message);
  await redis.zrem('event_queue', eventJson);
}