Index nearly everything, index early. Not indexing results in poor performances. Indexing too late... Tagged with webdev, programming, sql, postgres.

Dev.to is a community platform for developers, offering resources, discussions, and networking opportunities to empower individuals in their coding journey. Developers can learn new programming languages, frameworks, and tools, engage in discussions on best practices, and share their experiences with fellow developers to enhance their skills and grow their professional network.

Index nearly everything, index early . Not indexing results in poor performances. Use lower case everywhere (and underscores), do not name your tables with camelCase. Be super consistent when naming tables and columns. Never miss a foreign key . Implicit links and relations between tables should be avoided.

SQL tips for beginners; what I learned after 10+ years of occasionally writing queries and schemas as a web dev