Litestream idayambitsidwa ndikukhazikitsa njira yobwerezabwereza ya SQLite

Ben Johnson, mlembi wa BoltDB NoSQL yosungirako, anapereka pulojekiti ya Litestream, yomwe imapereka zowonjezera pakukonzekera kubwereza deta mu SQLite. Litestream sichifuna kusintha kulikonse ku SQLite ndipo imatha kugwira ntchito ndi pulogalamu iliyonse yomwe imagwiritsa ntchito laibulaleyi. Kubwereza kumachitika ndi njira yakumbuyo yomwe imayang'anira kusintha kwa mafayilo kuchokera ku database ndikuwasamutsira ku fayilo ina kapena kusungirako kunja. Khodi ya polojekitiyi idalembedwa mu Go ndikugawidwa pansi pa layisensi ya Apache 2.0.

Kuyanjana konse ndi database kumachitika kudzera mu SQLite API yokhazikika, i.e. Litestream sizimasokoneza mwachindunji ntchito, sizimakhudza magwiridwe antchito ndipo sizingawononge zomwe zili mu database, zomwe zimasiyanitsa Litestream ndi mayankho monga Rqlite ndi Dqlite. Zosintha zimatsatiridwa poyambitsa chipika cha WAL ("Write-Ahead Log") mu SQLite. Kusunga malo osungira, dongosolo nthawi ndi nthawi limaphatikiza kusintha kwa magawo a database (zithunzi), pamwamba pomwe kusintha kwina kumayamba kudziunjikira. Nthawi yopangira magawo ikuwonetsedwa pazokonda; mwachitsanzo, mutha kupanga magawo kamodzi patsiku kapena kamodzi pa ola.

Magawo akuluakulu ogwiritsira ntchito Litestream akuphatikiza kukonza zosunga zobwezeretsera ndikugawa zowerengera pamaseva angapo. Imathandizira kusamutsa mtsinje wosinthika kupita ku Amazon S3, Azure Blob Storage, Backblaze B2, DigitalOcean Spaces, Scaleway Object Storage, Google Cloud Storage, Linode Object Storage, kapena wolandila aliyense wakunja yemwe amathandizira protocol ya SFTP. Ngati zomwe zili mu database yayikulu zawonongeka, kopi yosunga zobwezeretsera ikhoza kubwezeretsedwanso kuchokera ku boma lolingana ndi nthawi yodziwika, kusintha kwapadera, kusintha komaliza, kapena kagawo kakang'ono.

Source: opennet.ru

Kuwonjezera ndemanga