Lorenzo Alberton

London, UK   ·   Contact me   ·  

Articles


Filter articles by topic

AJAX, Apache, Book Review, Charset, Cheat Sheet, Data structures, Database, Firebird SQL, Hadoop, Imagick, INFORMATION_SCHEMA, JavaScript, Kafka, Linux, Message Queues, mod_rewrite, Monitoring, MySQL, NoSQL, Oracle, PDO, PEAR, Performance, PHP, PostgreSQL, Profiling, Scalability, Security, SPL, SQL Server, SQLite, Testing, Tutorial, TYPO3, Windows, Zend Framework

Read-only db access to prevent SQL injection attacks

An idea for safer db applications: use read-only db access wherever possible. Use GRANT to create an user with read-only rights, and use it to prevent SQL injection attacks.   Read article

6 June 2006

Secure PHP installation on unix/linux systems

Simple guide to a more secure PHP installation on unix/linux systems.   Read article

24 May 2006

Extracting META information from PostgreSQL (INFORMATION_SCHEMA)

Extracting META information from a PostgreSQL database using the INFORMATION_SCHEMA views and the system catalogs (pg_class, pg_user, pg_view)   Read article

8 May 2006

PHP PDO_Firebird status

A quick roundup of the PHP PDO_Firebird driver. Test of its current status: what works and what doesn't.   Read article

11 April 2006

HowTo: Install Firebird/Interbase with PHP on Windows. A step-by-step tutorial.

A step-by-step tutorial to install Firebird SQL on Windows and enabling its usage in PHP.   Read article

30 March 2006