ืคึผืจืึธื”ืึธืกื˜ืขืจ > ื‘ืœืึธื’ > ืื™ื ื˜ืขืจื ืขื˜ ื ื™ื™ึทืขืก > ืžืขืœื“ื•ื ื’ ืคื•ืŸ DBMS SQLite 3.28

ืžืขืœื“ื•ื ื’ ืคื•ืŸ DBMS SQLite 3.28

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

ื”ื•ื™ืคึผื˜ ืขื ื“ืขืจื•ื ื’ืขืŸ:

  • ื™ืงืกืคึผืึทื ื“ื™ื“ ืคึฟืขื ืฆื˜ืขืจ ืคืึทื ื’ืงืฉืึทื ื– (ืคึฟืขื ืฆื˜ืขืจ ืคืึทื ื’ืงืฉืึทื ื– ืึธื“ืขืจ ืึทื ืึทืœื™ืกื™ืก ืคืึทื ื’ืงืฉืึทื ื– ื•ื•ืึธืก ืœืึธื–ืŸ ื™ืขื“ืขืจ ืจื•ื“ืขืจืŸ ืคื•ืŸ ืึท ืึธื ืคึฟืจืขื’ ืฆื• ื“ื•ืจื›ืคื™ืจืŸ ื—ืฉื‘ื•ื ื•ืช ืžื™ื˜ ืื ื“ืขืจืข ืจืึธื•ื–): ืฆื•ื’ืขื’ืขื‘ืŸ ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ืื•ื™ืกื“ืจื•ืง ื•ื™ืกืฉืœื™ืกืŸ, ืขืก ืื™ื– ื’ืขื•ื•ืืจืŸ ืžืขื’ืœืขืš ืฆื• ื ื•ืฆืŸ ืงื™ื™ื˜ืŸ ืคึฟืขื ืฆื˜ืขืจ ืคืึทื ื’ืงืฉืึทื ื– (ืื™ื™ืŸ ืคึฟืขื ืฆื˜ืขืจ ืื™ื– ื“ื™ืคื™ื™ื ื“ ืื™ืŸ ื“ืขืจ ื’ืขื’ื ื˜ ืคื•ืŸ ืื ื“ืขืจืŸ), ืฆื•ื’ืขืฉื˜ืขืœื˜ ืฉื˜ื™ืฆืŸ ื’ืจื•ืคึผื™ื ื’ื– ื ื™ืฆืŸ ื“ื™ GROUP ืื•ื™ืกื“ืจื•ืง, ืื•ืŸ RANGE ืจื™ืกื˜ืจื™ืงืฉืึทื ื– ื–ืขื ืขืŸ ื™ืžืคึผืœืึทืžืขื ืึทื“ PRECEDING ะธ ื•ื•ื™ื™ึทื˜ืขืจื“ื™ืง;
  • ื™ืžืคึผืจื•ื•ื•ื“ ื™ืžืคึผืœืึทืžืขื ื˜ื™ื™ืฉืึทืŸ ืคื•ืŸ ื“ื™ ื‘ืึทืคึฟืขืœ "ื•ื•ืึทืงื•ื•ื ืื™ืŸ", ื•ื•ืึธืก ืงืขื ืขืŸ ืื™ืฆื˜ ื–ื™ื™ืŸ ื’ืขื•ื•ื™ื™ื ื˜ ืžื™ื˜ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื– ื‘ื ื™ืžืฆื ืื™ืŸ ืœื™ื™ืขื ืขืŸ-ื‘ืœื•ื™ื– ืžืึธื“ืข;
  • ืฆื•ื’ืขืœื™ื™ื’ื˜ ื ื™ื™ึทืข ืึธื ืคึฟืจืขื’ ืึธืคึผื˜ื™ืžื™ื–ืึทื˜ื™ืึธื ืก: ืึทืงืกืขืœืขืจื™ื™ื˜ื™ื“ ืึธืคึผืขืจืึทืฆื™ืข ืคื•ืŸ โ€‹โ€‹โ€‹โ€‹LIKE ืื•ื™ืกื“ืจื•ืงืŸ ืฆื•ื–ืึทืžืขืŸ ืžื™ื˜ ื“ื™ ESCAPE ืงื™ื•ื•ืขืจื“ ืื•ืŸ ื•ื•ืขืŸ ื“ื™ "PRAGMA case_sensitive_like" ืžืึธื“ืข ืื™ื– ืขื ื™ื™ื‘ืึทืœื“. ืื™ืŸ ื“ืขื ื‘ื™ื™ึทื–ื™ื™ึทืŸ ืคื•ืŸ ื˜ื™ื™ืœ ืื™ื ื“ืขืงืก ื•ืžื ื™ื™ื˜ื™ืง ื˜ืฉืขืงืก ืคื•ืŸ ื“ืึธืš ืืžืช ื˜ื ืึธื™ื ืกืคึผืขืกื™ืคื™ืขื“ ืื™ืŸ ื“ื™ WHERE ืคึผื•ื ืงื˜ ื–ืขื ืขืŸ ื™ืœื™ืžืึทื ื™ื™ื˜ืึทื“;
  • ื“ืขืจ ื‘ืึทืคึฟืขืœ ".ืคืืจืืžืขื˜ืขืจยป ืคึฟืึทืจ ื“ื™ ืึทืจื‘ืขื˜ ืึทื˜ืึทื˜ืฉื˜ ืกืึทื‘ืกื˜ื™ื˜ื•ืฉืึทื ื– (ืžืึทืกืงืก ืกืึทื‘ืกื˜ืึทื˜ื•ื˜ืึทื“ ืื™ืŸ ืงื™ื™ืŸ ืกืงืœ ืื•ื™ืกื“ืจื•ืงืŸ). ืื™ืŸ ื“ื™ ".ืึทืจื›ื™ื™ื•ื•" ื‘ืึทืคึฟืขืœ, ื“ื™ "--ืึทืคึผื“ื™ื™ื˜" ืึธืคึผืฆื™ืข ืื™ื– ืจื™ื“ื™ื–ื™ื™ื ื“, ื•ื•ืึธืก ืื™ืฆื˜ ื”ืึธืคึผืงืขืŸ ืื•ืžื’ืขืขื ื“ืขืจื˜ ื˜ืขืงืขืก ืฉื•ื™ืŸ ืื™ืŸ ื“ื™ ืึทืจืงื™ื™ื•ื•, ืื•ืŸ ื“ื™ "--ื™ื ืกืขืจื˜" ืึธืคึผืฆื™ืข ืื™ื– ืฆื•ื’ืขืœื™ื™ื’ื˜ ืฆื• ืึทืจื™ื™ึทื ื ืขืžืขืŸ ื˜ืขืงืขืก ืื™ืŸ ื“ื™ ืึทืจืงื™ื™ื•ื•;
  • ื“ืขืจืฆื• ืฆื•ื’ืขื’ืขื‘ืŸ fossildelta.c, ื•ื•ืึธืก ืึทืœืึทื•ื– ืื™ืจ ืฆื• ืฉืึทืคึฟืŸ, ืฆื•ืœื™ื™ื’ืŸ ืื•ืŸ ื“ื™ืกืึทืกืขืžื‘ืึทืœ ืคึฟืึธืจืžืึทื˜ ืคืึธืกืกื™ืœ ื“ืขืœื˜ืึท ืขื ื“ืขืจื•ื ื’ืขืŸ ื’ืขื ื™ืฆื˜ ืื™ืŸ ื“ื™ RBU ืคืึทืจืœืขื ื’ืขืจื•ื ื’;
  • ื’ืขื•ื•ืืงืกืŸ ืจื™ืœื™ื™ืึทื‘ื™ืœืึทื˜ื™ ืคื•ืŸ ืืจื‘ืขื˜ืŸ ืžื™ื˜ ื“ืึทืžื™ื“ื–ืฉื“ ื“ืึทื˜ืึทื‘ื™ื™ืก ื˜ืขืงืขืก;
  • ื ืฉืคึผื™ื’ืœ ืคื•ืŸ ื“ื™ ืคึผืจื•ื™ืขืงื˜ ืจื™ืคึผืึทื–ืึทื˜ืึธืจื™ ืื™ื– ืœืึธื ื˜ืฉื˜ ืื•ื™ืฃ ื’ื™ื˜ื”ื•ื‘ (ื™ืงืขืจื“ื™ืง ืจื™ืคึผืึทื–ืึทื˜ืึธืจื™ ื’ืขืฉื˜ื™ืฆื˜ ื ื™ืฆืŸ ื•ื•ืขืจืกื™ืข ืงืึธื ื˜ืจืึธืœ Fossil, ื‘ืืฉืืคืŸ ื“ื•ืจืš ื“ืขืจ ืžื—ื‘ืจ ืคื•ืŸ SQLite).

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

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