← BACK TO PORTFOLIO

MINIX-PHP

Lightweight social media web application built using PHP, PostgreSQL, and Supabase.

RoleBackend Developer
Tech StackPHP, PostgreSQL, Supabase

OVERVIEW

MiniX-PHP is a lightweight, fully functional social media platform that allows users to create accounts, share posts, and interact with dynamic content. The project is specifically engineered to demonstrate modern backend development techniques, seamless cloud database integration, and scalable system architecture using PHP and PostgreSQL (via Supabase). It serves as a practical exploration of secure authentication systems, session management, and relational data handling within a web environment.

[ MiniX-PHP Platform Interface — Image Placeholder ]

KEY FEATURES

  • ▸ Authentication System: Secure user registration, login operations, and protected session management.
  • ▸ Social Feed System: Publish, display, and manage user-generated social posts dynamically.
  • ▸ Cloud Database Integration: Real-time storage and retrieval of relational data using Supabase and PostgreSQL.
  • ▸ Secure Data Handling: Enforced security protocols for managing passwords, user states, and input validation.
  • ▸ Responsive UI: Clean and accessible web interface constructed with HTML, CSS, and JavaScript.

SYSTEM ARCHITECTURE

Backend Logic
Developed purely in PHP, handling server-side rendering, routing, authentication, and core business logic.
Database Infrastructure
Employs PostgreSQL hosted on Supabase to guarantee scalable, secure, and highly available data operations.
Session Management
Tracks authenticated users persistently to deliver personalized feeds and maintain strict access control over actions.
Content Rendering
Dynamically fetches relational data from the cloud database to render real-time social feeds efficiently on the client side.

DATABASE SCHEMA & RELATIONSHIPS

The underlying data architecture utilizes PostgreSQL to maintain relational integrity. Supabase abstracts the infrastructure while allowing direct SQL interactions. One user can create multiple posts, linked via strict foreign key constraints.

Users Table
  • user_id: UUID PRIMARY KEY
  • username: VARCHAR (Unique)
  • email: VARCHAR
  • password: VARCHAR (Encrypted)
  • created_at: TIMESTAMP
Posts Table
  • post_id: UUID PRIMARY KEY
  • user_id: UUID FOREIGN KEY
  • content: TEXT
  • created_at: TIMESTAMP

INSTALLATION & SETUP

1. Clone the repository:

git clone https://github.com/AAFLY99/MiniX-PHP.git
cd MiniX-PHP

2. Environment Configuration:

Create your database credentials and Supabase connection settings to point to your cloud instance.

3. Run the Server:

Deploy the project using a local PHP server or an environment like XAMPP to test functionality.

FUTURE ROADMAP

Engagement Features
Implement post reactions, nested comments, and advanced profile customization for enriched user interactions.
Media & APIs
Add support for direct media/image uploads and design a robust REST API for potential third-party integrations.
Real-Time Enhancements
Develop a real-time chat system, push notifications, and optimize the layout heavily for mobile device parity.
View Code Repository