![Nirjal Paudel](/me.webp)
Nirjal Paudel
I'm Nirjal Paudel, a software developer specializing in database and backend technology, optimization and cloud
Recent Blogs
JSONB in PostgresSQL and its daily uses
Postgres is a powerful SQL database with extensive features. It supports two JSON data types, json and jsonb, offering various functions and operators. Using JSONB can optimize database queries and reduce joins, as illustrated by examples like Netflix profiles and inflation-resistant order data.
I have been optimizing my development productivity
How I enhanced developer productivity with personal tools, bash scripts, aliases and organizational practices
Temporary tables in SQL and How I used it to improve performance
In PostgreSQL, a temporary table is a table that exists only during a database session. It is created and used within a single database session and is automatically dropped at the end of the session.