![]() ![]() It is highly scalable in both the quantity of data it can manage and in the number of simultaneous users that can be accommodated. PostgreSQL is also locale-aware for case sensitivity, sorting, and formatting. Robust extensions: PostgreSQL houses robust feature sets such as point-in-time recovery, multi-version concurrency (MVCC), tablespaces, granular access controls, and online/hot backups.It includes most SQL: 2008 data types, including BOOLEAN, NUMERIC, INTEGER, DATE, VARCHAR, TIMESTAMP, INTERVAL, and CHAR. PostgreSQL is also ACID-compliant and provides full support for views, foreign keys, triggers, joins, and stored procedures, in various languages. Standards compliance and reliability: PostgreSQL’s write-ahead logging allows it to stand out as a highly fault-tolerant database.Now, let’s move on to take a look at some features of PostgreSQL that make it such an indispensable tool in the marketplace: In 2014, the PGconf ushered in a new era for PostgreSQL users.NYCPUG (New York City PostgreSQL User Group) joined the PgUS (United States PostgreSQL Association) back in 2013.In 1990, support for PL/ pgSQL and ACID compliance was added to PostgreSQL.Michael Stonebraker and his associates developed Postgres in 1986.Here’s a brief overview of PostgreSQL through the years: For instance, you can generate custom functions, define your data types, and even write code from various programming languages without having to recompile your database! History On top of being free and open-source, PostgreSQL is also highly extensible. PostgreSQL also boasts a rich history of supporting advanced data types along with performance optimization commonly found across its commercial database counterparts, like Microsoft SQL Server and Oracle. PostgreSQL is used as the main data warehouse or data store for various mobile, web, analytics, and geospatial applications. This powerful and stable database management system has been backed by over thirty years of active community development that has contributed to its reputation for integrity, reliability, resilience, performance, and correctness. ![]() PostgreSQL has established itself as an enterprise-class, advanced open-source database that supports both JSON (non-relational) and SQL (relational) querying. Microsoft reserves all other rights.What Is PostgreSQL? PostgreSQL logo (Image Source: Uberconf) You may copy, distribute, and display the icons only for the permitted use unless granted explicit permission by Microsoft. Microsoft permits the use of these icons in architectural diagrams, training materials, or documentation. The files in the icons folder are the same except there's no longer a CXP folder. The FAQs and Terms of Use PDF files appear in the first level when you download the SVG icons below. The folder structure of our collection of Azure architecture icons has changed. There are ~26 icons that have been added to the existing set. Updated icon names from Azure Security Center to Microsoft Defender for Cloud. Reorganized folder structure of some icons.Īdded 24 Microsoft Defender for IoT icons.Īdded 13 icons for various services and components.Īdded ~106 icons for various services and components. Icon updates MonthĪdded new Microsoft Entra ID icon. Don't use Microsoft product icons to represent your product or service.īrowse all Azure architectures to view other examples.Don't distort or change icon shape in any way.Use the icons as they would appear within Azure.In diagrams, we recommend including the product name somewhere close to the icon.Use the icon to illustrate how products can work together.On this page you'll find an official collection of Azure architecture icons including Azure product icons to help you build a custom architecture diagram for your next solution. Architecture diagrams like those included in our guidance can help communicate design decisions and the relationships between components of a given workload. Helping our customers design and architect new solutions is core to the Azure Architecture Center's mission.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |