PostgreSQL as a Schemaless Database

Description

PostgreSQL as a Schemaless Database. Christophe Pettus PostgreSQL Experts, Inc. PgDay FOSDEM 2013 Welcome! I’m Christophe.• PostgreSQL person since 1997.• Consultant with PostgreSQL Experts, Inc.• [e-mail]• thebuild.com• @xof on Twitter.• What’s on the menu? What is a schemaless database?• How can you use PostgreSQL to store • schemaless data? How does do the various schemaless • options perform? A note on NoSQL. Worst. Term. Ever.• It’s true that all modern schemaless • databases do not use SQL, but… Neither did Postgres before it became • PostgreSQL. (Remember QUEL?) The defining characteristic is the lack of a • fixed schema. Schematic. A schema is a fixed (although mutable • over time) definition of the data. Database to schema (unfortunate term) to • table to field/column/attribute. Individual fields can be optional (NULL).• Adding new columns requires a schema • change. Rock-n-Roll! Schemaless databases store “documents” • rather than rows. They have internal structure, but…• … that structure is per document.• No fields! No schemas! Make up whatever • you like! We are not amused. Culturally, very different from the glass • house data warehouse model. Grew out of the need for persistent object • storage… … and impatience with the (perceived) • limitations of relational databases and object-relational managers. Let us never speak of this again. There’s a lot to talk about in schemaless vs • traditional relational databases. But let’s not.

Sujets

• Informatique
• Marketing et communication

Informations

• Publié par: kyann
• Publié le: 04 juillet 2013
• Nombre de lectures: 158

Extrait

PostgreSQL
as a Schemaless Database.

Christophe Pettus
PostgreSQL Experts, Inc.
PgDay FOSDEM

2013

•
•
•
•
•
•

Welcome!

f xo Tonttwi.erC rhsiotIm’tgreSQL phe.Posecni991 sreps noanltwit C7.suon LxEerQSsogthtP cpetnc.s, Ipertoc.strepxegp@[e-mail]
sselameesabatadt haWch s aistsrg eoPt oSeLQw ca?Hou usn yo dows oeHrots es chemalesraoisus odt ehv options perform?

schemaless data?

•
•
•

What’s on the menu?

scn erodsslemahe . EvTermIt’ser. ehtt urllm taa esgref be or bitmace eeNtieh rid doPtssi citsiretcarah aofk ac lhe tng cefinihe dT•
•
•
•

A note on NoSQL.

Postgre
SQL
. (Remember QUEL?)

databases do not use SQL, but…

fixed schema.

st. Wor
tablh mue dexfi a guohtla( sAisa emch )ot unfortunate termesab ot ehcs( amtaDa.AdULL)l (Nionao tp neb sacefidll uaidivndISchematic.

over time) definition of the data.

•
•
•
•

change.

table to field/column/attribute.

am a s hesceq rreuiloc snmugnidwen
nts”aheveh yTctrustl naernt itaht ……tub ,erucSat dasabmahessleod“ emucs seerotre Rock-n-Roll!

rather than rows.

•
•
•
•

you like!

s rtcuuteri sepr document.No fisdleoN !hcs sameMa! ukewhp evat
rof deen eht fot ouw reGa dn… tbjecnt oistepers tnemorfid yreffy,ller vulCratuss the glaWe are not amused.

•
•
•

limitations of relational databases and
object-relational managers.

storage…

house data warehouse model.

he tpe (eircd)vepmi eita ecnhtiw
tuB in schelk about samelssv heTat ot tol a s’er tah nac uoyepxe?cttraditional relational databases.

schemaless data in PostgreSQL, how can
you?

Let us never speak of this
again.

•
•
•

•

And wot tnaw erots sonel’tdoya.tTopic’s t you: If
eg tti.•
•

What is schemaless data?

•
•

hierarchical structure of arrays and key-
value pairs.

one of these…

t if it doesn’t r/wo )si=(erocdrcument” Each “dorutc.denu nurtsot nea ms esesdomelaShc and how to reac …t ha etoecxpint acilnoitonk w sw appThe a
reJSONhsto.otdocument types:
•
XML
•
•

•

•

PostgreSQL has you
covered.

y’he gvehw et ta’teLes s tnooNid eerht tnereff tot ne,t bu, wo