Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
import { useTranslation } from "react-i18next";
import { HumanizeTs } from "@/components/HumanizeTs";
import { useAppDatabaseMetadata } from "@/hooks/useAppDatabaseMetadata";
import { getTimeForPbTimestampProtoEs } from "@/types";
import { Engine, State } from "@/types/proto-es/v1/common_pb";
import {
type Database,
SyncStatus,
} from "@/types/proto-es/v1/database_service_pb";
import {
getDatabaseEngine,
instanceV1HasCollationAndCharacterSet,
} from "@/utils";
export function DatabaseOverviewInfo({ database }: { database: Database }) {
const { t } = useTranslation();
const databaseEngine = getDatabaseEngine(database);
const databaseSchemaMetadata = useAppDatabaseMetadata(database.name);
const lastSyncMs = getTimeForPbTimestampProtoEs(database.successfulSyncTime);
return (
<div className="rounded-sm border border-block-border px-5 py-4">
<dl
className="grid grid-cols-1 gap-x-4 gap-y-4 sm:grid-cols-2"
data-label="bb-database-overview-description-list"
>
{instanceV1HasCollationAndCharacterSet(databaseEngine) && (
<>
<div className="col-span-1 col-start-1">
<dt className="text-sm font-medium text-control-light">
{databaseEngine === Engine.POSTGRES
? t("db.encoding")
: t("db.character-set")}
</dt>
<dd className="mt-1 text-sm text-main">
{databaseSchemaMetadata.characterSet}
</dd>
</div>
<div className="col-span-1">
<dt className="text-sm font-medium text-control-light">
{t("db.collation")}
</dt>
<dd className="mt-1 text-sm text-main">
{databaseSchemaMetadata.collation}
</dd>
</div>
</>
)}
<div className="col-span-1 col-start-1">
<dt className="text-sm font-medium text-control-light">
{t("database.sync-status")}
</dt>
<dd className="mt-1 text-sm text-main">
{database.syncStatus === SyncStatus.FAILED ? (
<>
<span className="text-error">
{t("database.sync-status-failed")}
</span>
<p className="mt-1 text-xs text-control-light">
{database.syncError}
</p>
</>
) : database.state === State.ACTIVE ? (
t("common.ok")
) : (
t("error-page.not-found")
)}
</dd>
</div>
<div className="col-span-1">
<dt className="text-sm font-medium text-control-light">
{t("database.last-sync")}
</dt>
<dd className="mt-1 text-sm text-main">
{lastSyncMs !== undefined ? <HumanizeTs tsMs={lastSyncMs} /> : "-"}
</dd>
</div>
</dl>
</div>
);
}