I have a project where I am collecting stock prices and other related data. The goal is to create a system which will :
- determine the number of new lows and new highs each day.
- tell me how many stocks in a certain sector / industry / Exchange Traded Fund have risen above or declined below a certain moving average.
There are other things I want the system to do but the above tasks are the most important.
I have been working with vbscript and SQL Server 2000 using a Windows 2000 server. Windows 2000 server is obsolete. The system I will build is not going to be for sale. I don't want to spend money buying a server, buying Windows server 2008 and buying licenses for SQL Server 2008 or whatever the new version is.
I understand PostgreSQL is a reasonably powerful database. It is also free.
SQL Server 2000 has tools in it to help create tables, create packages of code which will import from an Excel spreadsheet and perform many functions. Vbscript can call Access databases. The code in an Access database can invoke functions which can write and read data from a SQL Server 2000 database. Access can also create forms which can display data. It also has a report writer.
I want to stay in the Windows environment. The operating system of the pc on which my system will run is Windows 7 pro.
q1.) Where can I find tools which can help me manage a postgreSQL database?
q2.) I need some program to substitute for Access - something which can create screens, allow interaction (click a button and have a data entry screen appear, etc) What tool would you select for this? For example, for a casual programmer like me, what features of say Python might be attractive? Or may be Java is better? What would you use?
q3.) What software would you use to create reports?