And it was awesome, opening the email box and read that a new version of Task Rocket is comming. @MikeOtt sent me a fresh version of Task Rocket 1.5.
Installation Updated and ready for use with a simple Theme change and the changes went smoothie like the application itself.
So, do you have an error on your web application and you can find it on error log?
There’s a way to log errors by the .htaccess file
php_flag log_errors on
php_value error_log /home/path/public/PHP_errors.log
Hi there! Using Zend Framework 2 With doctrine have been nice! But commands for update and validate schema are hard to keep it in mind! So on Root Dir:
Validate an Update:
./vendor/bin/doctrine-module orm:schema-tool:update –dump-sql
Apply an Update:
./vendor/bin/doctrine-module orm:schema-tool:update –force
Hope It helps some one!
Don’t forget to leave a comment!
So, the idea is to execute a query in MySQL but export the result to a CSV file.
MySQL gives you the statement INTO OUTFILE
Select * from table_name into outfile ‘/path/to/file.csv
Hope it helps.
Hi there! I just find out Task Rocket and I didn’t hesitate to try it!
Task Rocket is a simple front-end task management built on wordpress.
Using mysql, I saw a awesome feature for concurrency in web applications. The reality is, big information systems needs to sharing data so, database can be a problem sometimes.
Here’s the deal:
I want to read a database record or update him too, without the risk of another database call modify him. Here we can use for update statement.
You have a table that has for a primary key a int value (like a counter) and later update him:
– Start a Transaction
– build your select for the record
select * from table where key_value = ‘value_string’ for update;
–here you can include updare statement
update table ….. etc, etc etc
–just commit transaction to take effect and release table
— consider that other table calls will wait until you call commit statement
the concept is simple and is available on most of PHP frameworks (Zend Framework too)
Hope it helps.
leave a comment…