The classic ETL process involves extracting data from the source, storing it in raw format in bucket storage, and then sequentially processing the files before loading them into an analytical database. The transformation of the raw data and loading it into ClickHouse previously took 45 to 60 minutes for 60…
Hi Readers, In this post, we’ll look at how to use PostgreSQL’s window functions instead of GROUP BY to handle calculations directly in your SQL queries. Window functions give you more control and can make your code simpler by reducing the need to do extra processing in your…
How to use Advisory Lock in rails using redis…
What is frozen attributes Frozen is an object or attribute immutable, this means that once an object is frozen, you cannot modify it or its state. When Rails needs to freeze an object, it typically does so by calling freeze on the object or its attributes at appropriate times in…
To generate a new table in rails we always use rails generate model, There is also an another way to create models dynamically.…
Generate PDF using wicked_pdf in rails…
Parse and import data from large excel file in Ruby on Rails…