Inguqulelo entsha ye-SQLite 3.33.0 sele ikhutshiwe kwaye ezi ziindaba zayo

Inguqulelo entsha ye I-SQLite 3.33 sele ikhutshiwe kwaye kuyo bayadibana ezinye iinguqu ilungile, umzekelo umzekelo QAPHELA KWINKXASO ukulandela syntax ngePostgreSQL, ukongeza, phucula ulwandiso ieee754 ukuxhasa iinombolo ze-IEEE 754 ze-binary64 kunye ne inyuse ubungakanani obukhulu beefayile zedatha kwi-281 TB.

Kulabo abangaqhelekanga ngephakheji ye-SQLite yi-DBMS engasindiYenzelwe njengethala leencwadi. Ikhowudi ye-SQLite isasazwa njengommandla woluntu, Oko kukuthi, inokusetyenziswa ngaphandle kwezithintelo kwaye ngaphandle kwentlawulo ngayo nayiphi na injongo.

Yiphakheji yesoftware ethi yaziwa ngokwakhiwa nokusebenza kwayo kusetyenziswa iqonga le-LFS-10.0.

Iimpawu ezintsha eziphambili ze-SQLite 3.33

Olunye lolona tshintsho lubalulekileyo kule nguqulo intsha yindlela UKUHLAZIYA UKUSUKA ekuphunyezweni ukuvuselela umxholo wetafile ngokusekwe kukhetho oluvela kwenye itafile this usebenzisa i-syntax ye-PostgreSQL ehambelanayo.

Ngokweqela le-SQLite, umbono WOKUHLAZIYA KUSUKA kulwandiso lwe-SQL Ivumela ingxelo yoVAVANYO ukuba ityhalelwe kwezinye iitafile kwindawo yogcino lwedatha.

Itheyibhile "ekujoliswe kuyo" yile theyibhile ihlaziyiweyo. Olunye uhlobo lweedatha ezinxulumene nolwalamano nazo zisebenzisa UPDATE FROM, kodwa ngenxa yokuba ulwakhiwo aluyonxalenye yemigangatho ye-SQL, imveliso nganye iphumeza UPDATE FROM ngokwahlukileyo.

Ukuphunyezwa kwe-SQLite kuzabalazela ukuthobela iPostgreSQL. Iseva ye-SQL kunye nokuphunyezwa kwe-MySQL yombono omnye kusebenza ngokwahlukileyo.

Kwicala lokulawula ukuthembeka I-PRAGMA, ngoku kunokwenzeka ukuba ujonge ngokungacwangciswanga iitafile ezithile kunye nezalathiso (Phambi kokuba ihlale ijonga lonke ugcino lwedatha), njengoko i-PRAGMA isenza isiseko sokungqinelana kwesiseko sedatha kunye nefomathi yenqanaba eliphantsi. Ukutshekishwa kwetafile okanye isalathiso sokungena ngokulandelelana, iimpazamo ZOKUJONGA, UKUQINISEKISA kunye nokunganyanzeleki, ukunyaniseka kuluhlu lwasimahla, kunye nokulahleka okanye ukungeniswa okungaphezulu kwesalathiso, amaphepha alahlekileyo, kunye namaxwebhu angalunganga.

Malunga nokuphuculwa kolwandiso ieee754, ngoku kunokwenzeka ukuba usebenze ngamanani e-IEEE 754 kanambambili64. Isicatshulwa esiveliswe ngohlobo lwempikiswano kwi-ieee754 () umsebenzi ufundeka ngabantu, kodwa kunzima ukusebenzisa njengenxalenye yebinzana elikhulu.

Yiyo loo nto ieee754_mantissa () kunye neeee754_exponent () iindlela zongezwa ukubuyisa amaxabiso M kunye no-E ahambelana nexabiso F lempikiswano yayo kuphela.

Uphuculo lwenziwe kumcwangcisi wombuzonjengoko ukusebenza kuphuculwe kwi "KHETHA min (x) UKUYA KUPHI kwaye KUPHI??,?,?)" xa isalathiso t (x, y) sikhona.

Kwindlela yeWAL (Bhala-phambili ukuNgena), ukuba umsebenzi wokubhala uyasilela, evelisa ukungangqinelani kwidatha yefayile ye-shm, le ntengiselwano ilandelayo ngoku inokubuyisela ukuthembeka kwefayile ye-shm xa kukho intengiselwano efundwayo esebenzayo, endaweni yokubonisa impazamo ye-SQLITE_PROTOCOL.

Olunye utshintsho olwenziweyo Kule nguqulo intsha, oku kulandelayo kuyabonakala:

  • Kwelinye icala, olunye utshintsho olubalulekileyo kukunyuka kobukhulu besiseko sedatha ukuya kwi-281 TB.
  • I-CLI ine-extensions eyandisiweyo eyandisiweyo kunye neeee754.
  • Yongeze ukongezwa kwedesimali ngokuchanekileyo ngokuchaseneyo nemisebenzi yezibalo, kukho imisebenzi emithathu yezibalo efumanekayo kubandakanya decimal_add, decimal_sub, kunye decimal_mul (le misebenzi mithathu yongeza, uthabathe, kwaye uphindaphinde iimpikiswano, ngokulandelelana).
  • Ukongeza, "ibhokisi" entsha, "json", "uphawu lokumakisha" kunye "netafile" iindlela zokuphuma ziye zongezwa kulungelelwaniso lomgca wokuyalela (CLI).
  • Kwimowudi yokuphuma kwikholamu, iikholamu zandiswa ngokuzenzekelayo ngumxholo woluhlu olude kakhulu.
  • Imowudi yokuphuma "quote" ithathela ingqalelo ixabiso lokwahlulahlula elimiselwe ngumyalelo ".

Gqibela ukuba unomdla wokwazi okungakumbi ngayo malunga nale nguqulo intsha, unokujonga iinkcukacha ngokuya kule khonkco ilandelayo.


Yiba ngowokuqala ukuphawula

Shiya uluvo lwakho

Idilesi yakho ye email aziyi kupapashwa. ezidingekayo ziphawulwe *

*

*

  1. Uxanduva lwedatha: UMiguel Ángel Gatón
  2. Injongo yedatha: Ulawulo lwe-SPAM, ulawulo lwezimvo.
  3. Umthetho: Imvume yakho
  4. Unxibelelwano lwedatha: Idatha ayizukuhanjiswa kubantu besithathu ngaphandle koxanduva lomthetho.
  5. Ukugcinwa kweenkcukacha
  6. Amalungelo: Ngalo naliphi na ixesha unganciphisa, uphinde uphinde ucime ulwazi lwakho.