Ndewo, Habr! Eleghị anya, onye ọ bụla n'ime anyị nwere faịlụ ebe anyị na-ezobe ihe bara uru ma na-adọrọ mmasị maka onwe anyị. Ụfọdụ njikọ akụkọ, akwụkwọ, ebe nchekwa, akwụkwọ ntuziaka. Ndị a nwere ike ịbụ ibe edokọbara ihe nchọgharị ma ọ bụ ọbụlagodi taabụ mepere emepe maka emechaa. Ka oge na-aga, ihe ndị a niile na-aza, njikọ na-akwụsị imeghe, na ọtụtụ n'ime ihe ndị ahụ na-aghọ ihe ochie.

Gịnị ma ọ bụrụ na anyị ekerịta ịdị mma a n'etiti obodo wee bipute faịlụ a na GitHub? Mgbe ahụ, ọrụ gị nwere ike ịba uru nye onye ọzọ, ma ị nwere ike ịnọgide na-emekọ ihe ọnụ, na-anabata mmelite sitere n'aka ndị chọrọ site na ezigbo PR. Nke a bụ kpọmkwem ihe akwadoro ọrụ ahụ. Ndepụta mara mma. Ọ gụnyere na TOP 10 GitHub repositories, nwere 138K kpakpando, na njikọ nke ọrụ gị nwere ike ịpụta kpọmkwem na mgbọrọgwụ README ya, nke ga-adọta nnukwu ndị na-ege ntị na ọrụ gị. N'ezie, nke a ga-achọ obere mgbalị. Achọrọ m ịkọrọ gị ahụmahụ m banyere mbọ ndị a.

Aha m bụ Maxim Gramin. Na CROC m na-eme mmepe Java na nyocha nchekwa data. Na post a, m ga-agwa gị ihe Ndepụta dị egwu bụ yana otu esi eme repo dị egwu nke gị.

Kedu ihe ndepụta dị egwu

Mgbe m ga-achọpụta ụfọdụ nkà na ụzụ ọhụrụ ma ọ bụ asụsụ mmemme, ihe mbụ m na-eme bụ ịga ebe a - Achọtara m ngalaba ziri ezi, na e nwere mpempe akwụkwọ kwesịrị ekwesị na ya. Na ikpe ikpe site na ọnụ ọgụgụ kpakpando na uto ha na-aga n'ihu, ọ bụghị naanị m na-eme nke a.

N'ezie, nke a bụ nkịtị flat readme.md, nke bi na iche iche ebe nchekwa, 8th n'etiti ụlọ ọrụ GitHub niile ma tinye njikọ na mpempe akwụkwọ ndị ọzọ raara nye isiokwu ọ bụla. Dịka ọmụmaatụ, na ngalaba Asụsụ Programming ị nwere ike ịchọta akwụkwọ na Awesome Python na Awesome Go, na Front-End Development nwere nnukwu ego na mmepe WEB. Na, n'ezie, - ngalaba Databases (Anyị ga-alaghachi na nke a ntakịrị oge). Ma ee, ihe a niile ejedebeghị na isiokwu teknụzụ. Dịka ọmụmaatụ, na ngalaba ntụrụndụ na egwuregwu ị nwekwara ike ịhụ ọtụtụ ihe na-atọ ụtọ (Enwere m mmasị n'onwe m egwu-echiche efu).
Isi ihe bụ na akwụkwọ ndị a niile na-edobe ọ bụghị onye edemede n'onwe ya, kama ọ bụ ndị obodo ma na-achịkọta ya n'ụzọ dị iche iche na nke siri ike. di egwu manifesto. Mpempe akwụkwọ ọ bụla bụ obodo nwere onwe nke ndị ọkachamara, na-ebi ndụ nke ya ma na-emeghe arịrịọ gị nke ga-eme ka ọ dịkwuo mma. Na kwa onye ọ bụla nwere ike ịmepụta mpempe akwụkwọ nke ya ma ọ bụrụ na ekpuchibeghị ụfọdụ isiokwu.

Onye dere echiche na onye nhazi nke ụlọ ọrụ a dum bụ onye ama ama Sindre Sorhus. onye mbụ na GitHub, odee ọzọ 1000 npm modul, ma ọ bụ ya ga-anata PRs gị.

Otu esi abanye na listi egwu

Ọ bụrụ na ị hụbeghị mpempe akwụkwọ kwesịrị ekwesị na isiokwu na-amasị gị, mgbe ahụ, nke a bụ akara mbụ na ị ga-eme ya n'onwe gị!

M ga-eji ihe atụ nke ụbụrụ m gwa gị. Ngwa nchekwa data dị egwu - Site na oru ngo ruo oru ngo m ga-arụ ọrụ na ọdụ data dị iche iche, na ya mere m ji malite faịlụ nke m na-anakọta ngwá ọrụ bara uru maka ịrụ ọrụ na ha, ụdị nchekwa data ọ bụla, IDE, panel admin, nlekota oru ngwaọrụ na ụdị niile. ihe dị iche iche. Ngwa ndị m jirilarị ma ọ bụ na-eme atụmatụ ịmalite iji. Ekesara m ndị ọrụ ibe m faịlụ a na CROC na karịa. Nke a nyeere ọtụtụ mmadụ aka ma na-adọrọ mmasị. N'ihi ya, achọrọ m ịbụ onye a ma ama mgbe otu ụbọchị m chọpụtara na na ngalaba Databases enweghị mpempe akwụkwọ na isiokwu a. M wee kpebie itinye nke m ebe ahụ.

Kedu ihe achọrọ maka nke a?

1. Anyị na-edebanye aha GitHub repo oge niile na aha dị egwu-ihe ọ bụla. N'ọnọdụ m ọ bụ egwu-database-ngwaọrụ
2. Anyị na-ebute mpempe akwụkwọ anyị na usoro dị egwu, nke a ga-enyere anyị aka generator-egwu-ndepụta, nke ga-ewepụta faịlụ niile dị mkpa n'ụdị achọrọ
3. Ịtọlite ​​​​ezigbo CI. dị egwu-lint na travis ci ga-enyere anyị aka ịchịkwa ndaba mpempe akwụkwọ anyị
4. Anyị na-eche ụbọchị 30
5. Anyị na-enyocha ma ọ dịkarịa ala PR mmadụ abụọ ọzọ
6. N'ikpeazụ, anyị na-eme PR na isi repo, ebe anyị na-agbakwunye njikọ na repo anyị. N'ebe a, ịkwesịrị iji nlezianya gụọ ihe niile ma jiri nlezianya mezuo ọtụtụ ihe achọrọ maka mpempe akwụkwọ ọhụrụ na PR n'onwe ya.

Pancake mbụ m tụgharịrị bụrụ lumpy

Ma obere oge gafere, anakọtara m ọbụna ihe ndị ọzọ, na-arụ ọrụ na mmejọ ma na-anwa anwa ime nwaa nke abụọ.

Mana echefuru m otu ihe dị oke mkpa, nke e jiri nwayọ gosi m:

Adịghị m akpachapụ anya ma etinyeghị m unicorn iji gosi na ọnọdụ niile ezutere

Mgbe ahụ ntakịrị oge gafere, ndezi ole na ole dabere na nkwupụta, yana ogologo oge a na-echere tweetna PR m nabatara.

N’ihi ya, aghọrọ m onye dere akwụkwọ mbụ m, ma ha malite ịnara ya Ndị PR site na obodo iji tinye ngwa ọhụrụ. Na ọtụtụ n'ime ha etinyelarị na Ngwa nchekwa data dị egwu. Ọ bụrụ na ị dị umengwụ iso njikọ ahụ,

ebe a bụ nhọrọ dị ugbu a n'oge mbipụta nke post

Ngwa nchekwa data dị egwu

Ndepụta ngwaọrụ nchekwa data chụpụrụ obodo

N'ebe a, anyị ga-anakọta ozi gbasara ngwa nnwale dị egwu bara uru nke na-eme ka nchekwa data dị mfe maka DBA, DevOps, Ndị nrụpụta na mmadụ nkịtị.

Nwere onwe gị ịgbakwunye ozi gbasara ngwaọrụ db nke gị ma ọ bụ ngwaọrụ db ndị ọzọ ọkacha mmasị gị.

ọdịnaya

• HERE
• Ndị njikwa GUI / ndị ahịa
• Ngwa CLI
• DB-schema igodo na nleba anya
• Ndị nlereanya
• Ngwa mbata
• Usoro mmepụta koodu
• Ndị na-ekpo ọkụ
• Ngwa ndabere
• Arụmọrụ imegharị/Data
• Ihe ederede
• Nleba anya/ọnụọgụ/arụmọrụ
  • Zabbix
• Testing
  • Generator data
• ochichi
• HA/Emebighị/Shading
• Kubernetes
• Nhazi Nhazi
• DevOps
• Nlereanya atụmatụ
• akuko
• Ihe nkesa
• Security
• Ndị na-emepụta koodu

HERE

• AnySQL Maestro - Ngwá ọrụ nchịkwa ọtụtụ ebumnuche Premier maka njikwa nchekwa data, njikwa na mmepe.
• Aqua Data Studio - Aqua Data Studio bụ ngwanrọ nrụpụta maka ndị nrụpụta data, DBA na ndị nyocha.
• Database.net - Ngwá ọrụ njikwa nchekwa data ọtụtụ nwere nkwado maka ọdụ data 20+.
• njide data - Cross-Platform IDE maka ọdụ data & SQL site na JetBrains.
• Onye nbipute - Onye njikwa nchekwa data zuru ụwa ọnụ na onye ahịa SQL.
• dbForge Studio maka MySQL - Universal IDE maka MySQL na MariaDB nchekwa data mmepe, njikwa na nchịkwa.
• dbForge Studio maka Oracle - IDE siri ike maka njikwa, nchịkwa na mmepe Oracle.
• dbForge Studio maka PostgreSQL - Ngwá ọrụ GUI maka ijikwa na ịzụlite ọdụ data na ihe.
• dbForge Studio maka SQL Server - Gburugburu mmepe jikọtara ike maka mmepe SQL Server, njikwa, nchịkwa, nyocha data na mkpesa.
• dbKoda - Oge a (JavaScript/Electron framework), IDE mepere emepe maka MongoDB. O nwere atụmatụ iji kwado mmepe, nchịkwa na nlegharị anya arụmọrụ na ọdụ data MongoDB.
• IBE ọkachamara - Ngwa GUI zuru oke maka Firebird na InterBase.
• HeidiSQL - Onye ahịa dị fechaa maka ijikwa MySQL, MSSQL na PostgreSQL, nke edere na Delphi.
• Ọrụ MySQL - MySQL Workbench bụ ngwa anya jikọtara ọnụ maka ndị nrụpụta nchekwa data, ndị mmepe na DBA.
• navicat - Ngwá ọrụ mmepe nchekwa data na-enye gị ohere ijikọ n'otu oge na MySQL, MariaDB, SQL Server, Oracle, PostgreSQL na ọdụ data SQLite site na otu ngwa.
• Oracle SQL Onye Mmepụta - Onye Mmepụta Oracle SQL bụ mpaghara mmepe n'efu, jikọtara ọnụ nke na-eme ka mmepe na njikwa data Oracle dị mfe na mbugharị ọdịnala yana igwe ojii.
• pgAdmin - Kacha ewu ewu ma nwee njikwa Open Source bara ụba na ikpo okwu mmepe maka PostgreSQL, nchekwa data mepere emepe kachasị elu n'ụwa.
• pgAdmin3 - Nkwado ogologo oge maka pgAdmin3.
• Onye nrụpụta PL/SQL - IDE nke ezubere iche maka mmepe nke ngalaba mmemme echekwara maka ọdụ data Oracle.
• PostgreSQL Maestro - Njikwa nchekwa data zuru oke ma dị ike, nchịkwa na ngwa mmepe maka PostgreSQL.
• Awo - Toad bụ ihe ngwọta nchekwa data mbụ maka ndị mmepe, ndị nchịkwa na ndị nyocha data. Jikwaa mgbanwe nchekwa data dị mgbagwoju anya site na iji otu ngwa njikwa nchekwa data.
• Toad Edge - Ngwa ọrụ mmepe nchekwa data dị mfe maka MySQL na Postgres.
• TOra - TOra bụ isi mmalite SQL IDE maka Oracle, MySQL na PostgreSQL dbs.
• Ụlọ ọrụ Valentina Studio - Mepụta, nye, jụọ ajụjụ ma nyochaa Valentina DB, MySQL, MariaDB, PostgreSQL na ọdụ data SQLite n'efu.

Ndị njikwa GUI / ndị ahịa

• Onye na-elekọta ya - Njikwa nchekwa data na otu faịlụ PHP.
• DbVisualizer - Ngwa nchekwa data zuru ụwa ọnụ maka ndị mmepe, DBA na ndị nyocha.
• HouseOps - Enterprise ClickHouse Ops UI maka ị na-agba ajụjụ, nyochaa ahụike ClickHouse ma mee ka ọtụtụ ndị ọzọ chee.
• JackDB - Dezie ohere SQL na data gị niile, n'agbanyeghị ebe ọ bi.
• OmniDB - Ngwa weebụ maka njikwa nchekwa data.
• Pgweb - Ihe nchọgharị weebụ dabere na PostgreSQL, nke edere na Go ma na-arụ ọrụ na igwe macOS, Linux na Windows.
• phpLiteAdmin - Ngwá ọrụ nchịkwa nchekwa data SQLite dabere na webụ edere na PHP yana nkwado maka SQLite3 na SQLite2.
• phpmyadmin - Ngwa weebụ maka MySQL na MariaDB.
• psequel - Psequel na-enye gị interface dị ọcha ma dị mfe iji rụọ ọrụ PostgreSQL ngwa ngwa.
• PopSQL - Oge a, onye nchịkọta akụkọ SQL maka otu gị.
• Postico - Onye ahịa PostgreSQL ọgbara ọhụrụ maka Mac.
• Robo 3T - Robo 3T (nke a na-akpọbu Robomongo) bụ ngwa njikwa MongoDB cross-centric cross-platform.
• Usoro Pro - Sequel Pro bụ ngwa njikwa nchekwa data Mac dị ngwa, dị mfe iji rụọ ọrụ na ọdụ data MySQL & MariaDB.
• Ụlọ ọrụ SQL Operations Studio - Ngwa njikwa data na-enyere aka ịrụ ọrụ na SQL Server, Azure SQL DB na SQL DW sitere na Windows, macOS na Linux.
• Ọkachamara SQLite - Eserese eserese na-akwado atụmatụ SQLite niile.
• sqlpad - Onye nchịkọta akụkọ SQL webụ na-agba n'igwe ojii nkeonwe gị.
• SQLPro - Onye njikwa Postgres dị mfe ma dị ike maka macOS.
• SQuirreL - Onye ahịa SQL eserese edere na Java nke ga-enye gị ohere ịlele nhazi nke nchekwa data ndabara JDBC, chọgharịa data na tebụl, nye iwu SQL wdg.
• Ngwa SQL - Njikwa nchekwa data maka VSCode.
• SQLyog - Kacha zuru ezu na mfe iji MySQL GUI.
• Tabix - SQL Editor & mepere emepe ọgụgụ isi azụmaahịa dị mfe maka Clickhouse.
• Isiokwu - Ngwa GUI nke oge a, nwa afọ na enyi maka ọdụ data mmekọrịta: MySQL, PostgreSQL, SQLite na ndị ọzọ.
• TeamPostgreSQL - GUI nchịkwa Weebụ PostgreSQL - jiri ọdụ data PostgreSQL gị site na ebe ọ bụla, nwere ọmarịcha weebụ AJAX na-enwu ọkụ.

Ngwa CLI

• ipython-sql - Jikọọ na nchekwa data maka inye iwu SQL n'ime IPython ma ọ bụ akwụkwọ ndetu IPython.
• iredis - Cli maka Redis nwere mmecha akpaaka na ngosipụta nke syntax.
• pgcenter - Ngwá ọrụ nchịkwa dị elu maka PostgreSQL.
• pg_ọrụ - Ngwa dị ka ngwa maka nlekota ọrụ sava PostgreSQL.
• pg_n'elu - 'n'elu' maka PostgreSQL.
• pspg - Postgres Pager
• sql - Oracle SQL Developer Command Line (SQLcl) bụ akara ahịrị iwu efu maka Oracle database.
• usql - Akara akara iwu zuru ụwa ọnụ maka PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, na ọtụtụ ọdụ data ndị ọzọ gụnyere NoSQL na ọdụ data na-abụghị mmekọrịta!

dbcli

• atenacl - AthenaCLI bụ ngwa CLI maka ọrụ AWS Athena nke nwere ike ime mmecha akpaaka na ịkọwapụta syntax.
• litecli - CLI maka ọdụ data SQLite nwere mmecha akpaaka na syntax.
• mssql-cli - Onye ahịa-akara iwu maka SQL Server nwere mmecha akpaaka yana ịkọwapụta syntax.
• mycli - Onye ahịa njedebe maka MySQL nwere AutoCompletion na Syntax Highlighting.
• pgcli - Postgres CLI nwere mmecha akpaaka na ịkọwapụta syntax.
• vcli - Vertica CLI nwere mmecha akpaaka yana ngosipụta syntax.

DB-schema igodo na nleba anya

• dbdiagram.io - Ngwa ngwa ma dị mfe iji nyere gị aka ise eserese mmekọrịta nchekwa data gị wee na-agba ọsọ ọsọ site na iji asụsụ DSL dị mfe.
• ERAlchemy - Njirimara Mmekọrịta Eserese ngwá ọrụ ọgbọ.
• SchemaCrawler - Ngwá ọrụ nchọpụta na nghọta nke nchekwa data efu.
• Nledo atụmatụ - Ịmepụta nchekwa data gị na akwụkwọ HTML, gụnyere eserese mmekọrịta.
• tbls - Ngwá ọrụ CI-Enyi na enyi maka akwụkwọ ndekọ data, nke edere na Go.

Ndị nlereanya

• Navicat Data Modeler - Ngwá ọrụ imewe nchekwa data dị ike ma dị ọnụ ahịa nke na-enyere gị aka ịmepụta echiche dị elu, ezi uche na ụdị data anụ ahụ.
• Oracle SQL Onye Mmepụta Data Modeler - Oracle SQL Onye Mmepụta Data Modeler bụ ngwa eserese na-akwụghị ụgwọ nke na-eme ka nrụpụta ọrụ dịkwuo mfe ma na-eme ka ọrụ nhazi data dị mfe.
• pgmodeler - Ngwá ọrụ nhazi data emebere maka PostgreSQL.

Ngwa mbata

• 2 bass - Ngwa nhazi data-dị ka koodu nke na-eji echiche nke scripts DDL ike.
• ụzọ ofufe - Ngwá ọrụ mbugharị ọdụ data.
• gh-ost - Mbugharị schema n'ịntanetị maka MySQL.
• liquibase - Ọbá akwụkwọ na-adabere na nchekwa data maka nsochi, jikwaa na itinye mgbanwe atụmatụ nchekwa data.
• ịkwaga - Dị ka diff mana maka atụmatụ PostgreSQL.
• node-pg-kwaga - Njikwa mbugharị nchekwa data Node.js wuru naanị maka postgres. (Ma enwere ike iji ya maka DB ndị ọzọ dabara na ọkọlọtọ SQL - dịka CockroachDB.)
• Pyrseas - Na-enye akụrụngwa iji kọwaa atụmatụ nchekwa data PostgreSQL dị ka YAML.
• SchemaHero - Onye ọrụ Kubernetes maka njikwa atụmatụ nchekwa data nkwupụta (gitops maka atụmatụ nchekwa data).
• Sqitch - nchekwa data nwere ezi uche - njikwa mgbanwe nke ala maka mmepe na-enweghị usoro yana ntinye a pụrụ ịdabere na ya.
• yuniql - Ma ihe ọzọ schema versioning na Mbugharị ngwá ọrụ dị nnọọ mere .NET Core 3.0+ na olileanya mma.

Usoro mmepụta koodu

• ddl-generator - Na-ewepụta SQL DDL (Asụsụ Definition Data) site na data tebụl.
• atụmatụ2ddl - Iwu ahịrị maka mbupụ atụmatụ Oracle ka ịtọlite ​​​​edl init scripts nwere ike nzacha ozi na-adịghị mma, kewapụrụ DDL na faịlụ dị iche iche, ọmarịcha usoro mmepụta.

Ndị na-ekpo ọkụ

• Nkọwapụta - Ihe ndabere REST API mepere emepe maka ngwa mkpanaka, webụ na ngwa IoT.
• Hasura GraphQL Engine - Na-ekpo ọkụ ngwa ngwa, ngwa ngwa GraphQL API na Postgres nwere njikwa ohere dị mma, na-ebutekwa webhooks na mmemme nchekwa data.
• jl-sql - SQL maka iyi JSON na CSV.
• mysql_fdw - PostgreSQL ihe mkpuchi data mba ofesi maka MySQL.
• Ọrụ data Oracle REST - Ngwa Java etiti-tier, ORDS maapụ HTTP(S) ngwaa (GET, POST, PUT, DELETE, wdg) na azụmahịa nchekwa data wee weghachi nsonaazụ ọ bụla ejiri JSON ahazi.
• Prism - Prisma na-atụgharị nchekwa data gị ka ọ bụrụ API GraphQL ozugbo.
• Zighachi - API REST maka nchekwa data Postgres ọ bụla.
• perst - Bụ ụzọ isi jee ozi API RESTful site na ọdụ data ọ bụla edere na Go.
• restSQL - Onye na-emepụta SQL nwere Java na HTTP API, na-eji API HTTP RESTful dị mfe yana XML ma ọ bụ JSON serialization.
• resquel - Gbanwee nchekwa data SQL gị ka ọ bụrụ API REST.
• sandman2 - Wepụta ọrụ API RESTful na akpaghị aka maka nchekwa data nketa gị.
• sql-akpụkpọ ụkwụ - REST dị elu na ihe mkpuchi UI maka ajụjụ SQL gị.

Ngwa ndabere

• pgbackrest - ndabere PostgreSQL ntụkwasị obi & weghachite.
• BaRMman - Nkwado ndabere na mpaghara mgbake maka PostgreSQL.

Arụmọrụ imegharị/Data

• Ihe ndekọ data - Ngwa maka inyocha na ibipụta data.
• dtle - Ọrụ Nyefe Data ekesara maka MySQL.
• pgsync - Mekọrịta data Postgres n'etiti ọdụ data.
• pg_chameleon - MySQL ka PostgreSQL oyiri usoro e dere na Python 3. Sistemu na-eji mysql-replication ọbá akwụkwọ sere ahiri oyiyi si MySQL nke echekwara n'ime PostgreSQL dị ka JSONB.
• PGDeltaStream - Ihe sava Golang iji na-ebugharị Postgres na-agbanwe ma ọ dịkarịa ala-otu ugboro n'elu websockets, na-eji atụmatụ ngbanwe ezi uche dị na Postgres.
• repmgr - Onye njikwa mmegharị nke kacha ewu ewu maka PostgreSQL.

Ihe ederede

• pgx_scripts - Nchịkọta obere edemede bara uru maka nyocha na nchịkwa data, nke ndị otu anyị mepụtara na PostgreSQL ọkachamara.
• pgsql-bloat-atụmatụ - Ajụjụ iji tụọ bloat ọnụ ọgụgụ na ndeksi na tebụl maka PostgreSQL.
• pgWikiDont - Nnwale SQL na-enyocha ma ọ bụrụ na nchekwa data gị na-agbaso iwu sitere na https://wiki.postgresql.org/wiki/Don’t_Do_This.
• pg-ọrụ - Ọrụ PostgreSQL bara uru.
• Akwụkwọ aghụghọ Postgres - bara uru SQL-scripts na iwu site .
• postgres_dba - Ngwa ọrụ bara uru maka Postgres DBA na ndị injinia niile na-efu efu.
• postgres_queries_and_commands.sql - Bara uru PostgreSQL ajụjụ na iwu.
• TPT - Edemede sqlplus ndị a bụ maka njikarịcha arụmọrụ nchekwa data Oracle & nchọpụta nsogbu.

Nleba anya/ọnụọgụ/arụmọrụ

• Ihe nlele ASH - Na-enye nlele eserese nke data akụkọ ihe mere eme nnọkọ n'ime Oracle na PostgreSQL DB.
• Monyog - Ngwá ọrụ nlekota MySQL na-adịghị akwụ ụgwọ & ọnụ ahịa.
• mssql-nlekota - Nyochaa sava SQL gị na arụmọrụ Linux site na iji anakọtara, InfluxDB na Grafana.
• Nyochaa Navicat - Ngwá ọrụ nleba anya ihe nkesa dịpụrụ adịpụ, dị mfe na enweghị ọrụ nke juputara na njirimara dị ike iji mee ka nlekota gị dị irè dị ka o kwere mee.
• Nlekọta na njikwa Percona - Mepee usoro ikpo okwu maka ijikwa na nyochaa arụmọrụ MySQL na MongoDB.
• onye nchikota pganalyze - Pganalyze onye nchịkọta ọnụ ọgụgụ maka ịnakọta metrics PostgreSQL na data ndekọ.
• postgres-nyocha - Ngwá ọrụ nchọpụta ọgbọ ọhụrụ nke na-enye ndị ọrụ ohere ime nyocha miri emi nke ahụike nke ọdụ data Postgres.
• postgres_exporter - Onye na-ebupụ Prometheus maka igwe ihe nkesa PostgreSQL.
• pgDash - Tulee ma soro akụkụ ọ bụla nke ọdụ data PostgreSQL gị.
• PgHero - dashboard arụmọrụ maka Postgres - nyocha ahụike, ndenye atụ aro, na ndị ọzọ.
• pgmetrics - Anakọta ma gosipụta ozi na stats sitere na sava PostgreSQL na-agba ọsọ.
• pgMustard - Onye ọrụ maka Postgres na-akọwa atụmatụ, gbakwunyere ndụmọdụ iji melite arụmọrụ.
• pgstat - Na-anakọta ọnụ ọgụgụ PostgreSQL, ma chekwaa ya na faịlụ CSV ma ọ bụ bipụta ya na stdout.
• pgwatch2 - Nleba anya / dashboarding metrics PostgreSQL na-agbanwe onwe ya.
• Ngwa mgbakwunye Telegraf PostgreSQL - Na-enye metrik maka nchekwa data postgres gị.

Zabbix

• Mamonsu - Onye nleba anya maka PostgreSQL.
• Orabbix - Orabbix bụ ngwa mgbakwunye emebere ka ya na Zabbix Enterprise Monitor na-arụ ọrụ iji nye nleba anya n'ọtụtụ dị iche iche, arụmọrụ yana mkpesa nnweta na nha maka ọdụ data Oracle, yana metrik arụmọrụ sava.
• pg_monz - Nke a bụ ndebiri nlekota Zabbix maka nchekwa data PostgreSQL.
• Pyora - Ederede Python iji nyochaa ọdụ data Oracle.
• ZabbixDBA - ZabbixDBA na-adị ngwa ngwa, na-agbanwe ma na-emepe ngwa mgbakwunye iji nyochaa RDBMS gị.

Testing

• DbFit - Usoro nnwale nchekwa data nke na-akwado mmepe nke koodu nchekwa data gị dị mfe.
• RegreSQL - Regression Na-anwale ajụjụ SQL gị.

Generator data

• Databene Benerator - Ọ bụ usoro maka iwepụta data nnwale dị elu nke dabara adaba maka sistemụ gị n'okpuru ule (na-ezere ụkpụrụ mgbochi Datalite).
• dbForge Data Generator maka MySQL - Ngwá ọrụ GUI siri ike maka imepụta oke data nnwale.
• dbForge Data Generator maka Oracle - Ngwá ọrụ GUI pere mpe mana dị ike maka ibipụta atụmatụ Oracle nwere ọtụtụ data nnwale ezi uche dị na ya.
• dbForge Data Generator maka SQL Server - Ngwá ọrụ GUI dị ike maka ọgbọ ngwa ngwa nke data nnwale bara uru maka ọdụ data.

ochichi

• pgbadger - ngwa ngwa PostgreSQL Log Analyzer.
• pgbedrock - Jikwaa ọrụ ụyọkọ Postgres, ndị otu ọrụ, nwe schema, na ihe ùgwù.
• pgslice - Postgres nkewa dị mfe dị ka achịcha.

HA/Emebighị/Shading

• Citus - Mgbatị Postgres na-ekesa data gị yana ajụjụ gị n'ofe ọnụ ọnụ.
• onye nkwado - A ndebiri maka PostgreSQL High Availability na ZooKeeper, wdgd, ma ọ bụ Consul.
• Percona XtraDB ụyọkọ - Ngwọta dị elu maka mkpokọta MySQL na nnweta dị elu.
• stolon - Onye njikwa PostgreSQL nke igwe ojii maka ịdị elu PostgreSQL.
• pg_auto_failover - Mgbatị na ọrụ Postgres maka ọdịda akpaaka na ịdị elu dị elu.
• pglookuut - PostgreSQL nleba anya mmegharị na ọdịda daemon.
• PostgreSQL akpaghị aka - Nnweta dị elu maka Postgres, dabere na ntụaka ụlọ ọrụ Pacemaker na Corosync.
• postgresql_cluster - Ụyọkọ nnweta dị elu nke PostgreSQL (dabere na "Patroni" na "DCS(etcd)"). Na-arụ ọrụ na-akpaghị aka na ike.
• Vitess - Usoro nchịkọta nchekwa data maka nhazi nke MySQL site na sharding zuru oke.

Kubernetes

• KubeDB - Ime ka nchekwa data mmepụta na-agba ọsọ dị mfe na Kubernetes.
• Onye ọrụ Postgres - Onye ọrụ Postgres na-eme ka ụyọkọ PostgreSQL dị na Kubernetes (K8s) nke Patroni kwadoro.
• Spilo - ụyọkọ HA PostgreSQL nwere Docker.
• StackGres - ọkwa ụlọ ọrụ, PostgreSQL zuru ezu na Kubernetes.

Nhazi Nhazi

• MySQLTuner-perl - Ederede edere na Perl nke na-enye gị ohere inyocha nrụnye MySQL ngwa ngwa wee mee mgbanwe iji bulie arụmọrụ na nkwụsi ike.
• PGConfigurator - Ngwá ọrụ ịntanetị efu iji mepụta nke kachasị postgresql.conf.
• pgtun - ọkachamara nhazi nhazi PostgreSQL.
• postgresqltuner.pl - Ederede dị mfe iji nyochaa nhazi nchekwa data PostgreSQL gị, ma nye ndụmọdụ nlegharị anya.

DevOps

• DBmaestro - DBmaestro na-eme ngwa ngwa ntọhapụ ma na-akwado ike n'ofe gburugburu gburugburu IT.
• Ngwa ngwa DevOps - Ngwa Toad DevOps na-arụ ọrụ mmepe nchekwa data n'ime usoro ọrụ DevOps gị - na-emebighị ogo, arụmọrụ ma ọ bụ ntụkwasị obi.

Nlereanya atụmatụ

• Atụmatụ Nlereanya Database Oracle - Oracle Database Sample Schems.

akuko

• Poly - Ngwa mkpesa SQL dị mfe iji rụọ ọrụ maka ndị hụrụ SQL n'anya.

Ihe nkesa

• DBdeployer - Ngwá ọrụ na-ebuga MySQL nchekwa data sava mfe.
• dbatools - Modul PowerShell nke ị nwere ike iche dị ka ụlọ ọrụ njikwa njikwa SQL.
• Postgres.app - Nwụnye PostgreSQL zuru oke dị ka ngwa Mac ọkọlọtọ.
• BigSQL - Nkesa enyi na enyi nke onye nrụpụta Postgres.
• Ụlọ Enyí - N'ihu njedebe njikwa PostgreSQL webụ nke na-ejikọta ọtụtụ ngwa na ngwa maka iji PostgreSQL.

Security

• accra - Ebe nchekwa nchekwa data. Proxy nchekwa data nwere izo ya ezo ọkwa ọkwa, chọọ site na data ezoro ezo, Mgbochi injections SQL, nchọpụta intrusion, mmanụ aṅụ. Na-akwado akụkụ ndị ahịa na akụkụ proxy ("transparent") nzuzo. SQL, NoSQL.

Ndị na-emepụta koodu

• CodeBuff - Asụsụ-agnostic mara mma-ebi akwụkwọ site na mmụta igwe.

Inye onyinye

• A na-anabata nkwado gị mgbe niile! Biko gụọ ya ntụnye aka akpa.

Ọ bụrụ na ị nwere nchọpụta ọ bụla maka nchekwa data, biko kesaa. Obi ga-adịkwa m ụtọ ịnata nzaghachi - PR na kpakpando. Ọ bụrụ na ị nwere ajụjụ ọ bụla gbasara ịmepụta mpempe akwụkwọ nke gị, deekwa ha.

isi: www.habr.com