3 Must-Read Books About Database Performance

SQL Performance Explained: Everything Developers Need to Know about SQL Performance

An in-depth book on how to improve database performance. The focus is on relational databases and it covers all major SQL databases without getting lost in the details of any one specific product. Starting with the basics of indexing and the WHERE clause, SQL Performance Explained guides developers through all parts of an SQL statement and explains the pitfalls of object-relational mapping (ORM) tools like Hibernate.

PostgreSQL 9.0 High Performance

An excellent book for intermediate to advanced PostgreSQL database administrators (DBA). Teaches everything about building, monitoring and maintaining a PostgreSQL installation while also providing useful and interesting information about database internals. If you truly want to understand how PostgreSQL operates and behaves under a high load this is a book for you.

High Performance MySQL: Optimization, Backups, and Replication

Advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.

Favorite Relational Database

Last week we conducted a small research in the form of a poll: "What is your favorite RDBMS?". The poll received more responses than anticipated – a little bit over 900 votes were submitted. The topic in question can induce flame wars, but this time it passed without major incidents. There were several attempts to vote for MongoDB, which is not a relational database management system, so we had to remove it from results. MongoDB is often considered a contentious subject when speaking in context of relational databases. To put in redditor's day_cq sarcastic words:

"mongodb all the way. full web scale power. i think mongodb should be written in nodejs to take advantage of event driven nature of fast web scale loop. and gruntjs and lessc and uglifyjs adds full power to angulrjs real time web scale RDBMS."

If you don't see a chart below, please view it here: Favorite relational database management system. Full results are shared publicly and we would like to invite you to create your own representation of the data.



Thank you all for participating!

Update: Tyson Hollas has submitted a better representation of the data. See the chart below.

Poll: What is Your RDBMS of Choice?

We have created a new poll to learn your favorite relational database management systems.

Poll: What is Your RDBMS of Choice?

Voting ends on Friday and results will be published soon after that in Database Friends blog. Stay tuned!

PostgreSQL Maestro 13.7 released

SQL Maestro Group announces the release of PostgreSQL Maestro 13.7, a powerful Windows GUI solution for PostgreSQL database server administration and database development.


Top 10 new features:

1. Support for foreign data management objects.
2. Improved support for composite types.
3. Keyboard-interactive SSH authentication.
4. Enhanced SQL Dump wizard.
5. New Nullable Column Checker tool.
6. New Start Page with quick access to recently connected databases.
7. Advanced metadata filtering abilities.
8. Improved SQL Editor and Script Runner.
9. Highlighted key columns and multi-column lookup editors in the data grids.
10. Colored profiles in Database Explorer.

There are also some other useful things. Full press release is available at the SQL Maestro Group website.

Groupdate.sql - Better SQL group by date

Groupdate.sql provides the simplest way to group by:

• day
• week
• month
• day of the week
• hour of the day
• and more

Timezone support is included and you can use Groupdate functions with any programming language. Supported SQL DBMS: MySQL and PostgreSQL.

Groupdate.sql creates SQL functions, which are stored by the database. You can use these functions with any ORM (or without one).

Example query with Groupdate functions

Groupdate.sql project page