Tux Machines

Databases: SQL Injections, PostgreSQL, and MySQL

Posted by Roy Schestowitz on Sep 06, 2023

=> Games: Strikes, Settlement, and Plenty on Steam Deck, SteamOS, GNU/Linux | Mozilla Leftovers (UPDATED)

Squirrel Strings

=> ↺ 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

=> ↺ 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

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

=> gemini.tuxmachines.org