Why Not PostgreSQL?
Given all the proselytizing thus far, it’s only fair that we point out situations
when PostgreSQL might not be suitable.
The typical installation size of PostgreSQL without any extensions is more than
100MB. This rules out PostgreSQL for a database on a small device or as a
simple cache store. Many light-weight databases abound that could better
serve your needs without the larger footprint.
Given its enterprise stature, PostgreSQL doesn’t take security lightly. If you’re
developing lightweight applications where you’re managing security at the
application level, PostgreSQL security with its sophisticated role and
permission management could be overkill. You might consider a single-user
user database such as SQLite or a database such as Firebird that can be run
either as client server or in single user embedded mode.
All that said, it is a common practice to combine PostgreSQL with other
database types. One common combination you will find is using Redis or
Memcache is used to cache PostgreSQL query results. As another example,
SQLite can be used to store a disconnected set of data for offline querying
while PostgreSQL is the main database backend for an application.
Finally, many hosting companies don’t offer PostgreSQL on a shared hosting
environment, or offer an outdated version. Most still gravitate towards the
impotent MySQL. To a web designer where database is an afterthought,
MySQL might suffice. But as soon as you learn to write any SQL beyond a
single-table select and simple joins, you’ll begin to sense the shortcomings of
MySQL. Since the first edition of this book, virtualization has resown the
landscape of commerical hosting, so having your own dedicated server is no
longer a luxury, but the norm. And when you have your own server, you’re free
to choose what you wish to have installed. PostgreSQL bodes well with the
popularity of cloud computing such as Platform as a service (PaaS) and
Database As a Service (DbaaS). Most of the major PaaS and DbaaS providers
offer PostgreSQL, notably Heroku, Engine Yard, Red Hat OpenShift, and
剩余450页未读，继续阅读
「已注销」
- 粉丝: 0
- 资源: 1
我的内容管理
展开
最新资源
- 最优条件下三次B样条小波边缘检测算子研究
- 深入解析：wav文件格式结构
- JIRA系统配置指南：代理与SSL设置
- 入门必备：电阻电容识别全解析
- U盘制作启动盘：详细教程解决无光驱装系统难题
- Eclipse快捷键大全：提升开发效率的必备秘籍
- C++ Primer Plus中文版：深入学习C++编程必备
- Eclipse常用快捷键汇总与操作指南
- JavaScript作用域解析与面向对象基础
- 软通动力Java笔试题解析
- 自定义标签配置与使用指南
- Android Intent深度解析：组件通信与广播机制
- 增强MyEclipse代码提示功能设置教程
- x86下VMware环境中Openwrt编译与LuCI集成指南
- S3C2440A嵌入式终端电源管理系统设计探讨
- Intel DTCP-IP技术在数字家庭中的内容保护
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
