Many relational database engines support views. Views can act as a kind of virtual tables and using them can sometimes greatly improve the architecture and the testability of the system, but of course, there might be the price to pay. Common simple calculations You might encounter a situation when the
One of the interesting technical challenges to solve when building a modern web application is to achieve acceptable responsiveness for a UI depending on sometimes sluggish API endpoints. User's perception of an application as slow is all about latency, reactions, wait times and feedback. Delays, freezes, feedback lags, unresponsiveness — all
What Is ORM ORM stands for Object-Relational Mapping and it can be simply described as mapping of classes (objects) to database tables. The concept is almost as old as object-oriented programming itself. It's hard to find which library was exactly first, but some suggest that it was TOPLink for Smalltalk.
When at the beginning of my professional career I meet first true professionals, one thing that I'd noticed was how effective they were with the tools they used. They extensively used hotkeys and different sorts of keyboard shortcuts to quickly craft things they want. Opposite, as a novice user from
When thinking of a modern development pipeline, I always find database development tooling undeveloped in comparison to what code development tools are offering. We have version control systems, review tools, CI/CD solutions, linters and many more. There are plenty of them so you can automate workflow as you want