info Overview
MySQL and PostgreSQL are the relational database management systems used across DASCLAB applications and research data pipelines. MySQL powers the DASCLAB website and student portal. PostgreSQL is used for complex spatial queries via the PostGIS extension in geospatial research projects. The DB101 course module covers both systems.
checklist Key Features
- ACID-compliant relational data storage
- Advanced JOIN operations and window functions
- Stored procedures and triggers
- Spatial extensions: PostGIS for geographic data (PostgreSQL)
- Full-text search capabilities
- XAMPP integration for local development