According to the 2023 Stack Overflow Developer Survey, PostgreSQL has achieved a significant milestone by overtaking MySQL as the most admired and desired database system among developers. This shift reflects a growing appreciation for PostgreSQL's robust feature set, reliability, and extensibility in the developer community.
This changing landscape has sparked innovation in the database-as-a-service space, particularly evident in the competition between two cutting-edge platforms: PlanetScale, built on MySQL, and Neon, powered by PostgreSQL. Both services are reimagining how developers interact with databases in the cloud era. These developments should be of interest to Navicat users, as both are fully supported by Navicat's comprehensive database development and management tools.
This blog will provide a comparison of the two services and offer some tips for choosing between them.
Range Types
It's no secret that PostgreSQL is one of the most flexible databases on the market. In fact, PostgreSQL's extensibility and rich feature set recently propelled PostgreSQL ahead of MySQL as the most admired and desired database system among developers. In this series on creating custom data types in PostgreSQL using Navicat Premium 17 we've explored a few options so far, including custom Domains, as well as Composite and Enumerated types. The topic of this week's blog will be Range types, which are particularly useful when you need to work with continuous intervals or ranges of values.
Enumerated Types
In this series on creating custom data types in PostgreSQL using Navicat Premium 17 we've explored a couple of options so far. In part 1, we learned how to create a custom Domain for the free DVD Rental database. Last week, we created a Composite Type to return complex data from a user-defined function. Today's blog will cover Enumerated Types, which limit values a set of predefined options.
Composite Types
Welcome to the second installment of this series on creating custom data types in PostgreSQL using Navicat Premium 17. In part 1, we learned how to create a custom Domain for the free DVD Rental database. A Domain is a user-defined data type with constraints such as NOT NULL and CHECK. In today's blog, we'll create a Composite Type to return complex data from a user-defined function.
Domains
Storing data in proper formats ensures data integrity, prevents errors, optimizes performance, and maintains consistency across systems by enforcing validation rules and enabling efficient data management. For these reasons, top tier relational databases like PostgreSQL offer a variety of data types. In addition, PostgreSQL enables custom data type creation via the "CREATE DOMAIN" and "CREATE TYPE" statements, allowing developers to extend data types for enhanced application-specific data validation, integrity, and consistency. In today's blog, we'll learn how to create a custom Domain for the free DVD Rental database using Navicat Premium 17. Part 2 will cover Types.
- 2026 (1)
- March (1)
- The Hidden Costs of Cloud Database Services (and When On-Prem Makes More Financial Sense)
- How AI Code Completion Is Changing the Way DBAs Write SQL
- Role-Based Access Control in Database Environments: Getting It Right
- On-Prem vs. Cloud Database Hosting: How to Choose the Right Approach for Your Organization
- Getting Started with AI Assistants in Navicat On-Prem Server 3.1
- SQL vs. NoSQL: Choosing the Best Fit for Your Project
- February (1)
- What Metrics Actually Matter in Database Monitoring
- A Practical Guide to Database Transaction Isolation Levels
- Database Connection Pooling Explained
- Managing Database Credentials Securely
- Building Resilient Database Architectures
- The Future of Database Licensing Models: Navigating the Shift in How We Pay for Data Infrastructure
- January (1)
- Harnessing PostgreSQL Power: An Introduction to Supabase
- The ROI of Database Automation: Quantifying the Business Value of Automated Tuning, Patching, and Optimization
- Database Observability: The New Frontier in Performance Management
- The Database Skills Gap Crisis: Navigating the Shortage of Database Professionals
- The Economics of Multi-Cloud Databases
- March (1)
- 2025 (1)
- December (1)
- November (1)
- October (1)
- September (1)
- August (1)
- Going Beyond Basic Monitoring with Modern Database Observability Platforms
- Privacy-Preserving Databases: Protecting Data While Enabling Access
- Privacy-Preserving Databases: Protecting Data While Enabling Access
- Privacy-Preserving Databases: Protecting Data While Enabling Access
- A Guide to Database Sharding as a Service
- July (1)
- June (1)
- The Rise of Embedded AI/ML Capabilities in Modern Databases
- Immutable Databases: the Evolution of Data Integrity?
- Seamless Information Access Through Data Virtualization and Federation
- Database DevOps Integration: Bridging the Gap Between Development and Operations
- Navicat Sponsors SQLBits 2025 – Supporting the Future of Data Platforms
- May (1)
- Edge Databases: Empowering Distributed Computing Environments
- The Rise of Low-Code/No-Code Database Interfaces: Democratizing Data Management
- Data Vault 2.0: A Modern Approach to Enterprise Data Modeling
- Streaming-First Architectures: Revolutionizing Real-Time Data Processing
- Navicat Proudly Sponsors PGConf.de 2025 as Silver Sponsor (Two Free Tickets Up for Grabs!)
- April (1)
- March (1)
- February (1)
- January (1)
- 2024 (1)
- 2023 (1)
- 2022 (1)
- 2021 (1)
- 2020 (1)
- 2019 (1)
- 2018 (1)
- 2017 (1)
