Ben Johnson, sengoli sa polokelo ea BoltDB NoSQL, o hlahisitse projeke ea Litestream, e fanang ka tlatsetso bakeng sa ho hlophisa phetisetso ea data ho SQLite. Litestream ha e hloke liphetoho ho SQLite mme e ka sebetsa le ts'ebeliso efe kapa efe e sebelisang laeborari ena. Ho pheta-pheta ho etsoa ke ts'ebetso ea morao-rao e entsoeng ka thoko e lekola liphetoho tsa lifaele ho tsoa polokelong ea litaba ebe e li fetisetsa faeleng e 'ngoe kapa polokelong ea kantle. Khoutu ea projeke e ngotsoe ho Go mme e ajoa tlasa laesense ea Apache 2.0.
Litšebelisano tsohle le database li etsoa ka SQLite API e tloaelehileng, ke hore. Litestream ha e kena-kenane ka ho toba le ts'ebetso, ha e ame ts'ebetso ebile e ke ke ea senya litaba tsa database, tse khethollang Litestream ho tsoa ho tharollo e kang Rqlite le Dqlite. Liphetoho li lateloa ka ho lumella hore WAL log ("Ngola-Ahead Log") ho SQLite. Ho boloka sebaka sa polokelo, nako le nako sistimi e kopanya letoto la liphetoho ho lilae tsa database (li-snapshots), ka holim'a moo liphetoho tse ling li qalang ho bokella. Nako ea ho etsa lilae e bonts'itsoe litlhophisong; mohlala, o ka etsa lilae hang ka letsatsi kapa hang ka hora.
Libaka tse ka sehloohong tsa kopo bakeng sa Litestream li kenyelletsa ho hlophisa li-backups tse sireletsehileng le ho aba mojaro oa ho bala ho li-server tse ngata. E ts'ehetsa ho fetisetsa phallo ea phetoho ho Amazon S3, Azure Blob Storage, Backblaze B2, DigitalOcean Spaces, Scaleway Object Storage, Google Cloud Storage, Linode Object Storage, kapa moamoheli ofe kapa ofe oa kantle ea tšehetsang protocol ea SFTP. Haeba litaba tse ka har'a database tse kholo li senyehile, kopi ea "backup" e ka khutlisoa ho tsoa sebakeng se lumellanang le ntlha e itseng ka nako, phetoho e itseng, phetoho ea ho qetela, kapa selae se boletsoeng.
Source: opennet.ru