All Ruby on Rails Node JS Android iOS React Native Frontend Flutter QA
The materialized view is a powerful database solution that allow us to access the view’s data faster by “caching” its response. The materialized view query is executed once when the view is created, not when accessing the data as it is with regular database views. It is a great and worth using feature when we do not need a view to return the most recent data or we know that we will more often read the view’s data than we will modify them. There is only one small problem while using such view: we need to handle the refresh of its data manually.
Read more
Postgres complex data types (hstore, json, jsonb, array) are very useful tools in database design. Having multiple values under one attribute definitely has its use cases. There are plenty of articles that compare the NoSQL database performance to the PostgreSQL JSON datatypes. Their results show the maturity of tools provided by this database management system. So which data types are best suited for what?
Read more
 Most of the time when we need to query some data from our database in a Rails based application, we just use ActiveRecord query interface. When the query is more complicated, we write it using SQL language. Sometimes it may be needed to use such SQL query in more than one place. In such cases (to better stick to the DRY principle), we can consider using a database view. In this blog post, I will present what are the database views and how to easily use them in Ruby on Rails application with the help of a Scenic gem.
Read more

PostgreSQL Advisory Locks

Thread synchronization is a topic that gives many developers nightmares. It's a very serious issue, hard to debug and solve, especially in desktop apps. However, web developers sometimes also have to tackle the challenge of making multiple threads work nicely with each other. So, what exactly is the problem here?
Read more
Need a successful project?
Estimate project or contact us
Netguru Codestories | PostgreSQL