The database view has been a very useful component in business intelligence for decades now. Learn more about that in this post.
PostgreSQL is indeed relevant, so you must back it up before you lose everything you need for your business. Learn more here.