{"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\/news\/rejting-populyarnosti-subd-postgresql-nazvan-subd-2023-goda","title":{"rendered":"Andmetebaaside populaarsuse reiting. PostgreSQL on nimetatud 2023. aasta andmebaasiks","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

DB-Engines on uuendanud oma andmebaaside populaarsuse reitingut ning andnud 2023. aasta andmebaasi tiitli projekti PostgreSQL, mis n\u00e4itas aasta jooksul suurimat populaarsuse kasvu 417 j\u00e4lgitava s\u00fcsteemi seast. Teise koha sai pilveplatvorm Databricks, mis t\u00f5usis aastaga 19. kohalt 17. kohale, kolmandale kohale t\u00f5usis Google BigQuery, mis t\u00f5usis 21. kohalt 19. kohale. <\/p>\n

Varem PostgreSQL tunnustati 2020., 2018. ja 2017. aasta andmebaasi aasta tiitliga. 2022. ja 2021. aastal p\u00e4lvis selle tiitli Snowflake, 2019. aastal MySQL, 2016. aastal Microsoft SQL Server, 2015. aastal Oracle, 2013. ja 2014. aastal MongoDB. <\/p>\n

Reitingu arvutamise metoodika meenutab TIOBE programmikeelte reitingut ja arvestab otsingumootorites tehtud p\u00e4ringute populaarsust, otsingutulemite arvu, arutelude mahtu populaarsetel aruteluplatvormidel ja sotsiaalmeedes, t\u00f6\u00f6otsingute arvu v\u00e4rbamistoimkondades ning mainimisi kasutajaprofiilides. <\/p>\n

Andmebaaside edetabelis hoiab PostgreSQL j\u00e4tkuvalt 4. kohta, hoolimata k\u00f5ige suuremast populaarsuse kasvust kogu edetabelis \u2014 34,11 punkti. Suuremat populaarsuse kasvu n\u00e4itavad ka projektid 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). 8. kohalt 7. kohale t\u00f5usis andmehoidla Elasticsearch, 33. kohalt 29. kohale \u2014 andmebaas Firebird, 44. kohalt 37. kohale \u2014 ClickHouse, 62. kohalt 50. kohale \u2014 Prometheus, 48. kohalt 42. kohale \u2014 OpenSearch, 85. kohalt 76. kohale \u2014 TimescaleDB. <\/p>\n

M\u00e4rgatavat populaarsuse langust aastaga t\u00e4heldatakse MySQL (-88,5 punkti), Microsoft SQL Serveri (-42,79 punkti), MongoDB (-37,70 punkti), Redis (-18,17 punkti) ja SQLite (-16,29 punkti) puhul. 7. kohalt 8. kohale langes andmebaas IBM Db2, 10. kohalt 11. kohale \u2014 SQLite, 43. kohalt 45. kohale \u2014 CouchDB, 57. kohalt 60. kohale \u2014 CockroachDB.

\"Andmetebaaside<\/center>
\"Andmetebaaside<\/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-news"],"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\udd47Andmetebaaside populaarsuse reiting. PostgreSQL on nimetatud 2023. aasta andmebaasiks | ProHoster","description":"DB-Engines on uuendanud oma andmebaaside populaarsuse reitingut ning andnud 2023. aasta andmebaasi tiitli projekti PostgreSQL, mis n\u00e4itas aasta jooksul suurimat populaarsuse kasvu 417 j\u00e4lgitava s\u00fcsteemi seast.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/news\/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.","og:url":"https:\/\/prohoster.info\/et\/blog\/news\/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}]}}