[ postgresql ] - - - (Win 2003)[quote] > [ MS SQL 200 ][/quote] We are adding a Windows server into our system that contains MS-SQL 2000 on it with another database to interact with. My question is to access both databases from the php server (freebsd), is it only a matter of compiling php with postgresql and mssql support in it or are there other things to consider? I know there are different function calls for each database type and even a PEAR interface that handles different databases with a common interface. I am just looking at my configurtion options/possibilities. Thanks in advance Mike [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => <80214b41.0311111113.3c342bf4@posting.google.com> [ref] => [htmlstate] => on_nl2br [postusername] => Mike [ip] => mikesta@hotmail [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 1 [islastshown] => [isfirstshown] => 1 [attachments] => [allattachments] => ) --> [ postgresql ] > - > - > - (Win 2003)[quote] > > [ MS SQL 200 ][/quote] > > >We are adding a Windows server into our system that contains MS-SQL >2000 on >it with another database to interact with. My question is to access >both databases from the php server (freebsd), is it only a matter of >compiling php with postgresql and mssql support in it or are there >other things to consider? I know there are different function calls >for each database type and even a PEAR interface that handles >different databases with a common interface. I am just looking at my >configurtion options/possibilities.[/quote] I don't think there is much of a problem other than smaller ones with each of the databases. I have Informix and MSSQL compiled as extensions here and it works fine. There is also a patch, which lets you write the microseconds into SQl server datetimes. I can send it to you on request. I think it has still not made it into PHP, I don't know why. Jochen [quote] > > > > > >Thanks in advance > >Mike[/quote] -- Jochen Daum - CANS Ltd. PHP DB Edit Toolkit -- PHP scripts for building database editing interfaces. [url]http://sourceforge.net/projects/phpdbedittk/[/url] [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => <80214b41.0311111113.3c342bf4@posting.google.com> [htmlstate] => on_nl2br [postusername] => Jochen Daum [ip] => jochen.daum@can [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 2 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> php and MS-SQL and PostgreSQL (with Apache) - PHP Development

php and MS-SQL and PostgreSQL (with Apache) - PHP Development

Hi, I have an architectural type question that centers around php. We have a website that people hit that uses php to dynamically generate web pages. We use Apache and php (although we don't have php compiled in with apache). Our Unix like server (FreeBSD) that has php (and Apache) on it that today communicates with the postgresql database on another Unix like server (Linux). I configured the php set of libraries with postgresql support in them. (Unix server) (Unix server) [Apache + PHP ] -----> [ postgresql ] - - - (Win 2003) > [ MS SQL 200 ] ...

  1. #1

    Default php and MS-SQL and PostgreSQL (with Apache)

    Hi,
    I have an architectural type question that centers around php.
    We have a website that people hit that uses php to dynamically
    generate
    web pages. We use Apache and php (although we don't have php compiled
    in with apache). Our Unix like server (FreeBSD) that has php (and
    Apache) on it that today communicates with the postgresql database on
    another Unix like server (Linux). I configured the php set of
    libraries with postgresql support in them.

    (Unix server) (Unix server)
    [Apache + PHP ] -----> [ postgresql ]
    -
    -
    - (Win 2003)
    > [ MS SQL 200 ]

    We are adding a Windows server into our system that contains MS-SQL
    2000 on
    it with another database to interact with. My question is to access
    both databases from the php server (freebsd), is it only a matter of
    compiling php with postgresql and mssql support in it or are there
    other things to consider? I know there are different function calls
    for each database type and even a PEAR interface that handles
    different databases with a common interface. I am just looking at my
    configurtion options/possibilities.





    Thanks in advance

    Mike
    Mike Guest

  2. #2

    Default Re: php and MS-SQL and PostgreSQL (with Apache)

    Hi Mike!

    On 11 Nov 2003 11:13:06 -0800, [email]mikestahotmail.com[/email] (Mike) wrote:
    >Hi,
    >I have an architectural type question that centers around php.
    >We have a website that people hit that uses php to dynamically
    >generate
    >web pages. We use Apache and php (although we don't have php compiled
    >in with apache). Our Unix like server (FreeBSD) that has php (and
    >Apache) on it that today communicates with the postgresql database on
    >another Unix like server (Linux). I configured the php set of
    >libraries with postgresql support in them.
    >
    > (Unix server) (Unix server)
    > [Apache + PHP ] -----> [ postgresql ]
    > -
    > -
    > - (Win 2003)
    > > [ MS SQL 200 ]
    >
    >
    >We are adding a Windows server into our system that contains MS-SQL
    >2000 on
    >it with another database to interact with. My question is to access
    >both databases from the php server (freebsd), is it only a matter of
    >compiling php with postgresql and mssql support in it or are there
    >other things to consider? I know there are different function calls
    >for each database type and even a PEAR interface that handles
    >different databases with a common interface. I am just looking at my
    >configurtion options/possibilities.
    I don't think there is much of a problem other than smaller ones with
    each of the databases.

    I have Informix and MSSQL compiled as extensions here and it works
    fine. There is also a patch, which lets you write the microseconds
    into SQl server datetimes. I can send it to you on request. I think it
    has still not made it into PHP, I don't know why.

    Jochen


    >
    >
    >
    >
    >
    >Thanks in advance
    >
    >Mike
    --
    Jochen Daum - CANS Ltd.
    PHP DB Edit Toolkit -- PHP scripts for building
    database editing interfaces.
    [url]http://sourceforge.net/projects/phpdbedittk/[/url]
    Jochen Daum Guest

  3. #3

    Default Re: php and MS-SQL and PostgreSQL (with Apache)

    Jochen Daum wrote:
    > fine. There is also a patch, which lets you write the microseconds
    > into SQl server datetimes. I can send it to you on request. I think it
    > has still not made it into PHP, I don't know why.
    >
    Hi Jochen, I wouldn't mind this patch. I use Oracle, PostegreSQL, MySQL,
    and MS-SQL at work and I wouldn't mind being able to keep everything in
    seconds/microseconds.

    Thanks!

    Terence Guest

  4. #4

    Default Re: php and MS-SQL and PostgreSQL (with Apache)

    Doesn't sound like there are too many issues on the face of it. My
    advice is to just do it. I still recomend the use of PEAR (or some other
    similar abstraction thing for which there are a few). While there will
    still be implementation differences, you can still potentially save
    yourself lots of work.

    I'm not sure what the performance comparrisons are between MSSQL and
    PostgreSQL, but I know I prefer working with Postgres -- it's much more
    powerful allowing you to choose a range of languages to use for stored
    procedures including C and perl. I also prefer sequences to MS's
    "identities". If it were up to me, I'd port the MS database to postgres
    :) But then you probably have other windows apps talking to it so you can't.

    My only real advice is to make sure you've tuned the postgres box, it
    makes a BIG difference to performance. I think this is simply a case of
    adjusting the buffer size it is allowed to use. By default, it is
    usually set too low. It all depends on how much that box can afford to
    give it without impacting on it's other processes. Of course then there
    are other issues like indexing and so forth.

    Terence Guest

  5. #5

    Post Re: php and MS-SQL and PostgreSQL (with Apache)

    Sir,

    I have a db in mssql server-2005. I want to convert that data from mssql to postgresql on windows-xp platform.

    First i have installed postgresql 9.1 on windows. The i installed apache2.2.22 and then trying to install the php. After installing the php the apache servert is not getting start. It is giving error as "The requested operation could not be started".

    I tried to search the reason in error-log of apache,php-error.log but failed to get the error.
    Where i am going wrong? what will be the reason for not getting stated the apache server ?

    Kindly help me in this regard
    Unregistered Guest

Similar Threads

  1. #39476 [NEW]: Apache 2.2.3/PHP 5.2.0/JpGrahp 2.1.3 crashed apache
    By digdug3 at zonnet dot nl in forum PHP Bugs
    Replies: 5
    Last Post: November 12th, 06:58 PM
  2. starting apache with mod_perl, error on Apache.pm
    By Selmar in forum PERL Modules
    Replies: 0
    Last Post: July 21st, 02:34 PM
  3. Replies: 0
    Last Post: August 4th, 05:44 PM
  4. Replies: 0
    Last Post: July 29th, 11:44 AM
  5. Replies: 2
    Last Post: July 27th, 05:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139