Re: [phpslash-users] abstracting DB calls
Brought to you by:
joestewart,
nhruby
From: e. p. <xe...@gr...> - 2000-10-05 19:04:25
|
On Wed, 4 Oct 2000, Ajay Sharma wrote: > A little history lesson, when 0.6 was started we were going to make our > id fields an MD5 hash thus, the varchar(32). But then we migrated over > to PHPLIB's next_id function which is much better. So recently (sept 17 > according to the CHANGES file) I updated the slash-all.sql file and > tried to replace all the varchar's with int's. > > So I might've missed some. okay... :) i wasn't paying attention. > > > can we clean the SQL structure up so that type conflicts don't crop > > up? this would bring phpslash-ft a step forward toward abstracting > > database calls. > > YES! I would like to see the structure be a more consistant, so if you > notice anything that doesn't look right, please bring it up on the list > so we can either explain it or correct it. I'm doing some printouts now so I can study them. will mess with the code on my box to see what attributes might need working on. > Plus, having the DB do all the datetime conversions is miles faster then > having the PHP script do it. Actually offloading as much work as > possible to the DB is what I'm trying to do. > > So the best solution (for now!) is to use that case statement for > separate DB's. In that case, I'm on the right track. Am doing case statements for DB specific handling. Can I suggest a global $db_type be included in config.php3 to handle DB specific issues? $db_type values would be "My", "Pg", "Or", "MS", "In" etc as they crop up. For the almost working prototype of phpslash-ft with PostgreSQL, check http://gra.ph/~xenos/phpslash. I've got the default db stuck in there so you can check what isn't working and what is working. -- eric pareja (xe...@gr...) <O> Here, have a clue. Get the picture. PGP key at http://gra.ph/~xenos/xenos.pusa.pgp <|PLUG|> http://gra.ph "Knowledge is inherently precious even if you can't sell it." - Dr. Greta Penninger in Bruce Sterling's "Distraction" |