Daim ntawv thov cov duab rau qhib cov ntaub ntawv SQLite ntawm Linux

Qee lub sijhawm peb yuav tsum qhib cov ntaub ntawv ntawm hom SQLiteCov. Ntawd yog, ib hom ntawm cov chaw khaws ntaub ntawv uas tau nrov, nws lub peev xwm los khaws cov ntaub ntawv yam tsis tas siv neeg rau zaub mov (raws li nrog MySQL lossis Postgre) yog ib yam uas tsis muaj qhov tsis txaus ntseeg nthuav.

Ob peb hnub dhau los ib qho kev paub ntawm kuv li uas nyob hauv Spain (ua haujlwm hauv qee hom tuam txhab web muab tso rau hauv Barcelona) hais rau kuv tias lawv tau tsim ib daim ntawv thov me los saib xyuas SEO ntawm qee qhov chaw, lossis qee yam zoo li ntawd ... nws tau ntxov heev thaum sawv ntxov thiab kuv tseem yuav luag tsaug zog hehe. Nws tau hais rau kuv tias nws xav tau hloov kho cov ntaub ntawv los ntawm SQLite database, tab sis nws tsis kam rau khau raj los ntawm Windows….

Thaum peb muaj cov ntaub ntawv sqlite thiab peb yuav tsum pom qee cov ntaub ntawv lossis hloov nws yooj yim, Peb tuaj yeem ua tau li cas? ... nyob rau hauv repo ntawm peb distro peb muaj ob daim duab thov rau qhov no: SQLiteMan y SQLiteBrowser

Hauv ArchLinux Kuv teeb tsa ob qho tib si nrog cov lus txib hauv qab no:

sudo pacman -S sqliteman sqlitebrowser

Hauv lwm qhov txawv li Debian lossis Ubuntu koj twb paub:

sudo aptitude install sqliteman sqlitebrowser

Muaj cov teeb meem uas tej zaum yuav tsis muaj sqliteman siv rau hauv lawv cov repo, nws tsis yog kev txhawj xeeb vim tias ob qho tib si (sqlitebrowser kuj) yog cov ntawv thov zoo heev

SQLiteMan

Nws yog Qt daim ntawv thov uas… kwv yees dab tsi, nws pab peb kom tso saib thiab hloov cov ntsiab lus los ntawm SQLite databases. ... zoo, txij ntawm no mus rau ntawm tus ncej Kuv xav tias nws yog cuab kev, txoj cai? 😀

Tsis muaj dab tsi loj ntxiv lawm. Nws yog daim ntawv thov uas ua qhov yog, tsis ntxiv los tsis tsawg. Qhov tseeb tshaj plaws (tsawg kawg hauv Arch repos) yog txij xyoo 2007, yog li peb tsis tuaj yeem thov ntau, nrog nws peb tuaj yeem:

  • Qhib cov ntawv khaws cia sqlite.
  • Txheeb xyuas cov qauv ntawm lub rooj, nrog rau lawv cov ntaub ntawv.
  • Peb kuj tuaj yeem hloov kho cov ntaub ntawv uas yog hauv cov teb lossis kab lub rooj.
  • Ua cov lus nug SQL.
  • Pragmas pauv.
  • Etc ...

Ntawm no yog ib qho screenshot:

sqliteman

Tab sis tsis txhob xav tias koj tuaj yeem ua qhov ntawd ... peb tuaj yeem ua haujlwm nrog cov ntxhuav, qauv, thiab lwm yam:

sqliteman-xaiv

Peb tuaj yeem ua dab tsi? ... zoo, qee yam yooj yim li kev tshawb (thiab hais tias peb siv ntau heev nyob rau lwm qhov system xws li PHPMyAdmin) peb tsis tuaj yeem ua nws, nws yog qhov ploj thaum peb muaj cov ntaub ntawv ntau. Hav! ... Kuv tsis yog qhov muag tsis pom kev, Kuv tau pom lub pob tshawb tab sis ... Kuv tsis tuaj yeem ua haujlwm rau kuv, tsawg kawg tsis nyob rau hauv txoj kev yooj yim, lwm yam uas yuav tshuav yuav tshawb nrhiav ncaj qha rau cov lus nug SQL, tab sis cov uas tsis siv rau qhov no ... zoo , uas lawv yuav tsis tuaj yeem tawm yam tsis muaj tawm hws. Kuv tau hais, yooj yim lossis intuitive search engine daim ntawv thov no tsis muaj.

Tsis tas li, peb tsis tuaj yeem txheeb cov kab los ntawm nias ntawm lub ncauj lus lossis nqe lus ntawm ib qho ntawm lawv. Ntawd yog, Kuv xav kom tus lej ID los ntawm qhov siab tshaj mus rau qis tshaj, yog tias kuv nyem rau ntawm lub npe (user_id piv txwv), nws tsis yuam kom nws los ntawm qis tshaj mus rau qhov siab tshaj plaws lossis lwm tus sab nraud.

Hauv kev xaus, yog daim ntawv thov Qt zoo los qhib hom ntaub ntawv no thiab saib cov ntsiab lus. Peb kuj tuaj yeem hloov kho cov ntaub ntawv nrog ob kab lus yooj yim, txhua yam, yooj yim heev. Txawm hais tias nws tsis muaj qee qhov kev nthuav dav ntxiv uas qee lub sijhawm peb yuav xav tau, tsawg kawg thaum peb ua haujlwm nrog ntau cov ntaub ntawv.

SQLiteBrowser

Lwm Qt ntawv thov rau tib yam. Ntxiv thiab, zoo heev, pom zoo heev. Peb tuaj yeem ua tau yuav luag ib yam li nrog rau ib qho ua ntej pom ... tab sis ua ntej, lub screenshot:

sqlitebrowser

Raws li kuv tau hais, koj tuaj yeem ua qhov yooj yim ib yam:

  • Khiav SQL lus nug los ntawm ib lub tab.
  • Nyeem thiab kho cov ntaub ntawv lossis cov ntaub ntawv khaws tseg hauv txoj hauv kev yooj yim heev.
  • Ua haujlwm nrog cov ntxhuav (nchuav lawv, pauv lawv, thiab lwm yam).
  • Kho teb qauv.
  • Kho kom raug pragmas.
  • Saib sql cov lus nug cav (qhov kev xaiv no hauv daim ntawv thov dhau los Kuv tsis pom nws)
  • Etc.

Ib zaug ntxiv, tus nrhiav tshawb ntawv ploj lawm 🙁

Zoo nkauj tab sis, SQLiteMan lossis SQLiteBrowser?

Raws li tsab xov xwm no hais tshwj xeeb nrog ob daim ntawv thov, nws yog ib qho ib txwm ua tias kev sib piv tau ua nyob nruab nrab ntawm lawv 😉

Kuv tsis paub tias nws yog kev txaus siab rau tus kheej lossis ib lub hom phiaj xav tau tiag tiag tab sis, Kuv pom SQLiteBrowser zoo tiav dua SQLiteMan.

Kuv tsis hais nws rau qee yam yooj yim npaum li sql log, tab sis vim tias nws muaj cov ntsiab lus uas daim ntawv thov dhau los tsis muaj, piv txwv li kuv tuaj yeem txheeb cov kab hauv cov txheej txheem nce lossis nqis (Kuv pom tias yuav luag tseem ceeb!), Kuv nrhiav tau GUI Kuv tsis paub ... zoo dua tiav, ntau polished, raws li nws qhia cov ntaub ntawv los yog cov liaj teb nyob rau hauv ntau txoj kev coj ua.

Ntxiv (thiab nws yog lwm yam tseem ceeb heev), peb muaj ib lub pob rov qab los thim rov qab los hloov cov ... O_O ... yuav ua li cas SQLiteMan tsis muaj qhov no? … WTF!

Yog tias kuv tau xaiv, SQLiteBrowser yuav yog kuv daim ntawv thov graphical rau Linux uas kho cov ntawv SQLite.

PS: Kuv vam tias Iván tau nyeem qhov no thiab tag nrho txhua yam, tias nws daws nws cov teeb meem. Los ntawm txoj kev, yog tias koj yeej nce nyiaj ... lossis qee yam zoo li ntawd, qhia nws rau peb hahaha, lossis tej zaum txoj haujlwm hauv cov tuam txhab ntawd web muab tso rau hauv Barcelona Nws yuav tsis mob leej twg, peb txhua tus paub yuav ua li cas lub ntsoog haha

Cov ntsiab lus ntawm tsab xov xwm ua raws li peb cov ntsiab cai ntawm kev tswj hwm kev ncaj nceesCov. Tshaj tawm ib qho yuam kev nyem no.

16 lus, tawm koj li

Tso koj saib

Koj email chaw nyob yuav tsis tsum luam tawm. Yuav tsum tau teb cov cim nrog *

*

*

  1. Lub luag haujlwm rau cov ntaub ntawv: Miguel Ángel Gatón
  2. Lub hom phiaj ntawm cov ntaub ntawv: Tswj SPAM, kev tswj xyuas tawm tswv yim.
  3. Sau raws cai: Koj kev tso cai
  4. Kev sib txuas lus ntawm cov ntaub ntawv: Cov ntaub ntawv yuav tsis raug xa mus rau lwm tus neeg thib peb tsuas yog los ntawm kev txiav txim siab raug cai.
  5. Cov ntaub ntawv khaws cia: Cov Ntaub Ntawv khaws tseg los ntawm Occentus Networks (EU)
  6. Txoj Cai: Txhua lub sijhawm koj tuaj yeem txwv, rov qab thiab tshem tawm koj cov ntaub ntawv.

  1.   cerberus said

    Koj yog tus neeg tawg!

  2.   Rapajk said

    Qhov zoo tshaj plaws rau SQLite, hauv kuv lub tswv yim, yog qhov Firefox plugin: "SQLite Tus Thawj Tswj". Txij li thaum kuv nrhiav tau nws, Kuv tsis tau siv ob txoj kev pab no ib zaug ntxiv li.

    1.    KZKG ^ Gaara said

      Yog, nws yog tsab xov xwm tom ntej no Kuv xav txog kev sau HAHAHAHA ... koj tau ua ntej kuv LOL !!

      1.    Rapajk said

        XD

    2.    jsbsan said

      Rapajk:
      "... Tus Thawj Tswj Xyuas SQLite ...."
      Yog lawm, tias Firefox ntxiv-tau zoo nyob thiab zoo heev ...
      Kuv tso koj ntawm qhov link rub tawm:
      https://addons.mozilla.org/es/firefox/addon/sqlite-manager/

  3.   Jorge said

    Zoo. Kuv siv Akonadi console rau ntawd ib yam nkaus.

    Txog tag nrho cov no, koj siv qhov twg los ntawm no? -> https://blog.desdelinux.net/wp-content/uploads/2014/12/sqliteman-options.png?7d6589 Zoo nkauj no.

    1.    KZKG ^ Gaara said

      Kuv siv Droid Sans rau txhua yam hauv qhov system 🙂

      1.    Jorge said

        Tsaug, tab sis kuv tsis paub yog tias koj pom tias kuv tau xa mus rau tias kev ntes.

      2.    Jorge said

        AH, tsis yog, tsis nco qab qhov kuv hais, ua tsaug, tam sim no kuv pom, txawm tias nws tsis zoo li ntawm no D:

  4.   miguel cumpa ascuña said

    Kuv siv rau yuav luag txhua kuv DB dbeaver http://dbeaver.jkiss.org/

  5.   dhunter said

    SQLiteMan tau zoo tshaj plaws hauv nws lub sijhawm tab sis tus tsim tawm tau tso nws ib cag, yog li nws tsis nyob hauv repos ntxiv lawm.

  6.   Hannibal Smith said

    Yuav ua li cas yog lub desktop chaw ntawm desdelinux admins?

    1.    elav ua said

      Hauv kuv qhov xwm txheej (thiab ntawm KZKG ^ Gaara) ces yog KDE. Kuv tsis paub tias Pablo hnav dab tsi tam sim no.

      1.    Hannibal Smith said

        Should koj yuav tsum sau kab lus hais txog koj lub desktops uas koj nyiam thiab vim li cas koj nyiam lawv 🙂 thiab qhov koj tsis nyiam txog lwm tus! 🙂

      2.    KZKG ^ Gaara said

        Qhov no tsis yog tam sim no ntau tab sis ... koj tuaj yeem muaj ib lub tswv yim: https://blog.desdelinux.net/por-que-usas-kde/

  7.   switcher said

    Ob peb xyoos dhau los kuv tau siv SQLite Studio, uas txawm hais tias nws yog lub teeb, multiplatform, portable thiab tseem ua kom txog hnub (tsawg kawg nrog cov beta version), muaj cov kab laum uas thaum kuv qhib lub hauv paus nrog cov chiv, lawv tuaj yeem ploj ntawm ib pliag mus rau lwm qhov (Kuv tsis paub yog tias lawv kho tau nws hauv qhov tseeb).
    Thaum kawg kuv tau nyob nrog SQLite Tus Thawj Tswj (feem ntau vim tias nws tuaj yeem qhib cov ntaub ntawv ntawm kuv Firefox profile thaum qhov kev zov me nyuam siv) thiab thaum kuv tsis muaj nws ces kuv siv sqlite3 los ntawm console.