Google e hlahisitse puo e ncha ea "logical programming" e ncha, Logica, e etselitsoeng ho qhekella le ho fetolela mananeo ho SQL. Puo e ncha e lebisitsoe ho ba batlang ho sebelisa syntax ea logic programming ha ba ngola lipotso tsa database. Hajoale, khoutu ea SQL e hlahisoang e ka sebelisoa polokelong ea Google BigQuery kapa ho PostgreSQL le SQLite DBMSs, tšehetso e ntseng e lekoa. Nakong e tlang ho reriloe ho atolosa palo ea lipuo tsa SQL tse tšehetsoeng. Khoutu ea projeke e ngotsoe ka Python mme e phatlalalitsoe tlasa laesense ea Apache 2.0.
Logica e ntse e tsoela pele ka nts'etsopele ea puo e 'ngoe e ntlafalitsoeng ea Google ea ho sebetsana le data, Yedalog,' me e fana ka maemo a sa fumaneheng ho SQL e tloaelehileng. Lipotso ho Logica li hlophisitsoe ka mokhoa oa sete ea lipolelo tse utloahalang. E ts'ehetsa li-module, tse tsoang kantle ho naha, le bokhoni ba ho sebelisa Logica ho tsoa ho khetla ea Jupyter Notebook e sebetsang. Mohlala, ho hlahisa kakaretso ea batho bao ho buuoang ka bona khafetsa litabeng tsa 2020, u ka sebelisa lenaneo le latelang la Logica ho fihlella polokelong ea polokelo ea GDELT: @OrderBy(Mentions, "mentions desc"); @Limit(Ho boleloa, 10); Ho boleloa(motho:, o bua ka? += 1) ka ho khetheha :- gdelt-bq.gdeltv2.gkg(batho:, letsatsi:), Substr(ToString(letsatsi), 0, 4) == “2020”, the_persons == Ho arohana (batho, ";"), motho ho_batho; $ logica e bolela.l matha E Bolela +———————+——————-+ | motho | e bolela_bala | +——————+——————-+ | Donald trump | 3077130 | | los angeles | 1078412 | | joe biden | 1054827 | | George Floyd | 872919 | | boris johnson | 674786 | | Barack Obama | 438181 | | vladimir putin | 410587 | | bernie sanders | 387383 | | Andrew cuomo | 345462 | | las vegas | 325487 | +——————+——————-+
Ho ngola lipotso tse rarahaneng ho SQL ho lebisa tlhokong ea ho ngola liketane tse boima tsa mela e mengata eo ho seng bonolo ho e utloisisa, ho kena-kenana le ho sebelisoa hape ha likarolo tsa potso, le ho thatafatsa tlhokomelo. Bakeng sa lipalo tse pheta-phetoang, SQL e ka sebelisa lipono le mesebetsi, empa ha e tšehetse ts'ebetso ea ho reka kantle ho naha ebile ha e fane ka ho feto-fetoha ha lipuo tsa boemo bo holimo (mohlala, u ke ke ua fetisetsa tšebetso ho ts'ebetso). Logica e u lumella ho etsa mananeo a tsoang ho li-blocks tse nyane, tse utloisisehang, le tse ka sebelisoang hape tse ka lekoang, tse amanang le mabitso a ikhethileng, 'me tsa hlophisoa ka liphutheloana tse ka sebelisoang e le karolo ea merero e meng.
Source: opennet.ru