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

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

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

  • ืฆื•ื’ืขื’ืขื‘ืŸ SQLITE_DBCONFIG_DQS_DML ืื•ืŸ SQLITE_DBCONFIG_DQS_DDL ืึธืคึผืฆื™ืขืก ืฆื• sqlite3_db_config () ืฆื• ืงืึธื ื˜ืจืึธืœื™ืจืŸ ืฆื™ ื”ืึทื ื“ืœื™ื ื’ ืžื™ื˜ ืื™ื™ืŸ ืื•ืŸ ื˜ืึธืคึผืœ ืฆื™ื˜ื™ืจืŸ ืื™ื– ืขื ื™ื™ื‘ืึทืœื“. SQlite ืขืจื™ื“ื–ืฉื ืึทืœื™ ื’ืขืฉื˜ื™ืฆื˜ ืงื™ื™ืŸ ืฆื™ื˜ืึทื˜ ืžืึทืจืงืก ืคึฟืึทืจ ืกื˜ืจื™ื ื’ืก ืื•ืŸ ื™ื“ืขื ื˜ื™ืคื™ืขืจืก, ืึธื‘ืขืจ ื“ื™ SQL ื ืึธืจืžืึทืœ ืจื™ืงื•ื•ื™ื™ืขืจื– ื‘ืคื™ืจื•ืฉ ื“ื™ ื ื•ืฆืŸ ืคื•ืŸ ืื™ื™ืŸ ืฆื™ื˜ืึทื˜ ืžืึทืจืงืก ืคึฟืึทืจ ืฉื˜ืจื™ืงืœ ืœื™ื˜ืขืจืึทืœ ืื•ืŸ ื˜ืึธืคึผืœ ืฆื™ื˜ืึทื˜ ืžืึทืจืงืก ืคึฟืึทืจ ื™ื“ืขื ื˜ื™ืคื™ืขืจืก (ืึทื–ืึท ื•ื•ื™ ื–ื™ื™ึทืœ ื ืขืžืขืŸ). ืกืงืœื™ื˜ืข ื ืึทื˜ื•ืจ ื”ืืœื˜ ืฆื• ื–ื™ื™ืŸ ื’ืขืฉื˜ื™ืฆื˜ ื“ื•ืจืš ืคืขืœื™ืงื™ื™ึทื˜, ืื•ืŸ ืึท ื‘ื•ื™ืขืŸ ืึธืคึผืฆื™ืข "-DSQLITE_DQS = 0" ืื™ื– ื’ืขืคึฟื™ื ื˜ ืฆื• ื’ืขื‘ืŸ ื”ืขืกืงืขื ืžื™ื˜ ื“ื™ ื ืึธืจืžืึทืœ;
  • ืึธืคึผื˜ื™ืžื™ื–ืึทื˜ื™ืึธื ืก ื”ืึธื‘ืŸ ืฉื•ื™ืŸ ืฆื•ื’ืขืœื™ื™ื’ื˜ ืฆื• ื“ื™ ืึธื ืคึฟืจืขื’ ืคึผืœืึทื ื ืขืจ ืฆื• ืคืึทืจื’ื™ื›ืขืจืŸ ื“ื™ ืึธืคึผืขืจืึทืฆื™ืข ืคื•ืŸ โ€‹โ€‹ื“ื™ AND ืื•ืŸ OR ืึธืคึผืขืจื™ื™ื˜ืขืจื– ื•ื•ืขืŸ ืื™ื™ื ืขืจ ืคื•ืŸ ื“ื™ ืึธืคึผืขืจืึทื ื“ื– ืื™ื– ืงืขืกื™ื™ื“ืขืจื“ื™ืง, ื•ื•ื™ ื’ืขื–ื•ื ื˜ ื•ื•ื™ ื“ื™ LIKE ืึธืคึผืขืจืึทื˜ืึธืจ ื•ื•ืขืŸ ื“ื™ ื–ื™ื™ึทืœ ืกืคึผืขืกื™ืคื™ืขื“ ืื•ื™ืฃ ื“ื™ ืœื™ื ืงืก ืื™ื– ื ื•ืžืขืจื™ืง;
  • ืฆื•ื’ืขื’ืขื‘ืŸ ืึท ื ื™ื™ึทืข ื•ื•ื™ืจื˜ื•ืึทืœ ื˜ื™ืฉ "sqlite_dbdata" ืฆื• ืฆื•ืจื™ืงืงืจื™ื’ืŸ ืื™ื ื”ืึทืœื˜ ืื™ืŸ ื“ื™ ืžืงื•ืจ ื–ื™ื™ึทืœ ื“ืึทื˜ืŸ ืžื“ืจื’ื”, ืืคื™ืœื• ืื•ื™ื‘ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ืื™ื– ืคืืจื“ืืจื‘ืŸ;
  • ืื™ืŸ CLI ืฆื•ื‘ื™ื ื“ ืฆื•ื’ืขื’ืขื‘ืŸ ื“ื™ ".ืจืขืงืึธื•ื•ืขืจ" ื‘ืึทืคึฟืขืœ, ื•ื•ืึธืก ืคืจื•ื•ื•ื˜ ืฆื• ืฆื•ืจื™ืงืงืจื™ื’ืŸ ื“ืึทื˜ืŸ ืคื•ืŸ ืึท ื“ืึทืžื™ื“ื–ืฉื“ ื“ืึทื˜ืึทื‘ื™ื™ืก ื•ื•ื™ ืคื™ืœ ื•ื•ื™ ืžืขื’ืœืขืš. ืื•ื™ืš ืฆื•ื’ืขืœื™ื™ื’ื˜ ืื™ื– ืึท ".ืคื™ืœืขืงื˜ืจืœ" ื‘ืึทืคึฟืขืœ ืคึฟืึทืจ ืคืœื™ืกื ื“ื™ืง ื˜ืขืกืฅ ืื•ืŸ ืึท ".ื“ื‘ืงืึธื ืคื™ื’" ื‘ืึทืคึฟืขืœ ืคึฟืึทืจ ื•ื•ื™ื•ื™ื ื’ ืึธื“ืขืจ ื˜ืฉืึทื ื’ื™ื ื’ sqlite3_db_config () ืึธืคึผืฆื™ืขืก.

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

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