Database
![High-output Project Management in Notion](https://uploads.sitepoint.com/wp-content/uploads/2021/02/1612403383notion-800.jpg)
Learn how to architect, implement and maintain a minimalist setup for team-based Notion setups. We walk you through setting up primary tables and show you how to best leverage them using Notion's unique superpowers.
![An Introduction to MongoDB](https://uploads.sitepoint.com/wp-content/uploads/2018/05/1581897968mongodb.png)
Learn the basics of MongoDB, the Mongo shell, popular drivers, common database operations and CRUD actions within the Mongo shell.
![MySQL Performance Boosting with Indexes and Explain](https://uploads.sitepoint.com/wp-content/uploads/2017/12/1512348791mysql-performance.jpg)
Claudio Ribeiro shows how you can use explain and indexes to spot and remedy possible performance issues with your database before they strike.
![How to Optimize SQL Queries for Faster Sites](https://uploads.sitepoint.com/wp-content/uploads/2017/11/1510527235sql-optimization.jpg)
Iain Poulson provides a helpful guide to database query optimization, showing how to track down slow database queries and fix them up.
![How to Optimize MySQL: Indexes, Slow Queries, Configuration](https://uploads.sitepoint.com/wp-content/uploads/2017/10/1509294383superhero-534120_1280.jpg)
Here's a compendium of practical MySQL optimization tricks - from bottlenecks to configuration and indexes. Leave your ORM behind and get your hands dirty!
![Introducing the Neo4j Symfony Bundle](https://uploads.sitepoint.com/wp-content/uploads/2017/08/1501830608graph0.png)
Tobias introduces us to the Neo4j bundle for Symfony. Dive into the mysterious (and mysteriously efficient) world that is graph databases with this tool!
![Re-Introducing Eloquent’s Polymorphic Relationships](https://uploads.sitepoint.com/wp-content/uploads/2015/02/1423519219laravel-l-slant.png)
Christopher presents Eloquent's polymorphic relationships in a human-friendly way - come learn what they're all about and master this awesome ORM!
![How to Search on Securely Encrypted Database Fields](https://uploads.sitepoint.com/wp-content/uploads/2017/05/1495982600security.jpg)
Scott explains how we can have a secure, encrypted, and hack-proof database, but still use normal SELECT and search queries on it. Interesting stuff!
![How to Synchronize WordPress Live and Development Databases](https://uploads.sitepoint.com/wp-content/uploads/2014/11/1415473542Fotolia_42677898_Subscription_Monthly_M-Small.jpg)
Developing WordPress themes and plugins on a local server can be problematic if it doesn't match your live system. Craig discusses synchronization options.
In this "next level Laravel" post, Younes explains an interesting approach to designing relationships with Eloquent: polymorphic relations.
![Using GDELT 2 with PHP to Analyze the World!](https://uploads.sitepoint.com/wp-content/uploads/2016/11/1480581006World-map-geometric-pattern-Converted.png)
Patrick looks at an example use of GDELT - the world's database of events - and uses it to analyze some world trends with PHP and SQL. Check it out!
![Quick Tip: The Convenient Magic of Eloquent Observers](https://uploads.sitepoint.com/wp-content/uploads/2015/02/1423519219laravel-l-slant.png)
Younes presents Eloquent Observers - a method of subscribing to changed on models and having those models notify all subscribers of changes. Check it out!
![Beaver in Action: Practical MySQL Optimization](https://uploads.sitepoint.com/wp-content/uploads/2016/11/1478609888994_REpWIE1JRyAyMjktMTk-Converted.png)
Kirill demonstrates a practical example of optimizing a website's MySQL queries - check it out, it might come in handy in your optimization gigs!
![Extending OctoberCMS – Building a Soft-Delete Plugin](https://uploads.sitepoint.com/wp-content/uploads/2014/11/1416147902october.png)
Younes extends OctoberCMS by building a soft-delete plugin, allowing you to delete posts by marking them as trashed, while still keeping them in the DB!
![A First Look at Atlas – the ORM That Delivers](https://uploads.sitepoint.com/wp-content/uploads/2016/10/1476710131atlas-carry-globe-kneeling-ISO.png)
Claudio takes a look at Atlas - a new type of ORM that doesn't oversell. If you're dying for a breath of fresh ORM air, check it out!
![How to Create a Pokemon Spawn Locations Recorder with CouchDB](https://uploads.sitepoint.com/wp-content/uploads/2014/08/1408002114pokemon.jpg)
Wern Ancheta shows you how to build a Pokemon spawn location recorder app with CouchDB and the Slim Framework, wrapping it up in good security practices!
![A Pokemon Crash Course on CouchDB](https://uploads.sitepoint.com/wp-content/uploads/2016/08/1470860091couch.png)
Wern Ancheta takes us through a practical crash course into using CouchDB - CRUD, configuration, cooperation with PHP, and more!
![Quick Tip: Testing Symfony Apps with a Disposable Database](https://uploads.sitepoint.com/wp-content/uploads/2014/12/1418948033symfony-logo.png)
Andrew explains how to perform database-related tests in a Symfony app much faster - with a disposable in-memory SQLite database, avoiding any bulky mocks
![Laravel Doctrine – Best of Both Worlds?](https://uploads.sitepoint.com/wp-content/uploads/2016/06/1469264341laravel-doctrine-flow.png)
Francesco introduces Laravel Doctrine, and builds a sample app with it - come learn about this powerful ORM + Framework mix!
![Phinx – the Migration Library You Never Knew You Needed](https://uploads.sitepoint.com/wp-content/uploads/2016/05/1469376229phinx.jpg)
Bruno demonstrates the use of Phinx, a framework-agnostic database migration package helping you write database-independent and versionable database changes
Wern creates a movie recommendation app with PredictionIO - a free machine learning engine
Danny explains migrations in Drupal 8 and demonstrates them on a simple example, paving the way for more complex operations
Wern Ancheta builds a Hacker News reader with a local cache from nothing with the Lumen microframework!
Bruno goes through the entire process of contributing to an open source project - from contact with the author to sending PRs. Come see how it works!
Zack Wallace covers three SQL join approaches which can aid you in filtering your data. If you're an SQL newbie, this post will teach you valuable things!
MySQL 5.7 introduced some awkward changes for older codebases and tends to break apps. Here's how to temporarily (or permanently) lower the strictness level
Most PHP developers are used to using cURL to fetch data from a server However, there’s a better alternative: the Guzzle HTTP client.
Andrew Cairns explains the Aggregate pattern and implements it on top of Laravel's Eloquent. Feeling the pro thirst? Give this advanced tutorial a go!
In the continuing SQL vs NoSQL debate, Craig discusses example project scenarios to determine which type of database offers the most benefit.
Here's a look at Yahoo's MySQL performance analyzer - we go through its options, from graphs to alerts. It's getting ever easier to speed up your DBs!