• Register
    • Help

    striker  0 Items
    Currently Supporting
    • Home
    • News
    • Forum
    • Wiki
    • Support
      • Manage Subscriptions
      • FAQ
      • Support For
        • VaultWiki 4.x Series
        • VaultWiki.org Site
    • What's New?
    • Buy Now
    • Manual
    • 
    • Support
    • VaultWiki 4.x Series
    • Task
    • Database Abstraction

    1. Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

      VaultWiki allows your existing forum users to collaborate on creating and managing a site's content pages. VaultWiki is a fully-featured and fully-supported wiki solution for vBulletin and XenForo.

      The VaultWiki Team encourages you to join our community of forum administrators and check out VaultWiki for yourself.

    Issue: Database Abstraction

    • Issue Tools
      • View Changes
    1. issueid=1931 August 18, 2010 7:56 PM
      pegasus pegasus is offline
      VaultWiki Team
      Database Abstraction

      In order to support databases from multiple products, and possibly stand-alone, need to write a VaultWiki database system that constructs all queries and passes them to the correct database class and translates any differences in table/field names.
    Issue Details
    Issue Number 1931
    Issue Type Task
    Project VaultWiki 4.x Series
    Category General
    Status Completed
    Priority 6 - Dev-Related Tasks
    Target Version 4.0.0 Alpha 1
    Resolved Version 4.0.0 Alpha 1
    Milestone VaultWiki 4 Alpha 1
    Software DependencyAny
    License TypePaid
    Votes to perform 0
    Votes not to perform 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. August 19, 2010 3:56 PM
      pegasus pegasus is offline
      VaultWiki Team
      Rather than waste memory and speed making a schema translation system for different database types (MySQL, MSSQL, PostgreSQL, etc), instead we will just encapsulate queries in functions, test the database type and then load the appropriate queries file.

      Instead the wrapper will just allow field and table name translations between products and map database methods to the appropriate product's database class.

      That much is complete.
      Reply Reply  
    2. September 27, 2010 6:22 PM
      pegasus pegasus is offline
      VaultWiki Team
      Looks like IPB uses a similar method for a schema translation system to what I originally had in mind. In order to support IPB, we'll have to develop this after all, so I'm reopening the task for further work.
      Reply Reply  
    3. September 28, 2010 8:34 PM
      pegasus pegasus is offline
      VaultWiki Team
      Using IPB as a model, I was able to complete the main layer. IPB included some features we don't need, so we didn't add support for them. However, we needed to add support for the following which wasn't possible in default IPB:
      • Sub-queries
      • CASE -> WHEN -> THEN -> ELSE statements
      • Multi-table DELETE commands
      • consistent table/field escaping

      Still have to add support for db_alter, which is weak in IPB compared to vBulletin (no automatic error checking).
      Reply Reply  
    4. September 29, 2010 11:39 AM
      pegasus pegasus is offline
      VaultWiki Team
      DB_alter support added; database abstraction layer complete. Ported and partially rewrote vBulletin's db_alter class to also add support for some things it was missing:
      • ADD/DROP PRIMARY KEY
      • CREATE/DROP TABLE
      • CHANGE COLUMN
      Reply Reply  
    + Reply

    Assigned Users
    Loading Please Wait
    Tags
    Loading Please Wait
    • Contact Us
    • License Agreement
    • Privacy
    • Terms
    • Top
    All times are GMT -4. The time now is 7:29 AM.
    This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Learn more… Accept Remind me later
  • striker
    Powered by vBulletin® Version 4.2.5 Beta 2
    Copyright © 2023 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
    Copyright © 2008 - 2013 VaultWiki Team, Cracked Egg Studios, LLC.