Kutulutsidwa kwa SQLite 3.37, 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:
- Thandizo lowonjezera popanga matebulo okhala ndi "STRICT", zomwe zimafunikira chizindikiro chamtundu wovomerezeka polengeza mizati ndikugwiritsanso ntchito macheke ofananiza amtundu wa data yomwe yawonjezeredwa pamizati. Mbendera ikakhazikitsidwa, SQLite iwonetsa cholakwika ngati sikungatheke kuponya zomwe zafotokozedwa kumtundu wagawo. Mwachitsanzo, ngati gawolo lidapangidwa ngati "INTEGER", ndiye kuti kupitilira nambala ya '123' kupangitsa kuti nambala 123 ionjezidwe, koma kuyesa kutchula 'xyz' sikulephera.
- M'ntchito ya "ALTER TABLE ADD COLUMN", cheke cha mizere yokhala ndi mizere yawonjezedwa powonjezera mizere yokhala ndi macheke potengera mawu akuti "CHECK" kapena "NOT NULL".
- Anakhazikitsa mawu akuti "PRAGMA table_list" kuti muwonetse zambiri zamatebulo ndi malingaliro.
- Mawonekedwe a mzere wa malamulo amagwiritsira ntchito lamulo la ".connection", lomwe limakulolani kuti muthandizire nthawi imodzi maulumikizidwe angapo ku database.
- Onjezani gawo la "-safe", lomwe limalepheretsa malamulo a CLI ndi mawu a SQL omwe amakulolani kuti mugwire ntchito ndi mafayilo a database omwe amasiyana ndi nkhokwe yotchulidwa pamzere wolamula.
- CLI yakonza bwino ntchito yowerengera mawu a SQL ogawidwa m'mizere ingapo.
- Ntchito zowonjezera sqlite3_autovacuum_pages(), sqlite3_changes64() ndi sqlite3_total_changes64().
- Wokonza mafunso amawonetsetsa kuti ORDER BY clauses m'magawo ang'onoang'ono ndi malingaliro anyalanyazidwa pokhapokha ngati kuchotsa ziganizozo sikusintha semantics ya funsolo.
- Zowonjezera generate_series(START,END,STEP) zasinthidwa, gawo loyamba lomwe ("START") lapangidwa kukhala lovomerezeka. Kuti mubwezeretse zomwe zidachitika kale, ndizotheka kumanganso ndi "-DZERO_ARGUMENT_GENERATE_SERIES".
- Kuchepetsa kukumbukira kukumbukira posungira schema ya database.
Source: opennet.ru