Re: need advice on a solution
On 10/04/2010 01:05 AM, Long Wind wrote:
(sorry, this is not Linux specific)
I trade stocks. I put stock prices in file. Often I need compute PE
for each day. To cope with stock split, I need to recompute prices as
if un-split. Sometimes to compute PE, I want to use average of the
last three years' earning
To complete these tasks
Solution 1: is it possible to use spreadsheet? OpenOffice or other?
Probably not, since the task is too complicated.
Solution 2: use mysql?
Not that evil pseudo-RDBMS, which wouldn't know data and relational
integrity from cr@p.
PostrgeSQL is *the* way to go, though it will take a bit more
up-front effort to learn what to do.
Only sql commands?
Certainly not plain INSERT, UPDATE, DELETE and SELECT statements,
but PostgreSQL has the powerful PL/pgSQL.
without a programming
language like jdbc?
jdbc is an API not a language.
Solution 3: programming in java. I find it clumsy.
Why limit yourself to Java? Perl and Python are up to the task, as
are C++ and FreePascal. (Yes, I'm pointedly ignoring C.)
I am familiar with java, no training is required for solution 3
For solution 1 and 2, I have to learn spreadsheet, sql and/or jdbc
SQL itself isn't difficult to learn. What you need is a clear head
(to see the whole problem) and to learn some data modeling skills.
Actually, DM skills will help you with non-database programming,
since what you get out of it are planning and design.
Seek truth from facts.