By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,361 Members | 1,677 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,361 IT Pros & Developers. It's quick & easy.

Is PhP/mySQL right for this project?

P: n/a
Note: This is different from previous post.

I am coming from a C/C++ background. I have a frontend (written in C#),
my backend was originally meant to be a J2EE application with
PostGreSQL. I am worried about support/maintenance issues going forward
since I no little J2EE (have some Java) - but am no longer able to rely
on the J2EE developer going forward.

I am now seriously considering using WAMP, but I am not yet terribly
convinced about inter-op issues between C# and PHP.

I also remain a bit sceptical about a possible lack of infrastructure
previously provided by the J2EE app server - i.e. scalability,
robustness, role based security etc. Are there any hard technical
documents I can refer to allay (at least) some of these fears?

I cannot seem to find any documentation referring to my type of setup -
i.e. a C# frontend and issuing requests (e.g. logon for user
authorization/verification etc). A search on Google is not bringing up
much. Any recommendation on books that will be helpful in instructing
how to build such a system (as well as mentioning any potential
pitfalls), will be very much appreciated.

MTIA

Dec 19 '05 #1
Share this Question
Share on Google+
15 Replies


P: n/a


Susan Baker wrote:
Note: This is different from previous post.

I am coming from a C/C++ background. I have a frontend (written in C#),
my backend was originally meant to be a J2EE application with
PostGreSQL. I am worried about support/maintenance issues going forward
since I no little J2EE (have some Java) - but am no longer able to rely
on the J2EE developer going forward.

I am now seriously considering using WAMP, but I am not yet terribly
convinced about inter-op issues between C# and PHP.

I also remain a bit sceptical about a possible lack of infrastructure
previously provided by the J2EE app server - i.e. scalability,
robustness, role based security etc. Are there any hard technical
documents I can refer to allay (at least) some of these fears?

I cannot seem to find any documentation referring to my type of setup -
i.e. a C# frontend and issuing requests (e.g. logon for user
authorization/verification etc). A search on Google is not bringing up
much. Any recommendation on books that will be helpful in instructing
how to build such a system (as well as mentioning any potential
pitfalls), will be very much appreciated.

MTIA

Hello ?!. Anybody reading this ?

Dec 19 '05 #2

P: n/a
Susan Baker wrote:
Hello ?!. Anybody reading this ?


Hi there. Yes I read your post ;)

There is one thing I did not understand in your description: what do you
mean by combining a C# frontend with a PHP or Java based backend? Could
you elaborate? Do you mean that both the frontend and backend are
accessing the same datebase? Or that you want to build a PHP-based web
application in addition to a fat/smart C# client?
Regards,
Horst

Dec 19 '05 #3

P: n/a


Horst Telliog(lu wrote:
Susan Baker wrote:

Hello ?!. Anybody reading this ?

Hi there. Yes I read your post ;)

There is one thing I did not understand in your description: what do you
mean by combining a C# frontend with a PHP or Java based backend? Could
you elaborate? Do you mean that both the frontend and backend are
accessing the same datebase? Or that you want to build a PHP-based web
application in addition to a fat/smart C# client?
Regards,
Horst


Hi Horst,

Thanks for replying. My (fat) frontend is written in C#. The
architecture is N-tier, with quite a fat (smart) frontend implemented
mostly in C#.

These are the functional requirements of the backend:

1). Handle request to logon from the frontend (requires backend to
authorize/verify user credentials)
2). Retrieve clientdata from backend database, encrypt this data and
return to front end (client)
3). Implement chatroom and forum server services for use by the frontend
(client)
4). Handle database requests (mostly running stored procedures) and
return results to the frontend (client).

This is what I need to do, and any help, pointers or book suggestions
will be very useful.

As an aside, I'm also considering moving from PostgreSQL to MySQL - but
Stored Procedures, Triggers and Views are only available in MySQL v 5.*.
How widespread is MySQL v 5.X implementations by ISPs is it really
production ready yet?

Look forward to your response.

Dec 19 '05 #4

P: n/a
Susan Baker wrote:
These are the functional requirements of the backend:

1). Handle request to logon from the frontend (requires backend to
authorize/verify user credentials)
2). Retrieve clientdata from backend database, encrypt this data and
return to front end (client)
3). Implement chatroom and forum server services for use by the frontend
(client)
4). Handle database requests (mostly running stored procedures) and
return results to the frontend (client).
What protocol is used for the fontend/backend communication? SOAP?
This is what I need to do, and any help, pointers or book suggestions
will be very useful.
Some books I found helpful are

"Better, Faster, Lighter Java" by Bruce Tate, ISBN: 0596006764
"Beyond Java" by Bruce Tate, ISBN: 0596100949
"Upgrading to PHP5" by Adam Trachtenberg, ISBN 0596006365
"PHP 5 Objects, Patterns, and Practice" by Matt Zandstra, ISBN: 1590593804
"Advanced PHP Programming" by George Schlossnagle, ISBN: B0009EK8A4

I am not sure if this is anywhere near what you are looking for ;)

I really like Java for my bigger projects with Hibernate as ORM-tool. I am
also very satisfied with PHP5. The only thing I really miss with PHP5 is a
good debugger which slows down development considerably.
As an aside, I'm also considering moving from PostgreSQL to MySQL - but
Stored Procedures, Triggers and Views are only available in MySQL v 5.*.
How widespread is MySQL v 5.X implementations by ISPs is it really
production ready yet?


Soory but I have no idea. The only thing I can say is that I used MySQL
versions 3.x and 4.x for years without any problem :)
Regards,
Horst

Dec 19 '05 #5

P: n/a


Horst Telliog(lu wrote:
Susan Baker wrote:

These are the functional requirements of the backend:

1). Handle request to logon from the frontend (requires backend to
authorize/verify user credentials)
2). Retrieve clientdata from backend database, encrypt this data and
return to front end (client)
3). Implement chatroom and forum server services for use by the frontend
(client)
4). Handle database requests (mostly running stored procedures) and
return results to the frontend (client).

What protocol is used for the fontend/backend communication? SOAP?


I don't know yet, I'm still finding out about PHP and what its capable
of doing. I would prefer not to use SOAP though because its too heavy/slow.

This is what I need to do, and any help, pointers or book suggestions
will be very useful.

Some books I found helpful are

"Better, Faster, Lighter Java" by Bruce Tate, ISBN: 0596006764
"Beyond Java" by Bruce Tate, ISBN: 0596100949
"Upgrading to PHP5" by Adam Trachtenberg, ISBN 0596006365
"PHP 5 Objects, Patterns, and Practice" by Matt Zandstra, ISBN: 1590593804
"Advanced PHP Programming" by George Schlossnagle, ISBN: B0009EK8A4

I am not sure if this is anywhere near what you are looking for ;)


Not really, ;-) - but thanks any way !

I really like Java for my bigger projects with Hibernate as ORM-tool. I am
also very satisfied with PHP5. The only thing I really miss with PHP5 is a
good debugger which slows down development considerably.
I had to move away from Java/J2EE because of support/maintainance
issues, for now I have scaled down the server side requirements so that
I can use PHP - however, it is still not clear to me, how o use a C#
frontend to communicate with PHP objects at the server side - this is
what I was trying to find out in my OP.
As an aside, I'm also considering moving from PostgreSQL to MySQL - but
Stored Procedures, Triggers and Views are only available in MySQL v 5.*.
How widespread is MySQL v 5.X implementations by ISPs is it really
production ready yet?

Soory but I have no idea. The only thing I can say is that I used MySQL
versions 3.x and 4.x for years without any problem :)
Regards,
Horst


Dec 19 '05 #6

P: n/a
On Mon, 19 Dec 2005 13:02:18 +0000, Susan Baker wrote:
-snip-
I really like Java for my bigger projects with Hibernate as ORM-tool.
I am also very satisfied with PHP5. The only thing I really miss with
PHP5 is a good debugger which slows down development considerably.

I had to move away from Java/J2EE because of support/maintainance
issues, for now I have scaled down the server side requirements so that
I can use PHP - however, it is still not clear to me, how o use a C#
frontend to communicate with PHP objects at the server side - this is
what I was trying to find out in my OP.


The same way you'd use C#, Java, Python, Perl or gazzillions of other
programming languages as middle tier layers. Web Services + SOAP

php has a whole suite of libraries already written for this type of
interoperation.

http://pear.php.net/package/SOAP

However as you are aleady using .net at the client end, why not write the
backend in C#?

Dec 19 '05 #7

P: n/a
Susan Baker wrote:
Thanks for replying. My (fat) frontend is written in C#. The
architecture is N-tier, with quite a fat (smart) frontend implemented
mostly in C#.
It'd be more helpful if you can be more specific. Words like
"front-end" and "back-end" don't really tell us much. Is your front-end
program a Windows application written in C#, or is an ASP.NET web
application?
These are the functional requirements of the backend:

1). Handle request to logon from the frontend (requires backend to
authorize/verify user credentials)
2). Retrieve clientdata from backend database, encrypt this data and
return to front end (client)
3). Implement chatroom and forum server services for use by the frontend
(client)
4). Handle database requests (mostly running stored procedures) and
return results to the frontend (client).


..Net can readily handle all of these tasks. I don't really see the
logic in trying to mate it with a different technology.

Dec 19 '05 #8

P: n/a


Chung Leong wrote:
Susan Baker wrote:
Thanks for replying. My (fat) frontend is written in C#. The
architecture is N-tier, with quite a fat (smart) frontend implemented
mostly in C#.

It'd be more helpful if you can be more specific. Words like
"front-end" and "back-end" don't really tell us much. Is your front-end
program a Windows application written in C#, or is an ASP.NET web
application?

Front end => Desktop GUI application
Written in C# (GUI and presentation logic)
This a standard exe written using WinForms

Backend
Functonal requirements specified below - what more do you need ?
These are the functional requirements of the backend:

1). Handle request to logon from the frontend (requires backend to
authorize/verify user credentials)
2). Retrieve clientdata from backend database, encrypt this data and
return to front end (client)
3). Implement chatroom and forum server services for use by the frontend
(client)
4). Handle database requests (mostly running stored procedures) and
return results to the frontend (client).

.Net can readily handle all of these tasks. I don't really see the
logic in trying to mate it with a different technology.


I know, but I don't want to get tied to proprietary technologies (i.e.
Microsoft). I was forced to switch the GUI (client application) from
SWING to C#, because Java simply could not "get its act together" in
terms of sheer performance on the desktop. I am moving from a J2EE
backend implementation because I cant maintain/support it personally
going forward - but I do not want to have to use IIS/ SQL Server and pay
$'000s in subscription fees - I am a small company and I simply cannot
afford that.
Dec 19 '05 #9

P: n/a


CJ Llewellyn wrote:
On Mon, 19 Dec 2005 13:02:18 +0000, Susan Baker wrote:
-snip-
I really like Java for my bigger projects with Hibernate as ORM-tool.
I am also very satisfied with PHP5. The only thing I really miss with
PHP5 is a good debugger which slows down development considerably.


I had to move away from Java/J2EE because of support/maintainance
issues, for now I have scaled down the server side requirements so that
I can use PHP - however, it is still not clear to me, how o use a C#
frontend to communicate with PHP objects at the server side - this is
what I was trying to find out in my OP.

The same way you'd use C#, Java, Python, Perl or gazzillions of other
programming languages as middle tier layers. Web Services + SOAP

php has a whole suite of libraries already written for this type of
interoperation.

http://pear.php.net/package/SOAP

However as you are aleady using .net at the client end, why not write the
backend in C#?

SOAP is too heavy (and thus WDSL/web services goes out the window too),
as I mentioned in a previous post. I want to use sockets (I was
expecting someone to suggest using HttpRequest class - or whatever) ...

It seems no one is even aware that this is possible...

Dec 19 '05 #10

P: n/a
On Mon, 19 Dec 2005 15:43:26 +0000, Susan Baker wrote:


CJ Llewellyn wrote:
On Mon, 19 Dec 2005 13:02:18 +0000, Susan Baker wrote: -snip-
I really like Java for my bigger projects with Hibernate as ORM-tool. I
am also very satisfied with PHP5. The only thing I really miss with
PHP5 is a good debugger which slows down development considerably.
I had to move away from Java/J2EE because of support/maintainance
issues, for now I have scaled down the server side requirements so that
I can use PHP - however, it is still not clear to me, how o use a C#
frontend to communicate with PHP objects at the server side - this is
what I was trying to find out in my OP.

The same way you'd use C#, Java, Python, Perl or gazzillions of other
programming languages as middle tier layers. Web Services + SOAP

php has a whole suite of libraries already written for this type of
interoperation.

http://pear.php.net/package/SOAP

However as you are aleady using .net at the client end, why not write
the backend in C#?

SOAP is too heavy (and thus WDSL/web services goes out the window too), as
I mentioned in a previous post. I want to use sockets (I was expecting
someone to suggest using HttpRequest class - or whatever) ...


Ask yourself what the advantage of trying to reinvent the wheel is? All
you'll achive is a greater understanding why standardised protocols are a
good thing(tm).

You can of cause use .net's http client and return XML records very much
the same way that RSS feeds/readers work.
It seems no one is even aware that this is possible...


Now we didn't say that, it's just not the PC approach.

Dec 19 '05 #11

P: n/a


CJ Llewellyn wrote:

<snip>


The same way you'd use C#, Java, Python, Perl or gazzillions of other
programming languages as middle tier layers. Web Services + SOAP

php has a whole suite of libraries already written for this type of
interoperation.

http://pear.php.net/package/SOAP

However as you are aleady using .net at the client end, why not write
the backend in C#?

SOAP is too heavy (and thus WDSL/web services goes out the window too), as
I mentioned in a previous post. I want to use sockets (I was expecting
someone to suggest using HttpRequest class - or whatever) ...

Ask yourself what the advantage of trying to reinvent the wheel is? All
you'll achive is a greater understanding why standardised protocols are a
good thing(tm).

</snip>

Um, speed. Its a well known and demonstrable fact that SOAP is a
monstrously "heavy" protocol and not really ideal for real time systems.
The benefits of being a standard are crippled by its outrageously
sluggish performance.
You can of cause use .net's http client and return XML records very much
the same way that RSS feeds/readers work.

No. NO XML PLEASE ...
It seems no one is even aware that this is possible...

Now we didn't say that, it's just not the PC approach.


Dec 19 '05 #12

P: n/a
Susan Baker wrote:
Front end => Desktop GUI application
Written in C# (GUI and presentation logic)
This a standard exe written using WinForms

Backend
Functonal requirements specified below - what more do you need ?


I see. Now it make sense. Personally I would have gone with .Net, since
Microsoft products have a way of working better together (and not
working with those from someone else), but as you stated, it's not an
option. Give the constraints, I don't see anything better than PHP +
MySQL.

Instead of adding a layer of abstraction (i.e. complicity) with a
technology like SOAP, I would just go plain-o HTTP. Just mimic what a
browser would do.

Dec 19 '05 #13

P: n/a


Chung Leong wrote:
Susan Baker wrote:
Front end => Desktop GUI application
Written in C# (GUI and presentation logic)
This a standard exe written using WinForms

Backend
Functonal requirements specified below - what more do you need ?

I see. Now it make sense. Personally I would have gone with .Net, since
Microsoft products have a way of working better together (and not
working with those from someone else), but as you stated, it's not an
option. Give the constraints, I don't see anything better than PHP +
MySQL.

Instead of adding a layer of abstraction (i.e. complicity) with a
technology like SOAP, I would just go plain-o HTTP. Just mimic what a
browser would do.


Thanks Chung,

BTW have you come accross any C# code that does this sort of thing?
(communicating with PHP). I believe the HttpRequest/Response class in C#
is the way to go - but still it would be nice to see some code .... Ah,
well ...

Sue

Dec 19 '05 #14

P: n/a
do messsage passing and everything yo need to intercomunicate with xml
and u can wotk with every lenguage u want

Dec 23 '05 #15

P: n/a
"pinguxx" <pi*****@gmail.com> wrote in news:1135375367.958908.240660
@g43g2000cwa.googlegroups.com:
and u can wotk with every lenguage u want


Does that include English?

Tim F

Dec 24 '05 #16

This discussion thread is closed

Replies have been disabled for this discussion.