SolSQL API powers a location-discovery platform, exposing a full suite of REST endpoints for managing places of interest, user accounts, social interactions (comments, reactions, favorites), and geographic reference data. Built on ASP.NET Core 8 with a MySQL backend, every operation routes through stored procedures for consistency and performance.Documentation Index
Fetch the complete documentation index at: https://mintlify.com/jparra-amell/api_solsql/llms.txt
Use this file to discover all available pages before exploring further.
Quickstart
Make your first API call in minutes with step-by-step setup instructions.
Authentication
Learn how to authenticate with the API using email, password, and role.
Places API
Explore, search, and manage places with full CRUD and detail views.
API Reference
Complete endpoint documentation for every resource in the API.
What you can do with SolSQL API
SolSQL API provides endpoints across several resource domains:- Places — Create, read, update, delete, activate/deactivate, and search places of interest with rich detail views
- Users — Register users, authenticate, and manage user accounts with BCrypt-hashed passwords
- Comments — Post, edit, and retrieve threaded comments on places
- Reactions — Record and manage user reactions (likes, etc.) on places
- Favorites — Let users save and retrieve their favorite places
- Photos — Attach and manage photo galleries for each place
- Reference Data — Manage geographic taxonomy (departments, cities) and place types
- Logs & Analytics — Query audit logs and comment statistics views
Technology stack
| Component | Technology |
|---|---|
| Runtime | ASP.NET Core 8 (.NET 8) |
| Database | MySQL (via Pomelo EF Core) |
| ORM | Entity Framework Core 8 |
| Auth | BCrypt.Net password hashing |
| API Docs | Swagger / OpenAPI (Swashbuckle) |
| Containerization | Docker |
Getting started
Review the quickstart
Follow the quickstart guide to understand how to connect and make your first request.
Authenticate
Call
POST /api/LoginRequest/login with your email, password, and role to verify your credentials.Build your integration
Use the full API Reference to integrate comments, reactions, favorites, and more.