ืื ืืขืืืื ื ืคืื SQLite 3.36, ืึท ืืืืืืืืื ืืืืก ืืืืืื ื ืืื ืึท ืฆืึทืคึผื-ืืื ืืืืืืึธืืขืง, ืืื ืืจืืืก. ืื SQLite ืงืึธื ืืื ืคืื ืื ืืขืจืืขืืืืื ืืื ืื ืฆืืืืจ ืคืขืื, ื.ืข. ืงืขื ืขื ืืืื ืืขืืืืื ื ืึธื ืจืืกืืจืืงืฉืึทื ื ืืื ืคืจืื ืคึฟืึทืจ ืงืืื ืฆืืืขืง. ืคืื ืึทื ืฆืืขื ืฉืืืฆื ืคึฟืึทืจ SQLite ืืขืืืขืืึธืคึผืขืจืก ืืื ืฆืืืขืฉืืขืื ืืืจื ืึท ืกืคึผืขืฉืื ืืืฉืืคื ืงืึธื ืกืึธืจืืืื, ืืืึธืก ืืืื ืงืึธืืคึผืึทื ืืขืก ืึทืืึท ืืื ืึทืืึธืืื, ืึธืจืึทืงืืข, ืืึธืืืืืึท, ืืขื ืืืื ืืื ืืืืืืขืจื.
ืืืืคึผื ืขื ืืขืจืื ืืขื:
- ืืขืจ ืจืขืืืืืึทื ืคืื ืื EXPLAIN QUERY PLAN ืืึทืคึฟืขื ืืื ืืขืืืื ืืจืื ืืขืจ ืฆื ืคึฟืึทืจืฉืืืื.
- ืื ืฉืืจื ืึทื ืึท ืืขืืช ืืื ืืืฉืขื ืขืจืืืืึทื ืืืขื ืืืจ ืคึผืจืึผืืื ืฆื ืึทืงืกืขืก ืึท ืจืึธืืืื ืืื ืึท VIEW ืึธืืขืจ ืกืืืงืืืขืจื. ืฆื ืฆืืจืืงืงืืืขื ืื ืคืืืืงืืื ืฆื ืึทืงืกืขืก ืจืึธืืืื ืคึฟืึทืจ ืงืืงื, ืื ืคึฟืึทืจืืึทืืืื ื ืึธืคึผืฆืืข "-DSQLITE_ALLOW_ROWID_IN_VIEW" ืืื ืฆืืืขืฉืืขืื
- ืื sqlite3_deserialize () ืืื sqlite3_serialize () ืื ืืขืจืคืืืกืื ืืขื ืขื ืขื ืืืืึทืื ืืืจื ืคืขืืืงืืึทื. ืฆื ืืืกืืืืึทื, ืื ืคึฟืึทืจืืึทืืืื ื ืึธืคึผืฆืืข "-DSQLITE_OMIT_DESERIALIZE" ืืื ืฆืืืขืฉืืขืื
- VFS "memdb" ืึทืืึทืื ืืึทื ืืืืืื ื ืคืื ืึท ืืื-ืืืงืึธืจื ืืึทืืึทืืืืก ืึทืจืืืขืจ ืคืึทืจืฉืืืขื ืข ืงืึทื ืขืงืฉืึทื ื ืฆื ืืขืจ ืืขืืืืงืขืจ ืคึผืจืึธืฆืขืก, ืึทืืื ืืึทื ื ืืื ืื ืืึทืืึทืืืืก ื ืึธืืขื ืืืืื ืืื "/".
- ืื "ืขืงืกืืกื-ืฆื-ืืื" ืึทืคึผืืึทืืึทืืืืฉืึทื ืืึทืงืขื ืขื ืืื ืื ืืขืฆืืข ืืขืืืื ื, ืืืึธืก ืกืืึธืื ืขืืืขืืข ืคึฟืจืืื, ืืื ืจืืืืขืจืืื.
- ืึธืคึผืืืืืืึทืืืึธื ืคึฟืึทืจ ืงืึทืืืืื ืื ื ืงืขืกืืืืขืจืืืง ืงืึธื ืืจืึธืืืจืื ื ืืื ืฆืืืขืคืืกื ืฆื ืึทืจืืขืื ืืื ืงืืืืจืื ืึธื ืืขืจืืืฉืื ื (ืคืึทืจืืื ืื).
- ืื REGEXP ืคืึทืจืืขื ืืขืจืื ื ืืื ืึทืจืืึทื ืืขืจืขืื ื ืืื ืื CLI.
ืืงืืจ: opennet.ru