Skip to main content

Search This Blog

How To Dev

A website sharing content on various technologies such as React, Angular, NodeJS, JavaScript, TypeScript, Golang, Python, PostgreSQL, MySQL, DevOps, Docker, K8s, Git, AWS, GCP and more.

Sitemap

Get link
Facebook
X
Pinterest
Email
Other Apps

A page aggregator designed for easy reference and search, compiling all blog posts for convenient access.

Loading all posts...

javascript react typesript web development

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Post a Comment

Popular posts from this blog

All Practice Series

Introduction This is a comprehensive page about the technologies I have shared in series format. You can view brief introductions and links to directly access each series you are interested in. In the field of software development, to deploy a product from the initial idea to its release, the standard process typically involves several stages as follows: Database : Designing and implementing the database according to business requirements, storing data during the system's operation. Backend : Handling the main logic of the system, communicating with the database and services. Frontend : Building the interface for users to interact with the system, which could be a desktop, mobile, or web application. This usually includes implementing UI/UX and integrating APIs from the backend. DevOps : Deploying the system for use, which can be done on a server or in the cloud. Testing : Applying testing methods to ensure the product meets the standards for release. Of course, these are just stan...

Understanding React Server Component

Introduction As most of us already know, React enables us to break down interfaces into independent parts called Components, facilitating reuse and customization. Currently, React Components are divided into two main types: Client Components : widely used in Client Side Rendering (CSR) applications. Server Components : a new type of component that renders on the server side before being sent to the client (browser). At first glance, it may seem similar to Server Side Rendering (SSR) which has been used for a while, but in reality, these two concepts have certain differences. The Difference of RSC (React Server Component) Ease of development: React Server Component allows easy direct connection to server-side resources such as databases or internal services, streamlining development processes. Improved performance: By reducing latency in communication between client and server, React Server Component enhances overall application performance. Reduced source code size: Libraries utili...

Kubernetes Deployment for Zero Downtime

Introduction In Kubernetes (K8s) , a Pod is the smallest resource unit used to run one or more containers during deployment. There are several ways to create a Pod : you can create it directly, use a ReplicationController , or a ReplicaSet . However, the most commonly used resource for managing Pods is the Deployment . When you use a Deployment , it actually creates a ReplicaSet to manage the Pods but comes with many additional benefits that support the deployment process. Some Advantages of Deployment : Ensures Pod Availability : It guarantees that the specified number of Pods are always running according to the configuration, automatically deploying additional Pods if any failures occur. Supports Restart and Undo Deployment : Allows you to easily restart or roll back to previous versions of your Deployment . Zero Downtime Deployment : When updating configurations or scaling Deployments , zero downtime is crucial. This means that new Pods are created while the old Pods are stil...

Deploying a NodeJS Server on Google Kubernetes Engine

Introduction to GKE Google Kubernetes Engine (GKE) is a managed Kubernetes service provided by Google Cloud Platform , facilitating simple and efficient deployment of Docker images. We only need to provide some configuration for the number of nodes, machine types, and replicas to use. Some Concepts Cluster A Cluster is a collection of Nodes where Kubernetes can deploy applications. A cluster includes at least one Master Node and multiple Worker Nodes . The Master Node is used to manage the Worker Nodes . Node A Node is a server in the Kubernetes Cluster. Nodes can be physical servers or virtual machines. Each Node runs Kubernetes , which is responsible for communication between the Master Node and Worker Node , as well as managing Pods and containers running on it. Pod A Pod is the smallest deployable unit in Kubernetes . Each Pod contains one or more containers, typically Docker containers. Containers in the same Pod share a network namespace, meaning they have the ...

React Practice Series

Introduction React is a JavaScript library created by Facebook , often referred to as the most popular frontend framework today. This page aims to gather articles related to ReactJS , covering topics such as theory, features, and commonly used packages in the process of building ReactJS applications. I will update this series with more articles in the future as new ideas for content come up. The articles are arranged in increasing order of difficulty, so if you have time, it's recommended to start from the beginning of the series. This will ensure you grasp the essential knowledge and information needed for the subsequent articles. Here are some key topics in the series that you need to explore to effectively use ReactJS : Fundamental : React Hook, React Reconciliation. State management : redux, mobx, recoil, zustand, xstate, etc. Middleware libraries : redux-thunk, redux-saga, redux-observable, etc. Popular packages : tasnstack query, immer, styled-components, etc. Rendering te...

Helm for beginer - Deploy nginx to Google Kubernetes Engine

Introduction Helm is a package manager for Kubernetes , which simplifies the process of deploying and managing applications on Kubernetes clusters. Helm uses a packaging format called charts , which are collections of files that describe a related set of Kubernetes resources. Key Components of Helm Charts : Helm packages are called charts. A chart is a collection of files that describe a related set of Kubernetes resources. A single chart might be used to deploy something simple, like a memcached pod, or something complex, like a full web app stack with HTTP servers , databases, caches, and so on. Values : Charts can be customized with values, which are configuration settings that specify how the chart should be installed on the cluster. These values can be set in a ` values.yaml ` file or passed on the command line. Releases : When you install a chart, a new release is created. This means that one chart can be installed multiple times into the same cluster, and each can be indep...

Docker Practice Series

Introduction Docker is an open platform for developing, shipping, and running applications. This page is dedicated to compiling articles related to Docker , covering both the theoretical aspects and practical applications of Docker in setting up popular tools essential for software development. I will be updating this series with more articles in the future as new ideas for topics arise. The articles are arranged in increasing order of difficulty, making it easier for you to follow along. If you have the time, I recommend starting from the beginning of the series to ensure that you grasp the necessary knowledge and information needed for the more advanced articles later on. Here are some key topics in the series that you need to explore to effectively use Docker : Basic knowledge Docker commands Docker Compose Building Docker images Performance improvement Integration with CI/CD Once you have a solid understanding of the foundational knowledge, the extended topics (including advanced...

A Handy Guide to Using Dynamic Import in JavaScript

Introduction In JavaScript, when we import a file, the process usually happens synchronously, known as static import. However, as our applications grow, this synchronous loading can lead to slower initial page loads due to larger JavaScript bundles. Moreover, there are times when imports are necessary only under specific circumstances, leading to unnecessary loading times for users who might not even utilize those features. Details Instead of burdening all users with unnecessary imports, dynamic imports come to the rescue. They allow us to load modules or files only when they are needed, thus improving performance and user experience. Dynamic imports are invoked using the import() function and return a promise. When using default exports, the exported data can be accessed through the default field, while other data can be accessed through fields with matching names. Here's how you can use dynamic imports: import ( "ramda" ). then ( module => { const moduleDefaul...

DevOps Practice Series

Introduction DevOps is a combination of development (Dev) and operations (Ops), aimed at uniting people, processes, and technology to enhance the software development lifecycle. Here are some key aspects of DevOps: Collaboration and Communication: DevOps fosters a culture where development, IT operations, quality engineering, and security teams work together seamlessly. Continuous Integration and Continuous Delivery (CI/CD): These practices automate the integration and delivery of code changes, ensuring faster and more reliable software releases. Infrastructure as Code (IaC): This approach involves managing and provisioning computing infrastructure through machine-readable scripts, rather than physical hardware configuration. Monitoring and Logging: Continuous monitoring and logging help teams to detect issues early and maintain system reliability. Automation: Automating repetitive tasks reduces errors and increases efficiency, allowing teams to focus on more strategic work. By impleme...

Powered by Blogger

Theme images by Michael Elkan

Popular posts from this blog

Understanding React Server Component

Introduction As most of us already know, React enables us to break down interfaces into independent parts called Components, facilitating reuse and customization. Currently, React Components are divided into two main types: Client Components : widely used in Client Side Rendering (CSR) applications. Server Components : a new type of component that renders on the server side before being sent to the client (browser). At first glance, it may seem similar to Server Side Rendering (SSR) which has been used for a while, but in reality, these two concepts have certain differences. The Difference of RSC (React Server Component) Ease of development: React Server Component allows easy direct connection to server-side resources such as databases or internal services, streamlining development processes. Improved performance: By reducing latency in communication between client and server, React Server Component enhances overall application performance. Reduced source code size: Libraries utili...

Numeric Types

Introduction Postgres is famous for being a feature-rich database, supporting a large list of data types that can be divided into several groups with distinct functions. First, we will explore a very commonly used group, Numeric Types, which includes the following data types: smallint : 2 bytes, (+/-) 32,767 integer or int : 4 bytes, (+/-) 2,147,483,646 (~2.1 billion) bigint : 8 bytes, (+/-) 9,223,372,036,854,775,807 (~9.22 million billion) numeric : 10 bytes, (+/-) 10^131071 Used to store fixed-precision decimal numbers, never suffering from implicit rounding errors Highly suitable for financial, monetary and accounting data Flexible size Up to 131,072 digits before the decimal point and 16,383 digits after the decimal point 100% absolute accuracy based on the numeric(Precision, Scale) configuration Precision : The total count of digits that can be stored (including digits both before and after the decimal point, excluding negative/positive signs or decimal points), ranging from ...

Using CROSS JOIN LATERAL in Postgres

Introduction In standard SQL, subqueries located in the JOIN clause operate independently, they cannot see or use data from tables located before (to the left of) it. When you add the LATERAL keyword, Postgres allows the subquery on the right to directly access column values of each row in the table on the left. Differences between Join types are as follows Standard CROSS JOIN takes the Cartesian product of 2 tables independent of each other (a multiplication of 2 tables without needing a condition) CROSS JOIN LATERAL operates like a for-each loop in programming, with each row in the left table, Postgres runs the subquery on the right to perform dynamic calculations repeatedly based on values from the left table and joins the results together. INNER JOIN is the intersection between 2 datasets, it only retains rows in 2 tables when both satisfy a specific join condition, the condition in ON is mandatory (unlike CROSS JOIN which does not require passing a condition) Can be combined...

Pivot in PostgreSQL

Introduction Pivot (or Pivot Table / Crosstab) is a technique used to transform data from rows to columns. This technique is very popular in data analysis and reporting, helping group scattered data rows into an easy-to-read summary table. Example of initial data (Long format): | Year | Quarter | Revenue | | : --- | : ------ | : ------ | | 2023 | Q1 | 100 | | 2023 | Q2 | 150 | | 2024 | Q1 | 120 | | 2024 | Q2 | 180 | Data after Pivot (Wide format): | Year | Q1 | Q2 | | : --- | : --- | : --- | | 2023 | 100 | 150 | | 2024 | 120 | 180 | How to Implement Unlike SQL Server or Oracle (which have native PIVOT syntax), PostgreSQL does not have a direct PIVOT keyword. You can accomplish this using the following common approaches: Using conditional aggregate functions ( SUM + FILTER or CASE ) is the simplest method, requiring no additional extensions and optimizing performance well. Using the tablefunc extension and the crosstab() fun...

Guide to integrating NextJS with gRPC and NestJS via HTTP/2

Introduction gRPC is a high-performance RPC (Remote Procedure Call) framework developed by Google, using Protocol Buffers (protobuf) as the interface definition language and data serialization format. Unlike traditional REST which uses text (JSON), gRPC transmits data in binary format to optimize payload size and processing speed. In particular, gRPC operates based on HTTP/2, providing outstanding advantages such as: Multi-plexing (sending multiple concurrent requests over a single connection), Header Compression, and Server Push, helping to reduce latency and increase bandwidth for microservices systems. In this article, I will use NextJS for the frontend and act as a BFF (Backend For Frontend) as a proxy server to aggregate information and communicate via HTTP/2 gRPC with the NestJS server. Our connection will be as follows: Frontend connects to NextJS proxy server using restful api HTTP/1.1, NextJS connects to NestJS using gRPC via HTTP/2, we need a NextJS middleware to handle it, n...

Table relationships

Introduction First, let us look at the concept of the three basic relationships in a Relational Database defined based on the fundamental nature of Cardinality links between two tables: One-to-One Relationship (1-1) A record in Table A is linked to exactly one record in Table B and vice versa. Implemented by placing a Foreign Key in one of the two tables and assigning it a UNIQUE constraint. Examples: A User has only one UserProfile. A Product has only one ProductDetail. When to use: When splitting an oversized table containing rarely used columns to optimize data read performance. When security is required: Separating sensitive information such as credit cards or passwords into a dedicated table with stricter access controls. One-to-Many Relationship (1-N) A record in Table A can be linked to multiple records in Table B. Conversely, a record in Table B is linked to only one record in Table A. Implemented by placing a Foreign Key in the "Many" side table (Table B) pointing t...

Distributed System Practice Series

Introduction A distributed system is a collection of independent computers in terms of hardware but communicating and coordinating with each other through a computer network, making end users feel like a single centralized system. In the era of big data and cloud computing, distributed architecture plays a backbone role for almost all large-scale online services. Core Characteristics For a system to be considered truly distributed, it must face and solve the following technical characteristics: No Shared Clock : Each node has its own physical clock and there is always a certain clock drift. Therefore, you cannot rely on absolute real time to determine the order of events happening between nodes. No Shared Memory : Nodes cannot directly read or write to each other's RAM. Every communication activity and state synchronization must be done through message passing such as protocols like HTTP/REST, gRPC or message brokers like Kafka, RabbitMQ. Concurrency : Multiple nodes process indepe...

Deploy React Application to Google Kubernetes Engine

Introduction In this article, I will guide you through deploying a React Application to Google Kubernetes Engine (GKE) . Previously, I wrote an article about deploying a NodeJS Application to GKE , which you can refer to for some basic information before continuing. Steps to Follow The process is quite similar to deploying a NodeJS Application and includes the following steps: Create a React Application Build a Docker image Push the Docker image Deploy the Docker image to GKE You will notice that when working with Kubernetes , the main difference is in the step where you build the Docker image . Depending on the application you need to deploy, there are different ways to build the Docker image . However, the common point is that once you build the Docker image , you have completed almost half of the process. This is because the subsequent steps involving Kubernetes are entirely the same. Detailed Process 1. Create a React Application In this step, you can either use an existing R...

Revoking JWT with Redis in NestJS

Introduction In the previous article, I provided instructions on using NestJS with JWT, and you may also realize that if you use JWT, once a token is issued, it cannot be revoked. This means that if you have a token that hasn't expired yet, you can continue to use the service. For small systems that do not prioritize security, this might not be a major issue and can be simply resolved by deleting the token from the frontend when the user logs out. However, if you need to build a system with extremely high security, where the token must be invalidated upon logout so that no one can use it to access the service, this article will guide you through how to achieve that. To do this, we will use Redis (which I have already guided you on in this article) to store tokens that have not expired but are requested to be deleted. The storage duration for these tokens will be exactly the time remaining until they expire. Thus, after applying Redis, the operation of tokens will be as follows: If ...

Uploading Files Safely to AWS S3 using Presigned URLs

Introduction If you saw my previous post, I showed you how to upload files to AWS S3 using NodeJS, but that isn't actually the most efficient way to handle file uploads. The best way to handle secure file uploads to AWS S3 is by using Presigned URLs. How the process works: The Frontend requests an upload link from the server. NestJS generates a temporary, short-lived URL from AWS. The Frontend uses that URL to PUT the file directly to S3. This saves server resources because the file data doesn't have to pass through your backend. Prerequisites If you are new to AWS S3, please check out my previous posts. You’ll need to understand the basics, including how to set up your AWS Access Key ID, AWS Secret Access Key, and how to create an S3 Bucket before moving forward. Implementation Details First, install the NestJS CLI and create a new project: npm install -g @nestjs/cli nest new {project name} Create a .env file and add your AWS credentials: REGION = {REGION} ACCESS_KEY_ID ...

Labels

devops87 typescript75 postgresql62 javascript58 docker39 nextjs38 software engineering38 cloud37 aws36 backend36

database32 nestjs32 aws cdk28 nodejs27 web development27 gcp24 react24 sql24 Kubernete21 deploy21 database optimization20 gcloud20 security19 kubectl18 postgres18 frontend17 backend development13 s313 indexing12 performance11 api9 ci/cd9 gke9 microservices9 automation8 cicd8 cloudfront8 database performance8 k8s8 optimization8 query planner8 typesript8 frontend development7 prisma7 serverless7 sql optimization7 bucket6 cluster6 concurrency control6 ecr6 gin index6 iam6 kind6 angular5 crud5 deployment5 google cloud5 hash join5 konva5 nosql5 performance optimization5 query optimization5 query tuning5 relational database5 seo5 sql performance5 ssr5 api security4 authentication4 b-tree4 b-tree index4 cloud computing4 composite index4 cte4 database design4 dead tuples4 express4 grafana4 graphql4 index only scan4 index scan4 jwt4 materialized view4 merge join4 middleware4 nginx4 performance tuning4 plpgsql4 proxy4 python4 query performance4 redis4 tutorial4 validation4 web performance4 acid3 ant design3 app router3 autovacuum3 cache3 caching3 canvas3 client components3 cybersecurity3 data visualization3 database indexing3 database security3 docker compose3 docker-compose3 ecs3 explain analyze3 fargate3 fastify3 full-text search3 gitlab3 golang3 google cloud run3 helm3 jsonb3 low latency3 micro-frontend3 minio3 monitor3 msw3 mvcc3 nested loop join3 node.js3 postgresql optimization3 programming3 prometheus3 real-time data3 scalability3 secret3 seq scan3 server components3 ssh3 sso3 terraform3 testing3 typeorm3 unit testing3 vite3 web security3 zustand3 advisory lock2 ai2 analytics2 api gateway2 authorization2 auto scale2 aws cli2 aws ecr2 aws ecs2 backend engineering2 blacklist2 brin index2 cAdvisor2 candlestick chart2 canvas performance2 cdn2 check constraint2 citus2 clauses2 cloud function2 cls2 coding2 compute engine2 connection pooler2 containerization2 cookie2 core web vitals2 csrf2 data integrity2 database engineering2 database lock2 database scaling2 database seeding2 database transactions2 databases2 dependency management2 distributed database2 distributed system2 dynamic rendering2 dynamic routes2 dynamodb2 e2e testing2 engineering2 exclusion constraint2 execution plan2 expression index2 for update2 framework2 frontend testing2 fullstack2 function2 google bucket2 google cloud build2 google cloud engine2 google cloud function2 google cloud storage2 grpc2 hash index2 hash partitioning2 heap scan2 high availability2 high performance2 html2 immer2 index2 index optimization2 ingress2 ingress controller2 inner join2 integration test2 integration testing2 isr2 jenkins2 kafka2 kubernetes2 lcp2 left join2 list partitioning2 localstorage2 lock modes2 main thread2 module federation2 monitoring2 nested loop2 nested query2 next2 normalization2 object2 oop2 orm2 partial index2 pgbouncer2 pipeline2 pod2 postgres vacuum2 posting list2 primary key2 range partitioning2 rate limit2 rds2 react fiber2 react hooks2 react testing library2 react-konva2 react-query2 reactjs2 reconciliation2 rendering2 requestanimationframe2 resizeobserver2 reverse proxy2 rewrites2 samesite2 sequential scan2 server actions2 server-sent events2 service2 sharding2 snaplet seed2 software testing2 sql tuning2 ssg2 ssm2 standalone2 state management2 static site generation2 storage2 stored procedure2 subquery2 swagger2 table bloat2 table partitioning2 tdd2 test automation2 unique index2 unit test2 usedeferredvalue2 valkey2 viewport culling2 virtualization2 vitest2 vm instance2 waf2 web dev2 window functions2 work_mem2 xss2 1nf1 2d graphics1 2nf1 3nf1 SQL1 access control1 access share1 access token1 aggregate constraint1 aggregate filter1 aggregate functions1 ai agent1 ai chatbot1 alpine1 amplify1 analyze1 analyze command1 ansible1 anti join1 anti-attack1 anti-semi-join1 anti-spam1 apache superset1 api protection1 api route1 api routes1 api simulation1 api testing1 api validation1 apollo client1 apollo server1 apollo-sandbox1 apollo-server1 app runner1 apple silicon1 application architecture1 array datatype1 artificial intelligence1 asc desc indexing1 asitop1 aspect ratio1 assignment cast1 async1 asynchronous1 asynchronous rendering1 auditing1 auto analyze1 auto-vacuum1 automation tool1 avif1 await1 aws eks1 aws lambda1 aws s31 backend integration1 batch processing1 batching1 bcnf1 bernoulli1 bff1 bi-directional1 big data1 bigint1 bitmap index scan1 bitmap scan1 block range index1 boilerplate1 broadcasting1 browser automation1 btree1 btree index1 bufbuild1 build phase1 bulk insert1 bun1 business logic1 callback url1 canvas api1 cap theorem1 cdk1 cert-manager1 chain of thought1 chart1 charts1 ci/cd security1 class-validator1 client-side rendering1 cloud database1 cloud databases1 cloud storage1 cloud-native1 cloudfare1 cloudwatch1 code analysis1 code stability1 coding tips1 coding tutorials1 columns1 commit1 common table expression1 common table expressions1 component test1 compression1 concurrency1 concurrent rendering1 conditional logic1 configmap1 configuration1 connect-rpc1 connection limit1 connection overhead1 connection pool1 connection pool security1 connectrpc1 const1 container image1 continuous delivery1 continuous integration1 contract testing1 controller1 coordinate transformation1 correlated subqueries1 correlated subquery1 cors1 cost model1 cost-based optimizer1 coverage1 covering index1 create role1 cross join lateral1 cross-platform1 cross-site request forgery1 crosstab1 crud api1 crypto dashboard1 csp1 csr1 csrf protection1 cube1 culling1 cumulative layout shift1 custom-hook1 d31 d3.js1 d3.js canvas1 data1 data aggregation1 data analysis1 data analysist1 data anomalies1 data bloat1 data mutation1 data storage1 data structures1 data transformation1 data types1 data validation1 data-fetching1 database access control1 database administration1 database conflict matrix1 database connection1 database engine1 database integrity1 database locking1 database maintenance1 database management1 database operations1 database protection1 database query tuning1 database relationships1 database replication1 database reporting1 database testing1 database transaction1 database tuning1 date_trunc1 db performance1 ddl1 debouncing1 declarative1 deletion anomaly1 denormalization1 dependency injection1 design pattern1 dev environment1 developer tools1 devtools1 diagram1 dirty read1 disk1 distinct on1 distributed caching1 distributed systems1 dml1 docker build1 dockerfile1 document api1 documentation1 dom1 domain integrity1 dompurify1 double1 dpr1 drag and drop1 drawing app1 dto1 dynamic import1 dynamic indexing1 dynamic policies1 ec21 ecommerce1 ecommerce architecture1 ecommerce schema1 eks1 elixir1 encapsulation1 enterprise app1 entity integrity1 environment management1 error boundary1 error handling1 etcd1 event handling1 event-based1 except1 exception filters1 exceptions handling1 exclusive lock1 exclusivestartkey1 exists1 explicit cast1 explicit locking1 extended1 external1 facade1 failover1 faker js1 faker.js1 fast-csv1 fast-gateway1 fault tolerance1 fetch api1 fetch first1 ffmpeg1 file upload1 filter where1 filtering clauses1 filters1 finance system1 fintech1 firebase1 flask1 float1 float32array1 flushSync1 folder-based routing1 for share1 foreign key1 form handling1 fp1 fps1 free host1 freeze1 front-end performance1 frontend performance1 frontend security1 frp1 function url1 functions1 gae1 general-purpose1 generated1 geometric data1 geometric types1 geqo1 gist1 gist index1 gist vs sp-gist1 github1 global error1 global secondary index1 gpu1 gpu optimization1 grant permissions1 graphql-codegen1 graphql-depth-limit1 graphql-request1 group by extensions1 groupaggregate1 grouping clauses1 grouping sets1 gsi1 guards1 guide1 handlers1 haproxy1 hash collision1 hash semi join1 hash table1 hash-based sharding1 hashaggregate1 hashids1 having clause1 headers1 health check1 heap1 heap page1 heap storage1 high cardinality1 high priority1 high-level1 hmac1 horizontal partitioning1 hpa1 http headers1 http/21 http21 httponly1 https1 huggingface1 human error1 hydration1 id encoding1 identity provider1 image export1 image optimization1 images1 imgproxy1 immutable1 implicit cast1 improve performance1 in clause1 in-memory1 include clause1 incremental static regeneration1 index overhead1 index performance1 index tuning1 indexing strategy1 infrastructure1 infrastructure as code1 inp1 insertion anomaly1 installation1 installation guide1 integer1 integration1 interactivity1 intercepting routes1 interceptors1 intermediate result1 internal mechanics1 intersect1 ioredis1 ip whitelist1 isolation levels1 it1 javascript runtime1 javascript testing1 jcasc1 jest1 jest config1 join1 join multiple tables1 join optimization1 joins1 jsdom1 json1 json export1 json querying1 json web token1 jsonb casting1 jsonb querying1 jsonb_ops1 jsonb_path_ops1 key management service1 keycloak1 keyset pagination1 kms1 kubernetes dashboard1 lambda1 lastevaluatedkey1 layering1 lazy loading1 least privilege1 libraries1 lightsail1 limit1 line chart1 linux memory1 live tuples1 llm inference1 load balancer1 load balancing1 loadbalancer1 local llm1 lock1 lock matrix1 logs1 loki1 lost update1 lower1 lru-cache1 lz41 mac1 machine learning1 main1 many to many1 markdown1 materialized view count1 max limit1 mc1 mcv1 md51 memoization1 memory1 memory overhead1 merge1 merge phase1 merge semi join1 mermaid1 message broker1 metadata xml1 mfa1 microsoft entra1 microsoft playwright1 migration1 minio client1 mlx-lm1 mock api1 mock data1 mocking1 modular architecture1 moleculer1 mongodb1 multi-column in1 multi-stage build1 multi-tenant security1 multi-threading1 multiple columns1 nestjs testing1 network layer1 next.config.ts1 nextjs 131 nextjs 141 nextjs app router1 nextjs image1 nextjs tutorial1 node.js interception1 non-repeatable read1 nonce1 normal forms1 not exists1 not found1 not in1 npm audit1 nrwl1 null1 null handling1 numeric1 nx1 obfuscation1 object storage1 offscreen canvas1 offset1 olap1 olap reporting1 oltp1 on conflict1 on-demand1 on-demand revalidation1 one to many1 one to one1 oom killer1 open source1 open source security1 open-source1 openapi1 optimistic locking1 order by1 order by nulls last1 origin1 out parameters1 overhead1 package manager1 package security1 packages1 pact1 page1 page layout1 page limit1 pages_per_range1 pagination1 paint application1 parallel fetching1 parallel routes1 partial prerendering1 partition pruning1 partitioning1 partitions1 passport-saml1 password hashing1 patroni1 payload limit1 performance test1 pessimistic locking1 pg-promise1 pg_cast1 pg_class reltuples1 pg_trgm1 pgcrypto1 pglz1 pipes1 pivot1 plain1 playwright1 poetry1 poetry.lock1 polymorphic relationship1 postgis1 postgres index1 postgres performance1 postgresql b-tree1 postgresql count1 postgresql indexing1 postgresql rls1 postgresql triggers1 postgresql tuning1 postman1 ppr1 precision1 prefetching1 prefix search1 preflight1 prepared statements1 presigned urls1 prisma-client1 probe phase1 productivity1 progressive enhancement1 promise1 protobuf1 protocol buffers1 proxy server1 pub/sub1 pure component1 pyenv1 pyproject.toml1 python versions1 qa1 quality improvement1 quantization1 queries1 query1 query execution order1 query planner cost model1 query routing1 querycommand1 qwen1 race condition1 raf1 ram1 random io1 range types1 rate limiting1 rbac1 rdbms1 react konva1 react query1 react suspense1 react.memo1 read committed1 read replicas1 readable syntax1 real dom1 real-time communication1 recursive query1 redirects1 redis cluster1 redux devtools1 referential integrity1 referer1 refresh concurrently1 relational database schema1 relational model1 rendering methods1 rendering optimization1 rendering pipeline1 repeatable read1 request-response1 responsive images1 rest1 rest api1 restful1 restful api1 returning1 revalidate1 revalidatepath1 reverse-proxy1 revoke permissions1 rich text1 role anywhere1 role assignment1 rollback1 rollup1 route handlers1 routing landmark1 row exclusive1 row level lock1 row lock1 row share1 row-level locks1 row-level security1 rpc1 s3 api1 s3 sdk1 saas data isolation1 saml21 sanitization1 savepoint1 scale out1 scale up1 scale-out1 scan1 scheduling1 seal1 security audit1 security definer1 security invoker1 seeding1 selection clauses1 self referencing1 semi join1 semi-join1 serial1 serializable1 server1 server component1 server side rendering1 server-side rendering1 server-side routing1 service provider1 service worker1 session mode1 sessionstorage1 setup1 share update exclusive1 shared buffers1 shared lock1 shared_buffers1 sharp1 single sign-on1 single-flight mutation1 skeleton screens1 skew bucket1 skip locked1 snapshot1 sns1 snyk1 socketio1 software architecture1 software-engineering1 solid1 sort phase1 sp-gist index1 space partitioning1 speed1 sql clauses1 sql injection mitigation1 sql join types1 sql joining order1 sql precedence1 sql procedure1 sql query1 sql rewrite1 sql server1 sql tips1 sql triggers1 sqs1 sse1 stale-while-revalidate1 standard view1 state-of-the-art1 statements1 storage strategies1 store.ts1 stored1 stored procedures1 strategic denormalization1 streaming1 streaming data1 styled-component1 sub partitioning1 sub-partitioning1 subtransactions1 supabase1 supavisor1 supertest1 suspense1 svg1 svg vs canvas1 synchronous1 system1 table lock1 table locks1 table-level locks1 tablefunc1 tablesample1 technical translation1 temporal database1 temporary table1 test coverage1 test-driven development1 testing library1 testing tools1 text1 text editor1 throttling1 tiling1 time-based revalidation1 tinymce1 tls certificate1 to_tsvector1 toast1 token1 token revocation1 tokenization1 transaction control1 transaction isolation1 transaction level lock1 transaction mode1 transactional isolation1 transactions1 transferable objects1 transform1 trigger1 trigger function1 triggers1 trigram1 trigram search1 troubleshooting1 tuple comparison1 type casting1 type hierarchy1 type-safe1 type.ts1 types1 ubuntu1 ui responsiveness1 unbalanced trees1 unified memory1 union all1 unique id1 unnest1 update anomaly1 upload1 upsert1 use-deferred-value1 use-transition1 user creation1 user defined function1 usetransition1 using clause1 using group by1 uuid1 uuid alternative1 vacuum1 vacuum full1 vacuum overhead1 vercel1 versioning1 virtual dom1 virtual environment1 virtual scroll1 visibility api1 visibility map1 vpc1 vulnerabilities1 vulnerability scanning1 wal1 wal log1 web1 web development.1 web engineering1 web server1 web vitals1 web worker1 web workers1 web-development1 webhook1 webp1 webpack1 websocket1 websockets1 whitebaord1 whiteboard1 window function1 write skew1 write-ahead logging1 xml1 xss prevention1 yarn audit1 zero copy1 zero downtime1 zig1

Show more Show less