4 ms·
The best way is through experience. Building an ERP system for a business is a great way to run into problems that need these kinds of solutions. You’ll be writ
by matte_black 9y ago
The best way is through experience. Building an ERP system for a business is a great way to run into problems that need these kinds of solutions. You’ll be writing triggers, indexes, stored procedures, views, etc.
And don’t use ORMs.
- jrumbut 9y agoHa! I had the pre-ORM ERP experience myself, definitely a way to learn how to go beyond the basics. Probably not available to the newest programmers though. For Postgres and other feature rich RDBMS's one important thing is to take some time to learn what's possible. generate_series() is at the heart of a lot of good reporting tricks, as shown in the article.