PHP – Enable FileInfo in Windows

1. Add php_fileinfo.dll to the list of enabled extensions 

extension=php_fileinfo.dll

2. Download GNU file package for windows
get it from here: http://gnuwin32.sourceforge.net/downlinks/file-bin-zip.php

Extract the folder from the archive called shared\file which contains 4 magic files (magic, magic.mgc, magic.mime, magic.mime.mgc).

3. Place these 4 files in a known place

4. Add system enviroment variable MAGIC that points to the file called magic. For example if you placed magic files in folder called magic in c:\php that means that the propper path is c:\php\magic\magic

5. If you use IIS restart it and fileinfo is ready for use

5a. If you use apache you will have to restart operating system for the service to acknowledge MAGIC env. variable.

 

source:

http://php.net/manual/en/fileinfo.installation.php

MySQL – Add Read-Only User

CREATE USER ‘tester’@’%’ IDENTIFIED BY ‘password’;

GRANT SELECT ON database.* TO ‘tester’@’%’;

 

PostgreSQL – List Column Names

to get list of columns on certain table use this command:

select column_name, data_type  from INFORMATION_SCHEMA.COLUMNS where table_name = ‘table’;

PostgreSQL – Backup Table Only

for version >= 8.4.0:
pg_dump –column-inserts –data-only –table=<table> <database>

for version < 8.4.0:
pg_dump -D -t <table> <database>

 

source:

http://stackoverflow.com/questions/2857989/using-pg-dump-to-only-get-insert-statements-from-one-table-within-database

MySQL Describe in PostgreSQL

We usually use DESCRIBE command in MySQL to display table structure, in PostgreSQL we use this command:

SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = ‘table’;

 

source:

http://stackoverflow.com/questions/109325/postgresql-describe-table