In this blog post, I will tell you some queries/ tricks to speed up your application using the power of a database. I am using Postgres and ActiveRecord rails, so all questions are related to these, but you can tell them with your database. Recently I got some performance issues when our user base increased … Continue reading Leverage A Database To Gain An Optimum Speed For Your Application
blog
Upload Your Large CSV Efficiently Using Rails
Active-record is an abstraction layer that facilitates creation, deletion and use of ORM objects whose data requires persistent storage to a database. This keeps us away from having to think too much about SQL level queries and makes it very easy for us to work with data. It gives us super easy interface that helps us to do “almost” anything that we can do with bare SQL statements. Apart from the basic CRUD operations, active-record lets us do more complicated database stuff like pick a group of records based on a criteria, order them, join tables, perform mathematical operations, etc.
Active-record pattern is liked by most because of the above mentioned reasons. But using active-record solely may not help when your application scales.
For example, active-record does not have a support to bulk insert into the database. Ofcourse we can use gems to do that, but I personally…
View original post 661 more words
Load Your Widgets In The React-Redux Application
I got an interesting requirement for my React app to display multiple widgets with the following conditions:
- Number of widgets to displayed – UNKNOWN
- Content to be displayed – UNKNOWN
- API endpoints – UNKNOWN
- Only known thing was the placeholder in the widgets where data needs to be displayed
- Need to display loader for each API call
Fortunately, an API was available to get details such as the number of widgets and their endpoints.
As per the requirement to display loader for each API call, the first screen was:
|
Initial Loader screen When the first API returns the response containing details regarding widgets such as the number of widgets and their endpoints, the above widget should turn into the following screen if there are 4 widgets data returned by initial API call:
 |
| screen 2 |
And each of the widgets will call different APIs to get the data it needs…
View original post 524 more words
Josh Software 