PP05 - Datenbanken

<article class="post-detail"> <header> <h2 class="post-title"> <a href="https://python-podcast.de/show/datenbanken/">PP05 - Datenbanken</a> (click here to comment) </h2> <!-- link is on one line to avoid underlined whitespace --> <div class="post-card-meta"> <a href="https://python-podcast.de/show/datenbanken/"><time datetime="2019-02-25T01:00:00+01:00">25. Februar 2019</time>,</a> <span class="author">Jochen</span> </div> </header> <div class="post-body"> <section class="block-overview"> <section class="block-paragraph"> Wir haben uns diesmal zum Thema Datenbanken und Python zusammen gesetzt. Datenbanken sind ein weites Feld und daher ist diese Sendung auch ein bisschen l&auml;nger geworden.<br /> <br /> </section> <section class="block-audio"> </section> <section class="block-paragraph"> </section> </section> <section class="block-detail"> <section class="block-paragraph"> <h2>Shownotes</h2> Datenbanken <ul> <li><a href="https://www.postgresql.org/">Postgres</a></li> <li><a href="https://www.mysql.com/">MySQL</a>&nbsp;<a href="https://mariadb.org/">MariaDB</a></li> <li><a href="https://www.mongodb.com/">MongoDB</a></li> <li><a href="http://couchdb.apache.org/">CouchDB</a></li> <li><a href="https://dgraph.io/">Dgraph</a></li> <li><a href="https://neo4j.com/">Neo4j</a></li> <li><a href="https://redis.io/">Redis</a></li> <li><a href="https://www.influxdata.com/">InfluxDB</a></li> <li><a href="https://www.timescale.com/">TimescaleDB</a></li> <li><a href="http://lucene.apache.org/">Lucene</a>&nbsp;<a href="http://lucene.apache.org/solr/">Solr</a>&nbsp;<a href="https://www.elastic.co/">Elastichsearch</a></li> </ul> <h3>Python ORM</h3> <ul> <li><a href="https://docs.djangoproject.com/en/2.1/topics/db/">Django</a></li> <li><a href="https://www.sqlalchemy.org/">SQLAlchemy</a></li> <li><a href="https://ponyorm.org/">Pony</a></li> <li><a href="http://docs.peewee-orm.com/en/latest/">peewee</a></li> </ul> <h3>&quot;Big Data&quot;</h3> <ul> <li><a href="https://docs.ibis-project.org/">Ibis</a></li> <li><a href="https://arrow.apache.org/">Arrow</a></li> <li><a href="https://spark.apache.org/docs/latest/api/python/index.html">pyspark</a></li> </ul> <h3>Papers</h3> <ul> <li><a href="https://www.seas.upenn.edu/~zives/03f/cis550/codd.pdf">A Relational Model of Data for Large Shared Data Banks </a></li> <li><a href="http://db.csail.mit.edu/projects/cstore/vldb.pdf">C-Store: A Column-oriented DBMS</a></li> </ul> <h3>Picks</h3> <ul> <li><a href="https://www.sqlite.org/index.html">Sqlite</a></li> <li><a href="https://github.com/simonw/datasette/blob/master/README.md">Datasette</a></li> <li><a href="https://magic.io/blog/asyncpg-1m-rows-from-postgres-to-python/">Async binary driver for postgres</a></li> <li><a href="https://docs.python.org/3/library/pickle.html">Pickle</a></li> </ul> <h3>Quellen</h3> <ul> <li><a href="https://www.dataengineeringpodcast.com/data-serialization-with-doug-cutting-and-julien-le-dem-episode-8/">Data serialization formats</a></li> <li><a href="https://www.dataengineeringpodcast.com/postgresql-with-jonathan-katz-episode-42/">Taking a tour of postgres</a></li> <li><a href="https://www.youtube.com/watch?feature=share&amp;v=43DZEy_J694&amp;app=desktop">Everything is miscellaneous</a></li> <li><a href="https://tomaugspurger.github.io/method-chaining">Method Chaining</a></li> <li><a href="https://simonwillison.net/2017/Oct/5/django-postgresql-faceted-search/">Implementing faceted search with Django and PostgreSQL</a></li> <li><a href="http://philip.greenspun.com/wtr/data-warehousing.html">Data Warehousing for Cavemen</a></li> </ul> </section> </section> </div> </article>