I-Google yethule ulimi olusha lokuhlela olunengqondo, i-Logica, oludizayinelwe ukukhohlisa idatha nokuhumushela izinhlelo ku-SQL. Ulimi olusha luqondiswe kulabo abafuna ukusebenzisa i-logic programming syntax lapho bebhala imibuzo yesizindalwazi. Okwamanje, ikhodi ye-SQL ewumphumela ingafakwa kusitoreji se-Google BigQuery noma ku-PostgreSQL kanye ne-SQLite DBMSs, ukusekela okusahlolwa. Esikhathini esizayo kuhlelwe ukwandisa inani lezilimi zesigodi ze-SQL ezisekelwayo. Ikhodi yephrojekthi ibhalwe ngePython futhi ishicilelwe ngaphansi kwelayisensi ye-Apache 2.0.
I-Logica iqhubeka nokuthuthukiswa kolunye ulimi lokucubungula idatha oluthuthukiswe yi-Google, i-Yedalog, futhi inikeza izinga lokucaphuna elingatholakali ku-SQL evamile. Imibuzo ku-Logica ihlelwe ngendlela yesethi yezitatimende ezinengqondo. Isekela amamojula, ukungenisa, kanye nekhono lokusebenzisa i-Logica kusukela kugobolondo le-Jupyter Notebook elisebenzisanayo. Isibonelo, ukuze wenze isifinyezo sabantu okukhulunywa ngaso kakhulu ezindabeni zango-2020, ungasebenzisa uhlelo olulandelayo lwe-Logica ukuze ufinyelele kusizindalwazi se-GDELT: @OrderBy(Mentions, “mentions desc”); @Limit(Okushiwo, 10); Isho(umuntu:, isho? += 1) ehlukile :- gdelt-bq.gdeltv2.gkg(abantu:, idethi:), Substr(ToString(date), 0, 4) == “2020”, the_persons == Hlukanisa (abantu, ";"), umuntu e_ebantwini; $ logica mentions.l run Isho +——————————————+ | umuntu | ibalula_ibali | +——————+——————-+ | Donald Trump | 3077130 | | los angeles | 1078412 | | joe biden | 1054827 | | uGeorge Floyd | 872919 | | boris johnson | 674786 | | Barack Obama | 438181 | | vladimir putin | 410587 | | Bernie Sanders | 387383 | | u-Andrew cuomo | 345462 | | las vegas | 325487 | +——————+——————-+
Ukubhala imibuzo eyinkimbinkimbi ku-SQL kuholela esidingweni sokubhala amaketanga emigqa eminingi anzima okungabonakali ukuthi aqondwe, aphazamisane nokusetshenziswa kabusha kwezingxenye zombuzo, futhi kube nzima ukulungisa. Ezibalweni eziphindaphindayo ezijwayelekile, i-SQL ingasebenzisa ukubuka nemisebenzi, kodwa ayisekeli imisebenzi yokungenisa futhi ayinikezi ukuguquguquka kwezilimi ezisezingeni eliphezulu (isibonelo, awukwazi ukudlulisa umsebenzi kumsebenzi). I-Logica ikuvumela ukuthi ubhale izinhlelo ezivela kumabhulokhi amancane, aqondakalayo, futhi asebenzisekayo anengqondo angahlolwa, ahlotshaniswe namagama athile, futhi ahlanganiswe abe amaphakheji angasetshenziswa njengengxenye yeminye imiklamo.
Source: opennet.ru