ืคึผืจืึธื”ืึธืกื˜ืขืจ > ื‘ืœืึธื’ > ืึทื“ืžื™ื ื™ืกื˜ืจืึทืฆื™ืข > ืžืขืกื™ื ื“ื–ืฉืขืจ ื“ืึทื˜ืึทื‘ื™ื™ืก (ื˜ื™ื™ืœ 2): ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’ "ืคึฟืึทืจ ื ื•ืฅ"

ืžืขืกื™ื ื“ื–ืฉืขืจ ื“ืึทื˜ืึทื‘ื™ื™ืก (ื˜ื™ื™ืœ 2): ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’ "ืคึฟืึทืจ ื ื•ืฅ"

ืžื™ืจ ื”ืึธื‘ืŸ ื”ืฆืœื—ื” ื“ื™ื–ื™ื™ื ื“ ื“ื™ ืกื˜ืจื•ืงื˜ื•ืจ ืคื•ืŸ ืื•ื ื“ื–ืขืจ PostgreSQL ื“ืึทื˜ืึทื‘ื™ื™ืก ืคึฟืึทืจ ืกื˜ืึธืจื™ื ื’ ืงืึธืจืขืกืคึผืึธื ื“ืขื ืฅ, ืึท ื™ืึธืจ ืื™ื– ื“ื•ืจื›ื’ืขื’ืื ื’ืขืŸ, ื™ื•ื–ืขืจื– ื–ืขื ืขืŸ ืึทืงื˜ื™ื•ื•ืœื™ ืคื™ืœื•ื ื’ ืขืก, ืื•ืŸ ืื™ืฆื˜ ืขืก ื›ึผื•ืœืœ ืžื™ืœื™ืึทื ื– ืคื•ืŸ ืจืขืงืึธืจื“ืก, ืื•ืŸ ... ืขืคึผืขืก ืื ื’ืขื”ื•ื™ื‘ืŸ ืฆื• ืคึผืึทืžืขืœืขืš.

ืžืขืกื™ื ื“ื–ืฉืขืจ ื“ืึทื˜ืึทื‘ื™ื™ืก (ื˜ื™ื™ืœ 2): ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’ "ืคึฟืึทืจ ื ื•ืฅ"
ืคืึทืงื˜ ืื™ื– ืึทื– ื•ื•ื™ ื“ื™ ื˜ื™ืฉ ื’ืจื™ื™ืก ื•ื•ืืงืกื˜, ืึทื–ื•ื™ ืื•ื™ืš ื“ื™ "ื˜ื™ืคืงื™ื™ึทื˜" ืคื•ืŸ ื“ื™ ื™ื ื“ืขืงืกื™ื–. โ€” ื›ืื˜ืฉ ืœืื’ืืจื™ื˜ืžื™ืฉ. ืึธื‘ืขืจ ืžื™ื˜ ืฆื™ื™ื˜, ื“ืึธืก ืคืึธืจืกืขืก ื“ื™ ืกืขืจื•ื•ืขืจ ืฆื• ื“ื•ืจื›ืคื™ืจืŸ ื“ื™ ื–ืขืœื‘ืข ืœื™ื™ืขื ืขืŸ / ืฉืจื™ื™ึทื‘ืŸ ื˜ืึทืกืงืก ืคึผืจืึธืฆืขืก ืคื™ืœืข ืžืึธืœ ืžืขืจ ื‘ืœืขื˜ืขืจ ืคื•ืŸ ื“ืึทื˜ืŸื•ื•ื™ ืื™ืŸ ื“ื™ ืึธื ื”ื™ื™ื‘.

ื“ืึธืก ืื™ื– ื•ื•ื• ืขืก ืงื•ืžื˜ ืฆื• ืจืึทื˜ืขื•ื•ืขืŸ ืกืขืงืฆื™ืข.

ืœืึธื–ืŸ ืžื™ืจ ื˜ืึธืŸ ืึทื– ืžื™ืจ ื–ืขื ืขืŸ ื ื™ืฉื˜ ื’ืขืจืขื“ื˜ ื•ื•ืขื’ืŸ ืฉืึทืจื“ื™ื ื’, ื“ืึธืก ืื™ื–, ื“ื™ืกื˜ืจื™ื‘ื™ื•ื˜ื™ื ื’ ื“ืึทื˜ืŸ ืฆื•ื•ื™ืฉืŸ ืคืึทืจืฉื™ื“ืขื ืข ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื– ืึธื“ืขืจ ืกืขืจื•ื•ืขืจืก. ื•ื•ื™ื™ึทืœ ืืคื™ืœื• ื“ื™ื˜ื™ื™ืœื“ ื“ื™ ื“ืึทื˜ืŸ ืื™ืŸ ืขื˜ืœืขื›ืข ืกืขืจื•ื•ืขืจืก, ืื™ืจ ื•ื•ืขื˜ ื ื™ืฉื˜ ื‘ืึทืงื•ืžืขืŸ ื‘ืึทืคืจื™ื™ึทืขืŸ ืคื•ืŸ ื“ื™ ืคึผืจืึธื‘ืœืขื ืคื•ืŸ "ืฉื•ื•ืขืœืŸ" ื™ื ื“ืขืงืกื™ื– ืื™ื‘ืขืจ ืฆื™ื™ึทื˜. ืขืก ืื™ื– ืงืœืึธืจ ืึทื– ืื•ื™ื‘ ืื™ืจ ืงืขื ืขืŸ ืคืึทืจื’ื™ื ืขื  ื–ื™ืš ืฆื• ืฉื˜ืขืœืŸ ืึท ื ื™ื™ึท ืกืขืจื•ื•ืขืจ ืื™ืŸ ืึธืคึผืขืจืึทืฆื™ืข ื™ืขื“ืขืจ ื˜ืึธื’, ื“ื™ื™ืŸ ืคึผืจืึธื‘ืœืขืžืก ื•ื•ืขื˜ ื ื™ื˜ ืžืขืจ ืœื™ื’ืŸ ืื™ืŸ ื“ื™ ืคืœืึทืš ืคื•ืŸ ืึท ืกืคึผืขืฆื™ืคื™ืฉ ื“ืึทื˜ืึทื‘ื™ื™ืก.

ืžื™ืจ ื•ื•ืขืœืŸ ื‘ืึทื˜ืจืึทื›ื˜ืŸ ื ื™ื˜ ืกืคึผืขืฆื™ืคื™ืฉ ืกืงืจื™ืคึผืก ืคึฟืึทืจ ื™ืžืคึผืœืึทืžืขื ื˜ื™ื™ืฉืึทืŸ ืคื•ืŸ ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’ "ืื™ืŸ ื™ื™ึทื–ื ื•ื•ืึทืจื’", ืึธื‘ืขืจ ื“ืขืจ ืฆื•ื’ืึทื ื’ ื–ื™ืš - ื•ื•ืึธืก ืื•ืŸ ื•ื•ื™ ื–ืึธืœ ื–ื™ื™ืŸ "ืฉื ื™ื™ึทื“ืŸ ืื™ืŸ ืกืœื™ื™ืกื™ื–", ืื•ืŸ ื•ื•ืึธืก ืึทื–ืึท ืึท ืคืึทืจืœืึทื ื’ ืคื™ืจื˜ ืฆื•.

ื‘ืึทื’ืจื™ืฃ

ืœืึธืžื™ืจ ื“ืขืคื™ื ื™ืจืŸ ืื•ื ื“ื–ืขืจ ืฆื™ืœ ื•ื•ื™ื“ืขืจ: ืžื™ืจ ื•ื•ื™ืœืŸ ืฆื• ืžืึทื›ืŸ ื–ื™ื›ืขืจ ืึทื– ื”ื™ื™ึทื ื˜, ืžืึธืจื’ืŸ ืื•ืŸ ืื™ืŸ ืึท ื™ืึธืจ, ื“ื™ ืกื•ืžืข ืคื•ืŸ โ€‹โ€‹โ€‹โ€‹ื“ืึทื˜ืŸ ืœื™ื™ืขื ืขืŸ ื“ื•ืจืš PostgreSQL ื‘ืขืฉืึทืก ืงื™ื™ืŸ ืœื™ื™ืขื ืขืŸ / ืฉืจื™ื™ึทื‘ืŸ ืึธืคึผืขืจืึทืฆื™ืข ื‘ืœื™ื™ื‘ื˜ ื‘ืขืขืจืขืš ื“ืขืจ ื–ืขืœื‘ื™ืงืขืจ.

ืคึฟืึทืจ ืงื™ื™ืŸ ืงืจืึทื ืึทืœืึทื“ื–ืฉื™ืงืœื™ ืึทืงื™ื•ืžื™ืึทืœื™ื™ื˜ื™ื“ ื“ืึทื˜ืŸ ( ืึทืจื˜ื™ืงืœืขืŸ, ื“ืึธืงื•ืžืขื ื˜ืŸ, ืœืึธื’ืก, ืึทืจืงื™ื™ื•ื•ื–, ...) ื“ื™ ื ืึทื˜ื™ืจืœืขืš ื‘ืจื™ืจื” ื•ื•ื™ ืึท ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’ ืฉืœื™ืกืœ ืื™ื– ื’ืขืฉืขืขื ื™ืฉ ื˜ืึธื’ / ืฆื™ื™ื˜. ืื™ืŸ ืื•ื ื“ื–ืขืจ ืคืึทืœ, ืึทื–ืึท ืึท ื’ืขืฉืขืขื ื™ืฉ ืื™ื– ืžืึธืžืขื ื˜ ืคื•ืŸ ืฉื™ืงืŸ ื“ืขื ืึธื ื–ืึธื’.

ื‘ืึทืžืขืจืงื•ื ื’ ืึทื– ื ื™ืฆืขืจืก ื›ึผืžืขื˜ ืฉื˜ืขื ื“ื™ืง ืึทืจื‘ืขื˜ ื‘ืœื•ื™ื– ืžื™ื˜ ื“ื™ "ืœืขืฆื˜ืข" ืึธื ืขืก ืึทื–ืึท ื“ืึทื˜ืŸ - ื–ื™ื™ ืœื™ื™ืขื ืขืŸ ื“ื™ ืœืขืฆื˜ืข ืึทืจื˜ื™ืงืœืขืŸ, ืึทื ืึทืœื™ื™ื– ื“ื™ ืœืขืฆื˜ืข ืœืึธื’ืก, ... ื ื™ื™ืŸ, ืึทื•ื•ื“ืื™, ื–ื™ื™ ืงืขื ืขืŸ ืžืขื’ื™ืœืข ื•ื•ื™ื™ึทื˜ืขืจ ืฆื•ืจื™ืง ืื™ืŸ ืฆื™ื™ื˜, ืึธื‘ืขืจ ื–ื™ื™ ื˜ืึธืŸ ื“ืึธืก ื–ื™ื™ืขืจ ื–ืขืœื˜ืŸ.

ืคื•ืŸ ื“ื™ ืงืึทื ืกื˜ืจื™ื™ื ืฅ ืขืก ืื™ื– ืงืœืึธืจ ืึทื– ื“ื™ ืึธืคึผื˜ื™ืžืึทืœ ืึธื ื–ืึธื’ ืœื™ื™ื–ื•ื ื’ ื•ื•ืึธืœื˜ ื–ื™ื™ืŸ "ื˜ืขื’ืœืขืš" ืกืขืงืฉืึทื ื– - ื ืึธืš ืึทืœืข, ืื•ื ื“ื–ืขืจ ื‘ืึทื ื™ืฆืขืจ ื•ื•ืขื˜ ื›ึผืžืขื˜ ืฉื˜ืขื ื“ื™ืง ืœื™ื™ืขื ืขืŸ ื•ื•ืึธืก ื’ืขืงื•ืžืขืŸ ืฆื• ืื™ื "ื”ื™ื™ึทื ื˜" ืึธื“ืขืจ "ื ืขื›ื˜ืŸ".

ืื•ื™ื‘ ืžื™ืจ ืฉืจื™ื™ื‘ืŸ ืื•ืŸ ืœื™ื™ืขื ืขืŸ ื›ึผืžืขื˜ ื‘ืœื•ื™ื– ืื™ืŸ ืื™ื™ืŸ ืึธืคึผื˜ื™ื™ืœื•ื ื’ ื‘ืขืฉืึทืก ื“ืขื ื˜ืึธื’, ื“ืึธืก ื’ื™ื˜ ืื•ื ื“ื– ืื•ื™ืš ืžืขืจ ืขืคืขืงื˜ื™ื•ื• ื ื•ืฆืŸ ืคื•ืŸ ื–ื›ึผืจื•ืŸ ืื•ืŸ ื“ื™ืกืง - ื–ื™ื ื˜ ืึทืœืข ืึธืคึผื˜ื™ื™ืœื•ื ื’ ื™ื ื“ืขืงืกื™ื– ืœื™ื™ื›ื˜ ืคึผืึทืกื™ืง ืื™ืŸ ื“ื™ ื‘ืึทืจืึทืŸ, ืื™ืŸ ืงืึทื ื˜ืจืึทืกื˜ ืฆื• ื“ื™ "ื’ืจื•ื™ืก ืื•ืŸ ืคืขื˜" ืึธื ืขืก ืื™ื‘ืขืจ ื“ื™ ื˜ื™ืฉ.

ืฉืจื™ื˜-ืคึฟืึทืจ-ืฉืจื™ื˜

ืื™ืŸ ืึทืœื’ืขืžื™ื™ืŸ, ืึทืœืฅ ื’ืขื–ืึธื’ื˜ ืื•ื™ื‘ืŸ ืกืึธื•ื ื“ืก ื•ื•ื™ ืื™ื™ืŸ ืงืขืกื™ื™ื“ืขืจื“ื™ืง ื ื•ืฅ. ืื•ืŸ ืขืก ืื™ื– ืึทื˜ืฉื™ื•ื•ืึทื‘ืึทืœ, ืึธื‘ืขืจ ืคึฟืึทืจ ื“ืขื ืžื™ืจ ื•ื•ืขืœืŸ ื”ืึธื‘ืŸ ืฆื• ืคึผืจื•ื‘ื™ืจืŸ ืฉื•ื•ืขืจ - ื•ื•ื™ื™ึทืœ ื“ืขืจ ื‘ืึทืฉืœื•ืก ืฆื• ืฆืขื˜ื™ื™ืœืŸ ืื™ื™ื ืขืจ ืคื•ืŸ ื“ื™ ืขื ื˜ื™ื˜ื™ื– ืคื™ืจื˜ ืฆื• ื“ื™ ื ื•ื™ื˜ ืฆื• "ื’ืขื–ืขืŸ" ื“ื™ ืคึฟืึทืจื‘ื•ื ื“ืŸ.

ืึธื ื–ืึธื’, ื–ื™ื™ึทืŸ ืคึผืจืึธืคึผืขืจื˜ื™ืขืก ืื•ืŸ ืคึผืจืึทื“ื–ืฉืขืงืฉืึทื ื–

ื–ื™ื ื˜ ืžื™ืจ ื‘ืึทืฉืœืึธืกืŸ ืฆื• ืฉื ื™ื™ึทื“ืŸ ืึทืจื˜ื™ืงืœืขืŸ ื“ื•ืจืš ื“ืึทื˜ืขืก, ืขืก ืžืื›ื˜ ื–ื™ื ืขืŸ ืฆื• ื˜ื™ื™ืœืŸ ื“ื™ ืขื ื˜ื™ื˜ื™ื–-ืคึผืจืึธืคึผืขืจื˜ื™ืขืก ื•ื•ืึธืก ืึธืคืขื ื’ืขืŸ ืื•ื™ืฃ ื–ื™ื™ (ืึทื˜ืึทื˜ืฉื˜ ื˜ืขืงืขืก, ืจืฉื™ืžื” ืคื•ืŸ ืจื™ืกื™ืคึผื™ืึทื ืฅ), ืื•ืŸ ืื•ื™ืš ื“ื•ืจืš ื“ืึทื˜ืข ืคื•ืŸ โ€‹โ€‹ืึธื ื–ืึธื’.

ื–ื™ื ื˜ ืื™ื™ื ืขืจ ืคื•ืŸ ืื•ื ื“ื–ืขืจ ื˜ื™ืคึผื™ืฉ ื˜ืึทืกืงืก ืื™ื– ืคึผื•ื ืงื˜ ื•ื•ื™ื•ื™ื ื’ ืึธื ื–ืึธื’ ืจืขื“ื–ืฉื™ืกื˜ืขืจื– (ืึทื ืจืขื“, ื™ื ืงืึทืžื™ื ื’, ืึทืœืข), ืขืก ืื™ื– ืื•ื™ืš ืœืึทื“ื–ืฉื™ืงืึทืœ ืฆื• "ืฆื™ืขืŸ ื–ื™ื™ ืื™ืŸ" ืื™ืŸ ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’ ื“ื•ืจืš ืึธื ื–ืึธื’ ื“ืึทื˜ืขืก.

ืžืขืกื™ื ื“ื–ืฉืขืจ ื“ืึทื˜ืึทื‘ื™ื™ืก (ื˜ื™ื™ืœ 2): ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’ "ืคึฟืึทืจ ื ื•ืฅ"

ืžื™ืจ ืœื™ื™ื’ืŸ ื“ื™ ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’ ืฉืœื™ืกืœ (ืึธื ื–ืึธื’ ื“ืึทื˜ืข) ืฆื• ืึทืœืข ื˜ื™ืฉืŸ: ืจื™ืกื™ืคึผื™ืึทื ืฅ, ื˜ืขืงืข, ืจืขื’ื™ืกื˜ืจื™ื–. ืื™ืจ ื˜ืึธืŸ ื ื™ื˜ ื”ืึธื‘ืŸ ืฆื• ืœื™ื™ื’ืŸ ืขืก ืฆื• ื“ื™ ืึธื ื–ืึธื’ ื–ื™ืš, ืึธื‘ืขืจ ื ื•ืฆืŸ ื“ื™ ื™ื’ื–ื™ืกื˜ื™ื ื’ DateTime.

ืกื•ื’ื™ื•ืช

ื–ื™ื ื˜ ืขืก ืื™ื– ื‘ืœื•ื™ื– ืื™ื™ืŸ ื˜ืขืžืข ืคึฟืึทืจ ืขื˜ืœืขื›ืข ืึทืจื˜ื™ืงืœืขืŸ, ืขืก ืื™ื– ืงื™ื™ืŸ ื•ื•ืขื’ ืฆื• "ืฉื ื™ื™ึทื“ืŸ" ืขืก ืื™ืŸ ื“ืขืจ ื–ืขืœื‘ื™ืงืขืจ ืžืึธื“ืขืœ; ืื™ืจ ื”ืึธื‘ืŸ ืฆื• ืคืึทืจืœืึธื–ื  ืื•ื™ืฃ ืขืคึผืขืก ืึทื ื“ืขืจืฉ. ืื™ืŸ ืื•ื ื“ื–ืขืจ ืคืึทืœ ืขืก ืื™ื– ื™ื“ืขืึทืœ ื“ืึทื˜ืข ืคื•ืŸ โ€‹โ€‹ืขืจืฉื˜ืขืจ ืึธื ื–ืึธื’ ืื™ืŸ ืงืึธืจืขืกืคึผืึธื ื“ืขื ืฅ โ€” ื“ืึธืก ื”ืฒืกื˜, ื“ืขืจ ืžืึธืžืขื ื˜ ืคึฟื•ืŸ ืฉืึทืคื•ื ื’, ืื™ืŸ ื“ืขืจ ืืžืชืŸ, ืคึฟื•ืŸ ื“ืขืจ ื˜ืขืžืข.

ืžืขืกื™ื ื“ื–ืฉืขืจ ื“ืึทื˜ืึทื‘ื™ื™ืก (ื˜ื™ื™ืœ 2): ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’ "ืคึฟืึทืจ ื ื•ืฅ"

ืœื™ื™ื’ ื“ื™ ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’ ืฉืœื™ืกืœ (ื˜ืขืžืข ื“ืึทื˜ืข) ืฆื• ืึทืœืข ื˜ื™ืฉืŸ: ื˜ืขืžืข, ื‘ืึทื˜ื™ื™ืœื™ืงื˜ืขืจ.

ืื‘ืขืจ ืื™ืฆื˜ ืžื™ืจ ื”ืึธื‘ืŸ ืฆื•ื•ื™ื™ ืคืจืื‘ืœืขืžืขืŸ ืื™ืŸ ืึทืžืึธืœ:

  • ืื™ืŸ ื•ื•ืึธืก ืึธืคึผื˜ื™ื™ืœื•ื ื’ ื–ืึธืœ ืื™ืš ืงื•ืงืŸ ืคึฟืึทืจ ืึทืจื˜ื™ืงืœืขืŸ ืื•ื™ืฃ ื“ืขืจ ื˜ืขืžืข?
  • ืื™ืŸ ื•ื•ืขืœื›ืข ืึธืคึผื˜ื™ื™ืœื•ื ื’ ื–ืึธืœ ืื™ืš ื–ื•ื›ืŸ ื“ื™ ื˜ืขืžืข ืคึฟื•ืŸ ื“ืขืจ ืึธื ื–ืึธื’?

ืžื™ืจ ืงืขื ืขืŸ, ืคื•ืŸ ืงื•ืจืก, ืคืึธืจื–ืขืฆืŸ ืฆื• ื–ื•ื›ืŸ ืื™ืŸ ืึทืœืข ืกืขืงืฉืึทื ื–, ืึธื‘ืขืจ ื“ืึธืก ื•ื•ืขื˜ ื–ื™ื™ืŸ ื–ื™ื™ืขืจ ื˜ืจื•ื™ืขืจื™ืง ืื•ืŸ ื•ื•ืขื˜ ืึธืคึผื ื™ื™ื’ืŸ ืึทืœืข ืื•ื ื“ื–ืขืจ ื•ื•ื™ื ื™ื ื’ื–. ื“ืขืจื™ื‘ืขืจ, ืื™ืŸ ืกื“ืจ ืฆื• ื•ื•ื™ืกืŸ ื•ื•ื• ืคึผื•ื ืงื˜ ืฆื• ืงื•ืงืŸ, ืžื™ืจ ื•ื•ืขืœืŸ ืžืึทื›ืŸ ืœืึทื“ื–ืฉื™ืงืึทืœ ืคึฟืึทืจื‘ื™ื ื“ื•ื ื’ืขืŸ / ืคึผื•ื™ื ื˜ืขืจื– ืฆื• ืกืขืงืฉืึทื ื–:

  • ืžื™ืจ ื•ื•ืขืœืŸ ืœื™ื™ื’ืŸ ืื™ืŸ ื“ื™ ืึธื ื–ืึธื’ ื˜ืขืžืข ื“ืึทื˜ืข ืคืขืœื“
  • ืœืึธืžื™ืจ ืฆื•ื’ืขื‘ืŸ ืฆื• ื“ืขืจ ื˜ืขืžืข ืึธื ื–ืึธื’ ื“ืึทื˜ืข ืฉื˜ืขืœืŸ ื“ืขื ืงืึธืจืขืกืคึผืึธื ื“ืขื ืฅ (ืงืขืŸ ื–ื™ื™ืŸ ืึท ื‘ืึทื–ื•ื ื“ืขืจ ื˜ื™ืฉ ืึธื“ืขืจ ืึท ืงื™ื™ื˜ ืคื•ืŸ ื“ืึทื˜ืขืก)

ืžืขืกื™ื ื“ื–ืฉืขืจ ื“ืึทื˜ืึทื‘ื™ื™ืก (ื˜ื™ื™ืœ 2): ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’ "ืคึฟืึทืจ ื ื•ืฅ"

ื–ื™ื ื˜ ืขืก ื•ื•ืขื˜ ื–ื™ื™ืŸ ื•ื•ื™ื™ื ื™ืง ืžืึธื“ื™ืคื™ืงืึทื˜ื™ืึธื ืก ืฆื• ื“ืขืจ ืจืฉื™ืžื” ืคื•ืŸ ืึธื ื–ืึธื’ ื“ืึทื˜ืขืก ืคึฟืึทืจ ื™ืขื“ืขืจ ื™ื—ื™ื“ ืงืึธืจืขืกืคึผืึธื ื“ืขื ืฅ (ื ืึธืš ืึทืœืข, ื›ึผืžืขื˜ ืึทืœืข ืึทืจื˜ื™ืงืœืขืŸ ืคืึทืœืŸ ืื•ื™ืฃ 1-2 ืฉื›ื™ื™ื ื™ืฉ ื˜ืขื’), ืื™ืš ื•ื•ืขืœ ืคืึธืงื•ืก ืื•ื™ืฃ ื“ืขื ืึธืคึผืฆื™ืข.

ืื™ืŸ ื’ืึทื ืฅ, ื“ื™ ืกื˜ืจื•ืงื˜ื•ืจ ืคื•ืŸ ืื•ื ื“ื–ืขืจ ื“ืึทื˜ืึทื‘ื™ื™ืก ื’ืขื ื•ืžืขืŸ ื“ื™ ืคืืœื’ืขื ื“ืข ืคืึธืจืขื, ื’ืขื ื•ืžืขืŸ ืื™ืŸ ื—ืฉื‘ื•ืŸ ืคึผืึทืจื˜ื™ืฉืึทื ื–:

ื˜ื™ืฉืŸ: RU, ืื•ื™ื‘ ืื™ืจ ื”ืึธื‘ืŸ ืึท ืขืงืœ ืฆื• ื“ื™ ืกื™ืจื™ืœืœื™ืง ืืœืคืื‘ืขื˜ ืื™ืŸ ื“ื™ ื ืขืžืขืŸ ืคื•ืŸ ื˜ื™ืฉืŸ / ืคืขืœื“ืขืจ, ืขืก ืื™ื– ื‘ืขืกืขืจ ื ื™ืฉื˜ ืฆื• ืงื•ืงืŸ

-- ัะตะบั†ะธะธ ะฟะพ ะดะฐั‚ะต ัะพะพะฑั‰ะตะฝะธั
CREATE TABLE "ะกะพะพะฑั‰ะตะฝะธะต_YYYYMMDD"(
  "ะกะพะพะฑั‰ะตะฝะธะต"
    uuid
      PRIMARY KEY
, "ะขะตะผะฐ"
    uuid
, "ะ”ะฐั‚ะฐะขะตะผั‹"
    date
, "ะะฒั‚ะพั€"
    uuid
, "ะ”ะฐั‚ะฐะ’ั€ะตะผั" -- ะธัะฟะพะปัŒะทัƒะตะผ ะบะฐะบ ะดะฐั‚ัƒ
    timestamp
, "ะขะตะบัั‚"
    text
);

CREATE TABLE "ะะดั€ะตัะฐั‚_YYYYMMDD"(
  "ะ”ะฐั‚ะฐะกะพะพะฑั‰ะตะฝะธั"
    date
, "ะกะพะพะฑั‰ะตะฝะธะต"
    uuid
, "ะŸะตั€ัะพะฝะฐ"
    uuid
, PRIMARY KEY("ะกะพะพะฑั‰ะตะฝะธะต", "ะŸะตั€ัะพะฝะฐ")
);

CREATE TABLE "ะคะฐะนะป_YYYYMMDD"(
  "ะ”ะฐั‚ะฐะกะพะพะฑั‰ะตะฝะธั"
    date
, "ะคะฐะนะป"
    uuid
      PRIMARY KEY
, "ะกะพะพะฑั‰ะตะฝะธะต"
    uuid
, "BLOB"
    uuid
, "ะ˜ะผั"
    text
);

CREATE TABLE "ะ ะตะตัั‚ั€ะกะพะพะฑั‰ะตะฝะธะน_YYYYMMDD"(
  "ะ”ะฐั‚ะฐะกะพะพะฑั‰ะตะฝะธั"
    date
, "ะ’ะปะฐะดะตะปะตั†"
    uuid
, "ะขะธะฟะ ะตะตัั‚ั€ะฐ"
    smallint
, "ะ”ะฐั‚ะฐะ’ั€ะตะผั"
    timestamp
, "ะกะพะพะฑั‰ะตะฝะธะต"
    uuid
, PRIMARY KEY("ะ’ะปะฐะดะตะปะตั†", "ะขะธะฟะ ะตะตัั‚ั€ะฐ", "ะกะพะพะฑั‰ะตะฝะธะต")
);
CREATE INDEX ON "ะ ะตะตัั‚ั€ะกะพะพะฑั‰ะตะฝะธะน_YYYYMMDD"("ะ’ะปะฐะดะตะปะตั†", "ะขะธะฟะ ะตะตัั‚ั€ะฐ", "ะ”ะฐั‚ะฐะ’ั€ะตะผั" DESC);

-- ัะตะบั†ะธะธ ะฟะพ ะดะฐั‚ะต ั‚ะตะผั‹
CREATE TABLE "ะขะตะผะฐ_YYYYMMDD"(
  "ะ”ะฐั‚ะฐะขะตะผั‹"
    date
, "ะขะตะผะฐ"
    uuid
      PRIMARY KEY
, "ะ”ะพะบัƒะผะตะฝั‚"
    uuid
, "ะะฐะทะฒะฐะฝะธะต"
    text
);

CREATE TABLE "ะฃั‡ะฐัั‚ะฝะธะบะขะตะผั‹_YYYYMMDD"(
  "ะ”ะฐั‚ะฐะขะตะผั‹"
    date
, "ะขะตะผะฐ"
    uuid
, "ะŸะตั€ัะพะฝะฐ"
    uuid
, PRIMARY KEY("ะขะตะผะฐ", "ะŸะตั€ัะพะฝะฐ")
);

CREATE TABLE "ะ”ะฐั‚ั‹ะกะพะพะฑั‰ะตะฝะธะนะขะตะผั‹_YYYYMMDD"(
  "ะ”ะฐั‚ะฐะขะตะผั‹"
    date
, "ะขะตะผะฐ"
    uuid
      PRIMARY KEY
, "ะ”ะฐั‚ะฐ"
    date
);

ื”ื™ื˜ ืึท ืฉื™ื™ืŸ ืคึผืขื ื™

ื ื•, ื•ื•ืึธืก ืื•ื™ื‘ ืžื™ืจ ื ื•ืฆืŸ ื ื™ื˜ ืงืœืึทืกื™ืฉ ืกืขืงืฉืึทืŸ ืึธืคึผืฆื™ืข ื‘ืื–ื™ืจื˜ ืื•ื™ืฃ ื“ื™ ืคืึทืจืฉืคึผืจื™ื™ื˜ื•ื ื’ ืคื•ืŸ ืคืขืœื“ ื•ื•ืึทืœื•ืขืก (ื“ื•ืจืš ื˜ืจื™ื’ืขืจื– ืื•ืŸ ื™ืจื•ืฉื” ืึธื“ืขืจ PARTITION BY), ืื•ืŸ "ืžืึทื ื™ื•ืึทืœื™" ืื•ื™ืฃ ื“ื™ ืึทืคึผืœืึทืงื™ื™ืฉืึทืŸ ืžื“ืจื’ื”, ืื™ืจ ื•ื•ืขื˜ ื‘ืึทืžืขืจืงืŸ ืึทื– ื“ื™ ื•ื•ืขืจื˜ ืคื•ืŸ ื“ื™ ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’ ืฉืœื™ืกืœ ืื™ื– ืฉื•ื™ืŸ ืกื˜ืึธืจื“ ืื™ืŸ ื“ื™ ื ืึธืžืขืŸ ืคื•ืŸ ื“ื™ ื˜ื™ืฉ ื–ื™ืš.

ืึทื–ื•ื™ ืื•ื™ื‘ ืื™ืจ ื–ืขื ื˜ ืึทื–ื•ื™ ื–ืขื ื˜ ืื™ืจ ื–ื™ื™ืขืจ ื‘ืึทื–ืึธืจื’ื˜ ื•ื•ืขื’ืŸ ื“ื™ ืกื•ืžืข ืคื•ืŸ โ€‹โ€‹ื“ืึทื˜ืŸ ืกื˜ืึธืจื“?, ื“ืขืžืึธืœื˜ ืื™ืจ ืงืขื ืขืŸ ื‘ืึทืงื•ืžืขืŸ ื‘ืึทืคืจื™ื™ึทืขืŸ ืคื•ืŸ ื“ื™ "ืขืงืกื˜ืจืข" ืคืขืœื“ืขืจ ืื•ืŸ ืึทื“ืจืขืก ืกืคึผืขืฆื™ืคื™ืฉ ื˜ื™ืฉืŸ. ืืžืช, ืึทืœืข ืกืึทืœืขืงืฉืึทื ื– ืคื•ืŸ ืขื˜ืœืขื›ืข ืกืขืงืฉืึทื ื– ืื™ืŸ ื“ืขื ืคืึทืœ ื•ื•ืขื˜ ื–ื™ื™ืŸ ื˜ืจืึทื ืกืคืขืจื“ ืฆื• ื“ื™ ืึทืคึผืœืึทืงื™ื™ืฉืึทืŸ ื–ื™ื™ึทื˜.

ืžืงื•ืจ: www.habr.com

ืœื™ื™ื’ืŸ ืึท ื‘ืึทืžืขืจืงื•ื ื’