BVBase

A powerful web-based database management system with REST API capabilities

Overview

BVBase is a comprehensive database management system that combines the power of web-based administration with robust API capabilities. It provides a secure and efficient way to manage your data through both a user-friendly web interface and programmatic access.

Key Features

  • Web-based Administration Interface
  • RESTful API Access
  • Secure Authentication System
  • Dynamic Table Management
  • Project-based Organization

Technical Details

  • PHP-based Backend
  • MySQL Database
  • Secure API Authentication
  • Version Control Integration
  • Cloud-ready Architecture

API Documentation

Authentication API

Login
POST /BVBase/services/bvdb_services.php
Content-Type: application/json

{
    "action": "login",
    "username": "string",
    "password": "string"
}
Returns JWT token for authentication
Logout
POST /BVBase/services/bvdb_services.php
Authorization: Bearer <token>

{
    "action": "logout"
}
Invalidates the current session

Database API

Execute Query
POST /BVBase/services/bvdb_services.php
Authorization: Bearer <token>

{
    "action": "execute_query",
    "project": "string",
    "query": "string"
}
Returns query results or affected rows
Get Projects
POST /BVBase/services/bvdb_services.php
Authorization: Bearer <token>

{
    "action": "get_projects"
}
Returns list of available projects
Security Information
  • All API requests require JWT token authentication
  • Tokens expire after 24 hours
  • Tokens must be included in Authorization header
  • Tokens are signed with secure secret key
  • Invalid/expired tokens return 401 Unauthorized

Web Interface

The web interface provides an intuitive way to manage your database. Features include:

  • Table creation and management
  • Data visualization and editing
  • Project organization
  • User management
  • Access control settings

Application Features

Login Page

  • Secure login form with username/password authentication
  • Session management with secure cookies
  • Automatic redirection to dashboard after successful login
  • Error handling and user feedback
  • Responsive design for all devices

Dashboard

Project Selection
  • Dropdown menu for project selection
  • Project information display
  • Automatic query execution on project change
Query Interface
  • SQL query input with syntax highlighting
  • Query history
  • Query validation
  • Error handling and display
Results Display
  • DataTables integration for advanced table features
  • Sorting and filtering
  • Pagination
  • Search functionality
  • Export options (CSV, Excel, PDF, Print)
User Management (Admin Only)
  • User list with details
  • Create new users
  • Edit existing users
  • Delete users
  • Role management
Security Features
  • Role-based access control
  • SQL injection prevention
  • XSS protection
  • CSRF protection
  • Secure session management

Getting Started

To start using BVBase:

  1. Send an email to vittorio.margherita@buonevacanze.org requesting access to the system
  2. Once approved, you will receive your login credentials
  3. Access the web interface at https://www.bvrobotics.com/BVBase/index.html
  4. Log in with your provided credentials
  5. Set up your first project
  6. Create and manage your tables
  7. Integrate with your applications using the API
Access to BVBase is granted on a case-by-case basis. Please include your intended use case in your access request email.