Logging is an important part of your PostgreSQL database monitoring suite, providing historical information for troubleshooting and forensic purposes: which user logged in when, what queries they ran and how long they took, when the database restarted.
Schemaless NoSQL database are a joy to use because they make it easy to iterate on your app, especially early on. And to be honest, the relational model isn’t always the best fit for real-world evolving and messy data. On the other hand, relational databases are proven, robust, and powerful. …
Learn how to run PostgreSQL in a virtualized environment like vSphere 4.1. This presentation covers what is different when the database is running in a Virtual Machine and its specific challenges.
If you’re a .NET developer, chances are you’ve worked solely with SQL Server, SQL CE, or SQLite in your day-to-day development. Some .NET developers venture over to the OSS side of things and might dabble in MySQL – but not many have embraced the amazing capabilities of PostgresSQL. This video …
This video discusses how to visualize PostgreSQL data with Google Web Toolkit (GWT). In addition to exploring what GWT is capable of, the presentation gives you a look at some chart tools, code and a live demo.
Stado provides a powerful and flexible analytical environment allowing users to process large amounts of data using a shared-nothing, massively parallel processing (MPP) architecture with PostgreSQL and PostGIS. Data is automatically partitioned across multiple nodes and each node processes its subset of data allowing queries to be distributed across the …
