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! 😃

    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...

      Really?

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

        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...

          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.

            What amounts of data are you looking at?

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

              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.

                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.

                  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.

                    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).

                      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).

                        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.

                          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

                            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.

                              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).

                                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...

                                  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.

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

                                      Originally posted by n00854180t
                                      I think the conversion process will probably be more of a headache than writing the software.

                                      Not if the link i gave you works as flawlessly with PG as with MySQL.

                                      I converted 23 db's in under an hour once the initial setup was accomplished. That took about 2 hours to get it working the way I wanted it to.