00:21.49 | *** join/#wowroster Anax (n=Anaxent@ip68-2-193-89.ph.ph.cox.net) |
00:37.15 | *** join/#wowroster Chris__ (n=Anaxent@ip68-2-193-89.ph.ph.cox.net) |
04:02.31 | *** join/#wowroster Tupsi3472 (n=Miranda@pD95F8D72.dip0.t-ipconnect.de) |
06:39.37 | *** join/#wowroster vecnah (n=vecna@vecna.vecnix.net) |
07:35.18 | *** join/#wowroster Kaos (n=Kaos@vir78-1-82-230-45-137.fbx.proxad.net) |
07:45.17 | *** join/#wowroster Kaos_ (n=Kaos@vir78-1-82-230-45-137.fbx.proxad.net) |
08:07.11 | *** join/#wowroster vecnah (n=vecna@vecna.vecnix.net) |
08:09.13 | *** join/#wowroster vecnah (n=vecna@vecna.vecnix.net) |
08:12.17 | *** join/#wowroster Kaos (n=Kaos@vir78-1-82-230-45-137.fbx.proxad.net) |
08:13.01 | *** part/#wowroster Kaos (n=Kaos@vir78-1-82-230-45-137.fbx.proxad.net) |
08:18.21 | *** join/#wowroster Kaos (n=Kaos@vir78-1-82-230-45-137.fbx.proxad.net) |
08:46.01 | *** join/#wowroster Kaos (n=Kaos@vir78-1-82-230-45-137.fbx.proxad.net) |
13:55.06 | *** join/#wowroster Kaos (n=Kaos@vir78-1-82-230-45-137.fbx.proxad.net) |
13:55.37 | *** part/#wowroster Kaos (n=Kaos@vir78-1-82-230-45-137.fbx.proxad.net) |
14:50.40 | *** join/#wowroster Kaos_ (n=Kaos@vir78-1-82-230-45-137.fbx.proxad.net) |
21:06.39 | *** join/#wowroster Mathuin (n=Mathuin@c-71-204-174-84.hsd1.ca.comcast.net) |
21:07.49 | Mathuin | I just posted on the forums about Postgresql support. I noticed the docs said MySQL, but I was hoping someone had already ported the MySQL stuff to Postgresql. I've done almost all of that for phpRaider but I'd love to go back to being just a user again. :-) |
21:07.58 | Mathuin | Anyone here know of any Postgresql support for Roster? |
21:11.53 | Zanix | there is none |
21:12.07 | Mathuin | Okay, so I have to do it all myself if I want to use Roster. |
21:12.09 | Zanix | alot of the queries in roster are made with only mysql in mind |
21:12.34 | Mathuin | I'd use anything else if it was half as good and had pgsql support already. :-) |
21:13.44 | Zanix | I dont blame ya |
21:13.55 | Zanix | cant use mysql at all? |
21:14.07 | Mathuin | Nope. |
21:14.17 | Mathuin | Sysadmin has a religious thing about it. |
21:14.50 | Zanix | ah |
21:14.57 | Zanix | well |
21:15.15 | Zanix | I havent used pgsql so I dont know what it would take to convert it |
21:15.39 | Mathuin | phpRaider was one day's work to get almost all the way there. |
21:15.56 | Mathuin | MySQL's got different calls that are non-standard so I had to make some workarounds. |
21:16.35 | Zanix | indeed, and I know we use quite a few mysql specific queries |
21:16.58 | Zanix | are you looking to try to convert 1.7.3 or 2.0 beta? |
21:17.28 | Zanix | and if you have any questions about the current code, we can try to answer them for you |
21:18.44 | Mathuin | Is the 2.0 beta actually fully functioanl? |
21:19.05 | *** join/#wowroster Tupsi (n=Miranda@pD95F8D72.dip0.t-ipconnect.de) |
21:19.16 | Zanix | mostly |
21:19.30 | Zanix | lol, there are a few bugs, and there is some things that havent been implemented yet |
21:19.54 | Zanix | like character removal on guild updates, right now it just sets them guildless |
21:20.21 | Mathuin | I think I'll go with 1.7.3, in the idle hopes of being able to leverage the addons. |
21:20.35 | Mathuin | I imagine you guys can take the fixes and implement them on the new version over time as appropriate. |
21:21.20 | Zanix | yeah, we are planning on a re-write of Roster in the future |
21:21.36 | Zanix | and we will want to use more generic sql queries |
21:22.09 | Mathuin | If phpRaider had put all the MySQL crap in one file, and resisted the urge to play fast and loose, it would have been a lunch-hour project. |
21:22.20 | Mathuin | Check out how phpBB2 did it, they had the right idea. |
21:22.25 | Zanix | lol |
21:22.33 | Zanix | I havent looked at it |
21:22.59 | Mathuin | In phpRaider, character creation involves adding a line to the character table and adding a corresponding line to the attribute data table. |
21:23.00 | Zanix | well, I have a little |
21:23.34 | Mathuin | They use a mysql trick to get the character ID, whereas with pgsql I'll make a query to grab the number. Minimal speed impact, instantly clear to later programmers. |
21:24.25 | Mathuin | What phpBB2 did was to have general functions for queries, updates, and inserts which had database-specific implementations. If you're using postgres, set a flag. If you're using oracle, set a flag. :-) |
21:25.43 | Zanix | ah, so a query for each sql db |
21:26.36 | Mathuin | Right. pg_connect includes the database name, unlike mysql_connect. |
21:27.13 | Mathuin | So the generic connect function includes the database name, and the mysql implementation includes mysql_select_id. |
21:27.17 | Mathuin | err, select_db. |
21:27.21 | Mathuin | But you see what I mean. |
21:27.24 | Zanix | indeed |
21:27.43 | Zanix | roster 2.0 has the db layer separated from the update/upload code |
21:27.50 | Mathuin | Awesome. |
21:28.03 | Mathuin | How can I look at the 2.0 code? If it's already abstracted, I might want that instead. |
21:28.21 | Zanix | well, there is a download of the beta in the BETA files forum |
21:29.16 | Mathuin | Is there anonymous read-only svn access? |
21:30.22 | Zanix | not yet |
21:30.44 | Zanix | I want to make some changes before we open it |
21:31.45 | Mathuin | I really like svn. I actually have my addons and account settings in a svn repository, so I can use multiple desktops to play the damned game. |
21:32.04 | Zanix | nice |
21:32.56 | Mathuin | The next step is to set it up so my guild can all get the same addons, and have their account settings saved individually. |
21:33.10 | Mathuin | Every time they check in, a script can automatically upload their character profiler data. ;-) |
21:34.06 | Zanix | thats an interesting use of svn |
21:34.54 | Zanix | when I ran a site for a guild I used to be in, we used UniUploader and javaUniuploader along with UniAdmin |
21:35.09 | Mathuin | I've found that anything users have to do by hand is too much work. |
21:35.31 | Zanix | no kidding |
21:36.37 | Mathuin | So yeah, there's a bit of activation energy in the building -- install Python, svn, pysvn, and copy my script over -- but after that, it's click an icon and play a game. |
21:39.55 | Mathuin | You've got some of the abstracting stuff done already in lib/dbal, I might be able to provide a pgsql version of that if it'll help. |
21:40.07 | Mathuin | But install.php and a bunch of other files do still have some mysql-specific stuff. ;-) |
21:40.31 | Zanix | yeah, they sure do |
21:40.32 | Mathuin | I think I'll wait until 2.0 beta stabilizes and the svn repo gets anon read-only access. |
21:41.13 | Mathuin | That way I can post diffs. |
21:41.16 | Zanix | might be a good idea |
21:41.25 | Mathuin | it also lets me enjoy playing the game which is nice. :-) |
21:41.38 | Mathuin | It was nice meeting you, and I'll check in from time to time and see how things are going. |
21:42.06 | Zanix | nice to meet you as well, I hope we can get a final build of 2.0 out within a month |
21:42.24 | Zanix | with only 6 developers, things kinda go slowly |
21:42.38 | Zanix | and one of them is design only |
21:42.42 | Mathuin | For sure, especially when they've all got other commitments, like school for themselves or their kids. |
21:42.49 | Zanix | indeed |
21:42.56 | Zanix | all of use have full time jobs |
21:43.38 | Mathuin | RL >> hacking. |
21:43.55 | Zanix | for most people, the sane ones |
21:43.58 | Zanix | lol |
21:44.52 | Mathuin | Heh. See you around... |
22:52.40 | dreamss | someone talking! |
22:52.41 | dreamss | yes |
23:16.00 | *** join/#wowroster vecnah (n=vecna@vecna.vecnix.net) |
23:17.26 | Zanix | lol |