-
第一章、PostgreSQL安装
- 1.PostgreSQL 简介
- 2.安装 PostgreSQL
- 3.安装 pgAdmin 管理工具
- 1.NULL 相关
- 2.时间相关
- 3.UUID 相关
- 4.聚合相关
- 5.加密相关
- 6.正则相关
- 1.WITH 子句
- 2.递归查询
- 3.层级查询
- 4.应用示例-九九乘法表
- 1.普通处理
- 2.使用 ON CONFLICT
- 1.问题的提出
- 2.相关考虑
- 3.分表实例
- 4.结束语
- 1.四个场景
- 2.应用示例
- 1.窗口函数介绍
- 2.常用窗口函数
- 1.积分游戏说明
- 2.制作ERD图
- 3.生成模型、数据准备
- 4.实现函数
- 5.测试验证
- 6.交互应用
- 7.问题思考
- 1.附录一、从文本中匹配想要的
- 2.附录二、加权选择
- 3.附录三、关于时间戳
- 4.附录四、Web服务Python实践
PostgreSQL 最简实践
通过 本书，你将能够自信且快速建立你自己的数据库应用程序。
本书将以一种合理的方式带你畅享PostgreSQL美景。内容包含PostgreSQL应用中常涉及的知识要点，以及基于相关知识的项目实例。
每一句代码，都真实的正确运行过。
每一段代码，都给出了运行所需的数据准备。
愿你的每一分钟都收获满满。
The author is letting you choose the price you pay for this book!
通过本书，你将能够自信且快速建立你自己的数据库应用程序。
本书将以一种合理的方式带你畅享PostgreSQL美景。内容包含PostgreSQL应用中常涉及的知识要点，以及基于相关知识的项目实例。
每一句代码，都真实的正确运行过。
每一段代码，都给出了运行所需的数据准备。
愿你的每一分钟都收获满满。
PDF
About
About the Book
欢迎来到PostgreSQL最简实践。
强大的开源数据库，PostgreSQL无疑是最好的选择之一，之一也许可以去掉。
如今获取相关的参考知识已经变得很容易，我们需要的是直击应用要点。
通过本书，你将能够自信且快速建立你自己的数据库应用程序。
本书将以一种合理的方式带你畅享PostgreSQL美景。内容包含PostgreSQL应用中常涉及的知识要点，以及基于相关知识的项目实例。
每一句代码，都真实的正确运行过。
每一段代码，都给出了运行所需的数据准备。
愿你的每一分钟都收获满满。
Welcome to PostgreSQL minimalist practice.
A powerful open source database, PostgreSQL is undoubtedly one of the best options, and one may be able to get rid of it.
Nowadays, it has become easy to obtain relevant reference knowledge. What we need is to get straight to the application points.
With this book, you'll be able to build your own database applications confidently and quickly.
This book will take you to enjoy the beauty of PostgreSQL in a reasonable way. The content includes key points of knowledge often involved in PostgreSQL applications, as well as project examples based on related knowledge.
Every line of code has actually been run correctly.
Each piece of code provides the data preparation required for operation.
May every minute of your life be fruitful.
Price
Pick Your Price...
Minimum price
$9.00
$18.00
You pay
$18.00Author earns
$14.40Author
About the Author
triplestudio
Contents
Table of Contents
The Leanpub 60 Day 100% Happiness Guarantee
Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
Now, this is technically risky for us, since you'll have the book or course files either way. But we're so confident in our products and services, and in our authors and readers, that we're happy to offer a full money back guarantee for everything we sell.
You can only find out how good something is by trying it, and because of our 100% money back guarantee there's literally no risk to do so!
So, there's no reason not to click the Add to Cart button, is there?
See full terms...
Earn $8 on a $10 Purchase, and $16 on a $20 Purchase
We pay 80% royalties on purchases of $7.99 or more, and 80% royalties minus a 50 cent flat fee on purchases between $0.99 and $7.98. You earn $8 on a $10 sale, and $16 on a $20 sale. So, if we sell 5000 non-refunded copies of your book for $20, you'll earn $80,000.
(Yes, some authors have already earned much more than that on Leanpub.)
In fact, authors have earned over $14 million writing, publishing and selling on Leanpub.
Learn more about writing on Leanpub
Free Updates. DRM Free.
If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).
Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.
Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.
Learn more about Leanpub's ebook formats and where to read them
Write and Publish on Leanpub
You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!
Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.
Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.