Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the sue domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the shortcodes-ultimate domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the complianz-gdpr domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php on line 6114

Deprecated: Creation of dynamic property EDD_Theme_Updater_Admin::$item_name is deprecated in /www/htdocs/w01a7138/opendb.de/wp-content/themes/mh-magazine/includes/updater/theme-updater-admin.php on line 54

Deprecated: Creation of dynamic property EDD_Theme_Updater_Admin::$beta is deprecated in /www/htdocs/w01a7138/opendb.de/wp-content/themes/mh-magazine/includes/updater/theme-updater-admin.php on line 60

Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php:6114) in /www/htdocs/w01a7138/opendb.de/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php:6114) in /www/htdocs/w01a7138/opendb.de/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php:6114) in /www/htdocs/w01a7138/opendb.de/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php:6114) in /www/htdocs/w01a7138/opendb.de/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php:6114) in /www/htdocs/w01a7138/opendb.de/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php:6114) in /www/htdocs/w01a7138/opendb.de/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php:6114) in /www/htdocs/w01a7138/opendb.de/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php:6114) in /www/htdocs/w01a7138/opendb.de/wp-includes/rest-api/class-wp-rest-server.php on line 1893
{"id":355,"date":"2010-08-18T19:00:04","date_gmt":"2010-08-18T17:00:04","guid":{"rendered":""},"modified":"2021-02-10T00:00:29","modified_gmt":"2021-02-09T23:00:29","slug":"mysql-postgresql-wo-es-hingeht_355","status":"publish","type":"post","link":"https:\/\/opendb.de\/postgresql\/mysql-postgresql-wo-es-hingeht_355\/","title":{"rendered":"MySQL und PostgreSQL: Wo es hingeht"},"content":{"rendered":"

Im Wesentlichen besetzen zwei Produkte den Markt relationaler, freier Datenbanken. W\u00e4hrend in der Vergangenheit das Rampenlicht auf MySQL strahlte, dr\u00e4ngt der bisherige Zweite PostgreSQL inzwischen aus dem Schatten heraus.<\/p>\n

Aus dem Angebot frei verf\u00fcgbarer relationaler Datenbanken stechen MySQL und PostgreSQL als wichtigste Vertreter hervor: MySQL ist bei vielen Web-Hostern verf\u00fcgbar, und PostgreSQL macht durch Standardkonformit\u00e4t sowie eine kontinuierliche Weiterentwicklung von sich reden.<\/p>\n

In der Vergangenheit konnte der Eindruck entstehen, PostgreSQL sei der ewige Zweite. MySQL war einfach zu installieren und zu bedienen, und dass ihm anf\u00e4nglich Funktionen wie Transaktionen, Stored Procedures und Trigger fehlten, erleichterte Laien die Einarbeitung. Inzwischen ist die Lage aber nicht mehr so klar. <\/p>\n

Dazu hat vor allem der Versionswirrwarr bei MySQL beigetragen. Als Produktivversion gilt zurzeit die Reihe 5.1, 5.0 ist jedoch noch weit verbreitet. Im April 2004 ver\u00f6ffentlichte Sun \u00fcberraschend eine Version 5.4, die vor allem Performance-Verbesserungen von Google enthielt. Sie schaffte es jedoch nicht zur Produktionsreife. Inzwischen arbeitet Oracle an MySQL 5.5.<\/p>\n

Um Klarheit \u00fcber die aktuelle und m\u00f6gliche zuk\u00fcnftige Entwicklung bei MySQL zu gewinnen, bat iX einen bei Oracle besch\u00e4ftigten Fachmann um einen Beitrag (s. iX 9\/10 S. 44). Zu Projekten wie dem 2007 angek\u00fcndigten MySQL 6 und der daf\u00fcr entwickelten transaktionsf\u00e4higen Storage Engine Falcon \u00e4u\u00dfert sich das Unternehmen jedoch nicht. Das l\u00e4sst nur den Schluss zu, dass diese Vorhaben gestorben sind. Zumal die Arbeit an dem seit 2005 zu Oracle geh\u00f6renden InnoDB schnell voranschreitet \u2013 zwei Transaktions-Backends aus demselben Haus d\u00fcrften f\u00fcr das Unternehmen keinen Sinn ergeben. <\/p>\n

Den Schwerpunkt der Entwicklung legt der neue MySQL-Eigent\u00fcmer Oracle offenbar auf unternehmensrelevante Funktionen…<\/p>\n

Weiterlesen: http:\/\/www.heise.de\/ix\/artikel\/Zweikampf-1058762.html<\/a><\/p>","protected":false},"excerpt":{"rendered":"

Im Wesentlichen besetzen zwei Produkte den Markt relationaler, freier Datenbanken. W\u00e4hrend in der Vergangenheit das Rampenlicht auf MySQL strahlte, dr\u00e4ngt der bisherige Zweite PostgreSQL inzwischen aus dem Schatten heraus.<\/p>\n

[…]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":{"0":"post-355","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-postgresql"},"_links":{"self":[{"href":"https:\/\/opendb.de\/wp-json\/wp\/v2\/posts\/355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/opendb.de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/opendb.de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/opendb.de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/opendb.de\/wp-json\/wp\/v2\/comments?post=355"}],"version-history":[{"count":0,"href":"https:\/\/opendb.de\/wp-json\/wp\/v2\/posts\/355\/revisions"}],"wp:attachment":[{"href":"https:\/\/opendb.de\/wp-json\/wp\/v2\/media?parent=355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/opendb.de\/wp-json\/wp\/v2\/categories?post=355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/opendb.de\/wp-json\/wp\/v2\/tags?post=355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}