Mikhail Khorpyakov - Spectral Core Blog

Mikhail Khorpyakov

Choosing a Database Without Hype and Buzz

Choosing a Database Without Hype and Buzz

The modern informational technology industry is obsessed with hype. You're obliged to pick a new fancy tech or you will be blamed in backwardness and people won't be interested in what you're building. But what is more important: the tools you're using or a product that you make?

Embedding Monaco Editor into a Web Application

Embedding Monaco Editor into a Web Application

Today, if you want to include a code editing features into your saas project, you don't have many alternatives other than the Monaco editor, a browser-based version of the popular Visual Studio Code editor.

Build It Up, Test It Down

Build It Up, Test It Down

Setting priorities is important and inevitable part of a software development process. Balancing development speed and quality is one of the basic compromises that a programmer should make.

Investigating Memory Leaks in Vue Applications With Chrome Memory Tools

Investigating Memory Leaks in Vue Applications With Chrome Memory Tools

When you build a complex Vue application consisting of many views with deeply nested components hierarchy, very soon you will encounter memory issues.

End-to-End Web Application Testing with New TestCafe Studio

End-to-End Web Application Testing with New TestCafe Studio

A recent beta release of the DevExpress' TestCafe Studio brought us a good opportunity to implement end-to-end testing for our new SQL Studio application. I will explain why TestCafe Studio is a good tool to quickly automate QA for any web site or application and why we end up

How to Integrate External DOM-dependent Libraries Into a Vue Application

How to Integrate External DOM-dependent Libraries Into a Vue Application

Integrating 3rd party libraries into a Vue application is not harder than in any other JavaScript reactive framework. Nothing special with using a single import statement. Integrating a component that depends on DOM and renders itself on a page is a different story. Examples are maps, editors, image manipulation tools

A database with a view

A database with a view

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

Balancing Responsiveness and State Consistency in SPA

Balancing Responsiveness and State Consistency in SPA

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,

A Case for ORM, a Case Against ORM

A Case for ORM, a Case Against ORM

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

Hot Keys and UX of Web Applications

Hot Keys and UX of Web Applications

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

Database tools I want

Database tools I want

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