PostgreSQL subqueries allow one SQL query to run inside another, making it possible to solve filtering, aggregation, comparison, and table based problems without writing separate queries. The lesson ...

When you execute an SQL query, the results do not return quickly.You may have had no issues during development, but the ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Many of PostgreSQL’s recent changes, from scaling via sharding to adding JSON document-processing functions, have been inspired by NoSQL. The new PostgreSQL 9.5 continues in that vein, but doesn’t ...

Asynchronous I/O, OAuth authentication, expanded SQL standards support, and new extension capabilities give developers faster performance, stronger security, and greater flexibility. The PostgreSQL ...

Don't be afraid of using your chosen database's command-line client. I might as well say this up front: I don't like using GUI (aka non-command-line or graphical) tools with my databases. This is ...