From owner-freebsd-questions@FreeBSD.ORG Tue Apr 24 02:37:50 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 3CC5A16A404 for ; Tue, 24 Apr 2007 02:37:50 +0000 (UTC) (envelope-from zhangweiwu@realss.com) Received: from bossdog.realss.com (bossdog.realss.com [211.157.108.128]) by mx1.freebsd.org (Postfix) with ESMTP id 2752913C457 for ; Tue, 24 Apr 2007 02:37:48 +0000 (UTC) (envelope-from zhangweiwu@realss.com) Received: from localhost (unknown [127.0.0.1]) by bossdog.realss.com (Postfix) with ESMTP id 550E23B8032; Tue, 24 Apr 2007 10:37:59 +0800 (CST) Received: from bossdog.realss.com ([127.0.0.1]) by localhost (bossdog.realss.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27002-10; Tue, 24 Apr 2007 10:37:56 +0800 (CST) Received: from [218.193.55.195] (154.18.61.59.board.xm.fj.dynamic.163data.com.cn [59.61.18.154]) by bossdog.realss.com (Postfix) with ESMTP id 523FD3B8030; Tue, 24 Apr 2007 10:37:55 +0800 (CST) From: Zhang Weiwu To: L Goodwin In-Reply-To: <566366.97155.qm@web58105.mail.re3.yahoo.com> References: <566366.97155.qm@web58105.mail.re3.yahoo.com> Content-Type: text/plain Organization: Real Softservice Date: Tue, 24 Apr 2007 10:34:09 +0800 Message-Id: <1177382049.7382.1.camel@joe.realss.com> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at bossdog.realss.com Cc: freebsd-questions@freebsd.org Subject: Re: best programming language for console/sql application? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 24 Apr 2007 02:37:50 -0000 If this is a product you developed long time ago, and especially if it's no longer used or the old company quit this business, it's probably possible to ask them if they can opensource the old product, and someone may come up and make it better? P.S. I was thinking of an ncurse-style interface, so can shell script do this? I thought shell tools like dialog wasn't powerful enough to support an user interface required by a bug tracker. On Mon, 2007-04-23 at 18:07 -0700, L Goodwin wrote: > I co-developed a UNIX-based multi-product bug tracking system using an > RDBMS (Informix, ISQL, Perform and ACE), bourne shell scripts, cron, > and UNIX Mail. This solution also worked on PC clients (we used > Reflection-X, but I'd recommend XWin32). Our design was selected over > a PC-only solution that another faction was pushing (we had more UNIX > clients than PC's at that time). > > It had some pretty sophisticated features for the time (some carried > over from a previous version), including: > > Automated email notifications and summaries designed to support our > software development methodology. > > Retrieve and display SCCS deltas to display code changed for a bug > fix. > > Ability to store bug regression tests (manual and automated) in > several different languages, and automatically generate automated > regression tests based on several different criteria, including > Product, Platform, Version Range, and Programming Language. This one > was my baby (brag). > > I've also rewritten HPUX makefiles in bsh to permit execution on > multiple UNIX platforms (HPUX make has some unique features not found > in make on other UNIX platforms). > > Based on the above experience, I'd recommend shell scripts, though > this will likely generate some opposition. In any case, if your system > only needs to run on one platform, I'd use built-in tools. > > Since then, I've played around with using perl for CGI scripting > (hated it), then PHP, which I love for this purpose. > > Zhang Weiwu wrote: > Dear list > > This is OT. I am a 4 year php developer and is very familiar > with > javascript and awk (familiar = knows and used all functions > and features > of the language itself) and I am a 5 year FreeBSD user. Being > frustrated > for the lack of a good console-based issue tracking tool (like > mantis or > bugzilla), I think I should start to write my own. I'll either > start > from scratch or (better) write a frontend for mantis which I > used for years. > > 1. If someone has already started, I should try join him/her > rather > than reinventing the wheel. So if someone knows any person who > is > starting to work on a slim console-based issue tracker, please > let > me know. I already did quit a few searches. I know someone is > working on a console front-end of G-Forge, but a big software > like > G-Forge is not what I am thinking of. > 2. If I start my own, I think I'll be using a console widget > library > (ncurse? because it's famous), an SQL database (no problem) > and a > programming language. I never developed console application > before, so here asking for suggestions on what programming > language to choose. Non of my known language > php/javascript/awk > are suitable so I guess I have to learn a new language anyway. > The > language better be easy to learn and work with (C++ is out), > not > necessarily have complicated calculation feature (like the > graphical report mantis makes), not necessarily OOP. I have > perl > and tcl in my head now, can you make some recommendations? > > Thanks! > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" > > > > > ______________________________________________________________________ > Ahhh...imagining that irresistible "new car" smell? > Check out new cars at Yahoo! Autos. -- Zhang Weiwu Real Softservice http://www.realss.com +86 592 2091112