Kutulutsidwa kwa DBMS SQLite 3.30

Lofalitsidwa kumasula SQLite 3.30.0, DBMS yopepuka yopangidwa ngati plug-in library. Khodi ya SQLite imagawidwa ngati malo a anthu onse, i.e. itha kugwiritsidwa ntchito popanda zoletsa komanso kwaulere pazifukwa zilizonse. Thandizo lazachuma kwa opanga ma SQLite limaperekedwa ndi bungwe lopangidwa mwapadera, lomwe limaphatikizapo makampani monga Adobe, Oracle, Mozilla, Bentley ndi Bloomberg.

waukulu kusintha:

• Anawonjezera luso logwiritsa ntchito mawu akuti "FILTER» zokhala ndi ntchito zophatikizika, zomwe zimapangitsa kuti athe kuchepetsa kufalikira kwa deta yomwe yasinthidwa ndi ntchito yophatikizira kumarekodi okha omwe amakwaniritsa zomwe zaperekedwa;
• "ORDER BY" block imapereka chithandizo kwa "NULLS POYAMBA"Ndipo"ZINTHU ZOTSIRIZA» kudziwa komwe kuli zinthu zomwe zili ndi mtengo wa NULL posankha;
• Lamulo ".chira»kubwezeretsa zomwe zili m'mafayilo owonongeka kuchokera ku database;
• Mu kukulitsa UBI thandizo anawonjezera indexing mawu;
• PRAGMA index_info ndi PRAGMA index_xinfo awonjezedwa kuti apereke zambiri za masanjidwe osungira a matebulo opangidwa mu "POPANDA ROWID" mode;
• API Yowonjezera sqlite3_drop_modules(), zomwe zimakupatsani mwayi woletsa kutsitsa kwamatebulo kuchokera pakugwiritsa ntchito;
• Dongosolo la database la schema parser lasinthidwa kuti liwonetse cholakwika pomwe mitundu, dzina, ndi tbl_name mizati mu tebulo la sqlite_master imawonongeka ikalumikizidwa osati mu writable_schema mode;
• The PRAGMA function_list, PRAGMA module_list ndi PRAGMA pragma_list malamulo amayatsidwa mwachisawawa. Kuti musinthe machitidwe omanga, muyenera kufotokoza momveka bwino "-DSQLITE_OMIT_INTROSPECTION_PRAGMAS";
• Pazigawo za SQL zomwe zimatanthauzidwa ndi pulogalamu, mbendera ya SQLITE_DIRECTONLY ikuperekedwa, yomwe imakupatsani mwayi woletsa kugwiritsa ntchito izi mkati mwa zoyambitsa ndi mawonedwe.

Source: opennet.ru