Ukusetyenziswa kwemizobo yokuvula iifayile ze-SQLite kwiLinux

UAlexander (aka KZKG ^ Gaara)

16 Izimvo

Ngamaxesha athile kufuneka sivule ifayile yohlobo SQLite. Oko kukuthi, uhlobo lwedatha oluthandwayo, amandla alo okugcina idatha ngaphandle kwemfuneko yeseva (njengakwi-MySQL okanye kwiPostgre) yinto ngaphandle kwamathandabuzo enomdla.

Kwiintsuku ezimbalwa ezidlulileyo umntu endimaziyo ohlala eSpain (isebenza kuhlobo oluthile lwenkampani ukuma kwewebhu e-Barcelona) bandixelele ukuba basaphuhlisa isicelo esincinci sokujonga i-SEO yeziza ezithile, okanye into enjalo ... kwakusekuseni kakhulu kwaye ndiphantse ndilale hehe. Indixelele ukuba ifuna ukuguqula ulwazi kwiziko ledatha le-SQLite, kodwa ayivumi ukuqala ngeWindows ...

Xa sinayo ifayile ye-sqlite kwaye sifuna ukubona idatha okanye, ukuyiguqula ngokulula, Singayenza njani? ... kwi-repo ye-distro yethu sinezinto ezibini ezibonisa oku: SQLiteMan y SQLiteBrowser

KwiArchLinux ndizifaka zombini ngalo myalelo ulandelayo:

sudo pacman -S sqliteman sqlitebrowser

Kwezinye ii-distros ezinje ngeDebian okanye Ubuntu osele uyazi:

sudo aptitude install sqliteman sqlitebrowser

Kukho ii-distros ezinokuthi zingabinayo i-sqliteman efakwe kwi-repo yabo, ayikhathazi kuba zombini (i-sqlitebrowser nayo) zizicelo ezilungileyo

SQLiteMan

Yisicelo seQt esi… ukuthelekelela ukuba yintoni, iyasinceda ukubonisa kunye nokuhlela umxholo osuka kwindawo yolwazi ye-SQLite. ... kakuhle, ngeli xesha leposi ndicinga ukuba lalicacile, akunjalo? 😀

Akukho nto imbi kwakhona. Sisicelo esenza into elungileyo, nokuba kungangaphezulu okanye kungaphantsi. Inguqulelo yamva nje (ubuncinci ifumaneka kwiArch repos) isukela ngo-2007, ke asinakho ukubuza okuninzi, ngayo sinako:

  • Vula ifayile ye-sqlite.
  • Ukuphonononga ubume beetafile, kunye nolwazi lwabo.
  • Sinokutshintsha idatha ekwimimandla okanye iiseli zetafile.
  • Yenza imibuzo ye-SQL.
  • Guqula iipragmas.
  • Etc ...

Nantsi umfanekiso weskrini:

isikwere

Kodwa sukucinga ukuba ungayenza loo nto ... singasebenza ngeetafile, izakhiwo, njl.

sqliteman-iinketho

Yintoni esingenakuyenza? ... kulungile, into elula njengokukhangela (Kwaye sisebenzisa kakhulu kwezinye iinkqubo ezinje nge-PHPMyAdminasinakuyenza, ilahlekile xa sinedatha enkulu. Hee! ... andiyimfama kangako, ndibone iqhosha lokukhangela kodwa ... andinakho ukundisebenzela, ubuncinci hayi ngendlela elula, enye into eya kuhlala iyakuba kukukhangela ngqo ngombuzo we-SQL, kodwa abo bangaqhelananga nale ... kakuhle, abangayi kuba nakho ngaphandle kokubila kancinci. Ndithe, injini yokukhangela elula okanye enomdla esi sicelo asinayo.

Kwakhona, asinakho ukuhlela iikholamu ngokunqakraza kwisihloko okanye kwisihloko senye yazo. Oko kukuthi, ndifuna uku-odola ii-ID ukusuka kwelona liphezulu ziye ezantsi, ukuba ndicofa isihlokoumsebenzisi_id umzekelo), akayithengisi ukusuka kwezantsi ukuya phezulu okanye ngokuchaseneyo.

Ngamafutshane, sisicelo esihle seQt sokuvula olu hlobo lwedatha kwaye ujonge umxholo wayo. Sisenokuhlela idatha ngonqakrazo olulula kabini, konke, kulula kakhulu. Nangona iswele ezinye iinkcukacha zokuba ngamanye amaxesha sinokufuna, ubuncinci xa sisebenza ngedatha eninzi.

SQLiteBrowser

Esinye isicelo seQt esifanayo. Kwakhona, kulungile kakhulu, kucetyiswa kakhulu. Sinokwenza phantse ngokufanayo naleyo ibonwe ngaphambili ... kodwa kuqala, umfanekiso-skrini:

Isikrubrowser

Njengoko benditshilo, unokwenza into efanayo:

  • Sebenzisa imibuzo ye-SQL kwithebhu.
  • Funda kwaye uguqule idatha okanye ulwazi olugcinwe ngendlela elula kakhulu.
  • Sebenza ngeetafile (zingabinanto, zinike igama kwakhona, njl.
  • Hlela ubume bentsimi.
  • Hlela pragmas.
  • Jonga ilog yombuzo we-sql (Andilufumananga olu khetho kwisicelo esedlule)
  • Njl

Kwakhona, injini yokukhangela ilahlekile 🙁

Kulungile kodwa, i-SQLiteMan okanye i-SQLiteBrowser?

Njengoko eli nqaku lijongana ngqo nokusetyenziswa okubini, kuyinto eqhelekileyo ukuba uthelekiso lwenziwe phakathi kwabo 😉

Andazi ukuba luxabiso lomntu okanye umbono oqinisekileyo kodwa, Ndifumanisa ukuba i-SQLiteBrowser igqityiwe ngcono kune-SQLiteMan.

Andiyithethi kwinto elula njenge-sql log, kodwa ngenxa yokuba ineenkcukacha zokuba isicelo sangaphambili asikho, umzekelo ndinokuhlela iikholamu ngokunyuka okanye ukuhla ngokulandelelana (Ndiyifumana iphantse yabaluleka!), Ndifumana i-GUI andiyazi ... igqityiwe ngcono, ipholile ngakumbi, njengoko ibonisa ulwazi okanye imihlaba ngendlela enocwangco.

Ngokuqhubekayo (kwaye yenye into kubaluleke kakhulu), sinamaqhosha okubuyisa okanye okulungisa utshintsho ... O_O ... kutheni iSQLiteMan ingenayo le nto? … WTF!

Ukuba ndinikwe ukhetho, i-SQLiteBrowser iya kuba sisicelo sam esibonisa iLinux esebenzisa iifayile ze-SQLite.

PS: Ndiyathemba ukuba u-Iván uyakufunda oku kwaye nangaphezulu kwako konke, ukuba uyayisombulula ingxaki yakhe. Ngendlela, ukuba uphumelele ukunyusa ... okanye into enjalo, yabelana nathi hahaha, okanye isikhundla kule nkampani ukuma kwewebhu e-Barcelona Ayizukulimaza nayo, sonke siyayazi ukuba ingxaki i-haha

Umxholo wenqaku uyabambelela kwimigaqo yethu imigaqo yokuziphatha yokuhlela. Ukuxela impazamo cofa apha.

Izimvo ezi-16, shiya ezakho

Shiya uluvo lwakho

Idilesi yakho ye email aziyi kupapashwa. ezidingekayo ziphawulwe *

*

*

  1. Uxanduva lwedatha: UMiguel Ángel Gatón
  2. Injongo yedatha: Ulawulo lwe-SPAM, ulawulo lwezimvo.
  3. Umthetho: Imvume yakho
  4. Unxibelelwano lwedatha: Idatha ayizukuhanjiswa kubantu besithathu ngaphandle koxanduva lomthetho.
  5. Ukugcinwa kweenkcukacha
  6. Amalungelo: Ngalo naliphi na ixesha unganciphisa, uphinde uphinde ucime ulwazi lwakho.

  1.   iizerberros sitsho
    yenzayo 9 iminyaka

    Uqhekekile!

    Phendula kwi-zerberros
  2.   rapajk sitsho
    yenzayo 9 iminyaka

    Eyona ilungileyo kwi-SQLite, ngokoluvo lwam, sisongezo seFirefox: "Umphathi weSQLite". Ukusukela oko ndiyifumeneyo, andikaze ndisebenzise enye yezi nkqubo kwakhona.

    Phendula kwiRapajk
    1.    I-KZKG ^ iGaara sitsho
      yenzayo 9 iminyaka

      Ewe, yayilinqaku elilandelayo bendicinga ukubhala HAHAHAHA… uhambe phambi kwam LOL !!

      Phendula KZKG ^ Gaara
      1.    rapajk sitsho
        yenzayo 9 iminyaka

        XD

        Phendula kwiRapajk
    2.    jsbsan sitsho
      yenzayo 9 iminyaka

      Rapajk:
      "... Umphathi weSQLite ...."
      Ewe, isongezelelo seFirefox sikhululekile kwaye silungile ...
      Ndikushiya ikhonkco lokukhuphela:
      https://addons.mozilla.org/es/firefox/addon/sqlite-manager/

      Phendula jsbsan
  3.   Jorge sitsho
    yenzayo 9 iminyaka

    Kulungile. Ndisebenzisa ikhonsoli yeAkonadi nayo.

    Kuko konke oku, yeyiphi imithombo oyisebenzisayo apha? -> https://blog.desdelinux.net/wp-content/uploads/2014/12/sqliteman-options.png?7d6589 Intle le.

    Phendula Jorgicio
    1.    I-KZKG ^ iGaara sitsho
      yenzayo 9 iminyaka

      Ndisebenzisa ii-Droid Sans kuyo yonke into ekwinkqubo 🙂

      Phendula KZKG ^ Gaara
      1.    Jorge sitsho
        yenzayo 9 iminyaka

        Enkosi, kodwa andazi ukuba uqaphele ukuba bendibhekisa KUKHO ukubanjwa okuthile.

        Phendula Jorgicio
      2.    Jorge sitsho
        yenzayo 9 iminyaka

        Hayi, hayi, ulibale into endiyithethileyo, enkosi, ngoku ndiyibonile, nangona ingakhangeleki ngolu hlobo apha D:

        Phendula Jorgicio
  4.   miguel cumpa ascuna sitsho
    yenzayo 9 iminyaka

    Ndisebenzisa phantse yonke i-dbeaver yam ye-DB http://dbeaver.jkiss.org/

    Phendula u-miguel cumpa ascuña
  5.   dhunter sitsho
    yenzayo 9 iminyaka

    I-SQLiteMan yayiyeyona nto ibalaseleyo ngexesha layo kodwa umphuhlisi uyibeke ecaleni, ke ayisekho kwi-repos.

    Phendula kwi-dhunter
  6.   UHannibal Smith sitsho
    yenzayo 9 iminyaka

    Zeziphi iimeko zedesktop zabaphathi be-desdelinux?

    Phendula u-Anibal Smith
    1.    iyeva sitsho
      yenzayo 9 iminyaka

      Kwimeko yam (kunye ne-KZKG ^ Gaara) emva koko yi-KDE. Andazi ukuba uPablo unxibe ntoni ngoku.

      Phendula u-elav
      1.    UHannibal Smith sitsho
        yenzayo 9 iminyaka

        Write kufuneka ubhale inqaku malunga needesktops zakho ozithandayo kwaye kutheni uzithanda 🙂 kwaye yintoni ongayithandiyo ngabanye! 🙂

        Phendula u-Anibal Smith
      2.    I-KZKG ^ iGaara sitsho
        yenzayo 9 iminyaka

        Le ayisiyonto yangoku kodwa ... unokuba noluvo: https://blog.desdelinux.net/por-que-usas-kde/

        Phendula KZKG ^ Gaara
  7.   umtshintshi sitsho
    yenzayo 9 iminyaka

    Kwiminyaka embalwa edlulileyo bendisebenzisa Isitudiyo seSQLite, nangona ilula, iplatifomu, iyaphatheka kwaye isekhona (ubuncinci kunye neenguqulelo ze-beta), yayine-bug ethi xa ndivula i-database enezinto ezibangela, ezi zinokuphela zisuka komnye umzuzu ziye komnye (andazi Yazi ukuba bayilungisile kwiinguqulelo zamva nje).
    Ekugqibeleni ndaye ndahlala nomphathi we-SQLite (ikakhulu kuba inokuvula iinkcukacha zephrofayili yam yeFirefox ngelixa inkqubo isasebenza) kwaye xa ndingenayo ke ndisebenzisa i-sqlite3 ngekhonsoli.

    Phendula uSwicher