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

PHP, Database, Security

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

PHP, Apache, Linux, mod_rewrite, Security

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

24 May 2006

Extracting META information from PostgreSQL (INFORMATION_SCHEMA)

PHP, Database, 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

PHP, PEAR, Database, Firebird SQL, Windows, PDO

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.

PHP, PEAR, Database, Firebird SQL, Windows

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

30 March 2006