ื“ื™ libSQL ืคึผืจื•ื™ืขืงื˜ ืกื˜ืึทืจื˜ืขื“ ื“ืขื•ื•ืขืœืึธืคึผื™ื ื’ ืึท ื’ืึธืคึผืœ ืคื•ืŸ ื“ื™ SQLite DBMS

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

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

ืฆื•ื•ื™ืฉืŸ ื“ื™ ื™ื™ื“ื™ืึทื– ืคึฟืึทืจ ืžืขื’ืœืขืš ื™ืงืกืคึผืึทื ืฉืึทืŸ ืคื•ืŸ SQLite ืคืึทื ื’ืงืฉืึทื ืึทืœื™ื˜ื™ ื–ืขื ืขืŸ ื“ืขืจืžืื ื˜:

  • ื™ื ืึทื’ืจื™ื™ืฉืึทืŸ ืคื•ืŸ ืžื›ืฉื™ืจื™ื ืฆื• ื‘ื•ื™ืขืŸ ืคื•ื ืื ื“ืขืจื’ืขื˜ื™ื™ืœื˜ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื– ืึทืคึผืขืจื™ื™ื˜ื™ื ื’ ืื•ื™ืฃ ื“ืขืจ ืžื“ืจื’ื” ืคื•ืŸ ื“ืขืจ ื‘ื™ื‘ืœื™ืึธื˜ืขืง ื–ื™ืš, ืื•ืŸ ื ื™ืฉื˜ ื“ื•ืจืš ืจืขืคึผืœืึทืงื™ื™ืฉืึทืŸ ืคื•ืŸ ืขื ื“ืขืจื•ื ื’ืขืŸ ืื™ืŸ ื“ื™ ื˜ืขืงืข ืกื™ืกื˜ืขื (LiteFS), ืื•ืŸ ืึธืŸ ื“ื™ ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’ ืคื•ืŸ ืึท ื‘ืึทื–ื•ื ื“ืขืจ ืคึผืจืึธื“ื•ืงื˜ (dqlite, rqlite, ChiselStore).
  • ืึธืคึผื˜ื™ืžื™ื–ืึทื˜ื™ืึธืŸ ืคึฟืึทืจ ื ื•ืฆืŸ ืคื•ืŸ ื™ื™ืกื™ื ื’ืงืจืึทื ืึทืก ืึทืคึผื™ืก, ืึทื–ืึท ื•ื•ื™ ื“ื™ io_uring ืฆื•ื‘ื™ื ื“ ืฆื•ื’ืขืฉื˜ืขืœื˜ ื“ื•ืจืš ื“ื™ ืœื™ื ื•ืงืก ืงืขืจืŸ.
  • ื“ื™ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ื ื•ืฆืŸ SQLite ืื™ืŸ ื“ื™ ืœื™ื ื•ืงืก ืงืขืจืŸ, ืขื ืœืขืš ืฆื• ื“ื™ eBPF ื•ื•ื™ืจื˜ื•ืึทืœ ืžืึทืฉื™ืŸ ืงืขืจืŸ ืฉื˜ื™ืฆืŸ, ืคึฟืึทืจ ืกื™ื˜ื•ืึทื˜ื™ืึธื ืก ื•ื•ื• ืขืก ืื™ื– ื ื™ื™ื˜ื™ืง ืฆื• ืจืึทื˜ืขื•ื•ืขืŸ ื“ืึทื˜ืŸ ืฉื˜ืขืœื˜ ืคื•ืŸ ื“ื™ ืงืขืจืŸ ื•ื•ืึธืก ื˜ืึธืŸ ื ื™ื˜ ืคึผืึทืกื™ืง ืื™ืŸ ื‘ืึทืจืึทืŸ.
  • ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ื‘ืึทื ื™ืฆืขืจ-ื“ื™ืคื™ื™ื ื“ ืคืึทื ื’ืงืฉืึทื ื– ื’ืขืฉืจื™ื‘ืŸ ืื™ืŸ ืงื™ื™ืŸ ืคึผืจืึธื’ืจืึทืžืžื™ื ื’ ืฉืคึผืจืึทืš ืื•ืŸ ืงืึทืžืคึผื™ื™ืœื“ ืื™ืŸ ื•ื•ืขื‘ืึทืกืกืขืžื‘ืœื™ ื™ื ื˜ืขืจืžื™ื“ื™ื™ื˜ ืงืึธื“.

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

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