diff options
| author | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-08-19 13:24:27 +0000 |
|---|---|---|
| committer | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-08-19 13:24:27 +0000 |
| commit | cefb812260f70ba7976723b175b632c24888b877 (patch) | |
| tree | dcb6d811160529d5b1a06d95cbc116065575bf2d /lib/ChangeLog | |
| parent | fda1595a68b3ee70222c81e8ee22b0232271f44d (diff) | |
Rewrote parts of DB.pm to use server-side prepared statements. I'm pretty sure this change will break something; excessive testing required.
Advantages:
- True server-side prepared statements (PgSQL didn't support them at the time I wrote the previous sqlprint)
- Proper support for the NULL value (just pass undef)
- Absolutely no room for SQL injection vulnerabilities (at least... when you don't use %s)
- Automatic type detection: no separate quoting functions for bool, integer or string data types
- Doesn't conflict with sprintf, you can call both without having to escape things
- !W and !H accept both hashrefs and arrayrefs, allowing multiple formats with different values
- !W and !H automatically add or omit the 'WHERE' and 'SET' clause where needed
Performance? I have absolutely no idea which method is faster.
git-svn-id: svn://vndb.org/vndb@98 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
Diffstat (limited to 'lib/ChangeLog')
| -rw-r--r-- | lib/ChangeLog | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/lib/ChangeLog b/lib/ChangeLog index 3d15c225..7b97bb63 100644 --- a/lib/ChangeLog +++ b/lib/ChangeLog @@ -13,6 +13,7 @@ TODO: - Fixed display of wrong ID in the screenshot diff - Fixed bug with the infinite thumbnail generation message when the server doesn't respond within one second. + - Rewrote VNDB::Util::DB::sqlprint to use server-side prepared statements 1.21 - 2008-08-16 (r90) - Added !vn and !uptime commands to Multi::IRC |