Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Postgres support  (Read 226 times) Bookmark and Share
DragonZX
Jr. Member
**
OS: Linux
Type: Owner dedicated server(s)
Gameservers: COD4
Posts: 13
Offline Offline
WWW
« on: September 10, 2011, 05:30:28 AM »
Please, help me to create PosgreSQL support for BB3. I do that for security reasons. I have a lot of sites on MySQL, and I need another SQL server for plugin connection... Also I want to create admin panel for this (searching db in 200000 strings is a very hard work for my CPU and my head).

Anybody help me!!!
Logged
Courgette
Senior Dev.
*
OS: Linux
Type: Home user
Posts: 3483
Offline Offline
WWW
Support Specialty: B3-Core, UrT/SmG/BFBC2 parsers, Plugin development
« Reply #1 on: September 10, 2011, 08:51:24 AM »
Hi, here's the roadmap for adding support for a new SGBD :

  • See the Storage class
  • Then see the DatabaseStorage class which inherits from the Storage class
  • Notice how the DatabaseStorage getConnection methods handles different SGBD
  • Now modify the getConnection method to add support for the postgresql protocol
  • adapt the sql scripts from the sql folder so that you get a script that is able to create tables for a PostgreSQL database
  • Validate all you work is working good by maintaining the automated tests for the B3 storage and make sure they pass when you run them
Logged
Follow me : @cucurb .~. new Smokin' guns official website
Tags:
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to:  


Rate this page +1 at Google Search


SimplePortal 2.3.1 © 2008-2009, SimplePortal