3 ms·
I'm surprised more folks don't store data about every page view/action in their database. If you have a lot of data, postgres_fdw makes it easy to scale. Analyt
by joevandyk 13y ago
I'm surprised more folks don't store data about every page view/action in their database. If you have a lot of data, postgres_fdw makes it easy to scale. Analytics becomes much simpler if all your data is in a single system.
- andreasklinger 13y agoAgree But to be fair: In my exp the timestamps on models are usually already sufficient. In most cases you want to monitor state changes.
- joevandyk 13y agoNot sure what you mean. Say you are an e-commerce business. If you store each page view in your system, it's simple to write a sql query that details where all your visitors are coming from, the path they take to order something, how long it takes them to order something, which users haven't ordered anything or visited the site in the past two weeks, etc. Adding a timestamp to a table doesn't really help here.