gitconnected·1yBackend Developer Roadmap 2025: The Complete Guide
This guide outlines the essential skills and timelines needed to become a proficient backend developer by 2025. It covers core topics such as programming languages (with a focus on Node.js), databases, APIs, version control, web servers, authentication, and deployment. The guide includes a free roadmap template with project ideas and a progress tracker to help you stay on course.
As a Programmer·1yNext.js Tutorial 2025 - Build a Full Stack Social App with React & Next.js
Learn to build a full stack social media application using React and Next.js. This detailed guide covers implementing core features like user authentication with Clerk, post creation, comments, likes, and notifications. The project also includes updating profiles, enabling dark mode, and ensuring a responsive UI design with Tailwind CSS. You will also integrate a PostgreSQL database using Prisma ORM and Neon, demonstrating key functionalities step-by-step.
Vlad Mihalcea·1yWhy you should use compact table columns
Using compact table columns can significantly enhance database performance by allowing more records and index entries to be stored in memory, thus speeding up SQL queries. This practice is effectively demonstrated by StackOverflow, which uses a highly efficient schema to serve millions of queries per second with minimal hardware. Tips include using smaller data types for keys and enforcing column length limits for VARCHAR fields.
PlanetScale·1yDatabase Sharding — PlanetScale
Sharding is the process of improving database scalability by distributing data across multiple servers, known as shards. This technique is widely used by large companies like Uber and Slack. Effective sharding involves choosing the right sharding strategy and shard key to optimize performance and avoid issues like cross-shard queries. PlanetScale, built on Vitess, provides tools to simplify sharding implementation and management. Additionally, sharding can help with data durability, high availability, and faster backups by using replicas.
Neon·1yFixing JavaScript Timezone Issues
Navigating timezone issues in JavaScript can be tricky. In a recent project, timezone metadata caused conflicts when booking parking slots. By removing timezone metadata and storing plain date-time strings, the team ensured consistent date and time storage across different timezones. Additionally, Neon’s easy connectivity and scalability proved beneficial for the project.
Community Picks·1yaurijs/jason: Slash database complexity away with jason.
jason is a lightweight, embeddable JSON database designed for Bun projects. It features schema validation, concurrency control, and built-in caching. The simple API allows easy CRUD operations and custom queries. Jason supports versioning to track document changes and offers different concurrency strategies. Contributions to the project are welcome.
ByteGrad·1yNext.js Multi-Tenant & Local-First Apps Are Easy Now
SQLite can be challenging to use in production, but Turo, a sponsor of the video, simplifies the process by allowing easy setup of multi-tenant and local-first apps. Turo can manage numerous databases, create embedded replicas for low latency, and even integrate AI capabilities like storing vector embeddings. In a demo, the post shows creating a Next.js app with Turo's database management, showcasing benefits like simple database replication, creating multi-database schemas, and enabling point-in-time recovery.
gitconnected·1yWhy Knowing TOAST in PostgreSQL is necessary for Backend Devs!
TOAST (The Oversized-Attribute Storage Technique) in PostgreSQL helps manage large data values exceeding the 8kB page size limit using compression and out-of-line storage. It supports various data types and uses four storage strategies: PLAIN, EXTERNAL, EXTENDED, and MAIN, each with different methods for managing oversized data. Understanding TOAST strategies can help optimize database performance.
Neon·1yBuild an end-to-end RAG pipeline entirely in psql using pgrag and DeepSeek
Retrieval-Augmented Generation (RAG) pipelines can be built entirely within psql using the pgrag extension, which works alongside the pgvector extension to enable efficient semantic searches within Postgres. The pgrag extension simplifies both the preparation of document embeddings and the handling of questions to retrieve relevant information. Users can extract text, generate embeddings, rerank results, and prompt AI chat models like DeepSeek directly within their database environment.
Community Picks·1yrealfakenerd/jason: simple, fast, lightweight JSON Database.
jason is a lightweight and embeddable JSON database designed for Bun projects, offering a simple API for CRUD operations and query functionalities. Features include schema validation, concurrency control, versioning support, built-in caching, and a flexible query system. The database can be easily integrated and used with minimal code, ensuring data integrity and preventing update conflicts.
Awesome Go·1yMake an MMO with Godot 4 + Golang: Database setup for persistent game world
Learn how to set up a SQLite database for a Godot 4 MMO using Golang. This guide covers establishing a connection, handling user registration and login, and writing SQL queries without using an ORM. Follow along to implement a secure and persistent game world. By the end of this tutorial, you'll have a functioning login system and the groundwork for more complex game logic.
Lobsters·1ySQLite4: SQLite4
SQLite4 was an experimental project from 2012 to 2014, aimed at rewriting SQLite. The project was discontinued, and its lessons were incorporated into SQLite3. SQLite4 was never released or maintained and should not be used. The repository exists purely for historical reference.
Community Picks·1yMy 2024 Web Development Journey: A 16-Year-Old's Perspective
A 16-year-old web developer reflects on their journey in 2024, starting with mastering Next.js 14 and Sanity CMS. They share their experiences with learning PostgreSQL and Prisma, building real-world projects, balancing academic life with coding, landing their first freelance client, and starting an internship. The post highlights their continuous learning efforts and investments in personal branding and professional growth.
codeHeim·1y#74 Golang - PostgreSQL with PGX in Go: Step-by-Step Tutorial
Learn to use the PGX package to interact with PostgreSQL in Go. This tutorial covers installation, setting up connections, creating tables, inserting data, handling transactions, querying data, and updating and deleting records efficiently using PGX.
Community Picks·1yForget SQL vs NoSQL - Get the Best of Both Worlds with JSON in PostgreSQL
The post explains how to leverage JSON within PostgreSQL to combine the benefits of both SQL and NoSQL databases. It details the evolution of JSON support in PostgreSQL, from the introduction of the JSON data type to more advanced features like JSONB and JSONPath. Additionally, it covers how to create and query JSON data, the importance of indexing for performance, and common anti-patterns to avoid. The post concludes by comparing JSON in PostgreSQL with traditional NoSQL databases and outlines when it's best to use each approach.
Tiger's Place·1yEvent sourcing (notes)
Event sourcing transforms events into the source of truth, providing perfect audit trails, time travel capabilities, and business insights. Snapshots optimize performance by saving system states, aiding in fast recovery and reducing replay load. Ideal for financial, legal, and complex business processes, event sourcing is distinguished from CDC by focusing on business decisions rather than database changes. Effective partitioning of data ensures efficient storage and retrieval.
Nick Chapsas·1yThe New Way to Seed Your Database in .NET 9
Learn about the new database seeding approach introduced in .NET 9 using EF Core 99. The post includes a step-by-step guide, highlights the importance of managing the seed process to avoid concurrency issues, and addresses the use of synchronization methods for effective data seeding.
Code Maze·1yTesting Database Connectivity with EF Core
Verifying database connectivity is crucial for application reliability and user experience. This post outlines two approaches to test database availability with EF Core: using the CanConnectAsync() method for application-level checks and the DbContext check with ASP.NET Core health checks framework for infrastructure-level monitoring. It also includes setup instructions for using a SQL Server Test Container and Docker.
The New Stack·1yDuck DB: Query Processing Is King
DuckDB is an in-process database that simplifies query processing without focusing on data persistence. It supports multiple programming languages and is efficient for testing scenarios and on-the-fly data transformations. DuckDB is especially useful for gaining SQL query support without the need for a full database system.
TestDriven.io·1yDatabase Indexing in Django
Database indexing improves data retrieval speed and optimizes query performance in relational databases. In Django applications, using indexes can enhance responsiveness, crucial for managing large datasets. This guide covers the fundamentals of indexing, its pros and cons, and its practical application in Django, showcasing examples with primary, unique, composite, and full-text indexes. The included sample project demonstrates the impact of indexes on query performance, highlighting best practices for implementation.
