MkIII_Supra
04-23-2007, 07:28 PM
Hey all!
Okay here is the deal, as some of you know I now work at UC Santa Cruz as the Energy Analyst. My job is cool and my boss is too. So cool in fact that he is all for allowing me to run Linux in office. That's great but... yeah you got it those damn pesky Win32 applications are biting me in the backside. So here is the deal though. Many of the applications are going away (about time!) because they are ancient. This is cool and what's even cooler is the newer applications are web based!
Now the caveat is that I have to create one of the applications myself. This in of itself is a dream come true and I have been slowly writing my spec sheet, data dictionary and database schemas so that when the time to code comes I have a solid frame to work with. This is my first REAL foray into the world of programming and now that I have a REAL project that I understand AND control, I want to do it using open source tools.
But I have a problem, and that is why I am here today. I have been doing simple applications with Access and VBA. I am tired of that and want to move to MySql and possibly Java (I like Java and did real well with it in school... although I have not used is since 2001. So my biggest hurdle that I am trying to get over is setting up the MySQL data base on both Linux and Windows, once I get that figured out and the tables built and populated my next task is to build the GUI front end for users so create filters on the fly and use stored SQL to obtain data as well. And the 3rd piece of the puzzle is getting Crystal Reports to work with it on Linux and Windows.
I have a working model of what I want to build in Access, but it's limited and if any of you have ever developed in Access you know the issues that can arise. So before I go and start buy books, which book is the absolute BEST for a NEWBIE BEGINNER to understand and grow from, then what is the BEST book for an INTERMEDIATE user for MySQL. Also if you know of any online training courses I would welcome those suggestions as well.
The absolute end goal is to build a cross platform binary that I can use on Macintosh, Linux and Windows. So Java is already mandated, and also because I am familiar with it already. BUT, that doesn't mean I am not open to suggestions for other languages. The other thing I will need is a Linux RAD tool for combing this project and making it a reality.
Well, I think that about covers my needs for now.
Thank you
Okay here is the deal, as some of you know I now work at UC Santa Cruz as the Energy Analyst. My job is cool and my boss is too. So cool in fact that he is all for allowing me to run Linux in office. That's great but... yeah you got it those damn pesky Win32 applications are biting me in the backside. So here is the deal though. Many of the applications are going away (about time!) because they are ancient. This is cool and what's even cooler is the newer applications are web based!
Now the caveat is that I have to create one of the applications myself. This in of itself is a dream come true and I have been slowly writing my spec sheet, data dictionary and database schemas so that when the time to code comes I have a solid frame to work with. This is my first REAL foray into the world of programming and now that I have a REAL project that I understand AND control, I want to do it using open source tools.
But I have a problem, and that is why I am here today. I have been doing simple applications with Access and VBA. I am tired of that and want to move to MySql and possibly Java (I like Java and did real well with it in school... although I have not used is since 2001. So my biggest hurdle that I am trying to get over is setting up the MySQL data base on both Linux and Windows, once I get that figured out and the tables built and populated my next task is to build the GUI front end for users so create filters on the fly and use stored SQL to obtain data as well. And the 3rd piece of the puzzle is getting Crystal Reports to work with it on Linux and Windows.
I have a working model of what I want to build in Access, but it's limited and if any of you have ever developed in Access you know the issues that can arise. So before I go and start buy books, which book is the absolute BEST for a NEWBIE BEGINNER to understand and grow from, then what is the BEST book for an INTERMEDIATE user for MySQL. Also if you know of any online training courses I would welcome those suggestions as well.
The absolute end goal is to build a cross platform binary that I can use on Macintosh, Linux and Windows. So Java is already mandated, and also because I am familiar with it already. BUT, that doesn't mean I am not open to suggestions for other languages. The other thing I will need is a Linux RAD tool for combing this project and making it a reality.
Well, I think that about covers my needs for now.
Thank you