PostgreSQL Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me

The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.

Go Back   Dev Shed ForumsDatabasesPostgreSQL Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old January 13th, 2002, 02:24 PM
torok torok is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Dec 2001
Location: Vancouver, Canada
Posts: 7 torok User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via ICQ to torok
Which client?

I'm in the early design stages of a program that will have the following features:
a) PostgreSQL database DBMS
b) graphical interface
c) invoice and order tracking
d) report printing / PDF generation
e) multiple concurrent users
f) Linux OR Windows server

The question is, how do I decide what client-side language to use? Java app across the network? PHP scripting/HTML? Java servlets?

Any suggestions?

Reply With Quote
  #2  
Old January 14th, 2002, 06:25 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 8th Plane (8500 - 8999 posts)
 
Join Date: Jun 2001
Location: Outside US
Posts: 8,527 pabloj User rank is Colonel (50000 - 60000 Reputation Level)pabloj User rank is Colonel (50000 - 60000 Reputation Level)pabloj User rank is Colonel (50000 - 60000 Reputation Level)pabloj User rank is Colonel (50000 - 60000 Reputation Level)pabloj User rank is Colonel (50000 - 60000 Reputation Level)pabloj User rank is Colonel (50000 - 60000 Reputation Level)pabloj User rank is Colonel (50000 - 60000 Reputation Level)pabloj User rank is Colonel (50000 - 60000 Reputation Level)pabloj User rank is Colonel (50000 - 60000 Reputation Level)pabloj User rank is Colonel (50000 - 60000 Reputation Level)pabloj User rank is Colonel (50000 - 60000 Reputation Level)pabloj User rank is Colonel (50000 - 60000 Reputation Level) 
Time spent in forums: 3 Months 1 Week 1 Day 3 h 19 m 49 sec
Reputation Power: 538
No client, just browser access to the application. I'd use php, it is excellent end easy, the problems will not come from the language, but from the app's design, I believe.

Reply With Quote
  #3  
Old January 22nd, 2002, 03:46 PM
rycamor rycamor is offline
Gödelian monster
Dev Shed Regular (2000 - 2499 posts)
 
Join Date: Jul 1999
Location: Central Florida, USA
Posts: 2,306 rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 3 Days 6 h 42 m 51 sec
Reputation Power: 60
You can't go wrong with either PHP or Java and a web-based approach, but be extremely careful about security.

If the development team is small, and work together, then PHP is a great choice. Java is sometimes a better choice for a large development team where there is a need for standardization, control, etc...

Mainly, choose what you are more confortable with. As pabloj says, the design of the database and the application is more important than the language used.

I recommend a couple good books:

"Database Design for Mere Mortals" (this gives you a great basic approach to databases in general) and "PostgreSQL Developers Handbook", which can be found at any decent online bookstore.

And, from experience, I will say that reporting is going to be your biggest headache, because there are very few report-building tools in open-source software. Allocate at least 30-40% your time for that alone.
__________________
The real n-tier system:

FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

Amazon wishlist -- rycamor (at) gmail.com

Reply With Quote
  #4  
Old March 18th, 2002, 09:39 PM
rycamor rycamor is offline
Gödelian monster
Dev Shed Regular (2000 - 2499 posts)
 
Join Date: Jul 1999
Location: Central Florida, USA
Posts: 2,306 rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 3 Days 6 h 42 m 51 sec
Reputation Power: 60
Let me add to my last comment, based on a little more experimentation: actually, complex reporting is not too much trouble if you enable ODBC and/or JDBC. Then, you can use pretty much any of the commercial reporting tools out there, such as Crystal Reports (ODBC), even Microsoft Access, or all kinds of Java reporting tools, which can connect to JDBC.

Also, there is an interesting open source reporting tool available at http://datavision.sourceforge.net/.

Don't spend too much time trying to do serious reporting with HTML, because it is a real pain to generate good printable output.

Reply With Quote
  #5  
Old March 18th, 2002, 09:51 PM
torok torok is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Dec 2001
Location: Vancouver, Canada
Posts: 7 torok User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via ICQ to torok
Hey, thanks very much for the extra comments, and the link! I've started a couple of projects now (and am starting to make a little cash from them), but unfortunately I've been using MSAccess.
I'd love to use Java and PostgreSQL, and started a preliminary design last week, but couldn't find an easy way to do reporting - this ought to help a great deal. The SQL is easy, the Java stuff isn't bad, but reporting was going to be a pain.

Thanks again!


Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesPostgreSQL Help > Which client?

Developer Shed Advertisers and Affiliates



Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

© 2003-2013 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap