Advertisement

MySQL

Latest Posts
  • Code
    Security
    Best Practices When Working With Sensitive Data: Securing Your ApplicationSecure wide retina preview
    Last time we learned how to secure our server, this time we'll cover securing sensitive data from within our application itself. We'll discuss proper database security, password salting with examples, and user privileges. Let's begin!Read More…
  • Code
    Plugins
    Custom Database Tables: Maintaining the DatabaseCustomdbtables part4
    Over the lifetime of your custom table you will probably find that you need to make changes to what it stores, or how it stores it. This may be in response to a need to store more (or less) data. It may be that the initial design of your database wasn’t intended to deal (efficiently) with what your user-base is now demanding. Either way, we need to know how to adapt our table to meet our new needs. This is what we’ll be looking at in this tutorial, and we’ll primarily focused on the function dbDelta() that we first met in part one.Read More…
  • Code
    PHP
    PHP Database Access: Are You Doing It Correctly?Php pdo
    We've covered PHP's PDO API a couple of times here on Nettuts+, but, generally, those articles focused more on the theory, and less on the application. This article will fix that! To put it plainly, if you're still using PHP's old mysql API to connect to your databases, read on!Read More…
  • Code
    PHP
    PDO vs. MySQLi: Which Should You Use?Boxer
    When accessing a database in PHP, we have two choices: MySQLi and PDO. So what should you know before choosing one? The differences, database support, stability, and performance concerns will be outlined in this article.Read More…
  • Code
    PHP
    Turbocharge Your Website With Memcached200x200
    Your latest PHP/MySQL website is finally online. And it's awesome. But it's not as fast as you want it to be, because of the many SQL queries running every time a page is generated. And above that, you have the feeling it will not scale well under heavy loads. And you are most likely right. In this tutorial, we will see how you can greatly improve your website's responsiveness, and help it scale to handle many simultaneous visitors, by implementing a cache layer between your code and your database. The good news is it is fairly easy, and can be done in a few minutes!Read More…
  • Code
    Databases
    An Introduction to Stored Procedures in MySQL 5200x200
    MySQL 5 introduced a plethora of new features - stored procedures being one of the most significant. In this tutorial, we will focus on what they are, and how they can make your life easier.Read More…
  • Code
    Databases
    An Introduction to MySQL 5: Views200x200
    The MySQL 5 series introduced quite a few changes. Triggers and stored procedures were two of the big ticket items. One of the lesser known additions, at least from the amount of writing on the subject, is the introduction of views. While after a quick look at MySQL views, you might not see the obvious advantages, they're there if you dig into them just a bit.Read More…
  • Code
    Databases
    Quick Tip: A Fast Overview of Querious (MySQL Manager)200x200
    In today's video quick tip, we'll have a quick (not sponsored) overview of a Mac database manager for MySQL that I came across yesterday, called Querious. As I mention in the screencast, I particularly like this one, because it just works -- without being too complicated or overwhelming in the way that PHPMyAdmin might be for some. Read More…
  • Code
    Databases
    Introduction to MySQL Triggers200x200
    Chances are, you know what a database trigger is, at least in conceptual terms. Chances are even greater that you know that MySQL supports triggers and has supported them for quite some time. I would guess, even armed with this knowledge, that a good many of you are not taking advantage of triggers with MySQL. They're one of those things which should absolutely be in your development toolbox, as they can really change the way that you look at your data.Read More…
  • Code
    Databases
    Visual Database Creation with MySQL WorkbenchWorkbenchstart
    In today's tutorial, you'll learn how to use a visual database modeling utility to draw a database diagram and automatically generate SQL. Specifically, we'll review how to use MySQL Workbench, a cross-platform, visual database design tool.Read More…
  • Code
    PHP
    How to Create a PHP/MySQL Powered Forum from ScratchPreview
    In this tutorial, we're going to build a PHP/MySQL powered forum from scratch. This tutorial is perfect for getting used to basic PHP and database usage. Let's dive right in!Read More…
  • Code
    Web Development
    Create an In-Place Editing System: One Step Further200x200
    A few months ago, you learned how to create an in-place editing system. Today, we'll take things a step further as we create a simple backend, which will allow our website to remember the changes that we've made. Read More…
Advertisement
Advertisement