5 Improper feature usage
In this chapter
- What choosing the
SQL_ASCIIencoding entails - Creating rules, and the associated pitfalls
- Misusing NoSQL features for SQL queries
- Improvising distributed/multi-master systems can lead to problems
The rich feature set of PostgreSQL is what makes it such a powerful tool for data processing. Far from being a traditional Relational Database Management System (RDBMS), additional features such as NoSQL capabilities, logical replication, foreign data wrappers and rules give you the flexibility to design a wide variety of database-oriented systems (and to make mistakes with those designs)!
5.1 Selecting SQL_ASCII as the encoding
Since the dawn of computing, character encoding, or the numeric representation of text characters, has used various encoding schemes for mapping characters to numeric values for storage. With the use of computers expanding around the globe, the need to create more (and almost always incompatible) code pages or character sets for use with different languages' written characters became a hot topic.