Databases: SQL Injections, PostgreSQL, and MySQL
-
Squirrel Strings
The possibility for injection vulnerabilities is everywhere. Most famously SQL injections where string templating or concatenation is used to build SQL commands. It's still very easy to create one of these vulnerabilities because the APIs are perfect for injection.
-
PostgreSQL make install times revisited
We continue our exploration of PostgreSQL build system performance. A long time ago, I wrote an article about how to optimize the performance of make install. This was quite helpful, as it reduced the time from 10.493 s by default to 1.654 s with some tweaks (6x faster). Now, with different hardware, a much newer PostgreSQL, and a new build system looming, let’s take another look.
-
GROUP BY Statement in MySQL
In the realm of relational databases, data retrieval and manipulation form the crux of most operations. MySQL, one of the most popular open-source relational database management systems, offers a plethora of SQL statements and clauses to cater to these needs.