All Ruby on Rails Node JS Android iOS React Native Frontend Flutter
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
In today's TIL we say hi to ActiveRecord's dependent hooks, explore how they relate to callbacks, and what impact could it have on the development of an app.
Read more
I’m amazed how much mobile developers despise SQL. It’s fast and efficient way of storing data, proven in battle in so many years. I guess the reason of that for many of them, myself included, is the way we were taught at universities. For a beginner programmer, it’s quite a challenge to dive in into SQL, with its complicated queries and non-intuitive relations. I remember being overwhelmed and repulsed by it. For the same reason, I hated C for so long. I guess it takes time to appreciate a technology fully, but the feeling of accomplishment after completing a low-level language project is much bigger than creating something with the use of easier, ready-to-go solutions.
Read more

GRDB.swift as a Solution for iOS Database

Most of apps need an database. A to-do list, a banking app, a game or even a simple "API reader" with offline mode. When targeting Apple operating systems the most natural choice seems to be Core Data. Designed by Apple in California. Nevertheless I am not the only one who has mixed feelings about it.
Read more
Newer
Older
Need a successful project?
Estimate project or contact us
Netguru Codestories | Database