In this half-hour talk, Tony Hede describes and compares a large number of databases, most of which are well known and widely used.
Category Archives: Databases
Bruce Momjian: Programming the SQL Way with Common Table Expressions
In this talk from Postgres Open 2013, Bruce Momjian introduces the idea of “Common Table Expressions” (aka “CTEs”), which allow you to accomplish a great deal of programming power within a single (if complex) SQL query. If you work with PostgreSQL, then you really should learn about CTEs, and this talk is one way to do it. Slides for this talk are at http://momjian.us/main/writings/pgsql/cte.pdf.
Ryan Neufeld: Web development with Clojure
Clojure is a modern Lisp that runs on the JVM. That’s nice, but not sufficient if you want to use Clojure to write Web applications. For that, you need a framework. In this O’Reilly Webinar, Ryan Neufield takes us through the basic steps necessary to create a Web application with Clojure.
Sam Madden’s “Column-Oriented Databases”
How is a column-oriented database different, and what advantages does it have over traditional, row-oriented databases?
Bruce Momjian’s “Inside PostgreSQL Shared Memory”
People are often surprised to find that PostgreSQL uses processes, rather than threads. This talk, by Bruce Momjian, describes how PostgreSQL’s processes share memory, and thus allow the database to operate efficiently despite its use of processes.