II.
SkillArea overview
Reference · liveskill-area:backend-data-persistence
Backend Data Persistence overview
Selecting and integrating data stores — relational (PostgreSQL, MySQL), document (MongoDB), key-value (Redis), and search (Elasticsearch) — with backend services. Covers connection pooling, migration strategies, query optimization, and multi-store architectures.
Attributes
displayName
Backend Data Persistence
description
Selecting and integrating data stores — relational (PostgreSQL, MySQL),
document (MongoDB), key-value (Redis), and search (Elasticsearch) —
with backend services. Covers connection pooling, migration strategies,
query optimization, and multi-store architectures.
domains
expertiseLevels
- intermediate
- expert
Outgoing edges
applies_to1
- specialization:backend-development·Specialization
prerequisite_for_learning8
- skill-area:caching-strategies·SkillAreaCaching
- skill-area:backend-async-processing·SkillAreaBackend Async & Background Processing
- skill-area:search-infrastructure·SkillAreaSearch Infrastructure
- skill-area:database-drivers-connectors·SkillAreaDatabase Drivers and Connectors
- skill-area:object-relational-mapping·SkillAreaObject-Relational Mapping (ORMs)
- skill-area:database-migrations-zero-downtime·SkillAreaZero-Downtime Database Migrations
- skill-area:postgres-tuning·SkillAreaPostgres Performance Tuning
- skill-area:graph-databases·SkillAreaGraph Databases
Incoming edges
lib_requires_skill_area12
- lib-agent:software-architecture--data-architect·LibraryAgentdata-architect
- lib-agent:web-development--backend-developer·LibraryAgentbackend-developer
- lib-process:software-architecture--data-architecture-design·LibraryProcessdata-architecture-design
- lib-process:web-development--mongodb-schema-design·LibraryProcessmongodb-schema-design
- lib-process:web-development--postgresql-database-design·LibraryProcesspostgresql-database-design
- lib-process:web-development--prisma-orm-integration·LibraryProcessprisma-orm-integration
- lib-skill:backend-development--growing-outside-in-systems·LibrarySkillgrowing-outside-in-systems
- lib-skill:software-architecture--db-query-analyzer·LibrarySkilldb-query-analyzer
- lib-skill:web-development--drizzle·LibrarySkilldrizzle
- lib-skill:web-development--mongodb·LibrarySkillmongodb
- lib-skill:web-development--postgresql·LibrarySkillpostgresql
- lib-skill:web-development--prisma-orm·LibrarySkillprisma-orm
library_used_by28
- library:hibernate·LibraryHibernate ORM
- library:hive·LibraryHive
- library:isar·LibraryIsar
- library:drift·LibraryDrift
- library:entity-framework·LibraryEntity Framework Core
- library:dapper·LibraryDapper
- library:efcore-migrations·LibraryEF Core Migrations
- library:ecto·LibraryEcto
- library:pgx·Librarypgx
- library:sqlx-go·Librarysqlx (Go)
- library:sqlx-rust·LibrarySQLx (Rust)
- library:sea-query·LibrarySeaQuery
- library:gorm·LibraryGORM
- library:gorm-v2·LibraryGORM v2
- library:sqlx-pg·LibrarySQLx (PostgreSQL)
- library:diesel-rs·LibraryDiesel
- library:spring-data·LibrarySpring Data
- library:exposed·LibraryExposed
- library:doctrine·LibraryDoctrine ORM
- library:eloquent·LibraryEloquent ORM
- library:room·LibraryRoom
- library:redis-py·Libraryredis-py
- library:flask-sqlalchemy·LibraryFlask-SQLAlchemy
- library:alembic·LibraryAlembic
- library:sea-orm·LibrarySeaORM
- library:doobie·LibraryDoobie
- library:slick·LibrarySlick
- library:sqlalchemy·LibrarySQLAlchemy
requires_skill_area45
- stack-profile:monorepo-fullstack·StackProfileMonorepo Full-Stack Stack (Turborepo, Next.js, NestJS, Prisma, PostgreSQL)
- stack-profile:geospatial-analytics·StackProfileGeospatial Analytics (PostGIS + Python + Leaflet/Mapbox + GeoPandas)
- stack-profile:graphql-api-platform·StackProfileGraphQL API Platform (Apollo Server + Prisma + PostgreSQL + React + TypeScript)
- stack-profile:project-management-app·StackProfileProject Management App Stack (React, WebSocket, PostgreSQL, Redis, Docker)
- stack-profile:crm-customer-platform·StackProfileCRM / Customer Platform Stack (Next.js, PostgreSQL, Redis, Elasticsearch, Stripe)
- stack-profile:high-perf-api-server·StackProfileHigh-Performance API Server Stack (Go, Chi, PostgreSQL, Redis, Prometheus)
- stack-profile:multi-tenant-saas-backend·StackProfileMulti-Tenant SaaS Backend Stack (NestJS, Prisma, PostgreSQL, Redis, Stripe, Docker)
- stack-profile:event-sourcing-cqrs·StackProfileEvent Sourcing / CQRS Stack (TypeScript, NestJS, PostgreSQL, Redis, Docker)
- stack-profile:enterprise-service-bus·StackProfileEnterprise Service Bus (Java, Spring Boot, RabbitMQ, Redis, PostgreSQL, Docker)
- stack-profile:government-portal·StackProfileGovernment Portal (.NET, Blazor, PostgreSQL, Keycloak, Docker, Azure)
- stack-profile:podcast-network·StackProfilePodcast Network (Next.js, Boto3, PostgreSQL, Stripe, Redis, TypeScript)
- stack-profile:photo-gallery-dam·StackProfilePhoto Gallery / DAM (React, Sharp, Boto3, PostgreSQL, Redis, FastAPI)
- stack-profile:music-streaming-backend·StackProfileMusic Streaming (Rust, Redis, PostgreSQL, Boto3, React, TypeScript)
- stack-profile:online-exam-assessment·StackProfileOnline Exam / Assessment (Next.js, PostgreSQL, Redis, Docker, TypeScript)
- stack-profile:lab-information-system·StackProfileLab Information System (Python, FastAPI, PostgreSQL, Boto3, React, Docker)
- stack-profile:forum-discussion-board·StackProfileForum / Discussion Board (Next.js, PostgreSQL, Redis, Elasticsearch, TypeScript)
- stack-profile:wiki-knowledge-base·StackProfileWiki / Knowledge Base (Next.js, PostgreSQL, Elasticsearch, Boto3, Redis)
- stack-profile:social-network-backend·StackProfileSocial Network Backend (Go, PostgreSQL, Redis, RabbitMQ, Elasticsearch, Boto3)
- stack-profile:identity-governance·StackProfileIdentity Governance (Keycloak, PostgreSQL, React, Go, Docker)
- stack-profile:ab-testing-platform·StackProfileA/B Testing Platform (Python, PostgreSQL, Redis, React, FastAPI, Prometheus)
- stack-profile:url-shortener-link-analytics·StackProfileURL Shortener / Link Analytics (Go, Redis, PostgreSQL, React, Docker)
- stack-profile:file-storage-object-gateway·StackProfileFile Storage / Object Gateway (Go, Boto3, PostgreSQL, Redis, Docker)
- stack-profile:haskell-web-service·StackProfileHaskell Web Service (Haskell, Servant, PostgreSQL, Docker, Nix)
- stack-profile:scala-akka-microservice·StackProfileScala Akka Microservice (Scala, Akka, Slick, PostgreSQL, Docker, SBT)
- stack-profile:ocaml-web-backend·StackProfileOCaml Web Backend (OCaml, Docker)
- stack-profile:crystal-web-app·StackProfileCrystal Web App (Crystal, PostgreSQL, Docker)
- stack-profile:fsharp-web-api·StackProfileF# Web API (F#, ASP.NET Core, PostgreSQL, Docker, .NET)
- stack-profile:clojure-ring-service·StackProfileClojure Ring Service (Java, Docker)
- stack-profile:clean-architecture-stack·StackProfileClean Architecture (Go, Chi, PostgreSQL, Docker, Testify)
- stack-profile:approval-workflow-engine·StackProfileApproval Workflow Engine (Go, PostgreSQL, Redis, React, gRPC, Docker)
- stack-profile:django-htmx·StackProfileDjango + HTMX + Alpine
- stack-profile:go-gin-postgres·StackProfileGo + Gin + Postgres
- stack-profile:rails-stack·StackProfileRails + Hotwire + Stimulus
- stack-profile:rust-axum-sqlx·StackProfileRust + Axum + SQLx + Postgres
- stack-profile:mean-stack·StackProfileMEAN Stack (MongoDB, Express, Angular, Node.js)
- stack-profile:go-grpc-postgres·StackProfileGo + gRPC + PostgreSQL
- stack-profile:fastapi-postgres·StackProfileFastAPI + SQLAlchemy + PostgreSQL
- stack-profile:spring-boot-stack·StackProfileSpring Boot + Java + Hibernate
- stack-profile:rust-actix-postgres·StackProfileRust + Actix Web + Diesel + PostgreSQL
- stack-profile:elixir-phoenix-postgres·StackProfileElixir + Phoenix + Ecto + PostgreSQL
- stack-profile:kotlin-ktor-exposed·StackProfileKotlin + Ktor + Exposed + PostgreSQL
- stack-profile:remix-prisma-stack·StackProfileRemix + Prisma + PostgreSQL
- stack-profile:htmx-go-stack·StackProfileGo + HTMX + Templ + SQLite
- stack-profile:lamp-stack·StackProfileLAMP Stack (Linux, Apache, MySQL, PHP)
- stack-profile:t3-stack·StackProfileT3 Stack (Next.js + tRPC + Prisma + Tailwind)
used_by_skill_area1
- framework:supabase·FrameworkSupabase
used_for10
- library:mongoose·LibraryMongoose
- library:knex·LibraryKnex.js
- library:sequelize·LibrarySequelize
- library:typeorm·LibraryTypeORM
- library:mikro-orm·LibraryMikroORM
- library:objection·LibraryObjection.js
- library:kysely·LibraryKysely
- library:drizzle-orm·LibraryDrizzle ORM
- library:prisma·LibraryPrisma
- tool:psql·Toolpsql