Core PHP Programming 3rd Ed.

n00854180t

I just bought this book yesterday, mostly as a reference. I noticed that in the Foreword PHPB is mentioned 😛! Anyway, looks like a pretty good book, nice and comprehensive. Has anyone used this book?

stolzyboy

Originally posted by n00854180t
I noticed that in the Foreword PHPB is mentioned 😛!

That's cuz we're the best...

Oh yeah, and cuz we're the best! 😃

n00854180t

LOL

stolzyboy

Originally posted by n00854180t
LOL

I think at one time, someone did an article about that book, but not sure, or at least someone was asked to do an article about that book...

n00854180t

Really?

Do you do any regular software dev Stolzy? C++ and the like?

stolzyboy

I did awhile back (2+ years), but the closest lately to low level programs is JAVA... I'm too busy with web related work at work to play with anything else...

n00854180t

After I finish my current project for work I am going to have to do some Win32 dev. I haven't really done that much Windows programming, I stuck mostly to small command line stuff and made text games 😛 If I can ever get a design document together I want to finally put together the Ogre Battle clone (esque) I have been wanting to for so long. I think doing the Win stuff should get me into the thick of it enough to start doing some of that stuff.

On a side note, do you know a good database system for Win32? The current database is in FoxPro and I don't want to deal with it. I already know MySQL and PgSQL, I don't want to have to learn a crappy MS database system (it's version 3.0 too 🙁 ). I don't know if PgSQL would be able to handle the volume of the data in our current db.

stolzyboy

What amounts of data are you looking at?

And what platform will this be, 2K, 2K SERVER, etc...?

n00854180t

Well it appears to be running on 98SE right now (OMFG that just kills me). If I had my way I would scrap the whole config and put it on Linux.

We have Win2k somewhere around here, although I am not sure if I want to use it. What is a good Win server (relatively speaking that is)? We can just buy the new version when the time comes.

stolzyboy

Windows 2000 Server is what we usually use, costs thousands though... The only reason I say to use that is cuz then you can run the MSSQL server... probably the best M$ db...

Other than that, not sure how stable postgre is on windows, but it and MySQL can handle loads of records... and certainly can handle anything that foxpro is running right now.

n00854180t

PgSQL is virtually non-existant on Windows. You have to install CygWin and install a c compiler to run the makefile etc. I got about 1/4 of the way and quit because it was cluttering the root of my drive up.

I think I could probably just go with MySQL but I have seen it used in Windows software, it just doesn't seem to perform that well. We have about 50000 customers in the database and about 40 products ( lot numbers variations for different countries etc). I am sure MySQL could handle it, but I don't know how well the software would perform trying to communicate with it.

jstarkey

Originally posted by n00854180t
I don't know if PgSQL would be able to handle the volume of the data in our current db.

I've used postgres on 13 million records and it did fine. It wasn't high traffic, but it was high load (creating topo maps on the fly using PHP/GD).

n00854180t

I would like to have a server OS (such as 2k server) but it is a relatively small business so spending 1000+ on the OS is not very good. I might be able to just stick it on Linux though (although it would be a headache for everyone but me LOL, as everyone in the company are Win users exclusively).

jstarkey

Originally posted by n00854180t
We have about 50000 customers in the database and about 40 products ( lot numbers variations for different countries etc).

50,000 records is pretty trivial for any decent DB.

You know, another option may be setting up a $500 machine for just a DB server, installing Linux and PgSQL for free.

stolzyboy

Originally posted by n00854180t
(although it would be a headache for everyone but me LOL, as everyone in the company are Win users exclusively).

well, then you'll just have to learn 'em the ways of OUR world

n00854180t

Originally posted by jstarkey
I've used postgres on 13 million records and it did fine. It wasn't high traffic, but it was high load (creating topo maps on the fly using PHP/GD).

That would be well enough, I think we have enough parts in the graveyard for another server (hehe the graveyard). I could probably slap together a server and put Linux on it, then just make the Win32 software and connect to the server. The only problem is how to migrate a crappy FoxPro db to PgSQL.

n00854180t

Originally posted by stolzyboy
well, then you'll just have to learn 'em the ways of OUR world

Hehe easier said than done really. Some of the people in the company think win98 is better than XP (Because it is too hard to setup no less LOL).

stolzyboy

Originally posted by n00854180t
The only problem is how to migrate a crappy FoxPro db to PgSQL.

give this a whirl, i've gotten it to work with mysql and it says it has PG support, so ya never know...

jstarkey

Originally posted by n00854180t
That would be well enough, I think we have enough parts in the graveyard for another server (hehe the graveyard).

Be sure that you don't skimp on the memory. The key is to not let the tables page to disk.

n00854180t

Hehe thanks for the link. I think the conversion process will probably be more of a headache than writing the software.