Leandro lfluvisotto

## magento_sql_snippets.md

      
              1 file
            
          
              5 forks
            
          
              0 comments
            
          
              15 stars
            
          
                petemcw
                / magento_sql_snippets.md
            
            
              Created
              July 21, 2011 19:41
            
              
                Magento SQL Snippets
              
          
    Magento SQL Snippets

Clear Temporary Data Tables

TRUNCATE `log_customer`;
TRUNCATE `log_quote`;
TRUNCATE `log_summary`;
TRUNCATE `log_url`;
TRUNCATE `log_url_info`;

  
## php speed up tips.html
<html>
<body>
<p>Here are Webber’s points:</p>
<ul>
<li>If a method can be static, declare it static. Speed improvement is by a factor of 4.</li>
<li>echo is faster than print.(<em>* compare with list from phplens by John Lim</em>)</li>
<li>Use echo’s multiple parameters instead of string concatenation.</li>
<li>Set the maxvalue for your for-loops before and not in the loop.</li>
<li>Unset your variables to free memory, especially large arrays.</li>
<li>Avoid magic like __get, __set, __autoload</li>

## magento-clean.sql
USE magentositedb;

TRUNCATE `magento_dataflow_batch_export`;
TRUNCATE `magento_dataflow_batch_import`;
TRUNCATE `magento_log_customer`;
TRUNCATE `magento_log_quote`;
TRUNCATE `magento_log_summary`;
TRUNCATE `magento_log_summary_type`;
TRUNCATE `magento_log_url`;
TRUNCATE `magento_log_url_info`;

## 000-java-php-diff.md

      
              5 files
            
          
              0 forks
            
          
              1 comment
            
          
              11 stars
            
          
                cspray
                / 000-java-php-diff.md
            
            
              Last active
              July 5, 2023 12:29
            
              
                A list of differences I've noticed between PHP and Java.
              
          
    Java vs. PHP

As is pretty obvious by my blog, GitHub repos and my job I'm a PHP developer. I'm also pretty adept with JavaScript and SQL. Lately I've been getting back into Java development a little more seriously. This gist is a series of short articles about some of the differences I've noticed between PHP and Java.
To be specific my Java development recently has been web development using Google App Engine. I am intending to create a RESTful API utilizing the language.
The differences discussed are not intended to be an indictment against either language. Some things about PHP I really like, some things about PHP I really dislike. The same goes for Java. Some things PHP is really good for and other things Java is really good for. This is not meant to be a religious war between languages.
I realize that in a way this is comparing apples and oranges. PHP is a dynamic, interpreted (althought yes it is still compiled) scripting language while Jav

  
## strip-definer-comments.md

      
              1 file
            
          
              1 fork
            
          
              0 comments
            
          
              1 star
            
          
                davidalger
                / strip-definer-comments.md
            
            
              Last active
              July 22, 2020 15:56
            
              
                Strip DEFINER comments from mysqldump. Usage is to pipe mysqldump through this sed command.
              
          
    Stripping DEFINER from MySQL dumps with sed

LC_ALL=C sed -E 's/DEFINER[ ]*=[ ]*`[^`]+`@`[^`]+`/DEFINER=CURRENT_USER/g'
Typical Usage

pv /path/to/mysqldump.sql.gz \

  
## README.md

      
              3 files
            
          
              0 forks
            
          
              1 comment
            
          
              24 stars
            
          
                SchumacherFM
                / README.md
            
            
              Last active
              September 21, 2018 10:05
            
              
                Avoiding database deadlocks in Magento 1.7
              
          
    After having many deadlocks due to a high order volumne I've applied the these fixes to the core. Some can be found in a Magento forum. Before the fixes we could only process 1 order every 5-10 secs. Updating to Magento 1.8 is currently not an option but in 1-2 months.
1st Deadlock

Mage_Sales_Model_Abstract::_afterSave must be removed and replaced with afterCommitCallback. This is important to move the grid update (of sales_flat_order_grid) out of the transaction.
2nd Deadlock

Rewrite the method of the Mage_CatalogInventory_Model_Observer::reindexQuoteInventory() to remove the price reindexing from the transaction. That index process will also be fired in event sales_model_service_quote_submit_success.

  
## local.xml
<?xml version="1.0"?>
<!-- license -->
<config>
    <global>
        <!-- global config -->
    </global>
    <frontend>
        <events>
            <!-- disble logs -->
            <controller_action_predispatch>

## gist:ed4b9cba14652e7212f5
javascript

ES6ValidationInspection
JSAccessibilityCheckInspection
JSBitwiseOperatorUsageInspection
JSCheckFunctionSignaturesInspection
JSClosureCompilerSyntaxInspection
JSCommentMatchesSignatureInspection
JSComparisonWithNaNInspection
JSConsecutiveCommasInArrayLiteralInspection

## gcloud-port-forward.md

      
              1 file
            
          
              9 forks
            
          
              3 comments
            
          
              26 stars
            
          
                jibs
                / gcloud-port-forward.md
            
            
              Created
              April 25, 2015 15:57
            
              
                port forwarding with a google cloud instance
              
          
    Google cloud's ssh command lets you pass standard ssh flags.
To, for example, forward local port 8088 to port 8088 on a vm instance, all you need to do is:
gcloud compute  ssh --ssh-flag="-L 8088:localhost:8088"  --zone "us-central1-b" "example_instance_name"

Now browsing to localhost:8088 works as it would with standard ssh.

  
## .bash_profile
parse_git_branch() {
  git branch 2> /dev/null | sed -e '/^[^*]/d' -e 's/* \(.*\)/(\1)/'
}
PS1='${debian_chroot:+($debian_chroot)}\[\033[1;31m\]\u\[\033[1;37m\]@\[\033[1;32m\]\h\[\033[1;37m\]:\[\033[1;36m\]\w \[\033[1;35m\]$(parse_git_branch) \[\033[1;33m\]\$ \[\033[0m\]'
	<html>
	<body>
	<p>Here are Webber’s points:</p>
	<ul>
	<li>If a method can be static, declare it static. Speed improvement is by a factor of 4.</li>
	<li>echo is faster than print.(<em>* compare with list from phplens by John Lim</em>)</li>
	<li>Use echo’s multiple parameters instead of string concatenation.</li>
	<li>Set the maxvalue for your for-loops before and not in the loop.</li>
	<li>Unset your variables to free memory, especially large arrays.</li>
	<li>Avoid magic like __get, __set, __autoload</li>
	USE magentositedb;

	TRUNCATE `magento_dataflow_batch_export`;
	TRUNCATE `magento_dataflow_batch_import`;
	TRUNCATE `magento_log_customer`;
	TRUNCATE `magento_log_quote`;
	TRUNCATE `magento_log_summary`;
	TRUNCATE `magento_log_summary_type`;
	TRUNCATE `magento_log_url`;
	TRUNCATE `magento_log_url_info`;
	<?xml version="1.0"?>
	<!-- license -->
	<config>
	<global>
	<!-- global config -->
	</global>
	<frontend>
	<events>
	<!-- disble logs -->
	<controller_action_predispatch>
	javascript

	ES6ValidationInspection
	JSAccessibilityCheckInspection
	JSBitwiseOperatorUsageInspection
	JSCheckFunctionSignaturesInspection
	JSClosureCompilerSyntaxInspection
	JSCommentMatchesSignatureInspection
	JSComparisonWithNaNInspection
	JSConsecutiveCommasInArrayLiteralInspection
	parse_git_branch() {
	git branch 2> /dev/null \| sed -e '/^[^]/d' -e 's/ \(.*\)/(\1)/'
	}
	PS1='${debian_chroot:+($debian_chroot)}\[\033[1;31m\]\u\[\033[1;37m\]@\[\033[1;32m\]\h\[\033[1;37m\]:\[\033[1;36m\]\w \[\033[1;35m\]$(parse_git_branch) \[\033[1;33m\]\$ \[\033[0m\]'