Kutulutsidwa kwa SQLite 3.38, DBMS yopepuka yopangidwa ngati laibulale ya pulagi, kwasindikizidwa. Khodi ya SQLite imagawidwa pagulu la anthu, 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.
Zosintha zazikulu:
- Zowonjezera zothandizira -> ndi ->> ogwiritsa ntchito kuti zikhale zosavuta kuchotsa deta mumtundu wa JSON. Syntax yatsopano ya opareshoni imagwirizana ndi MySQL ndi PostgreSQL.
- Kapangidwe kake kamakhala ndi ntchito zogwirira ntchito ndi data mumtundu wa JSON, kulumikizana komwe kumafunikira kusonkhana ndi mbendera ya "-DSQLITE_ENABLE_JSON1". Kuti muyimitse chithandizo cha JSON, mbendera ya "-DSQLITE_OMIT_JSON" yawonjezedwa.
- Anawonjezera unixepoch() ntchito yomwe imabwezeretsa nthawi ya epochal (chiwerengero cha masekondi kuyambira Januware 1, 1970).
- Kwa ntchito zomwe zimagwira ntchito ndi nthawi, zosintha za "auto" ndi "julianday" zakhazikitsidwa.
- SQL function printf() idasinthidwa kukhala mtundu () kuti igwirizane ndi ma DBMS ena (kuthandizira dzina lakale kumasungidwa).
- Onjezani mawonekedwe a sqlite3_error_offset() kuti zikhale zosavuta kupeza zolakwika pafunso.
- Mapologalamu atsopano awonjezedwa pakukhazikitsa matebulo enieni: sqlite3_vtab_distinct(), sqlite3_vtab_rhs_value() ndi sqlite3_vtab_in(), komanso mitundu ya opareshoni yatsopano SQLITE_INDEX_CONSTRAINT_LIMIT ndi SQLITE_INDEX_CONSTRAINT_OFFSET.
- Mawonekedwe a mzere wamalamulo amatsimikizira kugwiridwa koyenera kwa tabu ndi zilembo za feed za mzere pamawu otuluka mumitundu yamitundu yambiri. Zowonjezera zothandizira kugwiritsa ntchito zosankha za "--wrap N", "--wordwrap on" ndi "-quote" potulutsa magawo angapo. Lamulo la .import limalola kuwongolera mayina a magawo.
- Kuti afulumizitse kufunsidwa kwa mafunso akuluakulu, wokonza mafunso amagwiritsa ntchito mawonekedwe a probabilistic bloom fyuluta kuti adziwe ngati chinthu chilipo mu seti. Mtengo wosakanizidwa bwino umagwiritsidwa ntchito kukhathamiritsa kukonzedwa kwa UNION ndi UNION ALL midadada kutengera SELECT statements ndi ORDER BY clauses.
Kuphatikiza apo, mutha kuwona kusindikizidwa kwa mtundu wa sqlite-utils 3.24 set, womwe umaphatikizapo zofunikira ndi laibulale yosinthira mafayilo kuchokera ku database ya SQLite. Zochita monga kutsitsa mwachindunji data ya JSON, CSV kapena TSV mufayilo yosungira ndikudzipangira zokha zosungira zofunika, kugwiritsa ntchito mafunso a SQL pamafayilo a CSV, TSV ndi JSON, kusaka zolemba zonse munkhokwe, kusintha ma data ndi mapulani osungira. Nthawi zina ALTER sikugwira ntchito, TABLE (mwachitsanzo, kusintha mtundu wa mizati), kuchotsa magawo kukhala matebulo osiyana.
Source: opennet.ru