An gabatar da aikin DOOMQL, yana haɓaka bambance-bambancen wasan DOOM, wanda aka rubuta a cikin SQL kuma yana iya aiwatarwa a cikin CedarDB DBMS, wani ɗan lokaci mai jituwa tare da PostgreSQL. Wasan yana goyan bayan yanayin multiplayer kuma yana yin amfani da zane-zane na ASCII. Ana rarraba lambar aikin a ƙarƙashin lasisin MIT.
Duk abubuwan da ke cikin wasan, gami da lambar bayarwa, daidaita yanayin yanayin ɗan wasa a cikin wasanni masu yawa, da madauki na wasan, an rubuta su cikin SQL. Ana aiwatar da dabarun wasan ta amfani da tebur, ra'ayoyi (VIEWs), da hanyoyin da aka adana, waɗanda ke bambanta DOOMQL daga ayyukan makamantan su DuckDB-DOOM (yana amfani da hanyoyin da aka adana a cikin WebAssembly) da pg_doom (an aiwatar da shi azaman ƙari zuwa PostgreSQL a C).
An haɓaka DOOMQL ta amfani da manufar "komai bayanai ne", ta yin amfani da teburi don adana yanayin taswira, ƴan wasa, abubuwan da ke kewaya matakin, abubuwan shigar da bayanai, saituna, da sprites. Madauki na wasan da ke da alhakin sarrafawa da sabunta yanayin wasan ana gudanar da shi ta hanyar rubutun harsashi mai layi 20 wanda ke aiwatar da lambar SQL sau 30 a cikin dakika don ƙididdige yanayin harbi, bincikar karo, aiwatar da shigarwar, da sake kunna 'yan wasa.
Mai ba da 3D na tushen SQL yana goyan bayan gano hasken rai, tsinkayar tsinkaya akan yanayin 3D, sarrafa abin da ya zoba, da kuma na'urar Nunin Shugabanni (HUD). Ana aiwatar da duk dabaru na ma'ana ta amfani da ra'ayoyi. 'Yan wasa da yawa na iya haɗawa zuwa wasan a lokaci guda, kuma ana daidaita matsayinsu ta amfani da teburi da ra'ayoyi.
A gefen mai amfani, an ƙaddamar da abokin ciniki, wanda ya haɗa da kusan layukan lamba 150 a Python. An rage aikin abokin ciniki zuwa watsa bayanai game da maɓalli da firam ɗin firam ɗin zuwa tasha. An tsara abin da aka fitar ta hanyar tambayoyin SELECT da ake aiwatarwa lokaci-lokaci zuwa kallon "allon" a cikin DBMS, wanda ke samar da layin hoto a hankali (kowane fitowar layi don amsa tambayar SELECT yayi daidai da layi akan allon). Bayani game da maɓallai da ƙara sabbin ƴan wasa ana aiwatar da su ta hanyar tambayoyin INSERT.
source: budenet.ru
