ื›ึผืขืก, ื‘ืึทืจื’ื™ื ื™ื ื’ ืื•ืŸ ื“ืขืคึผืจืขืกื™ืข ื•ื•ืขืŸ ืืจื‘ืขื˜ืŸ ืžื™ื˜ InfluxDB

ื›ึผืขืก, ื‘ืึทืจื’ื™ื ื™ื ื’ ืื•ืŸ ื“ืขืคึผืจืขืกื™ืข ื•ื•ืขืŸ ืืจื‘ืขื˜ืŸ ืžื™ื˜ InfluxDB

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

ืึธืคึผืœื™ื™ืงืขื ื•ื ื’: ื“ื™ ืœื™ืกื˜ืขื“ ื™ืฉื•ื– ืึทืคึผืœื™ื™ื– ืฆื• InfluxDB ื•ื•ืขืจืกื™ืข 1.7.4.

ืคืืจื•ื•ืืก ืฆื™ื™ื˜ ืกืขืจื™ืข?

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

ื‘ืฉืขืช ืึทื ืึทืœื™ื™ื–ื™ื ื’ ื˜ืจืึทื ื–ืึทืงืฉืึทื ื–, ืึท ื’ืขื“ืึทื ืง ื’ืขืงื•ืžืขืŸ ืึทืจื•ื™ืฃ: ืฆื• ื ื•ืฆืŸ ื“ื™ InfluxDB ืฆื™ื™ื˜ ืกืขืจื™ืข ื“ืึทื˜ืึทื‘ื™ื™ืก ื•ื•ื™ ื“ื™ ื”ื•ื™ืคึผื˜ ืกื˜ืึธืจื™ื“ื–ืฉ. ื˜ืจืึทื ื–ืึทืงืฉืึทื ื– ื–ืขื ืขืŸ ืฆื™ื™ื˜ ืฆื™ื™ื˜ ืื•ืŸ ื–ื™ื™ ืคึผืึทืกื™ืง ื’ืขื–ื•ื ื˜ ืื™ืŸ ื“ื™ ืฆื™ื™ื˜ ืกืขืจื™ืข ืžืึธื“ืขืœ.

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

ืขืก ืื™ื– ื’ืขื•ื•ืขืŸ ืึท ื‘ื™ืกืœ ืงืึทื ืคื™ื•ื–ื™ื ื’ ืึทื– ืึทื–ืึท ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื– ื–ืขื ืขืŸ ื™ื•ื–ืฉืึทื•ื•ืึทืœื™ ื’ืขื ื™ืฆื˜ ืคึฟืึทืจ ื“ื™ ืฆื™ืœ ืคื•ืŸ ืงืึทืœืขืงื˜ื™ื ื’ ืžืขื˜ืจื™ืงืก. ืžืึธื ื™ื˜ืึธืจื™ื ื’ ืคื•ืŸ ืกืขืจื•ื•ืขืจืก, ื™ืึธื˜ ื“ื™ื•ื•ื™ื™ืกืึทื–, ืึทืœืฅ ืคึฟื•ืŸ ื•ื•ืึธืก ืžื™ืœื™ืึทื ื– ืคื•ืŸ ืคื•ื ืงื˜ืŸ ืคื•ืŸ ื“ื™ ืคืึธืจืขื "ืœื•ื™ืคืŸ": [<ืฆื™ื™ื˜> - <ืžืขื˜ืจื™ืง ื•ื•ืขืจื˜>]. ืึธื‘ืขืจ ืื•ื™ื‘ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ืึทืจื‘ืขื˜ ื’ืขื–ื•ื ื˜ ืžื™ื˜ ืึท ื’ืจื•ื™ืก ื“ืึทื˜ืŸ ืœื•ื™ืคืŸ, ื•ื•ืึธืก ื–ืึธืœ ืึท ืงืœื™ื™ืŸ ื‘ืึทื ื“ ืคืึทืจืฉืึทืคืŸ ืคึผืจืึธื‘ืœืขืžืก? ืžื™ื˜ ื“ืขื ืื™ืŸ ื–ื™ื ืขืŸ, ืžื™ืจ ื’ืขื ื•ืžืขืŸ InfluxDB ืฆื• ืึทืจื‘ืขื˜ืŸ.

ื•ื•ืึธืก ืึทื ื“ืขืจืฉ ืื™ื– ื‘ืึทืงื•ื•ืขื ืื™ืŸ InfluxDB

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

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

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

ืื•ืŸ ื™ื ืคืœื•ืงืก ื•ื•ืขื˜ ื™ื ื“ื™ืคึผืขื ื“ืึทื ื˜ืœื™ ืจืขื“ื•ืฆื™ืจืŸ ื“ื™ ื’ืจื™ื™ืก ืคื•ืŸ ื“ื™ ื“ืึทื˜ืŸ ืื•ืŸ ื•ื™ืกืžืขืงืŸ ื•ืžื ื™ื™ื˜ื™ืง ื˜ื™ื ื’ื–.

ื•ื•ืขื’ืŸ ืกื˜ืึธืจื“ ื“ืึทื˜ืŸ

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

ืคึผืจืึธื‘ืœืขืžืก

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

1. ื“ื™ืœื™ื˜ื™ื ื’ ื“ืึทื˜ืŸ

ืขืก ืื™ื– ืึท ืกืขืจื™ืข ืคื•ืŸ โ€‹โ€‹ื“ืึทื˜ืŸ ืžื™ื˜ ื˜ืจืึทื ื–ืึทืงืฉืึทื ื–:

SELECT time, amount, block, symbol FROM transactions WHERE symbol='USDT'

ื“ืขืจ ืจืขื–ื•ืœื˜ืึทื˜:

ื›ึผืขืก, ื‘ืึทืจื’ื™ื ื™ื ื’ ืื•ืŸ ื“ืขืคึผืจืขืกื™ืข ื•ื•ืขืŸ ืืจื‘ืขื˜ืŸ ืžื™ื˜ InfluxDB

ืื™ืš ืฉื™ืงืŸ ืึท ื‘ืึทืคึฟืขืœ ืฆื• ื•ื™ืกืžืขืงืŸ ื“ืึทื˜ืŸ:

DELETE FROM transactions WHERE symbol=โ€™USDTโ€™

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

ืื™ืš ืคืจื•ื‘ื™ืจ ืื•ื™ืกืžืขืงืŸ ื“ื™ ื’ืื ืฆืข ื˜ื™ืฉ:

DROP MEASUREMENT transactions

ืื™ืš ื˜ืฉืขืง ื“ื™ ื˜ื™ืฉ ื•ื™ืกืžืขืงืŸ:

SHOW MEASUREMENTS

ืื™ืš ื˜ืึธืŸ ื ื™ื˜ ื–ืขืŸ ื“ื™ ื˜ื™ืฉ ืื™ืŸ ื“ืขืจ ืจืฉื™ืžื”, ืึธื‘ืขืจ ืึท ื ื™ื™ึทืข ื“ืึทื˜ืŸ ืึธื ืคึฟืจืขื’ ื ืึธืš ืงืขืจื˜ ื“ื™ ื–ืขืœื‘ืข ื’ืึทื ื’ ืคื•ืŸ ื˜ืจืึทื ื–ืึทืงืฉืึทื ื–.

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

ื•ื•ื™ ืึท ืจืขื–ื•ืœื˜ืึทื˜, ื“ื™ืœื™ื˜ื™ื ื’ ืื•ืŸ ื“ืึทืŸ ืจื™ืกื˜ืึธืจื™ื ื’ ื“ื™ ื’ืื ืฆืข ื“ืึทื˜ืึทื‘ื™ื™ืก ื’ืขื”ืึธืœืคึฟืŸ.

2. ืคืœืึธื•ื˜ื™ื ื’ ืคื•ื ื˜ ื ื•ืžืขืจืŸ

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

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

3. ืงืขืกื™ื™ื“ืขืจื“ื™ืง ืงื•ื•ื™ืจื™ื– ืงืขื ืขืŸ ื ื™ื˜ ื–ื™ื™ืŸ ืฆื•ื’ืขืคืืกื˜ ืฆื• ืคืึทืจืฉื™ื“ืขื ืข ืฆื™ื™ื˜ ื–ืึธื ืขืก

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

ืื™ืŸ ื™ื ืคืœื•ืงืกื“ื‘, ื•ื•ืขืŸ ืื™ืจ ื’ืจื•ืคึผื™ื ื’ ื“ื•ืจืš ืฆื™ื™ื˜, ืื™ืจ ืงืขื ืขืŸ ืื•ื™ืš ืกืคึผืขืฆื™ืคื™ืฆื™ืจืŸ ืึท ื™ื‘ืขืจืจื•ืง, ืœืžืฉืœ ืคึฟืึทืจ ืžืึธืกืงื•ื•ืข ืฆื™ื™ื˜ (UTC+3):

SELECT MEAN("supply") FROM transactions GROUP BY symbol, time(1d, 3h) fill(previous)

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

ื›ึผืขืก, ื‘ืึทืจื’ื™ื ื™ื ื’ ืื•ืŸ ื“ืขืคึผืจืขืกื™ืข ื•ื•ืขืŸ ืืจื‘ืขื˜ืŸ ืžื™ื˜ InfluxDB

ืฆื• ื•ื™ืกืžื™ื™ื“ืŸ ื“ืขื ืคึผืจืึธื‘ืœืขื, ืžื™ืจ ื˜ืขืžืคึผืขืจืขืจืึทืœื™ ืกื•ื•ื™ื˜ืฉื˜ ื“ื™ ื“ื™ื ืกื˜ ืฆื• UTC + 0.

4. ืคืึธืจืฉื˜ืขืœื•ื ื’

ืขืก ื–ืขื ืขืŸ ืคื™ืœืข ื‘ืขื ื˜ืฉืžืึทืจืงืก ืื•ื™ืฃ ื“ืขืจ ืื™ื ื˜ืขืจื ืขืฅ ื•ื•ืึธืก ืคืึทืจื’ืœื™ื™ึทื›ืŸ InfluxDB ืื•ืŸ ืื ื“ืขืจืข ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืื™ืŸ ืขืจืฉื˜ืขืจ ื‘ืœื™ืง, ื–ื™ื™ ื’ืขืงื•ืงื˜ ื•ื•ื™ ืคึฟืึทืจืงื•ื™ืฃ ืžืึทื˜ืขืจื™ืึทืœืก, ืึธื‘ืขืจ ืื™ืฆื˜ ืื™ืš ื˜ืจืึทื›ื˜ืŸ ืขืก ืื™ื– ืขื˜ืœืขื›ืข ืืžืช ืื™ืŸ ื–ื™ื™.

ืื™ืš ื•ื•ืขืœ ื“ื™ืจ ื“ืขืจืฆื™ื™ืœืŸ ืžื™ื™ืŸ ืคืึทืœ.

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

SELECT * FROM coins_info WHERE time <= NOW() GROUP BY symbol ORDER BY time DESC LIMIT 1

SELECT * FROM dominance_info ORDER BY time DESC LIMIT 1

SELECT * FROM transactions WHERE time >= NOW() - 24h ORDER BY time DESC

ื“ืขืจืงืœืขืจื•ื ื’:

  1. ืื™ืŸ ื“ืขืจ ืขืจืฉื˜ืขืจ ื‘ืงืฉื”, ืžื™ืจ ื‘ืึทืงื•ืžืขืŸ ื“ื™ ืœืขืฆื˜ืข ืคื•ื ืงื˜ืŸ ืคึฟืึทืจ ื™ืขื“ืขืจ ืžืึทื˜ื‘ื™ื™ืข ืžื™ื˜ ืžืึทืจืง ื“ืึทื˜ืŸ. ืึทื›ื˜ ืคื•ื ืงื˜ืŸ ืคึฟืึทืจ ืึทื›ื˜ ืงืึธื™ื ืก ืื™ืŸ ืžื™ื™ืŸ ืคืึทืœ.
  2. ื“ื™ ืฆื•ื•ื™ื™ื˜ืข ื‘ืงืฉื” ื‘ืืงื•ืžื˜ ืื™ื™ื ืข ืคื•ืŸ โ€‹โ€‹ื“ื™ ื ื™ื™ืข ื ืงื•ื“ื•ืช.
  3. ื“ื™ ื“ืจื™ื˜ ืจื™ืงื•ื•ืขืก ืึท ืจืฉื™ืžื” ืคื•ืŸ ื˜ืจืึทื ื–ืึทืงืฉืึทื ื– ืคึฟืึทืจ ื“ื™ ืœืขืฆื˜ืข XNUMX ืฉืขื”; ืขืก ืงืขืŸ ื–ื™ื™ืŸ ืขื˜ืœืขื›ืข ื”ื•ื ื“ืขืจื˜ ืคื•ืŸ ื–ื™ื™.

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

ืื™ืš ื”ืึธื‘ืŸ ืึท ื“ืจื•ืง ืคึผืจื•ื‘ื™ืจืŸ ืื•ื™ืฃ ื“ืขื ืึทืคึผื™ ืื•ืคึฟืŸ. ืคึฟืึทืจ 25 ืจืคึผืก, ื“ืขืจ ืกืขืจื•ื•ืขืจ ื“ืขืžืึทื ืกื˜ืจื™ื™ื˜ื™ื“ ืึท ืคื•ืœ ืžืึทืกืข ืคื•ืŸ โ€‹โ€‹ื–ืขืงืก ืงืคึผื•ืก:

ื›ึผืขืก, ื‘ืึทืจื’ื™ื ื™ื ื’ ืื•ืŸ ื“ืขืคึผืจืขืกื™ืข ื•ื•ืขืŸ ืืจื‘ืขื˜ืŸ ืžื™ื˜ InfluxDB

ืื™ืŸ ื“ืขืจ ื–ืขืœื‘ื™ืงืขืจ ืฆื™ื™ื˜, ื“ื™ NodeJs ืคึผืจืึธืฆืขืก ื”ืื˜ ื ื™ืฉื˜ ืฆื•ืฉื˜ืขืœืŸ ืงื™ื™ืŸ ืžืึทืกืข.

ื“ื™ ื“ื•ืจื›ืคื™ืจื•ื ื’ ื’ื™ื›ืงื™ื™ึทื˜ ื”ืื˜ ืฉื•ื™ืŸ ื“ื™ื’ืจื™ื™ื“ื™ื“ ื“ื•ืจืš 7-10 ืจืคึผืก: ืื•ื™ื‘ ืื™ื™ืŸ ืงืœื™ืขื ื˜ ืงืขืŸ ื‘ืึทืงื•ืžืขืŸ ืึท ืขื ื˜ืคืขืจ ืื™ืŸ 200 ืžื™ื–, 10 ืงืœื™ื™ืึทื ืฅ ื”ืึธื‘ืŸ ืฆื• ื•ื•ืึทืจื˜ืŸ ืึท ืจื’ืข. 25 ืจืคึผืก ืื™ื– ื“ื™ ืฉื™ืขื•ืจ ืื™ืŸ ื•ื•ืึธืก ืคืขืกื˜ืงื™ื™ึทื˜ ื’ืขืœื™ื˜ืŸ; 500 ืขืจืจืึธืจืก ื–ืขื ืขืŸ ืื•ืžื’ืขืงืขืจื˜ ืฆื• ืงืœื™ื™ืึทื ืฅ.

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

ืจืขื–ื•ืœื˜ืึทื˜

ื“ื™ ืžืขืจืกื˜ ื•ื•ื™ื›ื˜ื™ืง ืžืกืงื ื ืคื•ืŸ ื“ื™ ื“ืขืจืคืึทืจื•ื ื’ ืื™ื– ืึทื– ืื™ืจ ืงืขื ืขืŸ ื ื™ืฉื˜ ื ืขืžืขืŸ ืึทืŸ ืื•ืžื‘ืึทืงืึทื ื˜ ื˜ืขื›ื ืึธืœืึธื’ื™ืข ืื™ืŸ ืึท ืคึผืจื•ื™ืขืงื˜ ืึธืŸ ื’ืขื ื•ื’ ืึทื ืึทืœื™ืกื™ืก. ื ืคึผืฉื•ื˜ ื–ื™ืคึผื•ื ื’ ืคื•ืŸ ืขืคืขื ืขืŸ ื™ืฉื•ื– ืื•ื™ืฃ ื’ื™ื˜ื”ื•ื‘ ืงืขืŸ ืฆื•ืฉื˜ืขืœืŸ ืื™ื ืคึฟืึธืจืžืึทืฆื™ืข ืฆื• ื•ื™ืกืžื™ื™ื“ืŸ ื˜ืฉื•ื–ื™ื ื’ InfluxDB ื•ื•ื™ ื“ื™ ื”ื•ื™ืคึผื˜ ื“ืึทื˜ืŸ ืงืจืึธื.

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

ืื™ืจ ืงืขื ืขืŸ ืฉื•ื™ืŸ ื’ืขืคึฟื™ื ืขืŸ ื•ื•ืขืจืกื™ืข 2.0.0-ื‘ื™ืชื ืื™ืŸ ื“ื™ ืคึผืจื•ื™ืขืงื˜ ืจื™ืคึผืึทื–ืึทื˜ืึธืจื™; ืžื™ืจ ืงืขื ืขืŸ ื ืึธืจ ื”ืึธืคึฟืŸ ืึทื– ื“ื™ ืจื’ืข ื•ื•ืขืจืกื™ืข ื•ื•ืขื˜ ื”ืึธื‘ืŸ ื‘ืึทื˜ื™ื™ึทื˜ื™ืง ื™ืžืคึผืจื•ื•ื•ืžืึทื ืฅ. ืื™ืŸ ื“ืขืจ ื“ืขืจื•ื•ื™ื™ืœ, ืื™ืš ื•ื•ืขื˜ ื’ื™ื™ืŸ ืœืขืจื ืขืŸ ื“ื™ TimescaleDB ื“ืึทืงื™ื•ืžืขื ื˜ื™ื™ืฉืึทืŸ.

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

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