Franchise: Inoshamisa SQL Online Mutengi

Dhata chikamu chakakosha chekushandisa kwazvino uye mazuva ese ivo vanotora yakanyanya yepamusoro yekutengesa kukosha nekuda kweiyo Big data, ndosaka nzira dzakasiyana dzekuchengetedza dhata dzichimuka zuva nezuva uye zvakare dzakasiyana zvishandiso zvekubatanidza kune akanyanya kufarirwa dhatabhesi. Imwe yakandishamisa zvinofadza ndeye SQL Online mutengi inonzi Franchise, kuti isu inobvumidza kuwana kune akasiyana dhatabhesi kubva kubhurawuza pasina chikonzero chekuisa chero chishandiso.

kodzero Pasina kupokana chishandiso chinotibvumira kuti tiite akakosha mabasa munguva pfupi, kubva chero kupi, pasina chikonzero chekuisa chechitatu bato kunyorera uye nezvose zvakanakira izvo zvemahara software zvinotipa isu. Ini pachangu, ini ndinofunga kuti chinonyanya kushamisa chinhu pamusoro pechikumbiro iko mukana wekushanda mune sevhisi inogarwa nevechitatu mapato, kana kungoita sevhisi yatinozvimisikidza pachedu uye nekwatiri kuzotonga kuzere kumatabhesi edu.

Chii chinonzi Franchise?

kodzero ane simba SQL mutengi, ivo open source uye yakagadzirwa mu JavaScript iyo yatinokwanisa kuwana kubva kune chero bhurawuza uye iyo inotibvumidza kuti tibatanidze kune akasiyana dhatabhesi nenzira yakapusa, mukuwedzera pakukwanisa kuitisa SQLite natively.

Pasina kuisa chero chinhu chatinogona kuita SQL mibvunzo kune edu dhatabhesi, pamusoro pekubatanidza CSV, JSON o XLSX izvo zvatinogona kubata nazvo SQLiteKuburikidza nechiedza chayo chakareruka asi chine simba tichakwanisa kuita mibvunzo yakawanda, kuona magirafu, kuenzanisa kwemibvunzo, kuyedza mibvunzo mitsva nekubatana nedhatabhesi.

Chishandiso chinotipa mukana wekubatanidza PostgreSQL , MySQL o hukuru, kuburikidza neshumiro inomhanya pane sevha panochengetwa dhatabhesi, nemirairo yakapusa isu tatova nezambuko pakati pe database uye mutengi weFranchise. Zvakakosha, iyo data haimbo pfuure neiyo Franchise server sezvo zvese zvichitarisirwa munharaunda (pakombuta yako), Kugadzira inokurumidza uye yakachengeteka maitiro.

Chimwe chezvinhu zvinokwezva zveFranchise ndezvekuti nzira iyo dhata ratiratidza isu, inogona kuva inoratidzwa mune tafura fomati kana kadhi kuona, ichitipa mukana wekutarisa iyo data panguva yatiri kuwana. Saizvozvowo, Franchise inopa kugona kuona data muchimiro chekuparadzira madhayagramu, mabarati machati, marati machati e data akateedzana enguva, mepu, nevamwe vazhinji.

Uyu SQL mutengi anotipawo kugona kuyedza mibvunzo, saka tinogona tamba nedhatabhesi yedu pasina kukanganisa iyo data iri mukugadzirwa, iyo yakawedzera pakukwanisa kugovana mibvunzo yese, mhedzisiro uye kutarisisa kwatakagadzira, inotipa mukana wakazara wekuwongorora nekutungamira kwedata rega kana pamwe chete.

Nzira yekushandisa sei Franchise?

Nzira yakakodzera kwazvo yekushandisa kodzero Iri kuburikidza nebasa rayo regore, kune izvi, ingovhura iyo application https://franchise.cloud/app/ uye tanga kubatanidza mafaera edu CSV, XLSX, JSON, SQLite o SQL, nenzira imwecheteyo yatinokwanisa kubatana nayo PostgreSQL , MySQL o bigquery, kuita rairo yakaratidzirwa.

Izvo zvakakosha kuti uzive kuti kubatana kune dhatabhesi yakachengetwa pakombuta yedu kana server isu tinofanirwa kunge takaisa npm y npx, iyo iri mu ubuntu uye zvigadzirwa zvaizoiswa seinotevera:

sudo apt-tora kuisa -y nodejs sudo apt-tora kuisa -y kuvaka-yakakosha sudo npm kuisa -g npx

Kana isu tichida kutora yedu Franchise yekumisikidza, isu tinofanirwa kuita mirairo iyo vanogadzira vanoratidza, iyo iwe yaunogona kuwana pazasi:

git clone --depth 1 https://github.com/HVF/franchise.git cd franchise npm kuisa npm kutanga

Nezvo, iwe unenge uine sevhisi inomhanya pane yako server, iyo iwe yaunogona kuwana kubva http://localhost:3000

Pasina kupokana, iyi SQL mutengi ichave chishandiso chinofanira kutariswa nevese Dhatabhesi manejimendi uye zvakare kune avo vakanyudzwa mukutungamira kweBig Data, ibasa rakareruka chaizvo kushandisa asi uine unviable kugona. Iyo interface uye kugona kwayo kwekuona zvinoita kuti zvive zvinofadza kushandisa uye pfungwa yayo inotibatsira kutamba neruzivo nemadhata edu zvakachengeteka, kubva chero kupi uye nezviri nyore zvinodiwa.