phpbddb-dev1

[phpBddb-dev1] db design

[Janis P. <jan...@on...>]

Hi!
That is true that it is hard to tell how the project will develop and what will be requested. But also I think that planning is very important because there are things that would become unavailable if we didn't took them in account while writing the client front-end. For example if we agree to do HTML parsing in the future we should design HTML so that it would be easily parsed.
I agree that most firewalls and etc. require special configuration to access server on any SQL port. If that could be possible solution it would save us a lot of time. :(
What I meant w parsing was that if we are using HTML as the data format we also need an HTML parser. It means a lot of string parsing but I agree that XML could be a possible solution. I just took a look at php manual and I think it has enough XML parsing already built in.
If it is this way it could become pear-to-pear network. (Just an idea) Main server could have a list of running clients and that's all. Clients would update their pear list from server and get XML from each other. This would cause more traffic than client-server solution but as it was mentioned before web servers are made for that.

Now back to the real world... :)
I took a look at CVS and I noticed *.inc files. I suggest that we could better use something like *_inc.php because *.inc files require special treatment. If no configuration is done to web server they are shown in plaintext. I have seen folks get hacked because of this.;)

I am kind of new to CVS. I have worked w different systems but CVS is something I want to learn. Does anyone knows a good place to start with?

Janis


--> http://www.one.lv - your number one mobile email service!

Re: [phpBddb-dev1] db design

[Brian <br...@br...>]

Hi,

i don`t want the same html page for end-user and parsing, so there`re will 
not occur any problem later on.
Best is, to use plain text to be parsed:

Here an example:
Server1 wants an information from Server2, lets say about new beer mats. 
What server1 knows is, when he queried server2 last time. So he will http 
request the document:

http://server2/data.php?command=showNewBeerMats&date=20020701

server2 answers with plain text:

PHPBDDB START
Foster||Australien Beer||345423.jpg||20020705||This is the comment|0
Anheuser||Import Beer||test.jpg||20020502||Here is the commen||Testserie
PHPBDDB END

If you know in which order information are provided you can fetch them to 
an array and insert them to your database at server1


>I agree that most firewalls and etc. require special configuration to 
>access server on any SQL port. If that could be possible solution it would 
>save us a lot of time. :(

You will need a dedicated server to do this, to access the database from a 
host other than localhost is not provided by most of the webhosters. I want 
a solution that nearly everybody can use.

>It means a lot of string parsing but I agree that XML could be a possible 
>solution. I just took a look at php manual and I think it has enough XML 
>parsing already built in.

XML or plain text files, we need to discuss this.

>If it is this way it could become pear-to-pear network. (Just an idea) 
>Main server could have a list of running clients and that's all. Clients 
>would update their pear list from server and get XML from each other. This 
>would cause more traffic than client-server solution but as it was 
>mentioned before web servers are made for that.

Yeah, but this could not be done with PHP only.


>I took a look at CVS and I noticed *.inc files. I suggest that we could 
>better use something like *_inc.php because *.inc files require special 
>treatment. If no configuration is done to web server they are shown in 
>plaintext. I have seen folks get hacked because of this.;)

You`re right, we will fix this with the code rewrite.


>I am kind of new to CVS. I have worked w different systems but CVS is 
>something I want to learn. Does anyone knows a good place to start with?

Well i hope you are using WinCVS or any other GUI. You will find some docs 
at SF Documentation,  or refer to the WinCVS Help Docs.
I think it is http://www.cvsgui.org .

Brian