SQLite injiniyar bayanai ne mai sauƙin nauyi, ana samunsa ta hanyar yaren SQL. Ba kamar sabobin bayanan gargajiya ba, kamar su MySQL ko PostgreSQL, keɓaɓɓiyar magana ba ta sake saba tsarin makircin-saba ba, amma don haɗa kai tsaye cikin shirye-shirye.
Cikakken bayanan (sanarwa, tebur, fihirisa da bayanai) ana adana shi a cikin fayil mai zaman kansa na dandamali. Godiya ga tsananin haske, da sauransu, ana amfani dashi a yawancin shirye-shiryen masarufi kuma sanannen sananne ne a cikin tsarin sakawa, gami da wayoyin zamani na zamani.
Sigar 3.25. Nau'in ya faro ne daga Satumba 2018. A cikin sigar 3.25, SQLite ya ba da tallafi don ayyukan Windows, wasu haɓakawa ga umarnin BABU TABLE da mai nema, da kuma wasu sabbin abubuwa.
Kamar yadda na wannan sigar, SQLite ya ƙara tallafi don sake sunan ginshiƙai a cikin tebur ta amfani da shi teburin BAYA BAYA SAMUN RUWAN RUGU COLUMN tsohon sunan TO sabon suna.
Sunan shafi an canza duka a cikin ma'anar teburin kanta kamar yadda yake a cikin dukkan bayanan, abubuwan da ke haifar da su, da kuma ra'ayoyin da ke ishara zuwa shafi.
Idan sake sunan shafi ya haifar da shubuha mai ma'ana a cikin fararwa ko ra'ayi, RENAME COLUMN ya fadi tare da kuskure kuma ba a amfani da canje-canje.
Sabuwar sigar SQLite, version 3.28 kuma yana kawo sabbin abubuwa da cigaba da yawa. Sabbin fasaloli sanannus sun haɗa da haɓakawa ga abubuwan Windows, haɓakawa ga tsarin TCL.
Thearin sabbin APIs, mafi ƙarancin kulawa da gurɓatattun fayilolin bayanai, da sauran haɓakawa. Ingantaccen fasali na Windows galibi sabbin ƙari ne ga sababbin sassan da sabbin hanyoyin sadarwa.
Sabbin bambance-bambancen karatu zuwa EXCLUDE
Mun lura da ƙari na sabon zaɓi "KARI" wanda ke da nau'i huɗu:
- KAWAR DA SAURAN: Wannan ƙimar tsoho ce. A wannan yanayin, babu layin da aka cire daga firam ɗin aikin taga kamar yadda aka ayyana ta farkon iyakarta da ƙarshenta.
- SAURAN LAHIRAN YANZU: A wannan yanayin, an cire layin na yanzu daga akwatin aiki. Nau'ikan nau'i-nau'i a cikin layi na yanzu sun kasance cikin tebur don nau'ikan tebur na GROUP da RANGE;
- CASAR GROUPE: A wannan yanayin, layin yanzu da duk sauran layukan da suke ma layin na yanzu an keɓance daga akwatin. Lokacin da aka aiwatar da magana ta CARCA, duk layuka tare da TAKARDAR DAYA ta hanyar ƙimomi ko duk layuka a cikin rashi in babu RU'DUWA TA claauke da magana ana la’akari da koda, koda kuwa nau'in firam ɗin ROWS ne.
- TIASAR LATSA: A halin na ƙarshe, layin na yanzu wani ɓangare ne na firam, amma an cire takwarorinsa.
Ingantaccen fasali
Hakanan a matakin ayyukan taga, an kara tallafi don sarkar windows, an ƙara tallafi don katunan GROUPS.
An kara tsayawa ga iyaka « Gabatarwa »Kuma» BAYAN «a cikin tsarin RANGE, ƙara sabon sqlite3_stmt_isexplain don ƙayyade idan bayanin da aka shirya shi ne BAYANI ko ba haka ba da haɓaka VACUUM INTO don aiki don ɗakunan bayanai kawai
A gefen ƙirar TCL, an ƙara zaɓin -returntype zuwa hanyar aiki da ƙari na sabuwar hanyar bind_fallback.
da kyautatawa da aka yi wa CLI suna da yawa. A wannan matakin, mun lura da ƙarin API na sqlite3_value_frombind () don sanin ko takaddar aikin SQL ta fito ne daga ƙayyadaddun ma'auni.
Ofarin tallafi don sigogi masu ɗaurewa da umarnin .parameter, gyara aikin rubutun () don haka yayin ƙirƙirar sabbin kundin adireshi tare da hanyar sabon fayil zai basu izini na izini a maimakon izini iri ɗaya kamar fayil ɗin.
Ya kasance yana ƙara Fossildelta.c don ƙirƙirar, amfani da kwance ɗamarar tsarin Delta na fayil ɗin Fossil DVCS wanda aka yi amfani da shi ta RBU da wasu ci gaba.
Don SQLite 3.28, mun kuma lura da ƙoƙarin da aka yi don yin tambayoyi har ma da sauri.
Si Kuna so ku sani game da SQLite kuma zazzage wannan sabon sigar da zaku iya ziyarta mahada mai zuwa.