Often you will read about Oracle and PostgreSQL. Looked how Enterprises developing their applications. To make the long story short: I have researched how I can solve these issues like above in the example.
POSTGRESQL INSTALL DB ON EXTERNAL DRIVE UPDATE
But what happens, if someone update data directly on database (for example by your self)? You will not see the changes on history table… One problem more after you solved a problem 😀
You will develop your own history table on application layer. Later on, you will ask: “Hmm, why is this data returned as 0/1 instead of a Boolean true/false? How can I follow the table changes?”. One day if you want to develop your own application, you will need to design the Database schema and you will ask “Okey, which fields needs my application and where do I need to save it?” For the first time maybe, you will not care about the datatypes, but once your application will reach 1Tb, you will be starting to tune your database. All tables, rows, relationships have been created automatically. On the application layer for example WordPress, I added the connection strings and it was done for me. Mostly I used preinstalled MySQL databases from webhosting providers. Several times I installed on CentOS/Ubuntu from the repository. I have used MySQL database like an external hard drive, just to save and store the data from an application. If you are planning PostgreSQL as your database but don’t know where to start, this blog may help you. In this Post you will learn how I met PostgreSQL and started to learn.
0 kommentar(er)
