ืžืขืœื“ื•ื ื’ ืคื•ืŸ rqlite 6.0, ืึท ืคื•ื ืื ื“ืขืจื’ืขื˜ื™ื™ืœื˜, ืฉื•ืœื“-ื˜ืึธืœืขืจืึทื ื˜ DBMS ื‘ืื–ื™ืจื˜ ืื•ื™ืฃ SQLite

ื“ื™ ืžืขืœื“ื•ื ื’ ืคื•ืŸ ื“ื™ ืคื•ื ืื ื“ืขืจื’ืขื˜ื™ื™ืœื˜ DBMS rqlite 6.0 ืื™ื– ื“ืขืจืœืื ื’ื˜, ื•ื•ืึธืก ื ื™ืฆื˜ SQLite ื•ื•ื™ ืึท ืกื˜ืึธืจื™ื“ื–ืฉ ืžืึธื˜ืึธืจ ืื•ืŸ ืึทืœืึทื•ื– ืื™ืจ ืฆื• ืึธืจื’ืึทื ื™ื–ื™ืจืŸ ื“ื™ ืึทืจื‘ืขื˜ ืคื•ืŸ ืึท ืงื ื•ื™ืœ ืคึฟื•ืŸ ืกื˜ืึธืจื™ื“ื–ืฉ ืกื™ื ื’ืงืจืึทื ื™ื™ื–ื“ ืžื™ื˜ ื™ืขื“ืขืจ ืื ื“ืขืจืขืจ. ืื™ื™ื ืขืจ ืคื•ืŸ ื“ื™ ืคึฟืขื™ึดืงื™ื™ื˜ืŸ ืคื•ืŸ rqlite ืื™ื– ื“ื™ ื™ื– ืคื•ืŸ ื™ื ืกื˜ืึทืœื™ืจื•ื ื’, ื“ื™ืคึผืœื•ื™ืžืึทื ื˜ ืื•ืŸ ื•ื™ืฉืึทืœื˜ ืคื•ืŸ ืึท ืคื•ื ืื ื“ืขืจื’ืขื˜ื™ื™ืœื˜ ืฉื•ืœื“-ื˜ืึธืœืขืจืึทื ื˜ ืกื˜ืึธืจื™ื“ื–ืฉ, ืขืคึผืขืก ืขื ืœืขืš ืฆื• ืขื˜ืง ืื•ืŸ ืงืึธื ืกื•ืœ, ืึธื‘ืขืจ ื ื™ืฆืŸ ืึท ืจื™ืœื™ื™ืฉืึทื ืึทืœ ื“ืึทื˜ืŸ ืžืึธื“ืขืœ ืึทื ืฉื˜ืึธื˜ ืคื•ืŸ ืึท ืฉืœื™ืกืœ / ื•ื•ืขืจื˜ ืคึฟืึธืจืžืึทื˜. ื“ื™ ืคึผืจื•ื™ืขืงื˜ ืงืึธื“ ืื™ื– ื’ืขืฉืจื™ื‘ืŸ ืื™ืŸ Go ืื•ืŸ ืคื•ื ืื ื“ืขืจื’ืขื˜ื™ื™ืœื˜ ืื•ื ื˜ืขืจ ื“ื™ MIT ื“ืขืจืœื•ื™ื‘ืขื ื™ืฉ.

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

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

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

ืคึฟืขื™ึดืงื™ื™ื˜ืŸ ืคื•ืŸ rqlite:

  • ื’ืจื™ื ื’ ืฆื• ืฆืขื•ื•ื™ืงืœืขืŸ ืึท ืงื ื•ื™ืœ, ืึธืŸ ื“ื™ ื ื•ื™ื˜ ืคึฟืึทืจ ืึท ื‘ืึทื–ื•ื ื“ืขืจ ืกืงืœื™ื˜ืข ื™ื ืกื˜ืึทืœื™ืจื•ื ื’.
  • ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ื’ืขืฉื•ื•ื™ื ื“ ื‘ืึทืงื•ืžืขืŸ ืจืขืคึผืœื™ืงื™ื™ื˜ื™ื“ ืกืงืœ ืกื˜ืึธืจื™ื“ื–ืฉ.
  • ื’ืจื™ื™ื˜ ืคึฟืึทืจ ื ื•ืฆืŸ ืื™ืŸ ืืจื‘ืขื˜ืŸ ืคึผืจืึทื“ื–ืฉืขืงืก (ืคึผืจืึธื“ื•ืงืฆื™ืข-ืžื™ื™ื ื•ื ื’).
  • ื“ื™ ื‘ื™ื™ึทื–ื™ื™ึทืŸ ืคื•ืŸ ืึท HTTP (S) API ื•ื•ืึธืก ืึทืœืึทื•ื– ืื™ืจ ืฆื• ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงืŸ ื“ืึทื˜ืŸ ืื™ืŸ ืคึผืขืงืœ ืžืึธื“ืข ืื•ืŸ ื‘ืึทืฉื˜ื™ืžืขืŸ ื“ื™ ืœื™ื“ื™ื ื’ ื ืึธื“ืข ืคื•ืŸ โ€‹โ€‹ื“ืขื ืงื ื•ื™ืœ. ืขืก ืื•ื™ืš ื’ื™ื˜ ืึท ื‘ืึทืคึฟืขืœ ืฉื•ืจื” ืฆื•ื‘ื™ื ื“ ืื•ืŸ ื“ื™ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ื ื•ืฆืŸ ืคืึทืจืฉื™ื“ืŸ ืงืœื™ืขื ื˜ ืœื™ื™ื‘ืจืขืจื™ื– ื’ืขื‘ื•ื™ื˜ ืคึฟืึทืจ SQLite.
  • ืึทื•ื•ืึทื™ืœืึทื‘ื™ืœื™ื˜ื™ ืคื•ืŸ ืึท ื“ื™ื ืกื˜ ืคึฟืึทืจ ื™ื™ื“ืขื ื˜ืึทืคื™ื™ื™ื ื’ ืื ื“ืขืจืข ื ืึธื•ื“ื–, ืึทืœืึทื•ื™ื ื’ ืื™ืจ ืฆื• ืฉืึทืคึฟืŸ ืงืœืึทืกื˜ืขืจื– ื“ื™ื ืึทืžื™ืงืึทืœืœื™.
  • ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ืขื ืงืจื™ืคึผื˜ื™ื ื’ ื“ืึทื˜ืŸ ื•ื•ืขืงืกืœ ืฆื•ื•ื™ืฉืŸ ื ืึธื•ื“ื–.
  • ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ืงืึทื ืคื™ื’ื™ืขืจ ื“ื™ ืžื“ืจื’ื” ืคื•ืŸ ืงืึธื ื˜ืจืึธืœื™ืจื•ื ื’ ื“ื™ ืฉื™ื™ื›ื•ืช ืื•ืŸ ืงืึธื ืกื™ืกื˜ืขื ืกื™ ืคื•ืŸ ื“ืึทื˜ืŸ ื•ื•ืขืŸ ืœื™ื™ืขื ืขืŸ.
  • ืึทืคึผืฉืึทื ืึทืœ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ืคืึทืจื‘ื™ื ื“ืŸ ื ืึธื•ื“ื– ืื™ืŸ ืœื™ื™ืขื ืขืŸ-ื‘ืœื•ื™ื– ืžืึธื“ืข, ื•ื•ืึธืก ื˜ืึธืŸ ื ื™ื˜ ืึธื ื˜ื™ื™ืœ ื ืขืžืขืŸ ืื™ืŸ ื“ื™ื˜ืขืจืžืึทื ื™ื ื’ ืงืึธื ืกืขื ืกื•ืก ืื•ืŸ ื–ืขื ืขืŸ ื’ืขื ื™ืฆื˜ ืฆื• ืคืึทืจื’ืจืขืกืขืจืŸ ื“ื™ ืกืงืึทืœืึทื‘ื™ืœื™ื˜ื™ ืคื•ืŸ ื“ื™ ืงื ื•ื™ืœ ืคึฟืึทืจ ืœื™ื™ืขื ืขืŸ ืึทืคึผืขืจื™ื™ืฉืึทื ื–.
  • ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ื“ื™ื™ืŸ ืื™ื™ื’ืขื ืข ืคืึธืจืขื ืคื•ืŸ ื˜ืจืึทื ื–ืึทืงืฉืึทื ื– ื‘ืื–ื™ืจื˜ ืื•ื™ืฃ ืงืึทืžื‘ื™ื™ื ื™ื ื’ ืงืึทืžืึทื ื“ื– ืื™ืŸ ืื™ื™ืŸ ื‘ืขื˜ืŸ (ื˜ืจืึทื ื–ืึทืงืฉืึทื ื– ื‘ืื–ื™ืจื˜ ืื•ื™ืฃ BEGIN, COMMIT, ROLLBACK, SAVEPOINT ืื•ืŸ RELEASE ื–ืขื ืขืŸ ื ื™ืฉื˜ ื’ืขืฉื˜ื™ืฆื˜).
  • ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ืงืจื™ื™ื™ื˜ื™ื ื’ ื”ื™ื™ืก ื‘ืึทืงืึทืคึผืก.

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

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

ืžืงื•ืจ: opennet.ru

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