Database

Dealing with giant tables in Postgres using Partitioning

Operation towards very large tables takes too much time in database. To overcome this problem, Postgres introduced partitioning using pg_partman extension. Steps to implement 1. Install extensionCREATE EXTENSION pg_partman; 2. Create tableCREATE TABLE events; 3. Create parent index tableSELECT create_parent(‘public.events’, ‘created_at’, ‘time’, ‘daily’); 4. Run partitioningSELECT run_maintenance(); Reference https://blog.heroku.com/handling-very-large-tables-in-postgres-using-partitioning

Discussion

Reaction Commerce

Reaction Commerce is an open source E-Commerce platform. We can implement basic ecommerce functionalities without additional coding. We just need to setup the platform using docker and we can do basic ecommerce functionalities like create product, create order, create tag, cart, etc. https://reactioncommerce.com/ https://github.com/reactioncommerce/reaction We can use this platform when we need to develop ecommerce …

Lecture

SWR – React Hooks library for data fetching

SWR is React Hooks library for data fetching. The name “SWR” is derived from stale-while-revalidate, a HTTP cache invalidation strategy popularized by HTTP RFC 5861. SWR is a strategy to first return the data from cache (stale), then send the fetch request (revalidate), and finally come with the up-to-date data. With SWR, components will get …