0xDBE: A First Look
0xDBE is a new tool by JetBrains made to solve all our database management problems. Soon, we'll be able to leave Workbench behind and work without crashes!
Tag: mysql
Repository Design Pattern Demystified
Amit Gupta simplifies and explains the Repository Design Pattern on a Laravel backed example
Google’s BigQuery Provides Free Access to GDELT
Google BigQuery now hosts GDELT - the world's largest dataset on human history - and it's free to use.
Autogenerate CRUD Apps with Phreeze
Taylor Ren explains how you can use Phreeze to autogenerate CRUD applications for your already existing databases - often in already existing apps.
MySQL Management with Packaged Apps
Learn about ChromeMyAdmin - a packaged app that lets you manage your MySQL/MariaDB database directly from any instance of your Google Chrome browser
Database Versioning with DBV
Wern Ancheta explains what DBV is and how one can use it to version control a database
A Look at Valentina
Taylor Ren looks at a relatively new suite of DB tools - Valentina - and gives you his opinion on it.
A Client-Server Dart App From Scratch: Getting Started
An introduction to creating a client-server dart app: setting up the environment, making sure we have the latest SDK, and going over some Dart basics.
Getting Started with Laravel on Nitrous.io
Learn to deploy your first Laravel application on Nitrous.io - the cloud development environment
Cursors in MySQL Stored Procedures
Taylor Ren explains and demonstrates the use of Cursors in MySQL's Stored Procedures
Horizontal Scaling of PHP Apps, Part 2
Horizontal scaling of databases in PHP applications - the how and why of master-slave replication
Stored Procedures in MySQL and PHP
Revisit the long forgotten topic of Stored Procedures in MySQL and PHP
Unique Index and its Rationale
Learn about unique index and the way they can increase performance when built correctly
How to Use Unique Indexes in MySQL and Other Databases
Read How to Use Unique Indexes in MySQL and Other Databases and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.
PHP and MySQL on Windows Azure: Starting with Git
Learn how to create and deploy a PHP+MySQL app on Windows Azure
How to Explain Your SQL EXPLAIN Queries
Read How to Explain Your SQL EXPLAIN Queries and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.
We’re Putting the (MySQL) Band Back Together
Read We're Putting the (MySQL) Band Back Together and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.
MySQL Views
Richard will explain how to create MySQL view and how to use it in your application. Something to note is MySQL views are only available from version 5.
Database as a Service: MySQL in the Cloud
In this article, Jacco Blankenspoor wanted to give you an impression of what is available in Database-as-a-Service.
SitePoint Podcast #161: The Return of the Yank with Kevin Yank
Episode 161 of The SitePoint Podcast is now available! This week our regular interview host Louis Simoneau (@rssaddict) interviews long-term podcast host, Kevin Yank (@sentience).
What’s New in WordPress 3.3
Read What's New in WordPress 3.3 and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.
Creating Drill-down Analytics with FusionCharts, PHP, MySQL and JSON
Read Creating Drill-down Analytics with FusionCharts, PHP, MySQL and JSON and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.
How to Create Scheduled Events in MySQL
In the last of a three-part database series, this tutorial explains how to create scheduled events in MySQL which run automatically at during pre-defined intervals.
How to Create Triggers in MySQL
In the second of a three-part database series, this tutorial explains how to create triggers in MySQL which run automatically when records are added, changed or deleted.
How To Automate Your Database Using Triggers and Events
A short tutorial of two powerful database features: triggers and events. When should and shouldn't they be used?
Understanding JOINs in MySQL and Other Relational Databases
SQL JOINs are often misunderstood and one of the biggest causes of database optimization problems. This brief tutorial explains JOINs and their use in MySQL and other relational databases.
How To Synchronize Your PHP and MySQL Timezones
Handling dates in PHP and MySQL is difficult unless timezones match. This tutorial provides code which should help solve date/time problems in your application.
What’s New in WordPress 3.1?
Read What's New in WordPress 3.1? and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.
MySQL Transaction Gotchas & Good Parts
Read MySQL Transaction Gotchas & Good Parts and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.
What’s New in MySQL 5.5
Read What's New in MySQL 5.5 and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.