Pavel is a web developer involved in all software development processes. He is passionate about UX/UI design and loves both frontend and backend development. He is zealous about teaching and sharing his knowledge with fellow developers.
Getting data into your database is easy, but querying large datasets is challenging—especially without the right indexes. Pavel Tkachenko teaches how to write performant SQL queries with EXPLAIN and ANALYZE.
Internationalization means adapting your application to the language and culture of your users—a difficult task! Luckily, Rails provides the I18n API. In this article, Pavel Tkachenko shows us how to start translating.