PyCharm Webinar: Why Postgres Should Be Your Document Database with Jim Fulton, March 20, 2017

jimfulton jimfulton Last update: Jun 29, 2021

PyCharm Webinar: Why Postgres Should Be Your Document Database

with Jim Fulton, March 20, 2017

In this webinar, we'll talk about why you might use PostgreSQL as your document database. We'll alsotalk about transactions, why they're important, and some commonpitfalls.

As an example, we'll look at implementing a two-tiered Kanban systemusing 3 approaches:

  • relational,
  • document oriented, and
  • object oriented.

All of the examples will use the Python programming language. We'll be using PyCharm to look at them.

You'll be able to follow along by looking at the databases usingdatabase connection information that I'll share at the time of theWebinar. (The PyCharm database toolmakes this especially easy.)

The first two examples are in directories in this repository:

rtasks
A (partial) relational implementation using Flask and SQL Alchemy.
jtasks
A (partial) document-oriented and relational implementation alsousing Flask and SQL Alchemy.

The third example looks a two-tiered kanban, which uses a hybridobject-oriented and document-oriented implementation. It uses bobo for it's web framework and Newt DB to provide the hybrid object-orienteddocument-oriented database on top of Postgres.

Links

PyCharm
https://www.jetbrains.com/pycharm/
PostgreSQL

https://www.postgresql.org/

PostgreSQL JSON types
https://www.postgresql.org/docs/current/static/datatype-json.html
PostgreSQL JSON functions and operators
https://www.postgresql.org/docs/current/static/functions-json.html
Full-text search
https://www.postgresql.org/docs/current/static/textsearch.html
Python
https://www.python.org/
SQL Alchemy object-relational mapper
https://www.sqlalchemy.org/
Newt DB, hybrid object-oriented and document-oriented database
http://www.newtdb.org
pq, a PostgreSQL-based transactional queuing system
https://github.com/malthe/pq/
pjpersist, an object-oriented interface to PostgreSQL.
https://github.com/Shoobx/pjpersist
Flask web framework
http://flask.pocoo.org/
Bobo web framework
http://bobo.readthedocs.io
Two-tiered Kanban
https://github.com/zc/twotieredkanban
Tags:

Subscribe to our newsletter