Skip to Content
Python数据处理
book

Python数据处理

by Jacqueline Kazil, Katharine Jarmul
July 2017
Intermediate to advanced
398 pages
11h 54m
Chinese
Posts & Telecom Press
Content preview from Python数据处理
116
6
2. PostgreSQL
Python
如果你熟悉
PostgreSQL
(或正在学习
PostgreSQL
),想要使用
PostgreSQL
数据库,那么用
Python
连接
PostgreSQL
也是很容易的。你也只需要做两步:安装驱动程序,用
Python
连接。
Python
PostgreSQL
驱动程序有很多(
https://wiki.postgresql.org/wiki/Python
),但最流行
的是
Psycopg
http://initd.org/psycopg/
)。
Psycopg
的安装页面(
http://initd.org/psycopg/
docs/install.html
)中详细介绍了如何在电脑上运行
Psycopg
,在
PostgreSQL
网站上也有关于
Python
如何使用
Psycopg
的详细介绍(
https://wiki.postgresql.org/wiki/Psycopg2_Tutorial
)。
6.7.2
 非关系型数据库
NoSQL
比方说,你喜欢使用数据库这个主意,但映射出所有关系会让你抓狂。可能只是因为你目
前没有真正理解数据的连接方式,也可能是因为你用的是平面数据(
flat data
,也就是说,
不必良好映射的无关系数据),或者也可能是因为你对学习
SQL
没有更强烈的兴趣。幸运
的是,还有一种适合你的数据库。
NoSQL
以及其他非关系型数据库将数据保存成平面格式(
flat format
),通常是
JSON
式。我们在第
3
章中说过,
JSON
查找信息的方法很简单。回到上一节关于我朋友的数据, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

数据科学中的实用统计学(第2版)

数据科学中的实用统计学(第2版)

Peter Bruce, Andrew Bruce, Peter Gedeck
Java持续交付

Java持续交付

Daniel Bryant, Abraham Marín-Pérez
解密金融数据

解密金融数据

Justin Pauley

Publisher Resources

ISBN: 9787115459190