ProHoster > Pūnaewele > Nā Administration > He pepa DIY maikaʻi loa, a i ʻole GitHub ma kahi o ka notepad

He pepa DIY maikaʻi loa, a i ʻole GitHub ma kahi o ka notepad

He pepa DIY maikaʻi loa, a i ʻole GitHub ma kahi o ka notepad

Aloha, Habr! Malia paha, loaʻa i kēlā me kēia o mākou kahi faila kahi e hūnā ai i kahi mea pono a hoihoi no mākou iho. ʻO kekahi mau loulou i nā ʻatikala, nā puke, nā waihona, nā manual. Hiki paha kēia i nā bookmark browser a i ʻole i wehe wale i nā ʻaoʻao i waiho ʻia no hope. I ka hala ʻana o ka manawa, pehu kēia mau mea a pau, pau nā loulou i ka wehe ʻana, a lilo ka hapa nui o nā mea i ka wā kahiko.

Pehea inā mākou e kaʻana like i kēia maikaʻi me ke kaiāulu a kau i kēia faila ma GitHub? A laila hiki i kāu hana ke hoʻohana i kekahi mea ʻē aʻe, a hiki iā ʻoe ke hoʻomau i ka pili pū me ka ʻae ʻana i nā mea hou mai ka poʻe makemake ma o ka PR kahiko. ʻO kēia ka mea i hoʻolālā ʻia no ka papahana. Nā papa inoa maikaʻi. Hoʻokomo ʻia ia i loko o ka TOP 10 GitHub repositories, loaʻa iā 138K mau hōkū, a hiki ke ʻike ʻia kahi loulou i kāu mau hana ma kāna kumu README, kahi e huki ai ka lehulehu i kāu hana. ʻOiaʻiʻo, pono kēia e hoʻoikaika iki. Makemake au e kaʻana like i koʻu ʻike o ia mau hana me ʻoe.

ʻO Maxim Gramin koʻu inoa. Ma CROC hana wau i ka hoʻomohala ʻana a me ka noiʻi ʻikepili. Ma kēia pou e haʻi aku wau iā ʻoe he aha nā Awesome Lists a pehea e hana ai i kāu repo weliweli.

He aha nā papa inoa Awesome

I ka wā e noʻonoʻo ai au i kekahi ʻenehana hou a i ʻole ka ʻōlelo papahana, ʻo ka mea mua aʻu e hana ai ʻo ka hele ʻana ma ʻaneʻi - ʻike wau i ka ʻāpana kūpono, a aia nā pepa kūpono i loko. A ke hoʻoholo nei i ka helu o nā hōkū a me ko lākou ulu mau ʻana, ʻaʻole wau wale nō ka mea e hana i kēia.
He pepa DIY maikaʻi loa, a i ʻole GitHub ma kahi o ka notepad

ʻOiaʻiʻo, he readme.md pālahalaha maʻamau kēia, e noho ana ma kahi kaʻawale hale waihona, 8th ma waena o nā waihona waihona GitHub āpau a me nā loulou i nā pepa ʻē aʻe i hoʻolaʻa ʻia i kekahi kumuhana. No ka laʻana, ma ka ʻōlelo Programming Languages ​​​​hiki iā ʻoe ke loaʻa nā pepa ma Awesome Python a me Awesome Go, a he nui nā kumuwaiwai o Front-End Development i ka hoʻomohala ʻana i ka WEB. A, ʻoiaʻiʻo, - ʻāpana i hōkeo 'ikepili (E hoʻi mākou i kēia ma hope iki). A ʻae, ʻaʻole i kaupalena ʻia kēia mau mea i nā kumuhana ʻenehana. No ka laʻana, i nā ʻāpana ʻoliʻoli a me nā pāʻani hiki iā ʻoe ke ʻike i nā mea hoihoi he nui (ʻoluʻolu wau weliweli-manaʻo).
ʻO ka hiʻohiʻona nui, ʻaʻole mālama ʻia kēia mau pepa āpau e ka mea kākau pilikino, akā na ke kaiāulu a hoʻohui ʻia e like me kahi kūikawā a koʻikoʻi loa. ʻo ka manifesto weliweli. ʻO kēlā me kēia pepa he kaiāulu kūʻokoʻa o nā loea, ola i kona ola ponoʻī a wehe ʻia i kāu mau noi huki e hoʻomaikaʻi ai. A hiki i kekahi ke hana i kā lākou pepa ponoʻī inā ʻaʻole i uhi ʻia kekahi kumuhana.

ʻO ka mea kākau o ka manaʻo a me ka coordinator o kēia ʻoihana holoʻokoʻa ʻo Sindre Sorhus kaao, kanaka mua ma GitHub, mea kākau hou aku 1000 npm modules, a nana no e loaa kou mau PR.
He pepa DIY maikaʻi loa, a i ʻole GitHub ma kahi o ka notepad

Pehea e komo ai i ka papa inoa weliweli

Inā ʻaʻole ʻoe i ʻike i kahi pepa kūpono ma kahi kumuhana āu e makemake ai, a laila ʻo ia ka hōʻailona mua e pono ai ʻoe e hana iā ʻoe iho!

E haʻi wau iā ʻoe me ka hoʻohana ʻana i ka laʻana o kaʻu brainchild. Nā Mea Hana Pūnaewele Kūlana — Mai ka papahana a i ka papahana pono wau e hana me nā ʻikepili like ʻole, a ʻo ia ke kumu aʻu i hoʻomaka ai i kahi faila kahi aʻu i hōʻiliʻili ai i nā mea hana pono no ka hana pū ʻana me lākou, nā ʻano mea neʻe ʻikepili āpau, nā IDE, nā panela admin, nā mea hana nānā a me nā ʻano like ʻole. mea like ole. ʻO nā mea hana aʻu i hoʻohana ai a i ʻole e hoʻolālā nei e hoʻomaka e hoʻohana. Kaʻana au i kēia faila me nā hoa hana ma CROC a ma waho. Ua kōkua kēia i nā poʻe he nui a he hoihoi. ʻO ka hopena, makemake au i ka kaulana i kekahi lā aʻu i ʻike ai i ka ʻāpana ʻikepili ʻaʻohe pepa ma kēia kumuhana. A ua hoʻoholo wau e hoʻohui i kaʻu ma laila.

He aha ka mea e pono ai no kēia?

  1. Hoʻopaʻa inoa mākou i kahi repo GitHub maʻamau me kahi inoa e like me ka weliweli-ʻo kēlā me kēia. I koʻu hihia he mea weliweli-database-tools
  2. Lawe mākou i kā mākou pepa i ke ʻano weliweli, e kōkua kēia iā mākou generator-weliwela-papa inoa, ka mea e hoʻopuka i nā faila pono a pau i ke ʻano i makemake ʻia
  3. Hoʻonohonoho i kahi CI maoli. weliweli-lint a e kōkua ʻo travis ci iā mākou e hoʻokele pono kā mākou pepa
  4. Kali mākou i 30 lā
  5. Manaʻo mākou i ka liʻiliʻi o 2 mau PR a nā poʻe ʻē aʻe
  6. A i ka hopena, hana mākou i kahi PR i ka repo nui, kahi mākou e hoʻohui ai i kahi loulou i kā mākou repo. Maanei ʻoe e heluhelu pono ai i nā mea āpau a hoʻokō pono i nā koi āpau no ka pepa hou a me ka PR ponoʻī.

ʻO kaʻu pancake mua lilo i puʻupuʻu
He pepa DIY maikaʻi loa, a i ʻole GitHub ma kahi o ka notepad
Akā ua hala ka manawa liʻiliʻi, ua hōʻiliʻili au i nā mea hou aku, hana i nā hewa a ʻaʻa lua hoao.

Akā, ua poina iaʻu i kahi mea koʻikoʻi, i hōʻike ʻia mai iaʻu:
He pepa DIY maikaʻi loa, a i ʻole GitHub ma kahi o ka notepad

ʻAʻole wau i makaʻala loa a ʻaʻole au i hoʻohui i kahi unicorn e hōʻoia i ka hoʻokō ʻana i nā kūlana āpau
He pepa DIY maikaʻi loa, a i ʻole GitHub ma kahi o ka notepad

A laila ua hala ka manawa hou, he mau hoʻoponopono hou ma muli o nā manaʻo, a me nā mea i kali lōʻihi ʻia tweetua ʻae ʻia kaʻu PR.

No laila, lilo wau i mea kākau o kaʻu pepa mua, a hoʻomaka lākou e loaʻa ʻO kā PR mai ke kaiāulu e hoʻohui i nā mea hana hou. A ua komo mua ka nui o lākou i loko Nā Mea Hana Pūnaewele Kūlana. Inā moloā ʻoe e hahai i ka loulou,

eia ke koho i kēia manawa i ka manawa o ka hoʻolaha ʻana o ka pou

Nā Mea Hana Pūnaewele Kūlana He pepa DIY maikaʻi loa, a i ʻole GitHub ma kahi o ka notepad

Ka papa inoa o nā mea hana waihona

Ma ʻaneʻi e hōʻiliʻili mākou i ka ʻike e pili ana i nā mea hana hoʻokolohua maikaʻi a maikaʻi hoʻi e maʻalahi me nā ʻikepili no DBA, DevOps, Developers a me nā mea make.

E ʻoluʻolu e hoʻohui i ka ʻike e pili ana i kāu mau mea hana db a i ʻole kāu mau mea hana db ʻaoʻao punahele ʻekolu.

Contents

ʻaneʻi

  • AnySQL Maestro — ʻO ka mea hoʻokele waiwai nui no ka hoʻokele waiwai, ka hoʻokele a me ka hoʻomohala ʻana.
  • ʻIkepili Aqua — ʻO Aqua Data Studio ka lako polokalamu huahana no ka Database Developers, DBAs, a me Analysts.
  • Database.net - Mea hana hoʻokele waiwai nui me ke kākoʻo no 20+ mau waihona.
  • ʻIkepiliGrip - Cross-Platform IDE no nā ʻikepili a me SQL na JetBrains.
  • dbeaver — Manakia waihona waihona honua manuahi a me ka mea kūʻai aku SQL.
  • dbForge Studio no MySQL - Universal IDE no MySQL a me MariaDB hoʻomohala ʻikepili, hoʻokele, a me ka hoʻokele.
  • dbForge Studio no Oracle - IDE ikaika no ka hoʻokele Oracle, hoʻokele, a me ka hoʻomohala ʻana.
  • dbForge Studio no PostgreSQL - Mea hana GUI no ka hoʻokele a me ka hoʻomohala ʻana i nā waihona a me nā mea.
  • dbForge Studio no SQL Server - Ka hoʻomohala hoʻomohala ikaika no ka hoʻomohala ʻana i ka SQL Server, hoʻokele, hoʻokele, ʻikepili ʻikepili, a me ka hōʻike.
  • dbKoda — Hou (JavaScript/Electron framework), wehe kumu IDE no MongoDB. Loaʻa iā ia nā hiʻohiʻona e kākoʻo i ka hoʻomohala ʻana, ka hoʻokele a me ka hoʻokō ʻana i nā ʻikepili MongoDB.
  • IBEExpert — Mea hana GUI piha no Firebird a me InterBase.
  • HeidiSQL - He mea kūʻai māmā no ka mālama ʻana i ka MySQL, MSSQL a me PostgreSQL, i kākau ʻia ma Delphi.
  • ʻO MySQL Workbench — ʻO MySQL Workbench kahi mea ʻike maka i hui pū ʻia no nā mea haku waihona waihona, nā mea hoʻomohala, a me nā DBA.
  • ʻO Navicat — He mea hana hoʻomohala waihona e hiki ai iā ʻoe ke hoʻopili like me MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, a me SQLite ʻikepili mai kahi noi hoʻokahi.
  • ʻO Oracle SQL Mea Hoʻolālā — ʻO Oracle SQL Developer kahi kaiapuni hoʻomohala manuahi a hoʻohui ʻia e hoʻomaʻamaʻa i ka hoʻomohala ʻana a me ka hoʻokele ʻana o Oracle Database ma nā hana kuʻuna a me ka Cloud deployments.
  • pgAdmin — ʻO ka mea kaulana loa a me ka hiʻona waiwai Open Source hoʻokele a me ka hoʻomohala ʻana no PostgreSQL, ka ʻikepili Open Source kiʻekiʻe loa ma ka honua.
  • pgAdmin3 - Kākoʻo lōʻihi no pgAdmin3.
  • Mea hoʻomohala PL/SQL — IDE i kuhikuhi pono ʻia i ka hoʻomohala ʻana i nā ʻāpana papahana i mālama ʻia no Oracle Databases.
  • PostgreSQL Maestro - Hoʻopiha piha a ikaika hoʻi ka hoʻokele waihona, admin a me ka mea hana hoʻomohala no PostgreSQL.
  • Kau ai - ʻO Toad ka hopena waihona waihona mua no nā mea hoʻomohala, nā mea hoʻokele a me nā ʻikepili ʻikepili. Hoʻoponopono i nā hoʻololi ʻikepili paʻakikī me kahi mea hana hoʻokele waihona hoʻokahi.
  • Kaʻaʻaʻa — Mea hana hoʻomohala waihona maʻalahi no MySQL a me Postgres.
  • TOra — ʻO TOra kahi kumu wehe SQL IDE no Oracle, MySQL a me PostgreSQL dbs.
  • ʻO Valentina Studio - Hana, lawelawe, nīnau a ʻimi iā Valentina DB, MySQL, MariaDB, PostgreSQL a me SQLite ʻikepili no FREE.

Nā Luna GUI/nā mea kūʻai aku

  • Luna Hoʻokele — Hooponopono waihona ma ka waihona PHP hookahi.
  • DbVisualizer — Mea hana waihona ʻikepili no nā mea hoʻomohala, DBA a me nā mea loiloi.
  • HouseOps — Enterprise ClickHouse Ops UI no ka holo ʻana i nā nīnau, ka nānā ʻana i ke olakino ClickHouse a hana i nā poʻe he nui e noʻonoʻo.
  • JackDB — Loaʻa pololei i ka SQL i kāu ʻikepili āpau, ʻaʻohe wahi e noho ai.
  • OmniDB — Mea paahana no ka hooponopono waihona.
  • Pgweb — He polokalamu kele pūnaewele pūnaewele no PostgreSQL, i kākau ʻia ma Go a hana ma nā mīkini macOS, Linux a me Windows.
  • phpLiteAdmin — Paahana hoʻokele waihona waihona SQLite pūnaewele i kākau ʻia ma PHP me ke kākoʻo no SQLite3 a me SQLite2.
  • phpMyAdmin - He kikowaena pūnaewele no MySQL a me MariaDB.
  • psequel - Hāʻawi ʻo PSequel i kahi maʻemaʻe a maʻalahi no ʻoe e hana wikiwiki i nā hana PostgreSQL maʻamau.
  • PopSQL — Mea hoʻoponopono SQL hou, hui pū no kāu hui.
  • Postico - He mea kūʻai mai PostgreSQL hou no ka Mac.
  • Robo 3T — ʻO Robo 3T (ʻo Robomongo ma mua) he mea hana hoʻokele MongoDB cross-centric cross-platform.
  • Hoʻopau Pro - ʻO Sequel Pro kahi palapala hoʻokele waiwai Mac wikiwiki a maʻalahi no ka hana ʻana me MySQL & MariaDB ʻikepili.
  • Keena Hana Hana SQL — He mea hana hoʻokele ʻikepili e hiki ai ke hana pū me SQL Server, Azure SQL DB a me SQL DW mai Windows, macOS a me Linux.
  • Kaha SQLite - Kākoʻo ke kikowaena kiʻi i nā hiʻohiʻona SQLite āpau.
  • sqlpad — E holo ana ka mea hoʻoponopono SQL pūnaewele ma kāu ao ponoʻī.
  • SQLPro - He luna Postgres maʻalahi a ikaika no macOS.
  • SquirreL — Graphical SQL client i kākau ʻia ma Java e ʻae iā ʻoe e ʻike i ke ʻano o kahi waihona waihona JDBC, nānā i ka ʻikepili i nā papa, hoʻopuka i nā kauoha SQL etc.
  • SQLTools — Hooponopono waihona no VSCode.
  • SQLyog - ʻO ka mea piha a maʻalahi hoʻi e hoʻohana i ka MySQL GUI.
  • ʻO Tabix — SQL Editor & Open source naʻauao ʻoihana maʻalahi no Clickhouse.
  • Pākaukau - Mea hana GUI hou, ʻōiwi, a aloha no nā ʻikepili pili: MySQL, PostgreSQL, SQLite a me nā mea hou aku.
  • TeamPostgreSQL — PostgreSQL Web Administration GUI — hoʻohana i kāu ʻikepili PostgreSQL mai nā wahi ʻē aʻe, me ka waiwai, ka uila-wikiwiki pūnaewele AJAX.

Nā mea hana CLI

  • ipython-sql - Hoʻohui i kahi waihona no ka hoʻopuka ʻana i nā kauoha SQL i loko o IPython a i ʻole IPython Notebook.
  • iredis - He Cli no Redis me ka Auto Completion a me ka Syntax Highlighting.
  • pgcenter — Mea hana hoʻokele like ʻole no PostgreSQL.
  • pg_activity - ʻO ka noi like ʻole no ka nānā ʻana i ka hana a ka server PostgreSQL.
  • pg_luna - 'luna' no PostgreSQL.
  • pspg —Postgres Pager
  • sqlcl — ʻO Oracle SQL Developer Command Line (SQLcl) kahi kikowaena laina kauoha manuahi no Oracle Database.
  • usql - He kikowaena laina kauoha āpau no PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, a me nā ʻikepili ʻē aʻe he nui me NoSQL a me nā ʻikepili pili ʻole!

dbcli

  • athenacl - ʻO AthenaCLI kahi mea hana CLI no ka lawelawe ʻo AWS Athena hiki ke hana i ka hoʻopau ʻana a me ka hōʻailona syntax.
  • litecli - CLI no nā ʻikepili SQLite me ka hoʻopau ʻana a me ka hōʻailona syntax.
  • mssql-cli — He mea kūʻai laina kauoha no SQL Server me ka hoʻopau ʻana a me ka hōʻailona syntax.
  • mycli - He mea kūʻai mai Terminal no MySQL me ka AutoCompletion a me ka Syntax Highlighting.
  • pgcli - Postgres CLI me ka autocompletion a me ka syntax highlighting.
  • vcli - ʻO Vertica CLI me ka hoʻopau ʻana a me ka hōʻailona syntax.

DB-schema hoʻokele a me ka nānā ʻana

  • dbdiagram.io — Mea hana wikiwiki a maʻalahi e kōkua iā ʻoe e huki i kāu mau kiʻi pili i ka waihona a kahe wikiwiki me ka hoʻohana ʻana i ka ʻōlelo DSL maʻalahi.
  • ERAlchemy — Mea hana hana kiʻi kiʻi pili hui.
  • SchemaCrawler - ʻO kahi ʻike schema database manuahi a me ka mea hana hoʻomaopopo.
  • Kiu hoʻolālā — Ka hana ʻana i kāu waihona i nā palapala HTML, me nā kiʻi kiʻi Entity Relationship.
  • tbls — Mea paahana CI-Friendly no ka palapala ʻana i kahi waihona, i kākau ʻia ma Go.

Nā mea hoʻohālike

  • Hoʻohālikelike ʻIkepili Navicat — He mea hana hoʻolālā waihona waiwai ikaika a maikaʻi hoʻi e kōkua iā ʻoe e kūkulu i nā hiʻohiʻona ʻikepili kiʻekiʻe, loiloi a me ke kino.
  • ʻO Oracle SQL Mea Hoʻohālike Ikepili — ʻO Oracle SQL Developer Data Modeler he mea hana kiʻi manuahi e hoʻonui ai i ka huahana a maʻalahi i nā hana hoʻohālike ʻikepili.
  • pgmodeler — Mea hana hoʻohālike ʻikepili i hoʻolālā ʻia no PostgreSQL.

Mea paahana

  • 2bass — Mea hana hoʻonohonoho waihona-as-code e hoʻohana ana i ka manaʻo o nā palapala DDL idempotent.
  • ala lele - Mea hana hoʻoneʻe waihona.
  • gh-ost — Ka neʻe ʻana o ka schema pūnaewele no MySQL.
  • liquibase — Waihona waihona waihona kūʻokoʻa no ka nānā ʻana, hoʻokele a hoʻohana ʻana i nā loli schema database.
  • neʻe - E like me ka ʻokoʻa akā no nā schemas PostgreSQL.
  • node-pg-neʻe — Node.js ka hoʻokele neʻe ʻana o ka waihona i kūkulu ʻia no nā postgres. (Akā hiki ke hoʻohana ʻia no nā DB ʻē aʻe e like me ka maʻamau SQL - e laʻa me CockroachDB.)
  • Pyrseas - Hāʻawi i nā pono hana e wehewehe i kahi schema database PostgreSQL e like me YAML.
  • SchemaHero — He mea hoʻohana Kubernetes no ka hoʻokele ʻana i ka ʻikepili ʻikepili (gitops no nā schemas database).
  • Sqitch - Hoʻoponopono hoʻololi hoʻololi maoli no ka hoʻomohala ʻana i ka framework-free a me ka hoʻolālā hilinaʻi.
  • yuniql — ʻO kekahi mea hana hoʻololi a me ka neʻe ʻana i hana ʻia me ka .NET Core 3.0+ maoli a manaʻolana ʻoi aku ka maikaʻi.

Mea hana code generation

  • ddl-generator — Infers SQL DDL (Data Definition Language) mai ka ʻikepili papa.
  • papahana2ddl — E hoʻohana i ka laina kauoha no ka hoʻokuʻu ʻana i ka schema Oracle e hoʻonohonoho i nā ddl init scripts me ka hiki ke kānana i ka ʻike makemake ʻole, hoʻokaʻawale i ka DDL i nā faila like ʻole, nā puka puka nani.

Pākī

  • Moanalua - He kumu wehe ʻo REST API backend no nā polokalamu kelepona, pūnaewele, a me IoT.
  • Hasura GraphQL Engine — Hoʻomaka koke i nā API GraphQL i ka manawa maoli ma nā Postgres me ka mana o ka hiki ke hoʻohana ʻia, e hoʻoulu pū i nā webhooks ma nā hanana waihona.
  • jl-sql - SQL no nā kahawai JSON a me CSV.
  • mysql_fdw — PostgreSQL ʻikepili ʻikepili haole no MySQL.
  • Nā lawelawe ʻikepili Oracle REST — He polokalamu Java waena, palapala ʻo ORDS i nā huaʻōlelo HTTP(S) (GET, POST, PUT, DELETE, etc.) i nā kālepa ʻikepili a hoʻihoʻi i nā hopena i hoʻohālikelike ʻia me JSON.
  • Prism - Hoʻololi ʻo Prisma i kāu waihona i kahi API GraphQL manawa maoli.
  • ʻO PostgREST - REST API no kēlā me kēia waihona Postgres.
  • Perst — He ala ia e lawelawe ai i kahi API RESTful mai nā waihona i kākau ʻia ma Go.
  • restSQL — Hoʻohana ʻo SQL generator me Java a me HTTP API, hoʻohana i kahi RESTful HTTP API maʻalahi me XML a i ʻole JSON serialization.
  • resquel - E hoʻololi maʻalahi i kāu waihona SQL i kahi REST API.
  • kahookah2 - Hoʻopuka koke i kahi lawelawe API RESTful no kāu waihona hoʻoilina.
  • sql-boot — Advanced REST a me UI wrapper no kāu mau nīnau SQL.

Mea paahana waihona

  • pgbackrest - Hoʻihoʻi a hoʻihoʻi ʻia ʻo PostgreSQL.
  • BaRMan — Luna Hoʻihoʻi a hoʻihoʻi no PostgreSQL.

Hana hou/ʻikepili

  • ʻIkepili - He mea hana no ka ʻimi a hoʻopuka ʻana i ka ʻikepili.
  • dtle — Ka lawelawe hoʻoili ʻikepili i hāʻawi ʻia no MySQL.
  • pgsync - Hoʻopili i ka ʻikepili Postgres ma waena o nā waihona.
  • pg_chameleon — MySQL i PostgreSQL replica system i kākau ʻia ma Python 3. Hoʻohana ka ʻōnaehana i ka waihona mysql-replication e huki i nā kiʻi lālani mai MySQL i mālama ʻia i PostgreSQL e like me JSONB.
  • PGDeltaStream - He kikowaena pūnaewele Golang e hoʻololi i nā Postgres ma ka liʻiliʻi-hoʻokahi ma luna o nā pūnaewele pūnaewele, me ka hoʻohana ʻana i ka hiʻohiʻona decoding logical Postgres.
  • repmgr — ʻO ka Luna Hoʻoponopono Hoʻolaha Nui loa no PostgreSQL.

Hōʻolālā

Nānā / Heluhelu / Hana

  • Nānā ASH - Hāʻawi i kahi hiʻohiʻona kiʻi o ka ʻikepili mōʻaukala manawa i loko o ka Oracle a me PostgreSQL DB.
  • Monyog — ʻAgent ʻole a me ke kumu kūʻai pono ʻole MySQL.
  • mssql-nānā - E nānā i kāu SQL Server ma Linux e hoʻohana ana i ka hōʻiliʻili, InfluxDB a me Grafana.
  • Navicat Monitor - ʻO kahi mea hana mālama mālama palekana palekana, maʻalahi a me ka ʻole i hoʻopiha ʻia me nā hiʻohiʻona ikaika e hoʻokō pono ai kāu nānā ʻana.
  • Ka nānā ʻana a me ka hoʻokele ʻana o Percona — Open source platform no ka mālama ʻana a me ka nānā ʻana i ka hana MySQL a me MongoDB.
  • pganalyze collector - Hoʻopili i ka ʻohi helu helu no ka hōʻiliʻili ʻana i nā metric PostgreSQL a me ka ʻikepili log.
  • postgres-checkup - Mea hana diagnostics hou e hiki ai i nā mea hoʻohana ke hana i kahi loiloi hohonu o ke olakino o nā ʻikepili Postgres.
  • mea hoʻopuka - Mea hoʻopuka Prometheus no nā kikowaena kikowaena PostgreSQL.
  • pgDash - E ana a hahai i nā ʻāpana āpau o kāu ʻikepili PostgreSQL.
  • PgHero - He papa hana hoʻokō no nā Postgres - nā loiloi olakino, nā kuhikuhi i manaʻo ʻia, a me nā mea hou aku.
  • pgmetrics - E hōʻiliʻili a hōʻike i ka ʻike a me nā stats mai kahi kikowaena PostgreSQL e holo nei.
  • pgMustard - He mea hoʻohana mea hoʻohana no Postgres e wehewehe i nā hoʻolālā, me nā ʻōlelo aʻoaʻo e hoʻomaikaʻi i ka hana.
  • pgstats - E hōʻiliʻili i nā helu helu PostgreSQL, a mālama iā lākou i nā faila CSV a paʻi paha ma ka stdout.
  • pgwatch2 — Hiki ke hoʻopaʻa ʻia me ka hoʻopaʻa ʻana i nā metric postgreSQL me ka nānā ʻana/dashboarding solution.
  • Telegraf PostgreSQL plugin - Hāʻawi i nā metric no kāu waihona postgres.

ʻO Zabbix

  • Mamonsu — Luna kiaʻi no ka PostgreSQL.
  • ʻOrapbix — ʻO Orabbix kahi plugin i hoʻolālā ʻia e hana pū me Zabbix Enterprise Monitor e hāʻawi i ka nānā ʻana i nā pae he nui, ka hana a me ka loaʻa ʻana o ka hōʻike ʻana a me ke ana ʻana no Oracle Databases, me nā metric performance server.
  • pg_monz - ʻO kēia ka Zabbix ka nānā ʻana no ka PostgreSQL Database.
  • Pyora — Palapala Python e nānā i nā ʻikepili Oracle.
  • ZabbixDBA - ʻO ZabbixDBA wikiwiki, maʻalahi a hoʻomau i ka hoʻomohala ʻana i ka plugin e nānā i kāu RDBMS.

ikea ai

  • DbFit — He kahua hoʻāʻo ʻikepili e kākoʻo ana i ka hoʻomohala maʻalahi o kāu code database.
  • RegreSQL - Ke ho'āʻo nei i kāu mau nīnau SQL.

Mea hana ʻikepili

hooponopono

  • pgbadger - He mea hōʻike loiloi PostgreSQL wikiwiki.
  • pgbeddrock - Hoʻokele i nā kuleana o kahi pūʻulu Postgres, nā lālā kuleana, ka mana schema, a me nā pono.
  • pgslice - ʻO ka hoʻokaʻawale ʻana i nā postgres e like me ka maʻalahi.

HA/Failover/Sharding

  • Citus - ʻO ka hoʻonui ʻia ʻo Postgres e hāʻawi ana i kāu ʻikepili a me kāu mau nīnau ma nā node he nui.
  • patroni — He la'ana no PostgreSQL High Availability me ZooKeeper, etcd, a i 'ole ke Kanikela.
  • ʻO Percona XtraDB Cluster — He Haʻina Scalability Kiʻekiʻe no ka MySQL Clustering a me ka Loaʻa Kiʻekiʻe.
  • stolon — Manamana PostgreSQL maoli no ke ao no ka loaʻa kiʻekiʻe o PostgreSQL.
  • pg_auto_failover - Hoʻonui ka Postgres a me ka lawelawe no ka failover automated a me ka loaʻa kiʻekiʻe.
  • pglookout - Ka nānā ʻana i ka replication PostgreSQL a me ka daemon failover.
  • ʻO PostgreSQL Automatic Failover — Loaʻa kiʻekiʻe no nā Postgres, e pili ana i nā kuhikuhi ʻoihana ʻo Pacemaker a me Corosync.
  • postgresql_cluster — PostgreSQL High-Availability Cluster (ma muli o "Patroni" a me "DCS(etcd)"). Ka hoʻopololei ʻana me Ansible.
  • Vitess — Pūnaehana clustering database no ka scaling horizontal o MySQL ma o ka sharding generalized.

Kubernetes

  • KubeDB - E hoʻomaʻamaʻa maʻalahi i ka ʻikepili helu hana ma nā Kubernetes.
  • Mea hoʻohana Postgres — Hiki i ka Postgres Operator nā pūʻulu PostgreSQL i loaʻa loa ma nā Kubernetes (K8s) i hoʻohana ʻia e Patroni.
  • Spilo - HA PostgreSQL Clusters me Docker.
  • StackGres — Papahana-hana, Full Stack PostgreSQL ma Kubernetes.

Hoʻoponopono hoʻoponopono

  • MySQLTuner-perl — Palapala i kākau ʻia ma Perl e hiki ai iā ʻoe ke nānā i kahi hoʻonohonoho MySQL me ka wikiwiki a hana i nā hoʻololi e hoʻonui i ka hana a me ke kūpaʻa.
  • PGConfigurator - Mea paahana pūnaewele manuahi e hoʻohua i kahi optimized postgresql.conf.
  • pgtune — Wizard hoʻonohonoho PostgreSQL.
  • postgresqltuner.pl — Palapala maʻalahi e nānā i kāu hoʻonohonoho ʻikepili PostgreSQL, a hāʻawi i nā ʻōlelo aʻo.

Nā DevOps

  • DBmaestro — Hoʻolalelale ʻo DBmaestro i nā pōʻai hoʻokuʻu a kākoʻo i ka agility ma waena o ka kaiaola IT holoʻokoʻa.
  • Toad DevOps Toolkit — Hoʻokō ʻo Toad DevOps Toolkit i nā hana hoʻomohala ʻikepili koʻikoʻi i loko o kāu kaila hana DevOps - me ka ʻole o ka hoʻokō ʻana i ka maikaʻi, ka hana a i ʻole ka hilinaʻi.

Nā laʻana hoʻolālā

Ho'oka'a'ike

  • Ua haʻi aku ʻo Cop - He palapala hōʻike hōʻike SQL maʻalahi i kūkulu ʻia no nā mea aloha SQL.

Māhele

  • DBdeployer — Mea hana e hoʻolālā maʻalahi i nā kikowaena waihona MySQL.
  • dbatools - PowerShell module āu e noʻonoʻo ai e like me ka laina kauoha SQL Server Management Studio.
  • Postgres.app — Hoʻokomo piha ʻia ʻo PostgreSQL i hoʻopaʻa ʻia e like me ka app Mac maʻamau.
  • BigSQL - He hoʻolaha hoʻomohala-aloha o Postgres.
  • Hale Elepani — Hoʻonohonoho mua ʻia ʻo PostgreSQL hoʻokele pūnaewele e hoʻopili ana i kekahi mau pono a me nā noi no ka hoʻohana ʻana me PostgreSQL.

maluhia

  • ʻAkala — Pūʻulu palekana waihona. ʻO ka proxy database me ka hoʻopunipuni pae-pae, ʻimi ma o ka ʻikepili i hoʻopili ʻia, ka pale ʻana i nā injections SQL, ka ʻike intrusion, honeypots. Kākoʻo i ka ʻaoʻao o ka mea kūʻai aku a me ka ʻaoʻao proxy ("transparent") hoʻopunipuni. SQL, NoSQL.

Nā mea hoʻopalapala code

  • CodeBuff — Paʻi nani ʻōlelo-agnostic ma o ke aʻo ʻana i nā mīkini.

Ka hoʻohālikelike

  • Hoʻokipa mau ʻia kāu mau haʻawina! E ʻoluʻolu e heluhelu i ka alakaʻi hāʻawi ka mua.

Inā loaʻa iā ʻoe nā ʻike no ka waihona, e ʻoluʻolu e kaʻana like. E hauʻoli nō hoʻi au i ka loaʻa ʻana o nā manaʻo - PR a me nā hōkū. Inā he mau nīnau kāu e pili ana i ka hana ʻana i kāu pepa ponoʻī, e kākau pū iā lākou.

Source: www.habr.com

Pākuʻi i ka manaʻo hoʻopuka