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

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

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

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

  • ืฆื•ื’ืขื’ืขื‘ืŸ ื“ื™ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ื ื•ืฆืŸ ื“ืขื ืื•ื™ืกื“ืจื•ืง "ืคื™ืœื˜ืขืจยป ืžื™ื˜ ื’ืขืžื™ื™ื ื–ืึทื ืคืึทื ื’ืงืฉืึทื ื–, ื•ื•ืึธืก ืžืื›ื˜ ืขืก ืžืขื’ืœืขืš ืฆื• ื‘ืึทื’ืจืขื ืขืฆืŸ ื“ื™ ืงืึทื•ื•ืขืจื™ื“ื–ืฉ ืคื•ืŸ ื“ืึทื˜ืŸ ืคึผืจืึทืกืขืกื˜ ื“ื•ืจืš ื“ื™ ื’ืขืžื™ื™ื ื–ืึทื ืคื•ื ืงืฆื™ืข ืฆื• ื‘ืœื•ื™ื– ืจืขืงืึธืจื“ืก ื•ื•ืึธืก ื‘ืึทืคืจื™ื“ื™ืงืŸ ืึท ื’ืขื’ืขื‘ืŸ ืฆื•ืฉื˜ืึทื ื“;
  • ื“ื™ "ORDER BY" ื‘ืœืึธืง ื’ื™ื˜ ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ื“ื™ "NULLS ืขืจืฉื˜ืขืจ"ืื•ืŸ"NULLS ืœืขืฆื˜ืขยป ืฆื• ื‘ืึทืฉื˜ื™ืžืขืŸ ื“ืขื ืึธืจื˜ ืคื•ืŸ ืขืœืขืžืขื ื˜ืŸ ืžื™ื˜ ืึท NULL ื•ื•ืขืจื˜ ื•ื•ืขืŸ ืกืึธืจื˜ื™ื ื’;
  • ื“ืขืจ ื‘ืึทืคึฟืขืœ ".ืขืจื”ื•ื™ืœืŸยป ืฆื• ื•ืžืงืขืจืŸ ื“ื™ ืื™ื ื”ืึทืœื˜ ืคื•ืŸ ื“ืึทืžื™ื“ื–ืฉื“ ื˜ืขืงืขืก ืคึฟื•ืŸ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก;
  • ืื™ืŸ ื™ืงืกืคึผืึทื ืฉืึทืŸ UBI ืฉื˜ื™ืฆืŸ ืฆื•ื’ืขื’ืขื‘ืŸ ื™ื ื“ืขืงืกื™ื ื’ ืื•ื™ืกื“ืจื•ืงืŸ;
  • PRAGMA index_info ืื•ืŸ PRAGMA index_xinfo ื”ืึธื‘ืŸ ืฉื•ื™ืŸ ืขืงืกื˜ืขื ื“ืขื“ ืฆื• ืฆื•ืฉื˜ืขืœืŸ ืื™ื ืคึฟืึธืจืžืึทืฆื™ืข ื•ื•ืขื’ืŸ ื“ื™ ืกื˜ืึธืจื™ื“ื–ืฉ ืื•ื™ืกืœื™ื™ื’ ืคื•ืŸ ื˜ื™ืฉืŸ ื‘ืืฉืืคืŸ ืื™ืŸ "ืึธืŸ ROWID" ืžืึธื“ืข;
  • ืฆื•ื’ืขื’ืขื‘ืŸ API sqlite3_drop_modules(), ื•ื•ืึธืก ืึทืœืึทื•ื– ืื™ืจ ืฆื• ืคืึทืจื•ื•ืขืจืŸ ืึธื˜ืึทืžืึทื˜ื™ืง ืœืึธื•ื“ื™ื ื’ ืคื•ืŸ ื•ื•ื™ืจื˜ื•ืึทืœ ื˜ื™ืฉืŸ ืคึฟื•ืŸ ื“ื™ ืึทืคึผืœืึทืงื™ื™ืฉืึทืŸ;
  • ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ืกื˜ืฉืขืžืึท ืคึผืึทืจืกืขืจ ืื™ื– ืคืืจืขื ื“ืขืจื˜ ืฆื• ื•ื•ื™ื™ึทื–ืŸ ืึท ื˜ืขื•ืช ื•ื•ืขืŸ ื“ื™ ื˜ื™ืคึผ, ื ืึธืžืขืŸ ืื•ืŸ ื˜ื‘ืœ_ื ืึทืžืข ืฉืคืืœื˜ืŸ ืื™ืŸ ื“ื™ sqlite_master ื˜ื™ืฉ ื–ืขื ืขืŸ ื“ืึทืžื™ื“ื–ืฉื“ ื•ื•ืขืŸ ืงืึธื ื ืขืงื˜ืขื“ ื ื™ืฉื˜ ืื™ืŸ ื•ืจื™ื˜ืึทื‘ืœืข_ืกื˜ืฉืขืžืึท ืžืึธื“ืข;
  • ื“ื™ ืคึผืจืึทื’ืžืึท function_list, PRAGMA module_list ืื•ืŸ PRAGMA pragma_list ืงืึทืžืึทื ื“ื– ื–ืขื ืขืŸ ืขื ื™ื™ื‘ืึทืœื“ ื“ื•ืจืš ืคืขืœื™ืงื™ื™ึทื˜. ืฆื• ื˜ื•ื™ืฉืŸ ื“ื™ ืคืขืœื™ืงื™ื™ึทื˜ ื‘ื•ื™ืขืŸ ื ืึทื˜ื•ืจ, ืื™ืจ ืžื•ื–ืŸ ืกืคึผืขืฆื™ืคื™ืฆื™ืจืŸ "-DSQLITE_OMIT_INTROSPECTION_PRAGMAS";
  • ืคึฟืึทืจ ืึทืคึผืœืึทืงื™ื™ืฉืึทืŸ-ื“ื™ืคื™ื™ื ื“ SQL ืคืึทื ื’ืงืฉืึทื ื–, ื“ื™ SQLITE_DIRECTONLY ืคืึธืŸ ืื™ื– ืคืืจื’ืขืœื™ื™ื’ื˜, ื•ื•ืึธืก ืึทืœืึทื•ื– ืื™ืจ ืฆื• ืคืึทืจื•ื•ืขืจืŸ ื“ื™ ื ื•ืฆืŸ ืคื•ืŸ ื“ื™ ืคืึทื ื’ืงืฉืึทื ื– ืื™ืŸ ื˜ืจื™ื’ืขืจื– ืื•ืŸ ืงื•ืงืŸ.

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

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