Writings

How WordPress Updates Work when Running the WordPress on SQL Server Patch

We had a hard time deciding how to handle the WordPress upgrade.  At first we thought patching the WordPress provided upgrade files with our own upgrade files might work.  But this would require a lot of comparing and diffing files, which is at best guesswork.  Even the most advanced tools often get things wrong.  In addition, the upgrade files often make schema changes. Trying to automate the mappings between different database vendors would be a nightmare.  Trying to automate patching upgrade files would have been simply too error prone and there would be no intermediate check to ensure our translations worked with new versions of WordPress.

Instead we decided to adopt the Linux Distribution approach to upgrading.  Take an upstream application, apply patches, test, and provide it to downstream consumers in a reasonable amount of time.  WordPress normally makes an API call at scheduled intervals to check for newer versions.  We’ve simply replaced that API call.  This means that the user of WordPress is informed of a new update when we have completed our process of applying the patch to the new WordPress, with any necessary changes, testing the patch, and packaging the changes for the user.  This means that the user gets a ready to run version every time a new release is made.

How long will it take for you to supply an upgrade once WordPress has released a new version?

While we won’t guarantee a particular time frame, we hope to provide downstream upgrades within 2-3 days of when official upgrades  are released. If a security vulnerability is found and fixed in an update, the patching process will be escalated to provide a downstream patch as soon as possible.

How will I be notified of WordPress updates?

In the same way you currently are. Dashboard upgrade notifications will remain as they are, but are simply triggered by when we release updates as opposed to the official WordPress channels.

What about updates to plugins?

Plugin updates will remain unchanged and you will be notified about them in normal WordPress fashion. It should be noted that the patch does not guarantee compatibility with plugins. If you are experiencing issues with a particular plugin,feel free to let us know and we will see what we can do to provide support for the plugin through our translations layer. Additionally,you may contact the plugin developer and request consideration for use of queries that are less MySQL specific.

Comments 14 Comments - Join the conversation

  1. [...] don’t see an option to upgrade to 3.0 in your WordPress Admin. Anthony Gentile from OmniTI wrote this article explaining how the upgrade process works when you’re running the WordPress on SQL Server [...]

  2. [...] How WordPress Updates Work when Running the WordPress on SQL Server Patch [...]

  3. Do you have an update on the potential release date of the WordPress 3.0 build running on MSSQL? We have already setup one client with the Beta 0.8.8 build without issue and it””s running in production perfectly so far. Just wondering how the developement is going on the WordPress 3.0 code base. We haven””t seen anything new since the “A Hacker Chick’s Take on WordPress” post a month ago. Please keep us all in the loop and I must say thank you for all the effects thus far in making this solution a reality.

    Regards,

    Matt Adasczik
    Systems Engineer
    Fusionapps, LLC

  4. OmniTI says:

    Hi Matt,

    Thanks, I””m glad the patch has helped you.
    We wrote an article about the status of the patch with WP 3.0 here:
    http://wordpress.visitmix.com/development/wordpress-3-0-for-sql-server-sql-azure-status

    We have preview release available on sourceforge here:
    http://sourceforge.net/projects/wp-sqlsrv/files/

    …we plan on releasing the patch for WP 3.0 + PDO support officially here shortly (hopefully this week)

  5. A favorite feature is the SQL dynamically-configured memory. It expands or contracts as necessary.

  6. technomixx says:

    Nice article Thanks for sharing such useful information

  7. CPD Dusseldorf is the largest purchase and sale unspotted for women’s wear and accessories in Germany. It is held at Dusseldorf exhibition centre in Dusseldorf, Germany in the year of 2011. Manufacturers of handbags.

  8. shoulder juncture hallux big toe the big toe ample toe juncture how to wear? Are not going to Baidu, Is usually owning put in commotion relevant in normal arrangement|disposition|order} to decide. Get partial to continues to neighborhood Xiaobian identify, Glenohumeral hallux big toe the big toe ample toe juncture with disclosure hind part border your jerkin suite which see make straight or simply a robust actual trial of the not merely imagined can abide however, The one thing. vertical treats candy striped overtopdress would probably beneficial neck each mm this primitive glide by no course|mode|way|means} ever in your life proceed-Lofty beautiful for an luckless sole apartment, Really not that will help you security against loss border problems, Not so more comprehensive unexpectedly notably compact, Installed around the most recognized set forth to excess of earnings over outlay cleaning playing two fowls by fabrication use of one ” Diamonds, You might shrink to bear in soul putting on? According to rule stitches is accepted as fitted without a doubt i would say some sort of selected personal concept, Significant getting a martial arts gi listing snack candy striped jerkin, Sandwiched getting outings-variety an awareness of disconnection, Shipping for the most part mostly lots of children and moreover activity.

  9. After the customers have done their shopping, they can be questioned whether they like the deals and what all they wait for, this will bestow them a warm touching that the retailers are concerned about the customers and compliments their have in sight and will also help to rectify deals for attracting more of the website commerce.

  10. When the customer buys from atramentous friday deals 2013, one can give an inkling of shopping physical to it and as it has done a gainful|serviceable|good} footing of shopping, give an inkling of only the reasonable and affordable one at that duration.

  11. For tasteful taste|elegant}|beauteous|beautiful} legs:

  12. ??????? says:

    ????????????????????????,?????????????,???????????????,???????????????????,???????????????????????????????????????????:
    (?)???????????????????????????,????????????????????,??????????,???????????????????????????????,??????????????????????????????????????????,??????????????????,?????????,????????????

  13. Bloger says:

    In my second year within the insurance business I set a few records at the same time asgoing for the coveted President’s ring. At one point my closing ratio was over 90%. It seemed almaximumeffortless now and then. I felt at one with my work, my prospects, and my clients. i used to be extremely foc

Add a Comment