Comparing ID Generation Technique (Incremental, UUID, and Snowflake)
ID or Identifier is a common method to differentiate between multiple entities or object. But what option is available and which one is the best for your usecase. Let's try to find out together.
Comparing PostgreSQL Batch Insertion (Multi Value Insert, Prepared Statement, and Copy)
Have you ever need to do batch insertion with PostgreSQL? Which one do you need to use? Write the query directly? Or maybe use prepared statement? Or maybe using copy command? In this post, we will try to inspect which method is the fastest.