Thursday, November 30, 2017

Build a desktop application with Electron

Magento 2 local setup - Version 2


it seems the following docker image works better for magento 2 local development


To Clean up docker image, volume, etc (Optional)


# docker system prune

# stop all containers:
# docker kill $(docker ps -q)

# remove all containers
# docker rm $(docker ps -a -q)

# remove all docker images
# docker rmi $(docker images -q)

# remove all volumes
#docker volume rm $(docker volume ls -f dangling=true -q)



  • git clone https://github.com/markoshust/magento2-docker.git
  • cd magento2-docker
  • docker-compose run --rm setup

after this command the DB setup would have completed and will have just the DB Image



  • Un comment docker-compose.override
  • mv docker-compose.override.yml.dist docker-compose.override.yml
  • docker-compose up -d app

This will create another 2 docker container, so we should have 3 containers running.



  • cp CONTAINER ID:/var/www/html ./ .      ( this is the container id of magento2docker_phpfpm_1)
  • http://m2.localhost:8000/index.php
  • Admin : http://m2.localhost:8000/index.php/admin_16wb2m/










Sample HelloWorld Module


Follow the steps in 











Connecting to Database












Wednesday, November 29, 2017

Aws Mobile Analytics


Dabbling on Aws Mobile Analytics





Monday, November 27, 2017

Course :MAGENTO 2 TESTING AND OPTIMIZATION

Course Mastering Magento2

Magento 2



https://www.udemy.com/mastering-magento-2/



https://u.magento.com/fundamentals-of-magento-2-development#.WhbBqrT81-U


http://mageclass.com/screencast-a-gentle-introduction-to-magento-2-for-magento-1-developers/

https://www.magestore.com/magento-2-tutorial/


https://www.thedash.com/



Install Docker

https://docs.docker.com/docker-for-mac/install/




11/25

https://github.com/clean-docker/Magento2 (This works)

https://rafaelstz.github.io/magento2/Install-Magento2-Docker-Development.html




Other Good Images

https://github.com/fballiano/docker-magento2


Magento Data Volumes

https://github.com/mageinferno/magento2-docker-compose


https://github.com/loganstellway/magento2-docker-swarm



Tutorials

http://mageclass.com/screencast-a-gentle-introduction-to-magento-2-for-magento-1-developers/
https://alankent.me/category/magento/
https://www.youtube.com/watch?v=tRmraOgVWtk

https://firebearstudio.com/blog/the-ultimate-magento-2-tutorial.html


Books


https://www.safaribooksonline.com/library/view/magento-2-development/9781785289897/
https://www.safaribooksonline.com/library/view/mastering-magento-2/9781785882364/
https://www.safaribooksonline.com/library/view/learning-magento-2/9781783288250/
https://www.safaribooksonline.com/library/view/magento-2-cookbook/9781785887062/



Video Tutorials

https://u.magento.com/fundamentals-of-magento-2-development#.WiLIG7Q-d24
https://www.safaribooksonline.com/library/view/magento-2-testing/9781787282308/
https://firebearstudio.com/blog/magento-2-video-tutorials.html




Build & Release



Less Vs Saas

https://github.com/SnowdogApps/magento2-frontools


Tech Stack


  1. Varnish
  2. Redis
  3. Elastic Search
  4. Gulp
  5. Docker
  6. How to upgrade new version of Magento.
  7. Composer how does it work for custom Module.
  8. Php Storm
  9. Testing
  10. Code Migration
  11. Database Migration
  12. 50% traffic is on mobile , how to optimize for mobile







Saturday, November 25, 2017

Magento 2 Local Setup






1. Create an account in Magento connect and have Public and private Key






2. Install Docker Edge Channel







3.  Once Docker Installed Execute this command

    git clone https://github.com/clean-docker/Magento2.git m2-docker &&
cd m2-docker && docker-compose up -d ;


Reference : https://rafaelstz.github.io/magento2/Install-Magento2-Docker-Development.html





4. Log Into docker Image


  docker exec -ti m2docker_apache_1 bash


5. Install Magento

composer create-project --repository-url=https://repo.magento.com/ magento/project-community-edition magento2


6. Get Mysql Ip

  docker inspect m2docker_db_1 | grep IPAddress


7. Start the setup of Magento2

















8. Docker Tips
    
      The first time installation might not work right if so if you wanted to clean up docker use these handy commands


# stop all containers:
# docker kill $(docker ps -q)

# remove all containers
# docker rm $(docker ps -a -q)

# remove all docker images
# docker rmi $(docker images -q)

9. How to setup Php Storm and edit the files in the container
        ToDo: Need to research how to setup docker volumes so that files can be shared and edited.         
10.   Links
           http://localhost:8080/
           http://localhost/
           http://localhost:8025/#
           http://localhost/magento2/
           http://localhost/magento2/admin_6p1kqi/

11.How the edit the magento2 files

         under the directory there is a mapping folder src

             m2-docker/src/magento2




ToDo:


   these Steps can be further simplified  with just one command docker-compose up;







Sunday, November 5, 2017

webassembly








Saturday, September 30, 2017

Monday, August 21, 2017

SQL Server



SQL Server:


Number of tables and sizes (Credit : stack overflow)

SELECT
    t.NAME AS TableName,
    s.Name AS SchemaName,
    p.rows AS RowCounts,
    SUM(a.total_pages) * 8 AS TotalSpaceKB,
    CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB,
    SUM(a.used_pages) * 8 AS UsedSpaceKB,
    CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS UsedSpaceMB,
    (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB,
    CAST(ROUND(((SUM(a.total_pages) - SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36, 2)) AS UnusedSpaceMB
FROM
    sys.tables t
INNER JOIN  
    sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN
    sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN
    sys.allocation_units a ON p.partition_id = a.container_id
LEFT OUTER JOIN
    sys.schemas s ON t.schema_id = s.schema_id
WHERE
    t.NAME NOT LIKE 'dt%'
    AND t.is_ms_shipped = 0
    AND i.OBJECT_ID > 255
GROUP BY
    t.Name, s.Name, p.Rows
ORDER BY
    t.Name


Size of Index


SELECT
    i.[name] AS IndexName,
    t.[name] AS TableName,
    SUM(s.[used_page_count]) * 8 AS IndexSizeKB
FROM sys.dm_db_partition_stats AS s
INNER JOIN sys.indexes AS i ON s.[object_id] = i.[object_id]
    AND s.[index_id] = i.[index_id]
INNER JOIN sys.tables t ON t.OBJECT_ID = i.object_id
GROUP BY i.[name], t.[name]
ORDER BY i.[name], t.[name]