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 ...

When you execute an SQL query, the results do not return quickly.You may have had no issues during development, but the processing slowed down as soon as the data increased in the production ...

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 ...

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 ...

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