financial application/systems database
when choosing a database for a financial application/system, what are few things to consider. I've worked with mysql, sql server and oracle, but apart from writing simple queries , I haven't dig deep into these databases. I know few differences between them , like one being free vs another. some have automatic logging and so forth.
if i were choosing to develop a financial app, is there any preferred database system to use?
if i were choosing to develop a financial app, is there any preferred database system to use?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
I would go with MySQL as long as is backed by Oracle. Also, you can have a look at MariaDB (that's the preferred one for the accounting solutions build by the company that I'm working for).
I'm not an expert in building financial apps, for sure you'll need some domain experts for the business rules. Some books you can find on Amazon: https://www.amazon.com/s?k
I would go with MySQL as long as is backed by Oracle. Also, you can have a look at MariaDB (that's the preferred one for the accounting solutions build by the company that I'm working for).
I'm not an expert in building financial apps, for sure you'll need some domain experts for the business rules. Some books you can find on Amazon: https://www.amazon.com/s?k
ASKER
thanks Eduard. I have been looking both at C# and python. I was leaning more towards python as it might be helpful later for some analysis and data visualisations , as python as lot of libraries which can do that. do you thing python will be good choice for developing api for a financial app.
Hi,
It's definitely possible to use python to build an API, but I would recommend using a compiled language like C# or Java, or, why not C++ to build it. Of course, if you need a rapid prototype, you can use python and, later on, when you'll need better performance and scalability, move towards other platforms/programming languages.
It's definitely possible to use python to build an API, but I would recommend using a compiled language like C# or Java, or, why not C++ to build it. Of course, if you need a rapid prototype, you can use python and, later on, when you'll need better performance and scalability, move towards other platforms/programming languages.
ASKER
@eduard - thank you very much . can you share with me couple of factors , why C# or a compiled language would be better than python , an interpreted language.
Hi,
My pleasure!
A compiled language has many advantages over an interpreted one, the most obvious being the execution speed of the programs. Next, the code safety, many errors being caught in the compilation stage. Also, the memory consumption is, usually, not that high like in case of an interpreted one.
An interpreted language allows higher flexibility, it's much easier to do changes and deploy the apps, but there is a high risk to find errors just at the runtime.
My pleasure!
A compiled language has many advantages over an interpreted one, the most obvious being the execution speed of the programs. Next, the code safety, many errors being caught in the compilation stage. Also, the memory consumption is, usually, not that high like in case of an interpreted one.
An interpreted language allows higher flexibility, it's much easier to do changes and deploy the apps, but there is a high risk to find errors just at the runtime.
ASKER
I'm also considering between mysql and postgresql . if you know , could you point out if one would be better than other for a financial application. if not, I will open a new question for these. Also, from your experience are there any books and articles , about building financial apps, api's that I can look at , that might be helpful.