Ukukhishwa kwe-DBMS SQLite 3.28

Kuthunyelwe ngu- ukukhululwa I-SQLite 3.28.0, i-DBMS engasindi edizayinelwe njengomtapo wolwazi ofakiwe. Ikhodi ye-SQLite isatshalaliswa njengesizinda somphakathi, i.e. ingasetshenziswa ngaphandle kwemikhawulo futhi mahhala nganoma iyiphi injongo. Usekelo lwezezimali lwabathuthukisi be-SQLite luhlinzekwa yinhlangano edalwe ngokukhethekile, ehlanganisa izinkampani ezifana ne-Adobe, i-Oracle, i-Mozilla, i-Bentley ne-Bloomberg.

main shintsha:

  • Kunwetshiwe imisebenzi yewindi (imisebenzi yewindi noma imisebenzi yokuhlaziya evumela ukuthi umugqa ngamunye wombuzo wenze izibalo kusetshenziswa eminye imigqa): ukwesekwa okwengeziwe kwenkulumo KUNGAKHISHI, kwaba nokwenzeka ukusetshenziswa amaketanga imisebenzi yewindi (iwindi elilodwa lichazwa endaweni yelinye), linikeziwe ukwesekwa ukwenza amaqembu kusetshenziswa isisho esithi GROUP, kanye nemikhawulo engu-RANGE iyasetshenziswa KUYANDULELA и UKULANDELA;
  • Ukusebenza okuthuthukisiwe komyalo "VACUUM KU", manje engasetshenziswa nezizindalwazi ezitholakala ngemodi yokufunda kuphela;
  • Kwengezwe ukulungiselelwa kwemibuzo emisha: Kusheshisiwe ukusebenza kwezinkulumo ezithi LIKE kanye negama elingukhiye elithi ESCAPE nalapho imodi ethi “PRAGMA case_sensitive_like” inikwe amandla. Ebukhoneni be inkomba ingxenye ukuhlolwa okungadingekile kwezimo ezisobala ezibalulwe kusigatshana LAPHO zisuswa khona;
  • Umyalo ".ipharamitha»komsebenzi okufakwe esikhundleni okunamathiselwe (imaski ifakwe esikhundleni sanoma yiziphi izinkulumo ze-SQL). Emyalweni othi ".ingobo yomlando", inketho ethi "--update" isiklanywe kabusha, manje eseqa amafayela angashintshiwe asevele engobo yomlando, futhi inketho ethi "--insert" yengeziwe ukuze ifake amafayela kungobo yomlando;
  • Kwengezwe fossildelta.c, okuvumela ukuthi udale, usebenzise futhi uhlukanise формат Izinguquko ze-Fossil Delta ezisetshenziswa esandisweni se-RBU;
  • Ukwethenjelwa okwandisiwe kokusebenza ngamafayela esizindalwazi alimele;
  • Isibuko senqolobane yephrojekthi yethulwe GitHub (okuyisisekelo inqolobane isekelwa kusetshenziswa isilawuli senguqulo izinsalela, edalwe umbhali we-SQLite).

Source: opennet.ru

Engeza amazwana