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.
Tag: mysql
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
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.
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).
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.
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.
MySQL Transactions & Why They Can’t Be Emulated in PHP
Read MySQL Transactions & Why They Can't Be Emulated in PHP and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.
Top 10 MySQL Mistakes Made By PHP Developers
A database is a fundamental component for most web applications. Let's look at the top 10 MySQL mistakes made by PHP developers and how to avoid them.