LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices

Reply
 
Search this Thread
Old 06-21-2005, 12:57 AM   #1
thadco
LQ Newbie
 
Registered: Jul 2003
Posts: 12

Rep: Reputation: 0
Front End Advice Please


About ten years ago I wrote a front end for a not too complicated insurance database using Visual Basic 4.0 16-bit over Access 2.0, with Crystal Reports for output. I'm still using it today.

The system consists of data entry, premium calculations, and report generation. There are lots of funky rules that very from client to client. Things having to do with dates, limits, and stuff like that. So over time, the application has become pure spaghetti code. It works, but it sure is ugly inside.

Anyway, I very much need to rewrite the whole thing from scratch and have certain requirements. I'm hoping someone out there can make some suggestions as to which tools I should use.

Requirements:

> I want nothing to do with Microsoft if at all possible. I don't necessarily mind developing on XP for now, but whatever I use must also be available on Linux. Shorthorn is the end for Microsoft as far as I'm concerned.

> The entire system must be web based, using open standards & tools. My main motivation is to make everything totally web accessible so I can have my customers enter data rather than me receiving faxes and emails then doing to transcription.

> I need to generate a crapload of semi-complicated reports that will print out properly for my customers. I've been using Crystal Reports since version 1.0, but alas, they are Windoze only. So that's a dead end now too.

Additional Considerations:

> I haven't done any real coding over the last decade and back then it was only in VB. So, I need something without a terribly steep learning curve. I'm willing to sacrifice extreme functionality for simplicity.

> Although I know many Linux folks prefer command line hand coding, I must confess that I have more of a GUI type of brain. The appeal of being able to draw everything out and then make it do what I want is significant.

> I'm pretty clear that the database will be either PostgreSQL or MySQL. I've never used either, but hope there are some GUI type tools that will allow me to structure the tables, define relationships, and build queries similarly to what I'm used to with Access. Is this wishful thinking?

So, I need suggestions for replacement tools for VB, Crystal, and Access.

One person I know is suggesting that I use Drupal over MySQL, but I'm not sure if that will do all the things I need.
 
Old 06-21-2005, 02:08 AM   #2
enemorales
Member
 
Registered: Jul 2004
Location: Santiago, Chile
Distribution: Ubuntu
Posts: 410

Rep: Reputation: 30
Hi,

I'ld suggest you PHP/MySQL. Both are very good pieces of software and there is plenty of information on the web to help you to learn them. For the creation/administration of your database, you can use myphpadmin, which is a web-based database administration that is not only useful for, well, managing databases, but also it will give you some tips about the kind of things you can/should do with a web-based interface.

I think that the more difficult thing is to replace Crystal Reports. I googled a little and found this http://www.agata.org.br/us/index.php. At least the screenshots look very nice...

HTH!
 
Old 06-21-2005, 04:02 AM   #3
thadco
LQ Newbie
 
Registered: Jul 2003
Posts: 12

Original Poster
Rep: Reputation: 0
Thanks for the pointer to Agata. I had been searching for some time but somehow missed that one. It looks like it might just do the trick.

Looks like I'll be learning how to turn on the LAMP.

Regards.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
vB forum front-end? General Linux - Software 3 10-18-2005 12:14 AM
Front- End for Qmail Koven Linux - Software 1 03-09-2005 02:56 PM
What does it mean to unpack your front end? dns21 Linux - Newbie 5 08-02-2004 01:03 AM
Anyone use Seahorse front-end for gpg? ArthurDent Linux - Software 1 06-03-2004 12:21 PM
after a web front end acid_kewpie Linux - Networking 1 08-15-2002 05:51 PM


All times are GMT -5. The time now is 09:38 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration