{"id":112701,"date":"2024-01-04T15:10:27","date_gmt":"2024-01-04T13:10:29","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/rejting-populyarnosti-subd-postgresql-nazvan-subd-2023-goda"},"modified":"2024-01-04T15:10:27","modified_gmt":"2024-01-04T13:10:29","slug":"rejting-populyarnosti-subd-postgresql-nazvan-subd-2023-goda","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/novosti-interneta\/rejting-populyarnosti-subd-postgresql-nazvan-subd-2023-goda","title":{"rendered":"Andmebaaside populaarsuse edetabel. PostgreSQL on nimetatud 2023. aasta andmebaasiks.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

DB-Engines on v\u00e4rskendanud oma andmebaaside populaarsuse edetabelit ja nimetanud 2023. aasta andmebaasiks PostgreSQL, mis on aasta jooksul n\u00e4idanud suurimat populaarsuse t\u00f5usu k\u00f5igi 417 j\u00e4lgitava s\u00fcsteemi seas. Teise koha sai pilveplatvorm Databricks, mis t\u00f5usis 19. kohalt 17. kohale, ning kolmandaks tuli Google BigQuery, mis t\u00f5usis 21. kohalt 19. kohale. <\/p>\n

Varem on PostgreSQL juba 2020., 2018. ja 2017. aastal tunnustatud aasta andmebaasihalduss\u00fcsteemiks. 2022. ja 2021. aastal sai selle tiitli Snowflake, 2019. aastal MySQL, 2016. aastal Microsoft SQL Server, 2015. aastal Oracle ning 2013. ja 2014. aastal MongoDB. <\/p>\n

Edetabeli kalkulatsioonimeetod meenutab programmeerimiskeelte TIOBE edetabelit ja arvestab otsingumootorites tehtud p\u00e4ringute populaarsust, tulemuste arvu otsingutulemustes, arutelu mahtu populaarsetes arutelulaual ja sotsiaalsetes v\u00f5rgustikes, t\u00f6\u00f6pakkumiste arvu v\u00e4rbamisk\u00fclad ja mainimisi kasutajaprofiilides. <\/p>\n

Mis puutub andmebaasihalduss\u00fcsteemide jaotusse reitingus, siis PostgreSQL j\u00e4tkab 4. koha hoidmist, hoolimata suurimast populaarsuse kasvust reitingus - 34.11 punkti. Populaarsuse kasvu n\u00e4itavad ka projektid nagu Databricks (+19.7 punkti, t\u00f5us 19. kohalt 17. kohale), Google BigQuery (+9 punkti, t\u00f5us 21. kohalt 19. kohale) ja Snowflake (+8.66 punkti, t\u00f5us 11. kohalt 9. kohale). Elasticsearch t\u00f5usis 8. kohalt 7. kohale, Firebird 33. kohalt 29. kohale, ClickHouse 44. kohalt 37. kohale, Prometheus 62. kohalt 50. kohale, OpenSearch 48. kohalt 42. kohale, ja TimescaleDB 85. kohalt 76. kohale. <\/p>\n

M\u00e4rkimisv\u00e4\u00e4rne populaarsuse langus aastaga on toimunud MySQL (-88.5 punkti), Microsoft SQL Serveri (-42.79), MongoDB (-37.70), Redis (-18.17) ja SQLite (-16.29) puhul. IBM Db2 kukkus 7. kohalt 8. kohale, SQLite 10. kohalt 11. kohale, CouchDB 43. kohalt 45. kohale ja CockroachDB 57. kohalt 60. kohale.

\"Andmebaaside<\/center>
\"Andmebaaside<\/center>
\n
Allikas: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u0418\u0437\u0434\u0430\u043d\u0438\u0435 DB-Engines \u043e\u0431\u043d\u043e\u0432\u0438\u043b\u043e \u0441\u0432\u043e\u0439 \u0440\u0435\u0439\u0442\u0438\u043d\u0433 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u043e\u0441\u0442\u0438 \u0421\u0423\u0411\u0414 \u0438 \u043f\u0440\u0438\u0441\u0443\u0434\u0438\u043b\u043e \u0437\u0432\u0430\u043d\u0438\u0435 \u0421\u0423\u0411\u0414 2023 \u0433\u043e\u0434\u0430 \u043f\u0440\u043e\u0435\u043a\u0442\u0443 PostgreSQL, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0437\u0430 \u0433\u043e\u0434 \u043f\u0440\u043e\u0434\u0435\u043c\u043e\u043d\u0441\u0442\u0440\u0438\u0440\u043e\u0432\u0430\u043b \u043d\u0430\u0438\u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u0440\u043e\u0441\u0442 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u043e\u0441\u0442\u0438 \u0438\u0437 417 \u043e\u0442\u0441\u043b\u0435\u0436\u0438\u0432\u0430\u0435\u043c\u044b\u0445 \u0441\u0438\u0441\u0442\u0435\u043c. \u0412\u0442\u043e\u0440\u043e\u0435 \u043c\u0435\u0441\u0442\u043e \u043f\u0440\u0438\u0441\u0443\u0436\u0434\u0435\u043d\u043e \u043e\u0431\u043b\u0430\u0447\u043d\u043e\u0439 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u0435 Databricks, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0437\u0430 \u0433\u043e\u0434 \u043f\u043e\u0434\u043d\u044f\u043b\u0430\u0441\u044c \u0441 19 \u043d\u0430 17 \u043c\u0435\u0441\u0442\u043e \u0432 \u0440\u0435\u0439\u0442\u0438\u0433\u0435, \u0430 \u0442\u0440\u0435\u0442\u044c\u0435 \u043c\u0435\u0441\u0442\u043e \u0437\u0430\u043d\u044f\u043b \u0434\u0432\u0438\u0436\u043e\u043a Google BigQuery, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043f\u043e\u0434\u043d\u044f\u043b\u0441\u044f \u0441 21 \u043d\u0430 […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":112702,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-112701","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-novosti-interneta"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Andmebaaside populaarsuse edetabel. PostgreSQL on nimetatud 2023. aasta andmebaasiks | ProHoster","description":"DB-Engines on v\u00e4rskendanud oma andmebaaside populaarsuse edetabelit ja nimetanud 2023. aasta andmebaasiks PostgreSQL, mis on aasta jooksul n\u00e4idanud suurimat populaarsuse t\u00f5usu k\u00f5igi 417 j\u00e4lgitava s\u00fcsteemi seas. Teise koha sai pilveplatvorm Databricks, mis t\u00f5usis 19. kohalt 17. kohale, ning kolmandaks tuli Google BigQuery, mis t\u00f5usis 21. kohalt","canonical_url":"https:\/\/prohoster.info\/et\/blog\/novosti-interneta\/rejting-populyarnosti-subd-postgresql-nazvan-subd-2023-goda","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0420\u0435\u0439\u0442\u0438\u043d\u0433 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u043e\u0441\u0442\u0438 \u0421\u0423\u0411\u0414. PostgreSQL \u043d\u0430\u0437\u0432\u0430\u043d \u0421\u0423\u0411\u0414 2023 \u0433\u043e\u0434\u0430 | ProHoster","og:description":"\u0418\u0437\u0434\u0430\u043d\u0438\u0435 DB-Engines \u043e\u0431\u043d\u043e\u0432\u0438\u043b\u043e \u0441\u0432\u043e\u0439 \u0440\u0435\u0439\u0442\u0438\u043d\u0433 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u043e\u0441\u0442\u0438 \u0421\u0423\u0411\u0414 \u0438 \u043f\u0440\u0438\u0441\u0443\u0434\u0438\u043b\u043e \u0437\u0432\u0430\u043d\u0438\u0435 \u0421\u0423\u0411\u0414 2023 \u0433\u043e\u0434\u0430 \u043f\u0440\u043e\u0435\u043a\u0442\u0443 PostgreSQL, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0437\u0430 \u0433\u043e\u0434 \u043f\u0440\u043e\u0434\u0435\u043c\u043e\u043d\u0441\u0442\u0440\u0438\u0440\u043e\u0432\u0430\u043b \u043d\u0430\u0438\u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u0440\u043e\u0441\u0442 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u043e\u0441\u0442\u0438 \u0438\u0437 417 \u043e\u0442\u0441\u043b\u0435\u0436\u0438\u0432\u0430\u0435\u043c\u044b\u0445 \u0441\u0438\u0441\u0442\u0435\u043c. \u0412\u0442\u043e\u0440\u043e\u0435 \u043c\u0435\u0441\u0442\u043e \u043f\u0440\u0438\u0441\u0443\u0436\u0434\u0435\u043d\u043e \u043e\u0431\u043b\u0430\u0447\u043d\u043e\u0439 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u0435 Databricks, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0437\u0430 \u0433\u043e\u0434 \u043f\u043e\u0434\u043d\u044f\u043b\u0430\u0441\u044c \u0441 19 \u043d\u0430 17 \u043c\u0435\u0441\u0442\u043e \u0432 \u0440\u0435\u0439\u0442\u0438\u0433\u0435, \u0430 \u0442\u0440\u0435\u0442\u044c\u0435 \u043c\u0435\u0441\u0442\u043e \u0437\u0430\u043d\u044f\u043b \u0434\u0432\u0438\u0436\u043e\u043a Google BigQuery, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043f\u043e\u0434\u043d\u044f\u043b\u0441\u044f \u0441 21 \u043d\u0430","og:url":"https:\/\/prohoster.info\/et\/blog\/novosti-interneta\/rejting-populyarnosti-subd-postgresql-nazvan-subd-2023-goda","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2024-01-04T13:10:29+00:00","article:modified_time":"2024-01-04T13:10:29+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":[],"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/112701","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=112701"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/112701\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/112702"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=112701"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=112701"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=112701"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}