Useful MySQL Commands

Below is a list of very common MySQL/MariaDB commands that any developer should know by heart. Export MySQL Database mysqldump -u username -p database_name > dump.sql Import MySQL Database mysql -u username -p -h servername database-name < data.sql Login MySQL Database mysql -uusername -p Create MySQL Users CREATE USER ‘username’@’localhost’ IDENTIFIED BY ‘password’; GRANT ALL PRIVILEGES ON database . tablename …

Useful MySQL Commands Read More »

Speaking at Laracon EU

I’m very excited to share that I will be speaking at Laracon EU 2021 from January 18th-22nd, 2021 and cannot wait to (virtually) see everyone at the event.  I will be discussing Choreography vs Orchestration in serverless microservices using Laravel. About Laracon EU Laracon EU hosts multiple annual conferences which are the main gathering of …

Speaking at Laracon EU Read More »

MongoDB Mac Cheat Sheet

Install MongoDB with brew. To start mongodb: brew services start mongodb To stop mongodb if it’s already running: brew services stop mongodb Tools Robomongo / Robo 3T MongoDB Compass Commands MongoDB Statistics – To get stats about MongoDB server, type the command db.stats() Currently selected database, use the command db Databases list, use the command …

MongoDB Mac Cheat Sheet Read More »

MySQL Best Practices

Database operations often tend to be the main bottleneck for most web applications today. As programmers need to do our part by structuring tables properly, writing optimized queries and better code. Table Names By convention, the “snake case” in lowercase (no PascalCase – we’re not using Microsoft SQL Server here!), plural name of the class will …

MySQL Best Practices Read More »

Welcome Laravel!

After much trial and error we’ve selected our future framework for all projects: Laravel! It has great documentation, a good community, lots of plugs and a steady update path. Plus it’s fun to code!