Fia HN: SQL-tap – Ɣeyiɣi ŋutɔŋutɔ SQL ʋuɖoɖo kpɔla na PostgreSQL kple MySQL

Nukae Nye SQL-tap eye Nukatae Wòle Be Nyatakakadzraɖoƒe ƒe Ƒuƒoƒo Ðesiaɖe Nalé Be Nae?

SQL-tap nye dɔwɔnu yeye si le ʋuʋu ɖi si na be dɔwɔlawo kpɔa PostgreSQL kple MySQL biabia le ɣeyiɣi ŋutɔŋutɔ me, tso terminal la dzi tututu. Woɖee fia le Hacker News abe "Fia HN" dɔ ene, ekpɔa kuxi aɖe si mɔ̃ɖaŋudɔwɔlawo ƒe ƒuƒoƒo ɖesiaɖe do goe gbɔ: nusi tututu SQL ʋuwo le ƒoƒom le wò nyatakakadzraɖoƒea le ɣeyiɣi ɖesiaɖe me gɔmesese.

Na ƒuƒoƒo siwo le dɔ siwo me nyatakakawo sɔ gbɔ ɖo wɔm — eɖanye be ema fia numekuku ƒe dashboardwo, CRM pɔmpiwo, alo asitsadɔwɔɖoɖo blibo abe Mewayz ene o — nyatakakadzraɖoƒe ƒe dzedzeme le ɣeyiɣi ŋutɔŋutɔ me meganye tiatia o. Enye gɔmedzedze ƒe nudidi na dɔwɔwɔ, vodadawo ɖɔɖɔɖo, kple dedienɔnɔ.

Aleke SQL-tap wɔa dɔ le Hood Te?

SQL-tap xea mɔ na nyatakakadzraɖoƒe ƒe ʋuʋu le network ƒe ɖoɖo nu evɔ mehiã be nàwɔ tɔtrɔ aɖeke le wò dɔwɔwɔ ƒe kɔpi alo nyatakakadzraɖoƒe ƒe ɖoɖowɔwɔ ŋu o. Eléa packet siwo le sisim le wò dɔwɔwɔ kple nyatakakadzraɖoƒe ƒe dɔwɔƒea dome le mɔ si mewɔa naneke o nu, eɖea PostgreSQL alo MySQL ka ƒe ɖoɖowɔɖi gɔme, eye wòɖea biabia ɖesiaɖe ƒe nukpɔkpɔ si le agbe, si woate ŋu aʋu la fiana esime wòle edzi yim.

Mɔnu sia naa viɖe geɖe wu nyabiasewo ƒe nuŋlɔɖi xoxowo. Mehiã be nàna biabia ƒe nuŋlɔɖi blewu nawɔ dɔ o, dɔwɔwɔ ƒe gazazã aɖeke meli tso nyatakakadzraɖoƒe ƒe ɖoɖo ƒe agbalẽdzikpɔkpɔ me o, eye afɔku aɖeke meli be biabia siwo bu si to wò ORM ŋu o. Ðeko dɔwɔnua léa ŋku ɖe ka la ŋu hegblɔa nusi wòkpɔna. Le dɔwɔla siwo zã gaƒoƒo geɖe tsɔ ku nu me le nuŋlɔɖi faɛlwo me henɔ agbagba dzem be yewoagbugbɔ nuwɔwɔ ƒe nya aɖe awɔ la, nyaŋuɖoɖo enumake ƒe ʋuƒo sia ƒomevi nye tɔtrɔ.

Dɔa doa alɔ ʋuʋu le biabia ƒe ƒomevi, kplɔ̃ ƒe ŋkɔ, kple dɔwɔwɔ ƒe ɣeyiɣi nu, si wɔe be wòwɔa dɔ le nɔnɔme siwo me wowɔa dɔ geɖe le gɔ̃ hã me afisi biabia akpe geɖe le sɛkɛnd ɖeka me nye nusi bɔ.

Nukatae Ɣeyiɣi Ŋutɔŋutɔ SQL ƒe Nukpɔkpɔ Le Vevie Na Egbegbe Asitsatsa ƒe Mɔ̃wo?

Egbegbe asitsatsa ƒe mɔnuwo mewɔa dɔ le nyatakakadzraɖoƒe ƒe kplɔ̃ ɖeka dzi o. Wowɔa ɖoɖo ɖe modules alafa geɖe siwo do ƒome kple wo nɔewo ŋu — dɔa dzikpɔkpɔ, fexexe, nudzraɖoƒe, HR, asisiwo ƒe kpekpeɖeŋu, kple bubuwo. Le Mewayz, míaƒe 207-module business OS subɔa zãla siwo wu 138,000, eye module mawo dometɔ ɖesiaɖe wɔa nyatakakadzraɖoƒe ƒe nyabiase siwo wòle be woawɔ dɔ nyuie eye kakaɖedzi le wo ŋu.

Ne nuƒolanɔƒe si ƒe lolome le nenema kpɔ blewu la, nusi gbɔ wòtso la nyanya evɔ womate ŋu akpɔe le ɣeyiɣi ŋutɔŋutɔ me o le abe aŋe didi le gbe me ene. Dɔwɔnuwo abe SQL-tap ene trɔa equation la keŋkeŋ. Le esi teƒe be nàsusu module si le biabia xɔasiwo hem vɛ la, àteŋu akpɔe wòanɔ dzɔdzɔm le agbe.

ƒe nyawo

Nyatakakadzraɖoƒe ƒe kuxi si xɔ asi wue nye esi màte ŋu akpɔ o. SQL ƒe ʋuɖoɖo ƒe dzedzeme le ɣeyiɣi ŋutɔŋutɔ me trɔa dɔwɔwɔ ƒe mɔxenu siwo womekpɔna o zua nya siwo dze ƒã, siwo woate ŋu aɖɔ ɖo — hafi wò zãlawo nade dzesii gbeɖe.

Gɔmeɖose sia wɔa dɔ nenye be èle gɔmedzedze aɖe wɔm kple PostgreSQL ƒe kpɔɖeŋu ɖeka alo dɔwɔƒe ƒe mɔ̃ si le asitsatsa miliɔn geɖe gbɔ kpɔm gbesiagbe.

Viɖe Vevi Kawoe Le Ɣeyiɣi Ŋutɔŋutɔ ƒe SQL Dzikpɔkpɔ Zazã Me?

Akpa siwo wɔa SQL dzikpɔkpɔ le ɣeyiɣi ŋutɔŋutɔ me — eɖanye to SQL-tap alo dɔwɔnu mawo tɔgbe dzi o — gblɔa ŋgɔyiyiwo ɣesiaɣi le woƒe dɔwɔwɔ ƒe akpa vovovowo me:

ƒe nyawo
• Nudzɔdzɔ ƒe ŋuɖoɖo kabakaba: Ne nyatakakadzraɖoƒe ƒe nya aɖe dze dɔwɔwɔ dzi la, ɣeyiɣi ŋutɔŋutɔ ƒe nukpɔkpɔ dzi ɖeɖe kpɔtɔ fia be ɣeyiɣi si woatsɔ akpɔ egbɔe tso gaƒoƒo yi aɖabaƒoƒo me. Èkpɔa nyabiase si me kuxi le la le ɣeyiɣi si me wòdze, tsɔ wu be nàgbugbɔ nudzɔdzɔwo atu tso nuŋlɔɖiwo me le nyateƒea megbe.
• Proactive performance tuning: Nyabiase ƒe nɔnɔme siwo le agbe kpɔkpɔ ɖea optimisation mɔnukpɔkpɔ siwo static analysis tools to la fiana. Àteŋu akpɔ N+1 biabia, kplɔ̃ bliboa ƒe skan siwo mehiã o, kple ƒoƒo siwo mehiã o ne wole dzɔdzɔm le zazã ŋutɔŋutɔ me.
• Dedienɔnɔ ƒe nɔnɔme si nyo wu: Ɣeyiɣi ŋutɔŋutɔ me ŋkuléle ɖe nu ŋu wɔa dɔ abe nuxlɔ̃ameɖoɖo kaba ene na SQL dodo ƒe agbagbadzedzewo, nyatakakawo ƒe gege ɖe eme si ŋu womeɖe mɔ ɖo o, kple biabia ƒe ɖoɖo siwo mebɔ o siwo ateŋu afia be woda le se dzi alo womeɖoe nyuie o.
• Dɔwɔwɔ ƒe dɔwɔwɔ nyuie wu: Dɔwɔlawo ateŋu akpɔ SQL si tututu woƒe kɔda la wɔna le teƒea ƒe ŋgɔyiyi kple ɖoɖowɔwɔ me, alé kpɔɖeŋu siwo mewɔa dɔ nyuie o hafi woaɖo ewɔwɔ gbɔ. Esia xɔ asi ŋutɔ ne wole dɔ wɔm kple ORM siwo ɖea biabia siwo le ete la ɖa.
• Ŋutete ƒe ɖoɖowɔwɔ ƒe nyateƒetoto: Lé ŋku ɖe biabia ƒe agbɔsɔsɔ ŋutɔŋutɔ kple woƒe sesẽ ŋu le ɣeyiɣi aɖe megbe naa nyatakaka siwo hiã be woatsɔ awɔ nyametsotso siwo ŋu wonya nu tsoe le dzidzedzekpɔkpɔ, indexing mɔnuwo, kple xɔtuɖoɖowo ƒe gadede ŋu.

Aleke Esia Sɔ Ðe Asitsatsa ƒe Dɔwɔɖoɖo Si Gã Wu Me?

Nyatakakadzraɖoƒe ƒe dɔwɔwɔ menye mɔ̃ɖaŋununya ƒe dzitsitsi dzro aɖe ko o. Ekpɔa ŋusẽ ɖe ezãlawo ƒe nuteƒekpɔkpɔ, dɔwɔwɔ nyuie, kple mlɔeba gakpɔkpɔ dzi tẽ. Adzɔxegbalẽvi ƒe screen si xɔa agba blewu gblẽa ga ŋutɔŋutɔ na asitsaha aɖe le dɔwɔwɔ si bu me. Ɣeyiɣi aɖe ƒe nuwuwu le dashboard si dze ŋgɔ asisiwo dzi gblẽa kakaɖedzi me eye wòʋãa churn.

Esia tae mɔ̃wo abe Mewayz ene dea ga geɖe nyatakakadzraɖoƒe ƒe nyonyome me le module 207 katã me. Nyabiase ɖesiaɖe le vevie ne wò mɔ̃a kpɔa nusianu gbɔ tso dɔa yometiti dzi va ɖo fetu ŋuti dɔwɔwɔ na dɔwɔƒe akpe geɖe dzi. Dɔwɔnuwo abe SQL-tap ene ƒe dodo ɖe dɔwɔƒea ƒe tɔtrɔ si keke ta wu ɖe ŋkuléleɖenuŋu gbãtɔ ƒe mɔ̃ɖaŋudɔwɔwɔ ŋu fia, afisi ƒuƒoƒowo tua ŋkuléle ɖe nu ŋu kple nukpɔkpɔ ɖe woƒe dɔwɔwɔ ƒe ɖoɖowo me tso ŋkeke gbãtɔ dzi tsɔ wu be woatsɔ bolt ablae le kuxiwo do mo ɖa vɔ megbe.

Na asitsaha siwo le woƒe mɔ̃ɖaŋununya ƒe ƒuƒoƒo me dzrom la, nusɔsrɔ̃a me kɔ: tia mɔ̃wo kple dɔwɔnu siwo tsɔa nukpɔkpɔ kple dɔwɔwɔ ɖoa nɔƒe gbãtɔ le ƒuƒoƒo ɖesiaɖe me, tso nyatakakadzraɖoƒea dzi va ɖo zãla ƒe ŋgɔdonya dzi.

Nyabiase Siwo Wobiana Enuenu

Ðe SQL-tap wɔa dɔ kple nyatakakadzraɖoƒe siwo wokpɔa alilikpo dzi abe Amazon RDS alo Google Cloud SQL enea?

SQL-tap wɔa dɔ to network traffic léle ɖe wò dɔwɔwɔ kple database server dome. Le alilikpo me nɔnɔmewo me la, zi geɖe la, esia bia be nàwɔ dɔwɔnua le network alo instance ɖeka dzi kple wò application server. Nyatakakadzraɖoƒe ƒe ɖoɖo aɖewo siwo dzi wokpɔna ateŋu aɖo seɖoƒe na packet-level access, eyata ele vevie be woaɖo kpe network ƒe mɔɖeɖewo dzi. Ƒuƒoƒo geɖewo wɔa SQL-tap le woƒe dɔwɔwɔ ƒe dɔwɔƒewo tsɔ wu be woawɔe le nyatakakadzraɖoƒe ƒe amedzro ŋutɔ dzi, si wɔa dɔ nyuie le alilikpo ƒe ɖoɖo akpa gãtɔ me.

Ðe SQL dzikpɔkpɔ le ɣeyiɣi ŋutɔŋutɔ me ateŋu axɔ ɖe nyatakakadzraɖoƒe ƒe dɔwɔwɔ dɔwɔnu xoxowo teƒea?

Ɣeyiɣi ŋutɔŋutɔ me ʋuwo kpɔkpɔ kpena ɖe dɔwɔnu xoxowo abe EXPLAIN numekuku, biabia ƒe ɖoɖowɔlawo, kple APM egbɔkpɔnuwo teƒe tsɔ wu be wòaxɔ ɖe eteƒe. SQL-tap bi ɖe nusi le dzɔdzɔm fifia ɖeɖefia wò me, esime dɔwɔnu xoxowo nyo wu na biabia tɔxɛwo ƒe deep-dive optimization. Nyatakakadzraɖoƒe ƒe ƒuƒoƒo siwo wɔa dɔ nyuie wu zãa mɔnu eveawo siaa ɖekae — ŋkuléle ɖe nu ŋu le ɣeyiɣi ŋutɔŋutɔ me be woatsɔ ade dzesi nyawo kaba, kple numekuku dɔwɔnuwo be woakpɔ wo gbɔ nyuie.

Aleke asitsaha ƒe OS abe Mewayz ene ateŋu akpeɖe ƒuƒoƒo siwo le avu wɔm kple dɔwɔwɔ ƒe kuxi sesẽwo ŋu?

Mewayz ƒoa asitsatsa ƒe modules 207 nu ƒu ɖe mɔ̃ ɖeka me, si ɖea ƒoƒo ɖekae ƒe taɖuame kple nyatakaka silo siwo dona tso dɔwɔnu vovovo gbogbo aɖewo ƒe ƒoƒo ɖekae me ɖa. Esi ɖoɖowo dzea egɔme tso $19 ɣleti sia ɣleti ta la, ƒuƒoƒowo kpɔa mɔ akpɔ dɔa dzikpɔkpɔ, CRM, fexexe, HR, nudzraɖoƒe, kple modules bubu geɖewo — wo katã woama nyatakakadzraɖoƒe ɖeka kple ŋgɔdonya. Nuƒoƒoƒu sia fia be ɖoɖo ʋɛ aɖewo koe wòle be woalé ŋku ɖe wo ŋu, ƒoƒo ɖekae ƒe teƒe ʋɛ aɖewo koe woatsɔ aɖɔ vodadawo ɖo, eye nyateƒetsoƒe ɖeka koe li na wò dɔwɔwɔ bliboa.

Asitsaha si wɔa dɔ nyuie tutu bia dɔwɔnu nyuitɔ kple nuƒolanɔƒe nyuitɔ siaa. Eɖanye be èle nyatakakadzraɖoƒe ƒe biabiawo ɖɔm ɖo kple SQL-tap alo nèle wò dɔwɔwɔ bliboa wɔm wòle bɔbɔe o, nukpɔkpɔ kple ƒoƒo ɖekae nye safui siwo ana nàdzidze nu nyuie.

Èle klalo be yeana yeƒe asitsadɔwo nanɔ bɔbɔe? Wɔ ɖeka kple ezãla siwo wu 138,000 siwo le woƒe dɔwɔƒewo dzi kpɔm le Mewayz. Dze wò dodokpɔ femaxee gɔme le app.mewayz.com eye nàkpɔ nusi asitsahabɔbɔ ƒe OS si wɔ ɖeka ateŋu awɔ na wò ƒuƒoƒoa.