ပရောဂျက် - မှန်ကန်သော Database ကို ရွေးချယ်ခြင်း

function chooseDatabaseType(scenario) {
  if (scenario.needsVectorSearch) {
    return {
      type: "Relational/document store + vector database (e.g. Postgres + pgvector)",
      reason: "app data needs relations, but similarity search over embeddings needs a vector index alongside it"
    };
  }
  if (scenario.needsComplexRelations) {
    return {
      type: "Relational (SQL) database",
      reason: "joins across authors, posts, comments, and tags need referential integrity and multi-table JOINs"
    };
  }
  if (scenario.needsSimpleKeyValueCache) {
    return {
      type: "Key-value store (e.g. Redis)",
      reason: "sub-millisecond reads/writes on simple key lookups matter more than relationships"
    };
  }
  if (scenario.needsFlexibleFastWrites) {
    return {
      type: "Document database (NoSQL)",
      reason: "flexible, fast-changing message shape and high write throughput fit a schema-less document model"
    };
  }
  return {
    type: "Relational (SQL) database",
    reason: "default to SQL when no specialized access pattern dominates"
  };
}

const scenarios = {
  blog: {
    needsComplexRelations: true,
    needsFlexibleFastWrites: false,
    needsSimpleKeyValueCache: false,
    needsVectorSearch: false
  },
  chat: {
    needsComplexRelations: false,
    needsFlexibleFastWrites: true,
    needsSimpleKeyValueCache: false,
    needsVectorSearch: false
  },
  cache: {
    needsComplexRelations: false,
    needsFlexibleFastWrites: false,
    needsSimpleKeyValueCache: true,
    needsVectorSearch: false
  },
  rag: {
    needsComplexRelations: false,
    needsFlexibleFastWrites: false,
    needsSimpleKeyValueCache: false,
    needsVectorSearch: true
  }
};

Object.entries(scenarios).forEach(([name, s]) => {
  const result = chooseDatabaseType(s);
  console.log(`${name}: ${result.type}\n  -> ${result.reason}`);
});