Thread: recommended programming language for postgresql
dear friends, may i know what is your recommended prgramming language that would create GUI and connects to postgresql. thanks for your advice. mon __________________________________ Do you Yahoo!? The all-new My Yahoo! - What will yours do? http://my.yahoo.com
Check out this thread: http://archives.postgresql.org/pgsql-general/2005-01/msg01178.php Also, you can use java, C, perl, python, PHP, and anything that can connect via ODBC, and that is only a start. A much more complete list is available here: http://www.postgresql.org/docs/interfaces What choice you make depends on what hardware/software/expertise you have available and what task you want to accomplish. For example, if you want a non-web-based product, that limits things to one class of solutions. If you want a web-based product, then there are other solutions. You will probably need to tell us a bit more about what you want to do if you want us to be more specific. Sean ----- Original Message ----- From: "Ramon Orticio" <rporticio@yahoo.com> To: <pgsql-novice@postgresql.org> Sent: Monday, January 24, 2005 9:03 PM Subject: [NOVICE] recommended programming language for postgresql > dear friends, > > may i know what is your recommended prgramming > language that would create GUI and connects to > postgresql. > > thanks for your advice. > > mon > > > > > __________________________________ > Do you Yahoo!? > The all-new My Yahoo! - What will yours do? > http://my.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
On Jan 24, 2005, at 9:03 PM, Ramon Orticio wrote: > dear friends, > > may i know what is your recommended prgramming > language that would create GUI and connects to > postgresql. If you have to ask, then you're probably a prime candidate for PHP. I prefer Perl, but it gives me features you might not need. -- Jason Dixon DixonGroup Consulting http://www.dixongroup.net
Hi Ramon, > may i know what is your recommended prgramming > language that would create GUI and connects to > postgresql. If you already know a GUI programming language and there is a way to access PostgreSQL from it, it is probably best if you stick with it. Otherwise I don't dare to suggest one, they all have their particular strengths and weaknesses. What kind of application you want to write? Cheers, Alex
On Mon, 2005-01-24 at 21:22 -0500, Jason Dixon wrote: > If you have to ask, then you're probably a prime candidate for PHP. I > prefer Perl, but it gives me features you might not need. > Wanna go into some detail here? Curious. :-) Cheers, -- Rodolfo J. Paiz <rpaiz@simpaticus.com>
On Jan 25, 2005, at 11:36 AM, Rodolfo J. Paiz wrote: > On Mon, 2005-01-24 at 21:22 -0500, Jason Dixon wrote: >> If you have to ask, then you're probably a prime candidate for PHP. I >> prefer Perl, but it gives me features you might not need. > > Wanna go into some detail here? Curious. :-) By the tone of Ramon's post, he hasn't done much programming. If web programming with a database is going to be the extent of his programming repertoire, then PHP is a good fit for him. However, I do a lot of other projects that stress complex data structures, regular expressions and the ability to craft my own OO frameworks (at times). These goals align themselves with the strengths of languages like Perl, Python and Ruby. That's not to say that you can't use PCRE with PHP, but the language has some limitations which bother me, in this order: 1) Security - a never-ending series of exploits and patches. From a sysadmin's perspective, it's a PITA. Rodolfo, I expect you know where I'm coming from. 2) No lexical scoping (namespaces within a block) 3) Promotes the interweaving of logic and presentation There are other things that will remain unmentioned as I could go on for hours. Needless to say, it's a sufficient language for many web developers. Unfortunately, it leaves me with a bad taste in my mouth. I'm not going to pretend that you can pick Perl up as quickly as PHP, but I can say that it will probably be worth the time investment. -- Jason Dixon DixonGroup Consulting http://www.dixongroup.net
PHP would be a good choice.. -----Original Message----- From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Ramon Orticio Sent: Monday, January 24, 2005 8:03 PM To: pgsql-novice@postgresql.org Subject: [NOVICE] recommended programming language for postgresql dear friends, may i know what is your recommended prgramming language that would create GUI and connects to postgresql. thanks for your advice. mon __________________________________ Do you Yahoo!? The all-new My Yahoo! - What will yours do? http://my.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
On Tue, 2005-01-25 at 10:36 -0600, Rodolfo J. Paiz wrote: > On Mon, 2005-01-24 at 21:22 -0500, Jason Dixon wrote: > > If you have to ask, then you're probably a prime candidate for PHP. I > > prefer Perl, but it gives me features you might not need. > > > > Wanna go into some detail here? Curious. :-) PerlTk? It might seem a bit odd, but I've used it to do DB stuff in a "desktop" app. Apart from that, I much prefer perls syntax than PHPs, and DBI in perl is just great. The Pear (PHP) DB abstraction layer also does a fair job of being DB agnostic, as DBI does in Perl. At the end of hte day, I don't think it really matters. Go with what you like. I'll use both PHP and Perl and will muck about with other languages (like java) when the mood strikes. -- Regards, Pete.