Google yakhazikitsa chilankhulo chatsopano chofotokozera, Logica, chomwe chimapangidwira kusokoneza deta ndikumasulira mapulogalamu mu SQL. Chilankhulo chatsopanochi chimayang'ana kwa iwo omwe akufuna kugwiritsa ntchito mawu omveka bwino polemba mafunso pa database. Pakali pano, khodi ya SQL yotsatila ikhoza kuchitidwa mu Google BigQuery yosungirako kapena mu PostgreSQL ndi SQLite DBMSs, thandizo lomwe likuyesabe. M'tsogolomu akukonzekera kukulitsa chiwerengero cha zilankhulo zothandizidwa za SQL. Khodi ya polojekitiyi idalembedwa ku Python ndikusindikizidwa pansi pa layisensi ya Apache 2.0.
Logica ikupitiliza kukulitsa chilankhulo china chopangidwa ndi Google, Yedalog, ndipo imapereka mulingo wosapezeka mu SQL wamba. Mafunso mu Logica amapangidwa ngati mawu omveka bwino. Imathandizira ma module, kulowetsa kunja, komanso kuthekera kogwiritsa ntchito Logica kuchokera ku chipolopolo cha Jupyter Notebook. Mwachitsanzo, kuti mupange chidule cha anthu omwe amatchulidwa kwambiri m'nkhani za 2020, mutha kugwiritsa ntchito pulogalamu ya Logica yotsatirayi kuti mupeze nkhokwe ya GDELT: @OrderBy(Mentions, "mentions desc"); @Limit(Kutchulidwa, 10); Kutchulidwa(munthu:, kutchulidwa? += 1) kosiyana :- gdelt-bq.gdeltv2.gkg(anthu:, deti:), Substr(ToString(tsiku), 0, 4) == “2020”, the_persons == Split (anthu, ";"), munthu mwa_anthu; $ logica mentions.l run Kutchula +———————+——————-+ | munthu | kutchula_kuwerengera | +——————+——————-+ | Donald Lipenga | 3077130 | | | los angeles | 1078412 | | | joe biden | 1054827 | | | George Floyd | 872919 | | | boris johnson | 674786 | | | Barack Obama | 438181 | | | vladimir putin | 410587 | | | Bernie Sanders | 387383 | | | Andrew kumo | 345462 | | | las vegas | 325487 | +——————+——————-+
Kulemba mafunso ovuta mu SQL kumabweretsa kufunika kolemba maunyolo olemetsa amizere ambiri omwe samveka bwino, amasokoneza kugwiritsa ntchito mbali zina za funsolo, komanso kukonza zovuta. Pamawerengedwe obwerezabwereza, SQL imatha kugwiritsa ntchito mawonedwe ndi ntchito, koma sizigwirizana ndi zolowetsa kunja ndipo sizipereka kusinthasintha kwa zilankhulo zapamwamba (mwachitsanzo, simungathe kupititsa ntchito ku ntchito). Logica imakulolani kuti mupange mapulogalamu kuchokera ku midadada yaying'ono, yomveka, komanso yosinthika yomwe ingayesedwe, yolumikizidwa ndi mayina enaake, ndikuyika m'magulu omwe angagwiritsidwe ntchito ngati gawo la ntchito zina.
Source: opennet.ru
