SQL databases & phpwcms

Post non-phpwcms related topics here - but I don't want to see "hey check this or that other cms". Post if you have a point or worthwhile comment, don't post just to increase you post count!

how should i build the database for my mod

list option 1
4
80%
list option 2
0
No votes
list option 3
0
No votes
list option 4
1
20%
 
Total votes: 5

User avatar
pSouper
Posts: 1552
Joined: Tue 11. Nov 2003, 15:45
Location: London
Contact:

SQL databases & phpwcms

Post by pSouper »

I'm currently writting a mod for phpwcms (webstats: more info soon)
and would like to know is it preffered that I...
  • create 3 new tables within the phpwcms database, two of which only store INT totals?(faster for the server)
  • create 1 new table then analize the data to extract the infomation required (cleaner looking database tables)
  • use a new database all together?(some isp only allow limited db's per user)]
  • go home and get a real job?(easier for me).
feelX
Posts: 76
Joined: Wed 25. Feb 2004, 03:13
Location: 127.0.0.1
Contact:

Post by feelX »

no offence to you :) but you realy think you want spent that time ?

it gives good free stats like awstats

so why wcms should be blown up ?
felix - proud member of los locos

"Never argue with an idiot. They drag you down to their level, then beat you with experience."
frold
Posts: 2151
Joined: Tue 25. Nov 2003, 22:42

Post by frold »

feelX wrote:no offence to you :) but you realy think you want spent that time ?

it gives good free stats like awstats

so why wcms should be blown up ?
you can not run awstats on all servers it req. perl/cgi-bin if I remember right!
http://www.studmed.dk Portal for doctors and medical students in Denmark
Jérôme
Posts: 481
Joined: Tue 16. Mar 2004, 10:33
Location: Cologne, Germany
Contact:

Post by Jérôme »

I'd prefer the first option with several new tables. The db tables could still look clean, there would only exist more of them ;).

One strong thing that makes me think so is the fact, that there would be needed at least two tables: one that stores the stats-categories, and one that stores the values of the categories (e.g.: Browsers - IE|Mozilla|Safari|etc., Resolutions - 1600x1200|1280x1024|800x600|etc.)

I suppose this is the kind of stats you want to do?
User avatar
pSouper
Posts: 1552
Joined: Tue 11. Nov 2003, 15:45
Location: London
Contact:

Post by pSouper »

no offence to you but you realy think you want spent that time ?
After seeing the 'BIG FAT ZERO' on Frold's 'phpwcms most wanted' list I thought I would hate to let that many people down ;)

no actually I have looked over a few webstats scripts and thought this was easy enough for a first script, I have just got to learn this php/sql so it's more a learning thing for me, a webstat thing for you ;)
ionrock
Posts: 279
Joined: Fri 20. Feb 2004, 17:04

Post by ionrock »

you might want to consider doing something that uses flat files. I have always found that the file stuff is always more difficult than the database side of things and that way you could get a head start on regex!!! And we all love regex ;)

That way you could also write something from stratch which will allow you to learn more anyway than applying some script. Just my 2 cents . Good Luck and feel free to ask for help.

*** also, php.net is the best docs I have ever used and when they don't cover something I check out irc.freenode.net #php
User avatar
pSouper
Posts: 1552
Joined: Tue 11. Nov 2003, 15:45
Location: London
Contact:

Post by pSouper »

thanks IR, I have just installed the newly posted webstats as integrated by someone else so have already pulled the plug on my script.

flatfiles? is that reading and writting to a file in acsii &/or binary?
User avatar
pSouper
Posts: 1552
Joined: Tue 11. Nov 2003, 15:45
Location: London
Contact:

Post by pSouper »

thanks IR, I have just installed the newly posted webstats as integrated by someone 'cguenther' so have already pulled the plug on my script.

flatfiles? is that reading and writting to a file in acsii &/or binary?
feelX
Posts: 76
Joined: Wed 25. Feb 2004, 03:13
Location: 127.0.0.1
Contact:

Post by feelX »

hmm ... my tough is xml is better than flatfiles and more flexible and it has standarts...
felix - proud member of los locos

"Never argue with an idiot. They drag you down to their level, then beat you with experience."
User avatar
pSouper
Posts: 1552
Joined: Tue 11. Nov 2003, 15:45
Location: London
Contact:

Post by pSouper »

Assomeone who doesn't know any better, I hope it's all good advice ;)
I would hate to be starting at the top and work backwards.
ionrock
Posts: 279
Joined: Fri 20. Feb 2004, 17:04

Post by ionrock »

I agree with xml. You still need to know how to do the editing of the file and such so that would be a good of using flat files. You could mess with incorporting something like blogger since it uses atom feeds which are xml. It would also be pretty easy (maybe too easy actuall ;)). In any sense just go for it and have fun.
User avatar
pSouper
Posts: 1552
Joined: Tue 11. Nov 2003, 15:45
Location: London
Contact:

Post by pSouper »

:) thanks, i'll play a little next week.
for now i have to work :( & :)
frold
Posts: 2151
Joined: Tue 25. Nov 2003, 22:42

Post by frold »

Im just making this post, so pSouper didn´t have more posts then I have :D
http://www.studmed.dk Portal for doctors and medical students in Denmark
frold
Posts: 2151
Joined: Tue 25. Nov 2003, 22:42

Post by frold »

ups double post:

Im just making this post, so pSouper didn´t have more posts then I have :D
http://www.studmed.dk Portal for doctors and medical students in Denmark
User avatar
pSouper
Posts: 1552
Joined: Tue 11. Nov 2003, 15:45
Location: London
Contact:

Post by pSouper »

take it out of here dude !!
there are good deeds to be done in here.

and i just got one more ;)
Post Reply